Scripting

Hi everyone,

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?

Many thanks