Maximo List Archive - ASSET COUNT by month

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.

ASSET COUNT by month

From: Javaid Ansari (2014-09-17 17:37)

Hello Gurus, I am trying to pull the Asset data from query for following:
ASSET TYPE, CLASSIFICATION, MONTH, COUNT
select A.ASSETTYPE, CS.DESCRIPTION, to_char(changedate,'mon-yyyy') count(*)
from ASSET A, CLASSSTRUCTURE CS
WHERE A.CLASSSTRUCTUREID=CS.CLASSSTRUCTUREID
and a.STATUS IN ('ACTIVE','IDLE DISCONNECTED','INVENTORY','NEW REVIEWED','PENDING SALE','IDLE CONNECTED','SURPLUS CONNECTED','CRITICAL SPARE')
GROUP BY A.ASSETTYPE, CS.DESCRIPTION, to_char(changedate,'mon-yyyy')
ORDER by a.assettype, CS.DESCRIPTION, to_char(changedate,'mon-yyyy')
My delimma is change date is updated whenever there is a modification in the asset. Is there any CREATION date which I can utilize in query?
Thanks
Javaid

From: peter.males (2014-09-18 02:26)

could use min(changedate) from assetstatus table - this should give you the asset creation date.