General discussion

Locked

SMS queries for MS products?

By chris.harrison ·
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.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SMS queries for MS products?

by chris.harrison In reply to SMS queries for MS produc ...

Point value changed by question poster.

Collapse -

SMS queries for MS products?

by hstahl In reply to SMS queries for MS produc ...

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

Collapse -

SMS queries for MS products?

by chris.harrison In reply to SMS queries for MS produc ...

The question was auto-closed by TechRepublic

Collapse -

SMS queries for MS products?

by maxwell edison In reply to SMS queries for MS produc ...

Greetings,

Cut and paste this link:

http://www.myitforum.com/

(REMOVE SPACES if they snuck into the pasted URL)

On that page is a downloadable utility that can help you.

Maxwell

Collapse -

SMS queries for MS products?

by chris.harrison In reply to SMS queries for MS produc ...

The question was auto-closed by TechRepublic

Collapse -

SMS queries for MS products?

by chris.harrison In reply to SMS queries for MS produc ...

This question was auto closed due to inactivity

Back to Networks Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums