Export custom inventory fields for archived Windows devices. SQL query?
our Windows clients are automatically archived after 90 days offline (MIA) and can then only be found under the assets. When I create reports (analysis_report_list.php) I can query the custom inventory fields of active devices but not archived assets?
How can I retrieve custom inventory fields from archived assets? In that case I would like to have an report of archived asset that contain these informations:
- Asset ID
- Device name
- CIR (software.php?ID=381)
Is such a query possible via SQL or another way?
Be the first to answer this question