/build/static/layout/Breadcrumb_cap_w.png
10/02/2017 822 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