This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

WHD - Audit Deleted Assets

If an asset is deleted from WHD is there any trace of it that is viewable from the database?  Is it possible to view recently deleted assets?  I am using a SQL database and WHD 12.5.  Thank you for your help.

  • For consistency, "deleted" things are typically still in the database...they are just marked as deleted in there.

    asset delete.png

    I don't see a field that stores the time it was deleted.

    There is a field in that    asset   table for "last_updated timestamp with time zone".   Although that very well may be it the time you're looking for, it wouldn't necessarily represent when it was deleted since it is possible that something updated the asset record after it was deleted.