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. [:(]
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)
Please log in to answer
Posted by:
serkowski
12 years ago
Posted by:
ptandoc
11 years ago
Posted by:
GillySpy
14 years ago
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
And of course, you are taking daily backups
Posted by:
stubox
14 years ago
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!
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
14 years ago
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.
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
14 years ago
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.
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.
Posted by:
Wildwolfay
11 years ago
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.
so that the conversation will remain readable.