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

SebastianBarnes · ‎11-15-2023

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 · ‎11-15-2023

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

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

View solution in original post

AshishKM · ‎11-15-2023

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

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

SebastianBarnes · ‎11-15-2023

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

Thank you!

AshishKM · ‎11-15-2023

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

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution