Administration Guide › Administration Searches › Run a New Administration Search › Searching by User Name

Searching by User Name

When searching for data, if you filter your search by user name, be aware of the following:

Domain Prefixes

By default, CA DataMinder uses Windows authentication to create user accounts. This means you must prefix user names with the domain when searching for user-specific items. For example, to refer to SpencerRimmel in the Unipraxis domain, the syntax is:

WHERE WgnUser.NativeUser='Unipraxis\SpencerRimmel'

Note: You do not need to supply a domain prefix if the user account was created manually by an administrator.

Oracle Requirements

When searching for data, user names are not usually case-sensitive. But if your CMS uses an Oracle database engine and you enter a custom search expression in the SQL tab, user names are case-sensitive.

For example, user SpencerRimmel can log on to the Administration Console by typing spencerrimmel or SPENCERRIMMEL. But if you want to search for this user, you must type SpencerRimmel in the SQL tab of the Administration Search dialog.

Note: This applies only to the SQL tab. On other search tabs, the User Name field is not case-sensitive.