As part of the pre/post patch or software deployment activity, system admins go through a tedious process of checking free space on all the servers. Sometimes sysadmins are even asked to check if the server was rebooted after the deployment. The script that I am sharing caters these requirements. All you need is excel and admin privileges to query remote machines from your computer.
The script runs a few remote wmi queries to get uptime data and System drive space details.
All you need to do is insert the list of host names or IP addresses in the Column A (starting A2) and hit the execute button.
Note – Make sure you enable macros in case its not enabled. You can always view the underlying code by clicking on the view code under developer tab.(Refer to my article in case the developer tab is not enabled by default) Although the script has been tested on various operating system, it is recommended that you run the script on a test server or lab environment first.
Let me know how it works for you all.