query help needed

[hougaard]

Does anybody know if the following is possible.

By mistake we have uninstalled a programme on several pc's with sms. we have managed to rebuild everything again, but not all. I would like a query that can find a .exe file in the windows/system32 directory but another .exe file should not be in the programme folder. In that way i could find pc's that have had the programme installed before, but the programme is now gone, as this .exe file is no longer in the programme folder.
make any sence??

 

[Jerz]

Can you just run the standard report to see what machines have the first.exe in system32 (indicating the program has been there onec upon a time), export to excel, run again to see where second.exe is currently, export to excel. Use excel to 'subtract' the second list from the first (pivot table). This will leave you with who still needs it re-installed. Put them in a collection, and target away.

There is probably a way to write this right into a dynamic query-based collection, but that's not my skillset, I would grind it out as mentioned above....

David J.

 

[hougaard]

Hello Jerz.
Thanks for your answer. This I have done, but it leaves me with several hundreds of pc's which I need to manually type into a collection, I will do this as a last solution, but I hope someone knows a way to do it directly in sms.

 

[tbrennans]

Yeah download one of the many "copy" programs out there that imports text files into collections, such as

http://www.myitforum.com/articles/8/view.asp?id=1309

There are a few sms console plugins that do this also.

SMS 2003 sp3 breaks most of them :-(

 

[imesun]

You can run a query for all the systems who have it installed the exe being a criteria. Then create a sub selected query of all systems not in the first query. That should return all the systems that got the application removed.

Hope I understood the problem correctly.