Windows Server: SAN storage script

Hello,

I have been asked to report on all the servers that are connected to SAN. We have a few hundred servers. These servers are Windows 2008 R2.

Could you please help me with a script or a way to get this info.

Thanks
Parity123Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
What are you being asked to report! There are different ways to pull info using powershell, wmic
As well as other tools.
Parity123Author Commented:
List all the servers , drive letters, and disk space, that are using SAN for storage. Could you please provide me a sample script or tool I can use. Thanks.
arnoldCommented:
wmi logicaldisk will include the information
DriveType, but I think the SAN resource will be seen/reflected the same way C: is as a localDrive

I think you should be looking/generating this report from the SAN.
There you have the allocated LUNS, and the hosts to which each LUN is allocated.

This will give you a narrowed down list.
you can then use powershell to remotely connect to each server's wmi interface and query the logicaldisk.
The result will then based on partition/lun size would need to be combined with the SAN report to complete ....
The below describes the class.
and includes a VB script example.
https://msdn.microsoft.com/en-us/library/aa394173%28v=vs.85%29.aspx

The following is a powershell example to query WMI.
https://technet.microsoft.com/en-us/library/ee176860.aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.