/build/static/layout/Breadcrumb_cap_w.png

Search for smart filter turns up no results but should

We have many software entries in the software catalog that are not installed on any device. However, when I try to create a smart filter, it says no results. Please see the image for a reference. If there are devices that show 0 under the devices column, why does the search not show any results when using that criteria?
UHfUgo.png

1 Comment   [ + ] Show comment
  • When you perform a search using Devices it actually performs a search for machines that have the software title installed, even though the column shows the number of devices. That is very counter intuitive. That might be worth submitting a ticket to Quest as a bug, or a feature enhancement.

    When I want to clear out the software inventory, I sort on the Devices column, make sure all of the titles on the page = 0 and then select all, choose action, delete. - chucksteel 6 years ago
    • What are the pros and cons of deleting software from the catalog vs leaving them - other than the obvious of thousands of software listings you have to sort through.

      Also, where is the page to submit a bug or feature enhancement? I have found it before but it is never easy to find on their site. - jessburd 6 years ago
      • I just like to keep the table clean. I created a work around, will post the answer. - chucksteel 6 years ago

Answers (2)

Posted by: chucksteel 6 years ago
Red Belt
1
I found a way to create a smart label that works:
Create a smart label using Devices = 0 (it won't return any results)
Browse to Home, Label Management, Smart Labels
Find the smart label you just created and open it
Click on the Edit SQL button
Replace the SQL query with this:
SELECT DISPLAY_NAME, PUBLISHER, SOFTWARE.ID as TOPIC_ID, 
(SELECT COUNT(MACHINE_ID) FROM MACHINE_SOFTWARE_JT WHERE SOFTWARE_ID = SOFTWARE.ID) AS MCOUNT
FROM SOFTWARE  
HAVING MCOUNT = 0
Save the smart label
Profit


Comments:
  • I know this is a little old now, but thanks! I've been trying to figure this out for more than 2 years now! - aparten 5 years ago
Posted by: Drave 6 years ago
Purple Belt
0
Make sure to have your label updating prioritized properly i definitely had an issue with labels not listing devices in that column but had devices when you actually looked in the smart label.

Ill expand on how to do this when i get to my computer.
 
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