Discussion Locked

SMS queries for MS products?

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone have experience of writing SMS queries to search for MS products such as Visual Studio, SQL Server etc?

I'm finding that a product-based software search will return inaccurate results, as many of our PC's which do not have these products installed, do have distributed files with the product name in the file headers.

Any info on creating definitive search criteria would be greatly appreciated.

6 replies

by hstahl

I've faced similar issues writing queries (and not just MS Products). I haven't found a magic bullet solution to the problem, but do have some general guidelines I've come up with:

- If possible, search for an *exact* match to either a software name or particular file instead of a "like," e.g. "Word for Windows" or "winword.exe"

- If there is a file name that seems to be common among programs try to find a way to exclude the one you don't want. A "and where not 'Product X'" sometimes works.

- Sometimes searching for the main .exe or main product name isn't the way to go. Instead, find a component that only the install you're looking for has and search for that.

Hope those help.

-Heath

This discussion is closed to new replies.