How do I create a report based upon when a computer asset was last modified and have it also display the last date modified?

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

Not sure if this is exactly what you need or not, but here are a couple of variations - the computers are listed from most recently modified (top) to least (bottom):

 select A.NAME as COMPUTER_NAME,
A.MODIFIED as LAST_MODIFIED
from ASSET_DATA_5 AD5
left join ASSET A on AD5.ID = A.ASSET_DATA_ID and A.ASSET_TYPE_ID=5
order by LAST_MODIFIED desc

This variation only lists the date modified (drops the timestamp):

 select A.NAME as COMPUTER_NAME,
date(A.MODIFIED) as LAST_MODIFIED
from ASSET_DATA_5 AD5
left join ASSET A on AD5.ID = A.ASSET_DATA_ID and A.ASSET_TYPE_ID=5
order by LAST_MODIFIED desc

Hope that helps!  ^_^

John

Answered 04/19/2014 by: jverbosk
Red Belt

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