Documentum: DQL to get folders and permissions

To retrieve the folder paths and permissions on each folder, use the following query:

SELECT sr.r_folder_path, ar.r_accessor_name, ar.r_accessor_permit, ar.r_accessor_xpermit 
FROM dm_acl_s a, dm_acl_r ar, dm_folder s, dm_folder_r sr
WHERE a.r_object_id = ar.r_object_id
AND s.r_object_id=sr.r_object_id
AND a.object_name = s.acl_name
AND sr.r_folder_path like '/CABINET_NAME%'
AND sr.i_position = -1

 

 

Java: Log4J Logging different levels to different appenders

The following log4j.properties file will do the following:

  1. Only log ERROR level messages from all custom and third party libraries
  2. Log all DEBUG level messages from com.dctm.utils package to logfilename.log
  3. Log all INFO level messages to the Console

 

# Root logger option
log4j.rootLogger=ERROR, file, stdout
log4j.logger.com.dctm.utils=DEBUG

# Direct log messages to a log file
log4j.appender.file=org.apache.log4j.RollingFileAppender
log4j.appender.file.File=C:\\Users\\Username\\logfilename.log
log4j.appender.file.MaxFileSize=10MB
log4j.appender.file.MaxBackupIndex=10
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n
 
# Direct log messages to stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.Threshold=INFO
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n