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

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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
Answered 05/05/2011 by: jmcelvoy
Second Degree Blue Belt

Please log in to comment
Answer this question or Comment on this question for clarity