/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comment

Comments

  • 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.
    • 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.
      • I just like to keep the table clean. I created a work around, will post the answer.
Please log in to comment

Answer this question or Comment on this question for clarity

Answers

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

Answered 03/29/2018 by: chucksteel
Red Belt

Please log in to comment

Share