select pg_link(downcase(nvl(system/dns_name,system/name)), '/app/inventory/device/index/'|| /#id) as "Name", join(interface/inet/ip_address, ', ') as "IP Address", last_seen as "Last Seen on Network", /#created_at as "First seen" from /network/device where system is not null and /#created_at > date('7 days ago') order by 4 desc |
|