Is there anyway to get at the date information in an asset record
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.
Answers (1)
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
