Archived Device Detail Report help
I would like to write a report for all Archived Devices. This is found by opening Asset Management>Assets. Then view by Archived Items. From the list here, there are two links for each device. The first opens Archived Asset Detail and has data concerning the date the asset was archived. The second link ***this is what I want to report on*** is opens Archived Device Details. This shows the system name, description, OS name & version, RAM, Processors & software that was installed.
Is there a way to generate a report for this data? Does anyone know which table this data exists in?
Answers (2)
Ok so the main asset information continues to reside in the ASSET table, the archived asset is just marked as archived with an associated date.
This should mean that the associated data should also be in the asset type table, so in the case of Devices that would be ASSET_5 as the asset type id is 5.
If your KACE setup has been configured to write data such as manufacturer and model into the asset data that data should still be in the ASSET_5 table you just need to write the report in SQL to pull out the data for you, using the archive fields in your WHERE statement to only select archived assets
Comments:
-
first - thank you for the reply.
I use a tool called Advanced Query Tool. It allows me to see the database structure and read tables.
Table ASSET_DATA_5 is the closest to the one you mentioned. however, when I open the table, 95% of the values are set to (null). There are a few rows that are not null but they contain pretty much all zeroes.
I have not locate the archive data yet, despite reviewing the contents of all of the tables - rush5150 2 years ago
May have answered my own question. The data that I was looking for was after a unit is archived, where does KACE store the archived unit's name, user, os & other hardware/software data.
It is in the Archive Asset Device table. Hardware information is dumped into a HARDWARE_JSON field in JSON format. The same for the SOFTWARE_JSON field.