Software Report Excluding Updates
How do I get a report to find all servers beginning with ABC and list the software installed excluding for example, "Update for Microsoft" and "Security Update for Microsoft" and "Microsoft Visual C++"..........
Do I need a SQL query or can I use the wizard. Everything I try ends with no results of anything.
Answers (1)
Top Answer
You can manually enter a SQL query or use the wizard to generate the required SQL query in the Reporting module.
In some cases, the wizard may not have an option to meet your requirements for the report output. Creating your own SQL query may be your best option.
Note: The device detail page Installed Software list concatenates the SOFTWARE.DISPLAY_NAME with the SOFTWARE.DISPLAY_VERSION. The SQL query will fail if you use the Software name from the UI in the where clause.
Here is a working SQL example that excludes two software items in the report output. ('Microsoft Visual C++ 2010 x64 Redistributable - 10.0.40219', 'Mozilla Firefox (x64 en-US)')
Select MACHINE.NAME,
SOFTWARE.DISPLAY_NAME
from MACHINE
join MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID
join SOFTWARE on SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
where SOFTWARE.DISPLAY_NAME not in ('Microsoft Visual C++ 2010 x64 Redistributable - 10.0.40219', 'Mozilla Firefox (x64 en-US)')
This basic example can be modified to include other MACHINE or SOFTWARE table columns.
Comments:
-
Thanks, the issue is we have no local SQL admins to help so we have to piece things together. - lama01 9 months ago
-
So how do you get all the software listed on one line for each server instead of 1 line per software? - lama01 9 months ago
-
Select MACHINE.NAME,
GROUP_CONCAT(SOFTWARE.DISPLAY_NAME SEPARATOR ', ')
from MACHINE
join MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID
join SOFTWARE on SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
where SOFTWARE.DISPLAY_NAME not in ('Microsoft Visual C++ 2010 x64 Redistributable - 10.0.40219', 'Mozilla Firefox (x64 en-US)')
GROUP by MACHINE.NAME - KevinG 9 months ago-
Thanks! - lama01 9 months ago
