troubleshooting Question

Sort PCs in Sites

Avatar of DRRAM
DRRAM asked on
VB ScriptPowershellMicrosoft Excel
135 Comments1 Solution782 ViewsLast Modified:
Please I need a script that gives me as a result the number of computers located in a site :
Example :
I have IN FILE EXCEL :
Scope                                     Start IP Address                 End IP Address
[12.182.1.0] SITE 1                12.182.1.11                           12.182.1.30
[12.182.8.0] SITE 2                12.182.8.130                        12.182.8.254
and I have :
Name-PC              IP Address
       PC1                12.182.1.17
       PC2                12.182.8.144
       PC3                12.182.1.19
       PC4                 12.182.1.29
I will find the number of computers that are in the site 1 and site 2 ...
 thank you very much in advance
ASKER CERTIFIED SOLUTION
redmondb

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 135 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 135 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros