Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
  • 631 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