/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Is there anyway to get at the date information in an asset record

05/11/2020 137 views

I am trying to write a report that shows assets and they date of when the record was created and last modified. How do I get access to that information either in a report or list display.

0 Comments   [ + ] Show comments

Comments


All Answers

0

Try using this SQL in a report, and maybe add Break on Column ASSET_TYPE.NAME


SELECT ASSET.NAME as Asset_Name, 

ASSET_TYPE.NAME as Asset_Type, 

ASSET.CREATED as Created_Date,

ASSET.MODIFIED as Last_Updated

FROM ASSET    ASSET

     INNER JOIN ASSET_TYPE ASSET_TYPE

        ON (ASSET.ASSET_TYPE_ID = ASSET_TYPE.ID)

WHERE ((ASSET.ASSET_TYPE_ID = 5) OR (ASSET.ASSET_TYPE_ID > 10))

GROUP BY ASSET_TYPE.NAME


I've just called the relevant fields from the main ASSET Table, joined the ASSET_TYPE table so you can get the asset type name rather than ID.

I have also restricted the types of assets included, in the Where statement to Asset ID 5 - Devices and anything over Asset ID 10, so every custom asset type


Answered 05/12/2020 by: Hobbsy
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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