Create a Data Source to Display UserName and UserIdent

Because the Active Directory User Conversion Wizard displays TMS users with just the UserIdent information, you might find it helpful to create a data source that displays both the UserName and the corresponding UserIdent information.

1. Go to Data Sources > New to open the Data Sources New screen

2. Start by selecting the Segment that this data source should be part of

3. Fill in a Name for the data source (ex: User Name List)

4. Fill in a Description of this data source (ex: Listing of TMS UserNames and UserIdents).

5. In the Type drop-down menu, select Detailed List.

6. In the Module drop-down menu, select Resources

7. Both Category and Sub Category are optional fields, but aid in searching for a data source

8. In the Status drop-down menu, select Active

9. Click Save

10. When the Data Source Editor tab becomes available, select the tab and then select the SQL sub tab

11. Click Override SQL

12. When the confirmation pop-up window appears, confirm that you want to override the SQL entry

13. In the SQL entry box, enter the following SQL code:

    SELECT UserName, UserIdent

    FROM tblTMSUsers

    WHERE Disabled = '0'

    ORDER BY UserName

14. Click Save to commit your changes.

    If you select the Designer sub tab, you can see the data returned by the SQL you entered.