Report of all PCs and their Add/Remove Software List
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
Answers (1)
Please log in to answer
Posted by:
sarahrs
7 years ago
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
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 - sarahrs 7 years ago