Useful DQL Queries: Users

Show when a user’s properties were last changed:

select r_modify_date from dm_user where user_name = ‘Sandra’

List all deactivated user accounts:

select user_name from dm_user where user_state = 1

List the LDAP servers being used to authenticate users:

select user_login_domain from dm_user where user_source = ‘LDAP’

List documents currently checked out by a particular user:

select object_name from dm_document where r_lock_owner = ‘liam’

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: