Model, Component, and Package Management > Model management > Model Explorer > Command line interface - ScfUtils > Listing database users and groups through ScfUtils (Model Explorer)
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"