VBS to check Date Modified on multiple exes in a directory on multiple servers and report versions to an excel spreadsheet
Posted on 2011-03-22
Here is my senario
I have 5 servers that run an application. This application lives in a directory c:\ProgramName
and in this directory there are quite a few exe files that are updated on a regular basis from a network directory \\Server\share\newreleases
I need a script that will check the Date Modified on all EXEs in the C:\ProgramName directory on each server and output it to an excel document in a colum for each server.
I also need a 6th colum that will check the \\server\share\newreleases directory and output it to the same excel spreadsheet so I can compare the versions
Server1 Server2 Server3 Server4
A.EXE - DateModified A.exe - Datemodified A.exe - Datemodified A.exe - Datemodified
Pretty much it is a listing of all the Modified dates of all exes in each servers c:\programname directory and a network share that holds the latest exes
I need it to be as organized as possible and something that I can run on the fly to check the modified dates of all servers against the \\server\share\newreleases directory.
I need to be able to run this script from one location as a scheduled task so I can not put a copy on each server. It must be central.