IT Asset Status

dvientos
Kilo Explorer

Does anyone know if a history is kept for the IT Asset Management field "status" as it changes?

We want to be able to know when a status goes from one status to another. For example from status "received" to status "in use". I hope there is a time stamp so that we can determine how long it took for the asset to go from one status to another.

Thanks,

Domenic

4 REPLIES 4

prdelong
Kilo Guru

If you enable the audit attribute on the cmdb_ci table, you can create a metric definition and track it that way.

wiki.servicenow.com/index.php?title=Metric_Definition_Support


dvientos
Kilo Explorer

How do I enable the audit attribute on CMDB_ci table?


I should actually clarify. You don't want to audit the entire cmdb_ci table. That will eventually effect instance performance if you are running any type of auto-discovery tool and is not needed. You should enable auditing on the cmdb_ci_hardware table, but it should already be OOB. Creating a metric definition for the install status field should let you do what you are looking for.


fran14
Kilo Explorer

IT Asset Management starting in Berlin does have new tables.



You need to be an admin to turn on auditing.



The easiest way to turn on Auditing for you all your hardware assets (all fields) is:



- Log in as a sys admin


- Go to Asset Management and open a record in 'Hardware Asset'


- Right click on header.. choose Personalize Dictionary


- In the collection record for ALM_Hardware, edit the audit field and change the false to true.




Now when an asset record field (for any hardware) is changed, you can right click on the header again, go to History..List and view all the history / audit data.



Fran.