And need to do three things, I would ideally like to do this in the one statement as I want to pipe the output of the command to a graph generator cmdlet - but I will take what I can get!...
1) For each 'Result' value found (will be a folder name) I want to search 4 remote machine paths ('MAC1','MAC2','MAC3','MAC4') to see if the folder exists on these machines - it will exist on one of them and return the appropriate machine name to the piped output of the cmdlet.
2) The 'RunTime' is being output I guess as a formatted number i.e. 20,000. I would like to have this as a straight integer with no comma delimeter. I have tried...
3) At the moment the code searches for 'initiated.txt' files, but I can see the requirements changing to include files of type '*.alo'. Is there a way I can add this as a search option in the statement and populate a new column with something like ALO/TXT to differentiate? This is the least important option at the moment.