Reporting on assets that have been in certain state for a number of days?

[SebastianBarnes]

Hello everyone,

I am trying to report on all assets that have been in a particular state for > 60 days so that they can be researched. Has anyone tackled something like this before? It seems like this may be a good candidate for using Performance Analytics, but I wanted to check here first.

If someone does leverage Performance Analytics for this, could you please provide some insight on how you approached this?

Thank you in advance, 

Sebastian

[AshishKM · Accepted solution]

Hi @SebastianBarnes ,

You can try with metric definition on alm_asset table and calculate the duration for state change. 

Later you can create report on metric_instance table.

-Thanks,

AshishKMishra

[SebastianBarnes]

Hi Ashish, this is a great suggestion. I will start here.

Thank you!

[AshishKM]

Hi @SebastianBarnes, Thank for marking accepted solution/helpful, happy to help that my reply works for you.