Edwin M Sarmiento Menu Skip to content. Close oFile. Posted on Tuesday, October 30, Please note: I reserve the right to delete comments that are offensive or off-topic. Leave a Reply Cancel reply Your email address will not be published. During these operations, if the system is not reachable on the network, the Notes column will report it as being offline.
By default, the number of systems that will be run against at a time is So in this latest version, you can now sort a column by clicking it. The following figure shows sorting the Audited column so that the system with the most patches required is first.
Another option I added was the ability to send a reboot command to the remote systems; it will continue to monitor the system until it is back online. To avoid having too many systems being rebooted at one time, I have hard-coded a limit of five systems at a time to be rebooted. If a machine has not been reported as being back online within five minutes, it will be registered as being offline and will need more investigation into the system to see why it has not came back online.
To do this, first select the Reboot option below the server list, and you can choose to run the command against every system by clicking Run. Or you can run the command against a specific computer or computers by selecting them from the server list, right-clicking the server list, and then clicking Run. A warning is first presented advising the user that the computer will be rebooted if the user chooses to continue.
Clicking Yes will continue the reboot process. When completed, you will see the Completed note in the Notes column or the Offline note. Another option implemented in version 1. This is done by selecting the Test Network Connection check box, clicking Run or selecting the systems, and clicking Run from the menu when right-clicking the server list.
As you can see, two systems are online and the rest are offline. Note that the total time to perform this was just less than 13 seconds. I thought that this would be a nice and obvious addition to this utility. One big caveat is that this can only be run against one system at a time.
Here is the script:. Application" objExcel. Add objExcel. Cells intRow, IntCol. Cells intRow, 2. Range "A1:E1". Select objExcel. OpenTextFile "MachineList. Cells intRow, 3. Cells intRow, 4. I have no clue about powershell. I just learned how to write. I have a script that can pull most of the information, but I can't get the bat file to export properly using WMI.
I have the above script that will export nicely into an excel document. And when doing the audits currently we have to run two different files and then compile them into one excel document to submit up. You should get some real time tools to do this. Regardless, there are plenty of scripts for Powershell on this site that could be tweaked to meet your needs.
Is there anything special that has to be done to ps scripts to convert them to vbs? The company leans towards either bat files or vbs, and like I stated I am completely new to any of this so I wouldn't know where to begin.
I have looked all over the web and have found various scripts that will pull just the IP Address, however none that pull all the data we need. How to Audit Installed Software from the Command Line This article explains how to extract information installed on the local or remote PCs by executing Windows commands from the command-line prompt.
Getting a Software Audit Information Using WMI Windows Management Instrumentation WMI is a special system interface that provides an access for Windows components and external applications to the system information that includes software inventory data. Related Articles.
Freeware Inventory Utility. Recommended Inventory Tool. Useful Resources.
0コメント