Report of all software installed on 1 pc
I need to create a report I can run to export a list of all software installed on a particular pc. I thought I could do this with the inventory tab of the K1000 box, but I can't seem to figure that out. Any suggestions? I'm getting ready to deploy Windows 7 to a few pc's and I need a complete list of everything they currently have so I can get it set back up. Thanks.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
jmcelvoy
12 years ago
I have this report that lists all software installed on ALL computers. How would I modify this to just get the software from 1 computer?
Select CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) as MACHINE_NAME, DISPLAY_NAME, DISPLAY_VERSION, PUBLISHER from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE)
where
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and
SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
and not IS_PATCH
order by MACHINE_NAME, DISPLAY_NAME
Select CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) as MACHINE_NAME, DISPLAY_NAME, DISPLAY_VERSION, PUBLISHER from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE)
where
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and
SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
and not IS_PATCH
order by MACHINE_NAME, DISPLAY_NAME
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.