systeminactivityreport

SELECT system.mgm_id,

    system.system_id,

    system.profile_name AS system_name,

    system.organization,

    system.last_checkin_time,

    (CURRENT_TIMESTAMP - system.last_checkin_time) AS inactivity,

    system.synced_date

   FROM system

  ORDER BY system.mgm_id, system.system_id, system.organization;