How to view Archived Devices and a Query to report on all Archived Devices

• 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

FROM view_archivedobject_v2

)

SELECT view_archivedobject_v2.archivedobject_pk AS "ID"

,view_archivedobject_v2.object_name "Name"

,view_archivedobject_v2.details->>'service_level' AS "Service Level"

,view_archivedobject_v2.details->'device_os'->>'os' AS "Operating System"

,(

SELECT

string_agg(a.ip, ', ' ORDER BY a.ip) AS "IP Addresses"

FROM

archived_objects a

WHERE

a.id = view_archivedobject_v2.archivedobject_pk

)

FROM

view_archivedobject_v2