Software query needed
If you don't mind, I need a MySQL query that will show me every software title in the system (currently running build 6010) that is currently not listed as installed on any workstation in the inventory.
To clarify, when I bring up the master scanned software list, it shows how many workstations each title is installed on, and several are 0 meaning they were once installed, but aren't anymore. Since there are thousands of titles in the list, I would like this query so that it is easier to find and remove unused software titles from the list.
Additionally, if you could add a cleanup feature in a future release that would allow a person to quickly delete any unused software titles, that would be helpful for maintaining a clean software list. Then again, maybe something like this already exists in version 7 and I just haven't seen it yet.
To clarify, when I bring up the master scanned software list, it shows how many workstations each title is installed on, and several are 0 meaning they were once installed, but aren't anymore. Since there are thousands of titles in the list, I would like this query so that it is easier to find and remove unused software titles from the list.
Additionally, if you could add a cleanup feature in a future release that would allow a person to quickly delete any unused software titles, that would be helpful for maintaining a clean software list. Then again, maybe something like this already exists in version 7 and I just haven't seen it yet.