List file counts per group?

Richard_Hardacre_(richard.hardacre@uk.qioptiq.com_

I'm attempting to put together some SQL which will show file counts by group (probably via owner's primary group) but so far my understanding of the schema (9.1 at the mo) is failing me and nearly everything is aligned to "Coordinators". We don't have any projects set up, just a bunch of root folders, usually with group permissions on them.Anyone got any clues, i could show my dodgily joined SQL here but it's probably way up the wrong tree!

Tim_Hunter

just confirming what you are asking? I have something similar you can probably edit.SELECT A.DATAID as folderid,D1.NAME as ObjectName,D1.DATAID,nvl(st.subtype, 'UNK: '||d1.subtype) as ObjType,CASE A.RIGHTIDWHEN -1 THEN 'Public Access'WHEN -2 THEN 'System Administrators' ELSE 'Group ID: ' ||A.RIGHTID END as privsassignedto,(CASE WHEN mod(floor(A.PERMISSIONS / 2),2) = 1 then 'S' else null end)||(CASE WHEN mod(floor(A.PERMISSIONS/36865),2) = 1 then '/SC' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/65536),2) = 1 then '/M' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/16),2) = 1 then '/EP' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/131072),2) = 1 then '/EA' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/4),2) = 1 then '/AI' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/16384),2) = 1 then '/DV' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/8),2) = 1 then '/D' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/8192),2) = 1 then '/R' else null END)as PERMISSIONS,K.NAME as GroupNameFROM DTREE D1, DTREEACL A, KUAF K ,ll_subtypes stWHERE A.DATAID = D1.DATAID /* AND A.ACLTYPE = 0 *//* AND D1.SUBTYPE = 0 -- FOLDERS ARE 0 */AND D1.subtype = st.id(+)AND K.ID = A.RIGHTID AND A.RIGHTID IN (%1)ORDER BY K.NAME, D1.NAME