/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: airwolf 14 years ago
Red Belt
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%".
Posted by: jkatkace 14 years ago
Purple Belt
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.
Posted by: mlathrop 14 years ago
Fifth Degree Brown Belt
0
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
7th Degree Black Belt
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ