List of all Assets
Hello,
I need a report that would list ALL assets in the Kace and that would show if the asset has a machine defined as well. Is this possible?
I need a report that would list ALL assets in the Kace and that would show if the asset has a machine defined as well. Is this possible?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
GillySpy
12 years ago
I cannot write this for you since assets have unique meta data in every kbox.
However, the computer assets relationship to a machine is well defined.
However, the computer assets relationship to a machine is well defined.
select A.NAME "Asset Record", IFNULL(M.NAME,'<none>') "Machine Record"
from ASSET A left join MACHINE M on A.MAPPED_ID=M.ID
ORDER BY 2,1
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
