I am baffled by an issue searching SW inventory. I query “Adobe Acrobat” and get full result of all Adobe Acrobat, However when refining the search for “Adobe Acrobat 9”, I only get results containing “Adobe Acrobat 9 Pro”, no results for ”Adobe Acrobat 9 Standard” are returned. Further refining the search to “Adobe Acrobat 9 Standard” returns ZERO results, when there are actually 11 Software Inventory items for "Adobe Acrobat 9 Standard" (multiple versions) Is this a bug? Or am I overlooking search parameters?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
I'm not sure if you are searching in the web console or using the SQL browser or a SQL report to display results. If you are using SQL, you'll need to use the percent (%) symbol as a wildcard - i.e. "Adobe Acrobat 9%".
Answered 02/24/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Take a very close look at the number of spaces in the software name vs. what you type. I'll bet there's an extra space or two in there.

Regular expressions can be your friend in a case like this. Something like

Adobe\s+Acrobat\s+9\s+Standard

would probably give good results.
Answered 02/24/2010 by: jkatkace
Purple Belt

Please log in to comment
0
I am using the web console and I am actually cutting pasting the name to ensure it is exact with no extra spaces
Answered 02/24/2010 by: mlathrop
Fifth Degree Brown Belt

Please log in to comment
0
If you're certain then I would open a ticket for this.

If I got this ticket I would ask for some more evidence. I would like to see the output of this query:
select DISPLAY_NAME, HEX(DISPLAY_NAME) from SOFTWARE WHERE
DISPLAY_NAME LIKE '%Adobe%' ORDER BY 1

http://www.kace.com/support/customer/faq/index.php?action=artikel&cat=9&id=10&artlang=en
Answered 02/24/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share