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,

Alvaro_de_Andres

select fr.r_folder_path, count(f.object_name) as folders from

dm_folder f,dm_sysobject_r sr,dm_folder_r fr

where cabinet('/yourcabinet', descend)

and sr.i_folder_id = fr.r_object_id

and f.r_object_id = sr.r_object_id and sr.i_position = -1

and fr.i_position = -1

group by fr.r_folder_path