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)