device42 / doql_scripts_examples Goto Github PK

----------- POST FUNCTION -----------
https://192.168.0.151/services/data/v1.0/query/
Status code: 200
Query: select sip.ip "IPv4 or IPv6 Address", d.device_pk, a.appcomp_pk, s.software_pk, si.serviceinstance_pk, d.asset_no "UNIQUE ASSET IDENTIFIER", d.virtual_host "Virtual", null "Public", (select string_agg(f."URL", ', ') from view_device_custom_fields_flat_v1 f where f.device_fk = d.device_pk) "URL", null "NetBIOS Name", null "MAC Address", null "Authenticated Scan", null "Baseline Configuration Name", d.os_name "OS Name", d.os_version "OS Version", r.name "Location", null "Asset Type", null "Hardware Make/Model", null "In Latest Scan", v.name "Software/ Database Vendor", s.name "Software Name", su.version "Software Version", null "Patch Level", null "Function", s.notes "Comments", null "Serial #/Asset Tag#", sn.network "VLAN/Network ID", null "Administrator/ Owner", null "Application Administrator/ Owner" from view_appcomp_v1 a join view_device_v1 d on d.device_pk = a.device_fk join view_softwareinuse_v1 su on su.device_fk = d.device_pk and su.appcomp_fk = a.appcomp_pk join view_software_v1 s on s.software_pk = su.software_fk join view_serviceinstance_v1 si on si.device_fk = d.device_pk and si.appcomp_fk = a.appcomp_pk join view_serviceportip_v1 sip on sip.mapped_serviceinstance_fk = si.serviceinstance_pk left join view_room_v1 r on r.room_pk = d.calculated_room_fk left join view_vendor_v1 v on v.vendor_pk = s.vendor_fk left join view_ipaddress_v1 ip on ip.ip_address = sip.ip or case when family(ip.ip_address) = 4 then host(('::ffff:' || ip.ip_address::text)::inet)::inet else null end = sip.ip left join view_subnet_v1 sn on sn.subnet_pk = ip.subnet_fk LIMIT 1000 OFFSET 0
------- END OF POST FUNCTION -------