/build/static/layout/Breadcrumb_cap_w.png

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. 


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: KevinG 10 months ago
Red Belt
0

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 10 months ago
  • So how do you get all the software listed on one line for each server instead of 1 line per software? - lama01 10 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 10 months ago
      • Thanks! - lama01 10 months ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ