Finding no. of subfolder within each folder inside a cabinet

anand_siv

Hi All,

Please let us know if we could execute a query to find out no. of subfolder within each foler inside a cabinet.

thanks,

anand_siv

found below query to find the list of subfolder

select c.r_object_id, c.object_name, count(f.r_object_id) as folders

from dm_folder c, dm_folder f

where folder('/Temp',descend) and any f.i_folder_id = c.r_object_id

group by c.r_object_id, c.object_name, c.r_link_cnt