User Information #

Results are loaded to table ss_SysUserInfo

Parameters #

Parameter	Purpose
@Env	SQL Sales Environment Name, see Setup
@Special1	Future use, not currently used
@Special2	Future use, not currently used

Example of Use #

exec ss_UserInfo 'DEMO'

SQL-SALES ss_SysUserInfo run date: 2023-11-09 ———————-

23:51:09: Using Env|Schema: DEMO2|dbo

23:51:09: Starting ss_SysUserInfo retrieval

23:51:12: Connection method ODBC & SOAP API

23:51:12: Drop existing ss_SysUserInfo if exists and recreate

—————————————————————–

ss_SysUserInfo #

• UserId (User.Id of the @Env user)
• Name (User.Name of the @Env user)
• Username (User.Username of the @Env user)
• Email (User.Email of the @Env user)
• ProfileName (User.ProfileId.Profile.Name of the @Env user)
• RoleName (User.RoleId.UserRole.Name of the @Env user)
• SessionId (The Salesforce Session Id of the established session)
• UserGroups (Member Groups of the @Env user)
• PermissionSetGroups (PermissionSetGroups of the @Env user)

#