how can I print an inventory report on just one computer
I would like to print the inventory of just one computer
2 Comments
[ + ] Show comments
-
Do you mean custom inventory or all the program's installed ? - rock_star 9 years ago
-
I mean, one device/computer and all its software that is installed on it - jarvies 9 years ago
Answers (2)
Please log in to answer
Posted by:
rock_star
9 years ago
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
Posted by:
aragorn.2003
9 years ago
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
