/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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