/build/static/layout/Breadcrumb_cap_w.png

Tracking deleted assets

Hello!

I've raised the issue of tracking deleted assets with Dell Kace support and they have noted it for future enhancement if enough people request it. But it wont be added to the Kbox's functionality at the moment which leaves me in a position needing to think of alternative ways to acheive the same.

Essentially I need to be able to keep track of Assets that are deleted for auditing purposes, somehow. At the moment, an asset has its own 'history', when it was created, changes made to its name or other attributes etc. But when the asset is deleted from the Kbox, thats it, its gone!

The fear is a few assets could be deleted maliciously or accidentally and over time the list of assets would become increasingly inaccurate. This would be our main day-to-day asset tracking system and whilst there would be a paper trail of purchase orders and invoices for hardware, if for example a laptop was deleted from the Kbox and stolen we wouldn't necessarily know.

I've been thinking and it would be easy to create a custom Helpdesk rule that regularly emails a list of all the Assets. Then some other mechanism would need to read the email, perform the comparison of lists and trigger alerts to warn us.

Ideally this would be peformed within the Kbox though. e.g. everytime an asset is deleted a note is recorded within a new table, that we could then lookup. Or an email is sent when an asset is deleted.

This is my problem. Any help or suggestions would be greatly appreciated! My IT Director is refusing to let us change over to the Kbox as our primary asset tracking system until this problem is addressed. [:(]

0 Comments   [ + ] Show comments

Answers (7)

Posted by: serkowski 12 years ago
Senior Yellow Belt
0

Anyone come up with a solution for this?

So far, the "best" solution I can think of is to do this offline by comparing daily database backups.  Ugh!

 

Posted by: ptandoc 10 years ago
Senior Yellow Belt
0

You can find this in Settings -> History -> Asset History Listing.  Do an Advance Search and there's a dropdown box for Change Type and Deletion is one of the options (we're on inversion 5.4.7684).

Posted by: GillySpy 13 years ago
7th Degree Black Belt
0
You could schedule a report as an email. You could have a VMWare standby (this is an option you can purchase via sales) and if a delete happens by accident you could bring up your backup (make sure you isolate the virtual network) and export it off of the VM.

And of course, you are taking daily backups
Posted by: stubox 13 years ago
Blue Belt
0
Thanks Gilly

Yep we backup the Kbox every night. Your idea would be good for restoring accidentally deleted assets but it doesn't address the problem of how to tell if an asset has been deleted. Unless I have completely misunderstood your post? A scheduled report (as an email) identifying deleted assets would be perfect!
Posted by: GillySpy 13 years ago
7th Degree Black Belt
0
There would be no way of knowing that for sure. Very kludgy but the ASSET.ID column is sequential so you could keep track of the number of gaps. An increase in the ID should match the number of new assets. Any discrepancy means that assets were deleted.

e.g
Day 1: 1,2,3,5
Day 2: 1,3,5,6,7,9

on Day 1 you knew what you had. On Day the number went up by 4 but the count only went up by 2 which means 2 were deleted. Item #2 would be in the backup. Item #8 was created and deleted the same day so is lost.
Posted by: stubox 13 years ago
Blue Belt
0
Good idea Gilly, we may fall back on this if my app doesnt work.

At the moment I'm working on a VB.net app that reads the Asset table for a list of Asset ID numbers, takes the Asset_Type_ID to find the associated details from the Asset_Data_x table and stores it all in a CSV. Then on subsequent runs compares the live Asset table with the CSV to find missing assets, and if it does it emails the Asset_Data_x to an administrator. Pretty simple VB stuff really.

If/when its working I'll post again.

N.B. Asset_Data_x - the x is the table number, e.g. Asset_Data_19 in our Kbox DB holds the name and type of thin client devices.
Posted by: Wildwolfay 10 years ago
Red Belt
0

You could create a whole new asset_DATA_table and make it the historical table?  Set it up so anything placed in another ASSET_DATA_## also creates in the ASSET_DATA_##History but does not delete from that backup asset_data.  Granted your doubling the amount of information you have but you can have 1 active and 1 that stay historically the same (or collects data actively, but does not remove)

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ