Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

query help needed

query help needed

query help needed

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??

RE: query help needed

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.

RE: query help needed

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.

RE: query help needed

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


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

SMS 2003 sp3 breaks most of them sad

RE: query help needed

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close