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?
1 Comment
[ + ] Show comment
Answers (2)
Please log in to answer
Posted by:
chucksteel
6 years ago
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
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.
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
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