Asset audit date for Asset Management

[dmitrib]

Hi all,

I was wondering whether any of you has found/used any out-of-box fields in the Asset Management module to track the last date that a physical inventory/audit of assets has been done. For example, if we have a PC at a desk in the Boston office and we go through and scan that PC, thus acknowledging it exists and update that entry in the CMDB (and then do that for a few floors or for an entire office), where could we put the date of that office audit?

I am asking this, because we realized the Last Updated field that's out-of-box doesn't really cut it here, as this could be updated by a manual or automated update to the record, which could happen without an audit taking place. We need to be able to see what assets were last updated in which audit. This way, we could improve the accuracy of the CMDB by seeing what assets have not been picked up in audits and thus should be marked as Missing.

Happy to listen in on your opinions!

Thanks!

[eican]

There is always the option of creating one — that way you are safe that no SNC function will overwrite its value.

[geoffcox · Accepted solution]

We have added many such fields: Last Audit Date, Last Opsware Sync Date, Last BladeLogic Sync Date, Last Install Status Change Date, etc.

You then need a line of code in the audit script to timestamp your audit (populate the new field with the current date/time).

current.u_last_audit_date = gs.nowDateTime();

Cheers,

                  Geoff.

[dmitrib]

Thanks Geoff! We've implemented something similar meanwhile - through loads. Will look to automate more of it.

[geoffcox]

Great! Please mark the question as answered if my suggestion was helpful to you.