Asset state is "In stock"

[shid077]

How can i find out or calculate how long the the Asset state is "In stock" from alm_asset table.

[Community Alums]

Hi @shid077 ,

Please follow this thread : https://www.servicenow.com/community/sam-forum/i-need-to-calculate-no-of-days-the-state-of-asset-is-...

[Abhishek Varma]

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0780039

[Abhishek Varma]

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0780039

[Runjay Patel]

Hi @shid077 ,

Follow below steps.

1. Create one metric definition like below.
2. 
3. Create one business rule, open the OOB on which is running on task table and do insert and update.
4. 
5. Create report on metric_instance table and filter with metric definition and state value like below.
6. 

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------