摘要:
1.List files and folder in specified folder pathSELECT DISTINCT s.object_name, fr.r_folder_path FROM dm_sysobject(ALL) s,dm_sysobject_r sr,dm_folder_r...
阅读全文
posted @ 2015-03-27 16:20
alex_cool
阅读(494)
推荐(0)
编辑
摘要:
1.Get Content Size in folderSELECT SUM(r_full_content_size/1024.0) FROM dm_sysobjectWHERE FOLDER('{0}', DESCEND)2.Count of documents in each folder/su...
阅读全文
posted @ 2015-03-27 15:50
alex_cool
阅读(475)
推荐(0)
编辑
摘要:
1.Get file extensionSELECTdos_extensionFROMdm_formatWHEREname IN (SELECTa_content_typeFROMdm_document(ALL)WHEREr_object_id = '{0}')2.Get content pathS...
阅读全文
posted @ 2015-03-27 15:30
alex_cool
阅读(347)
推荐(0)
编辑