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?
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 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.

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
Answered 03/05/2012 by: GillySpy
Seventh Degree Black Belt

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