We do around 1000 Server patching in a day. As part of patching activity we run a script before patching to get the snapshot of the services and we run the script again after patching to see if there is any problem in any services.
I have a vbs file (enclosed) which will Check:
a) Ping Status
b) RDC Status
c) Last Bootup Time
d) Services with type as Auto and in Stopped state.
Now I have multiple domains and I need to run the VBScript on each and every domain.
My requirement is:
a) To run the script for all domains from One Single domain.
b) Need to modify the vbs script to HTA script which will read the text file and run against all the domains from one domain and result on screen and then option button to export to Excel or CSV. I am OK if it has option where it prompts for username and password with which it will run against all other domains.
c) Script should continue to next server if it has struck at any server.
d) Also can the output have conditional Formatting or you can say treshold, if any server where the ping is failed or RDC is failed or Services are stopped with type Automatic, it should highlight in Red so that we can take quick actions
e) Script already has option to send e-mail and which needs to stay and should send e-mail after the script has completed its job.
I hope I have specified the requirement properly.
If anyone needs any infomation please let me know.