Vbscript audit software
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. When adding these scripts to my existing script it comes up with multiple errors or loops and crashes my PC. VB scripts are a thing of the past and so are bat files.
The company doesn't know what they don't know which is why they would want to stick with the status quo. Be the hero and learn some basic Powershell and the possibilities for automating many Windows processes.
I have tagged someone that probably has something written that you can use. The issue is that I found that using Windows 7 like we do currently it will not properly export to a csv file. I have it set to export to a. As for your suggestion, Rockn, of learning power shell, I will be learning it. This is just a temp solution before I learn enough ps to create what I need. Neally, I looked at that link and was mind blown, ps is too new for me considering what I have knowledge of at the moment.
I downloaded it but could not get it to work in our environment with my lack of knowledge on editing scripts. Here is the. Just to give you an idea of my lack of knowlege, I started this job only 4 months ago and had never touched code of any sort prior.
I was given one bat file as a template to install a program remotely. Everything else I have done has been based off the one template, and lots of research online. We have everything saved to a target. We need it to export to an excel document with the listed info above across the top row, and then the pc info for each to populate below them in their respective columns.
We do not want it to loop through our AD, we only have a small list that we are given at at time, usually only about 10 - 15 pc's. SystemName Next. Quit end if. Function HostOnline strComputername. In my next blog entry, I will start with reading an Excel spreadsheet using VBScript and continue on to incorporate this script. Your email address will not be published.
Save my name, email, and website in this browser for the next time I comment. Thanks for the comment. 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. Parsing and using Out-GridView to display the output against a file that could possibly contain several thousand lines of information would slow things down quite a bit.
Just right-click a system, click WindowsUpdateLog in the shortcut menu, and then click one of the four options Last 25 , Last 50 , Last , and Entire Log to have the utility grab the remote log and display it.
While not necessarily needed, I figured I would add an option to view the currently installed updates on one or more remote systems. Just select the systems, right-click Installed Updates , and then click View Installed Updates in the shortcut menu. After all of the updates have been gathered, you can then view the installed updates on each system. I hope everyone enjoyed this post displaying some of the new features of my latest project. This is a work in progress and will have more releases in the future.
If you have any feature requests or any bugs that you find, be sure to log them in the Issue Tracker on CodePlex. Tomorrow, I will address some issues I ran into while creating this utility and the steps I took to resolve them. I promise you will see some code in that post. I invite you to follow me on Twitter and Facebook. If you have any questions, send email to me at scripter microsoft. See you tomorrow. Until then, peace. Comments are closed. Scripting Forums. PowerShell Forums.
Comments
Post a Comment