- With the release of 17.11, Device42 gave customers the ability to Archive Devices instead of deleting for better tracking of device history. To view Archived Devices, in the Main Appliance, navigate to Analytics->Audit Logs->Archived Objects. To export a list of your Archived Devices, navigate to Tools->Saved DOQL Queries. Click “Add Saved DOQL Query”, give it a name like Archived Devices, and then paste the query below. Click Save and then find it in the list of Queries and click on the Query URL to run the report.
WITH archived_objects AS
SELECT view_archivedobject_v2.archivedobject_pk AS id
,jsonb_array_elements(view_archivedobject_v2.details -> 'ip_addresses')->>'ip_address' AS ip
SELECT view_archivedobject_v2.archivedobject_pk AS "ID"
,view_archivedobject_v2.details->>'service_level' AS "Service Level"
,view_archivedobject_v2.details->'device_os'->>'os' AS "Operating System"
string_agg(a.ip, ', ' ORDER BY a.ip) AS "IP Addresses"
a.id = view_archivedobject_v2.archivedobject_pk