Query: ibm_is_security_group_age_table

select
  sg.name as "Name",
  sg.id as "ID",
  now()::date - sg.created_at::date as "Age in Days",
  sg.created_at as "Create Time",
  a.name as "Account",
  sg.account_id as "Account ID",
  sg.region as "Region",
  sg.resource_group ->> 'name' as "Resource Group",
  sg.crn as "CRN"
from
  ibm_is_security_group as sg,
  ibm_account as a
where
  sg.account_id = a.customer_id
order by
  sg.name;