I would like to print the inventory of just one computer
2 Comments   [ + ] Show Comments

Comments

  • Do you mean custom inventory or all the program's installed ?
  • I mean, one device/computer and all its software that is installed on it
Please log in to comment

Answers

0
select
    S.DISPLAY_NAME as SOFTWARE_NAME,
    S.DISPLAY_VERSION as VERSION,

from MACHINE M

left join MACHINE_SOFTWARE_JT MSJ ON M.ID = MSJ.MACHINE_ID
left join SOFTWARE S ON MSJ.SOFTWARE_ID = S.ID

where M.ID = 1
Answered 03/30/2015 by: rock_star
Black Belt

Please log in to comment
0
You can also create a normal device report with all columns you need and create a filter.

System Name = COMPUTERNAME or
System Name contains COMPUTERNAME


Answered 03/31/2015 by: aragorn.2003
Red Belt

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

Share