/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Report of all PCs and their Add/Remove Software List

10/02/2017 887 views
I am trying to make a report that will output to excel. It needs to list the PC in the first column. The Software in the second column.

Now I have been able to get close to this but as this information is in 2 different tables, I cannot get it setup so that I can use the filter feature in excel.

So, does anyone have some sort of list or table of what the SQL tables and fields are? Or would someone work with me on getting something put together?

Thanks in advance.
1 Comment   [ + ] Show comment

Comments

  • select SOFTWARE.DISPLAY_NAME,
    SOFTWARE.DISPLAY_VERSION,
    MACHINE.NAME as Computer_Name

    from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE)

    where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
    and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
    and not SOFTWARE.IS_PATCH
    order by SOFTWARE.DISPLAY_NAME

All Answers

0
select SOFTWARE.DISPLAY_NAME,
SOFTWARE.DISPLAY_VERSION,
MACHINE.NAME as Computer_Name

from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE) 

where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID 
and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID 
and not SOFTWARE.IS_PATCH
order by SOFTWARE.DISPLAY_NAME
Answered 10/04/2017 by: sarahrs
White Belt

 
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