user

 SELECT c.contentid, c.title, s.spacekey, cps.cont_perm_type, cp.groupname

FROM SPACES s
JOIN CONTENT c ON s.spaceid = c.spaceid
JOIN CONTENT_PERM_SET cps ON c.contentid = cps.content_id
JOIN CONTENT_PERM cp ON cps.id = cp.cps_id
WHERE cp.groupname = '<group_name>';

SELECT cwd_user.user_name, 
       cwd_user.active, 
       cwd_user.id, 
       cwd_user.first_name, 
       cwd_user.last_name, 
       cwd_directory.id, 
       cwd_directory.directory_name, 
       To_timestamp(Cast(cwd_user_attribute.attribute_value AS DOUBLE PRECISION) 
                    / 1000) AS last_login_date
FROM   cwd_user 
       join cwd_directory 
         ON cwd_user.directory_id = cwd_directory.id 
       join cwd_user_attribute 
         ON cwd_user.id = cwd_user_attribute.user_id 
WHERE  ( Extract(epoch FROM Now()) ) - ( Cast( 
              cwd_user_attribute.attribute_value AS DOUBLE PRECISION) / 1000 ) 
       >= 
              7776000
       AND cwd_user_attribute.attribute_name = 'lastAuthenticated' 
       AND cwd_user.active = 'T' 
ORDER  BY last_login_date 
           DESC;
 The value 7776000 represents 90 days in seconds (90*24*60*60), you can adjust this value at your convenience.SELECT cwd_user.user_name, 
       cwd_user.active, 
       cwd_user.id, 
       cwd_user.first_name, 
       cwd_user.last_name, 
       cwd_directory.id, 
       cwd_directory.directory_name, 
       To_timestamp(Cast(cwd_user_attribute.attribute_value AS DOUBLE PRECISION) 
                    / 1000) AS last_login_date
FROM   cwd_user 
       join cwd_directory 
         ON cwd_user.directory_id = cwd_directory.id 
       join cwd_user_attribute 
         ON cwd_user.id = cwd_user_attribute.user_id 
WHERE  ( Extract(epoch FROM Now()) ) - ( Cast( 
              cwd_user_attribute.attribute_value AS DOUBLE PRECISION) / 1000 ) 
       >= 
              7776000
       AND cwd_user_attribute.attribute_name = 'lastAuthenticated' 
       AND cwd_user.active = 'T' 
ORDER  BY last_login_date 
           DESC;
 The value 7776000 represents 90 days in seconds (90*24*60*60), you can adjust this value at your convenience.

https://ektron0116.neocities.org/software/0119-2.zip