ITNinja Question

List of all Assets

03/05/2012 1697 views
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


Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

All Answers

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

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ