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 |
|
