SELECT CASE WHEN t14.name IS NULL THEN 'n/a' ELSE t14.name END AS "Name", CASE WHEN t14.location IS NULL THEN 'n/a' ELSE t14.location END AS "Address", t6.model AS "type", t6.version AS "Version", ostype||' '||osversion AS "OS", to_timestamp(cast(t0.time AS text),'YYYY-MM-DD HH24:MI:SS.MS') AS "Lastest Heartbeat Interval", CASE WHEN cast(to_char((now()-t0.time AT TIME ZONE 'GMT'),'SSSS') as numeric)