BIP – Query to extract File details loaded through File Import and Export

Use below query to extract files loaded through Tools -> File Import and Export along with UCM Content ID and the account used:

SELECT DDOCTITLE 		"File Name"
      ,DWEBEXTENSION	        "File Extension"
      ,DDOCACCOUNT		"Account"
      ,DDOCAUTHOR		"Owner"
      ,DINDATE			"Upload Date"
      ,DDOCNAME 		"Content Id"
      ,DDOCTYPE			"Doc Type"	
  FROM revisions
 WHERE DWEBEXTENSION <> 'log' 
   AND DDOCTITLE NOT LIKE 'ESS%'
 ORDER BY DCREATEDATE DESC