Asset state is "In stock"

shid077
Tera Contributor

‎11-18-2024 02:26 AM

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

0 Helpfuls
  • 460 Views
4 REPLIES 4

Community Alums
Not applicable

‎11-18-2024 02:38 AM

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-...

 

0 Helpfuls

Runjay Patel
Giga Sage

‎11-29-2024 03:18 AM

Hi @shid077 ,

Follow below steps.

  1. Create one metric definition like below.
  2. RunjayPatel_0-1732878784312.png

     

  3. Create one business rule, open the OOB on which is running on task table and do insert and update.
  4. RunjayPatel_1-1732878942921.png

     

  5. Create report on metric_instance table and filter with metric definition and state value like below.
  6. RunjayPatel_2-1732879087555.png

     

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

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

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

0 Helpfuls