rob3770

A simple command which displays certain services within a file listing of servers... wmic /output:"e:\scripts\service check\test\Services_Before.csv" /NODE:@"e:\scripts\service check\test\servers.txt" /failfast:on service where (name="clipsrv" or name="asfagent" or name="alg") get caption,startmode, state, status /format:csv The output is within one excel cell and has to be manually edited via excel to seperate the comma delimiters, once this is done another script runs and produces an after csv file, this file is then compared to the first and any differances are highlighted. Im trying to automate the output so that the end user doesn't have to manually edit the file and when opened it will already be seperated. OS's are Windows 2000/2003/2008

I can't enclose anything as its an automated output

Hi, This is the WMIC output in CSV format... Node,Caption,StartMode,State,Status TSER-RKER-01,ASF Agent,Auto,Running,OK In order to have them comma seperated within Excel then the app needs to be open and Text to Columns needs to be played with. This is the output im after... Node Caption StartMode State Status TSER-RKER-01 ASF Agent Auto Running OK

Im scripting a WMIC batch job which will run against a list of live servers and services, it will list out the required servers and output them too a CSV file. Now thats simple but the output needs to be auto sorted in a spreadsheet when opened, not like this (service,type,running,auto,etc). Is there a why for this to be done as there will be another one created that should compare the 2 spreadsheets and display the differances for powerdowns etc. Cheers guys and gals Rob