SW Inventory Item Searching
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
Answers (4)
Please log in to answer
Posted by:
airwolf
14 years ago
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%".
Posted by:
jkatkace
14 years ago
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.
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.
Posted by:
mlathrop
14 years ago
I am using the web console and I am actually cutting pasting the name to ensure it is exact with no extra spaces
Posted by:
GillySpy
14 years ago
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:
http://www.kace.com/support/customer/faq/index.php?action=artikel&cat=9&id=10&artlang=en
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.