How to run a software report excluding baseline programs used by company
I am not an SQL programmer, and I don't see a way to exclude items using the Report Wizard, only include.
I am looking to run a report that shows all software installed on our computers, except this list:
- Office365
- Citrix
- Adobe Cloud
- SimpleHelp
- Sentinel One
- Rapid 7
- G-Selector
- WideOrbit
- Java OpenWebstart
We have a Software report already, but I do not know how to add exclusions:
Select CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) as MACHINE_NAME, DISPLAY_NAME, DISPLAY_VERSION, PUBLISHER from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE)
where
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and
SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
and not IS_PATCH
order by MACHINE_NAME, DISPLAY_NAME
Thanks in advance to any responses.
Answers (1)
I don't think you can add to the "Category" list for the software, but you could use the Notes field on the Software inventory to add codes to mark the software. For example you could add the text [MyCo Base] to the software you want to exclude, then create a query to exclude those items.
Select
Concat(MACHINE.NAME, '|', MACHINE.SYSTEM_DESCRIPTION) As Machine_Name,
SOFTWARE.DISPLAY_NAME,
SOFTWARE.DISPLAY_VERSION,
SOFTWARE.PUBLISHER,
SOFTWARE.NOTES
From
SOFTWARE,
MACHINE_SOFTWARE_JT,
MACHINE
Where
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID And
SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID And
Not SOFTWARE.IS_PATCH And
SOFTWARE.NOTES <> '[MyCo Base]'
Order By
SOFTWARE.DISPLAY_NAME
