Listing database users and groups through ScfUtils (Model Explorer)
This topic covers listing database users, groups and active users through ScfUtils.
ScfUtils provides a command line interface for performing Model Explorer functions.
If you have installed Modeler to the default locations, ScfUtils resides in the following location:
C:\Program Files (x86)\Windchill Modeler\Modeler\Exe\SCFUtils.exe
For information about managing principals using Model Explorer, see the following topics:
To list users in database through ScfUtils
Syntax:
ScfUtils -listdbusers Enterprise "<database-ref>"
Where:
• <database-ref> specifies the reference to the database to list users.
Enter the database reference in the following format: \\SQL\<instance-name>\<database>
Example:
ScfUtils -listdbusers Enterprise "\\SQL\Server1@MODELER\ModelsDB"
To list groups in database through ScfUtils
Syntax:
ScfUtils -listdbgroups Enterprise "<database-ref>"
Where:
• <database-ref> specifies the reference to the database to list groups.
Enter the database reference in the following format: \\SQL\<instance-name>\<database>
Example:
ScfUtils -listdbgroups Enterprise "\\SQL\Server1@MODELER\ModelsDB"
To list active users in database through ScfUtils
Syntax:
ScfUtils -listdbactiveusers Enterprise "<database-ref>"
Where:
• <database-ref> specifies the reference to the database to list active users.
Enter the database reference in the following format: \\SQL\<instance-name>\<database>
Example:
ScfUtils -listdbactiveusers Enterprise "\\SQL\Server1@MODELER\ModelsDB"