Miscellaneous

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