Delims and changing Variable values.

Hi Guys,

In Trying to separate an IP address to create a scope basically I want to increment the 3rd octet in the address by the required amount in this case 1. Also want to set an address to the broadcast address and set the end of the scope based on how many node address that will need to be left available.

Set Host=192.168.0.0    Set /P End=Please enter the number of node address that you would like to leave free:  if not defined %End% set ResRange= 240  Else set ResRange=254-%End%   Echo Reserved Range is %ResRange%    setlocal EnableDelayedExpansion  FOR /F "tokens=1,2,3 delims=." %%G IN ("%Host%") DO set 510IP=%%I+1  Call Set FullIP =%%G.%%H.%510%.  Call Set HostEnd=%FullIP%254  Call Set ScopeEnd=%FullIP%%ResRange%    echo netsh dhcp server %DCIP% add scope %Host% 255.255.254.0 %ScopeName% %ScopeName%_VLANx  echo netsh dhcp server %DCIP% scope %Host% add iprange %FullIP%1 %ScopeEnd%  echo netsh dhcp server %DCIP% scope %Host% set optionvalue 003 IPADDRESS %HostEnd%  Goto EOF

My problem at the moment is that that Im having is A that the Res Range keeps being set to 240 regardless and that the %FullIP%, %ScopeEnd%, and %HostEnd% are all coming back empty.

Any help with this would be amazing.

Tea Tutaki

Changed type Bill_Stewart Wednesday, January 4, 2017 9:43 PM

Reply:

Don't use shell script (batch). Switch to PowerShell instead and things will be a lot less painful.

-- Bill Stewart [Bill_Stewart]

------------------------------------
Reply:

Here is a solution: https://gallery.technet.microsoft.com/scriptcenter/ipcalc-PowerShell-Script-01b7bd23

\_(ツ)_/

------------------------------------
Reply:

Indeed. Here's another solution:

Windows IT Pro - Working with IPv4 Addresses in PowerShell

-- Bill Stewart [Bill_Stewart]

------------------------------------
Reply:

Now why didn't you post that to begin with? I think you know the author.

\_(ツ)_/

------------------------------------
Reply:

... and if I didnt want to use powershell... OK I will write power shell. Decided to do this in Batch since working with 2008 boxes and can only use Netsh commands with these boxes. I already have this script https://gallery.technet.microsoft.com/scriptcenter/ipcalc-PowerShell-Script-01b7bd23 but was trying to avoid dissecting it to function with the Netsh commands.

Will go over the Windows IT Pro - Working with IPv4 Addresses in PowerShell article and write something else :(, thanks guys.

Tea Tutaki

------------------------------------
Reply:

With PD we usually don't need "netsh" to accomplish a result.

Hey - its the 21st century. Join us.

\_(ツ)_/

------------------------------------

more on serialized mode and range locks, and the elimination thereof

(oops, meant to post this on the Azure SQL forum, sorry)

Remember my little case (linked below) where in an update statement I *do* specify my PK, and yet it generates range locks, and the speculation was the additional predicate made it unsafe? Well. Even without the extra predicate, it misbehaves, and when I say misbehaves I mean it is generating 2668 locks, even though there's only one row to lock, *and* the execution plan estimates 50 rows!

But here's a thing. Slap the old "option(recompile)" on the end of the update statement and it only generates a couple of key locks and a couple of page locks, presumably the affected secondary indexes - and none of them are range locks. And the execution plan - well, the actual execution plan - estimates 1 row.

Or, use constants instead of variables for the values of the key fields.

Testing is still in progress to see if this relieves the deadlocks ...

Thanks,

Josh

ps - it also helps if you exactly match the types of the variables with the column definitions, implicit conversion of nvarchar() to varchar() is also part of the problem.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6d54bc71-4679-48d4-b529-71ec9637840b/does-serialized-mode-always-take-range-locks-even-for-single-row?forum=sqldatabaseengine

Edited by JRStern Friday, November 18, 2016 5:16 AM

Good book recommendation for SQL statements in Power Query?

I want to be able to more effectively write SQL statements in the initial connection to SQL Server tables. I'm not looking to become an expert or anything, but just want a really good resource (book preferred as I hate reading this kind of thing in a browser) that will enable me to more easily do the joins and set criteria before the data even hits the PQ window.

Thanks.

Changed type Winnie LiangMicrosoft contingent staff Wednesday, November 9, 2016 3:16 AM For discussion

Reply:

Hi Ed,

I notice that you are looking for a book to learn the SQL connection for Power Query. In the following similar thread, Miguel.Llopis was provided a suggestion about it:

https://social.technet.microsoft.com/Forums/en-US/e11edea6-0d5d-4339-99ce-811060a2f573/guidance-on-learning-power-query-in-ordered-manner?forum=powerquery

Additionally, I suggest you can also open a discussion in Power Query forum to confirm if the friends there can give more suggestions about it:

https://social.technet.microsoft.com/Forums/office/en-US/home?forum=powerquery

Regards,

Winnie Liang

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

------------------------------------
Reply:

Thanks Winnie. I'll give it a look. Only issue is it is 2 years old and as often as PQ gets updated, not sure how much is out of date.

I'll check out the forum you recommended too.

------------------------------------

Calling all SharePoint Gurus. November readers need feeding!

"An influential teacher, or popular expert"

Oh mighty reader, we need your enlightenment! Only YOU can show us… the TRUE WAY to code!

Win the dedication and adoration of generations to come, by giving something back to those less awesome.

Show your technical prowess, and divine knowledge of your craft.

Teach us good code from bad. Show us the way (or the work-around)

We can offer you the very best platform that you need to preach these good words.

Join us and lead this technical community in a whole new way, into a brighter future!

Become a TechNet Guru and you may find your own life also significantly enriched!

Win awards, interviews, invites, reviews, medals, friends, recognition points, high fives, hugs, smiles, and so much more!

All you have to do is add an article to TechNet Wiki from your own specialist field. Something that fits into one of the categories listed on the submissions page. Copy in your own blog posts, a forum solution, a white paper, or just something you had to solve for your own day's work today.

Drop us some nifty knowledge, or superb snippets, and become MICROSOFT TECHNOLOGY GURU OF THE MONTH!

This is an official Microsoft TechNet recognition, where people such as yourselves can truly get noticed!

HOW TO WIN

1) Please copy over your Microsoft technical solutions and revelations to TechNet Wiki.

2) Add a link to it on THIS WIKI COMPETITION PAGE (so we know you've contributed)

3) Every month, we will highlight your contributions, and select a "Guru of the Month" in each technology.

If you win, we will sing your praises in blogs and forums, similar to the weekly contributor awards. Once "on our radar" and making your mark, you will probably be interviewed for your greatness, and maybe eventually even invited into other inner TechNet/MSDN circles!

Winning this award in your favoured technology will help us learn the active members in each community.

Feel free to ask any questions below.

More about TechNet Guru Awards.

Thanks!

Kamlesh and...

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

Reply:

Middle of the month and still waiting Guru to write 1st article in this section!

Thanks,

If my reply is helpful please mark as Answer or vote as Helpful.

My blog | Twitter | LinkedIn

This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

------------------------------------

Calling all Power Pivot Gurus. November readers need feeding!