---
title: User Information
description: "Table of Contents - [User Information](#user-information) - [Parameters](#parameters) - [Example of Use](#example-of-use) - [ss_SysUserInfo](#sssysuserinfo) ## User Information Results are loaded to table `ss_SysUserInfo` ## Parameters | **Parameter** | **Purpose** | | --- | --- | | **@Env** | SQL Sales…"
url: "https://sql-sales.com/docs/user-information/"
updated: "2026-08-31"
category: "Helper Tools & Scripts"
---

# User Information

Table of Contents

- [User Information](#user-information)
- [Parameters](#parameters)
- [Example of Use](#example-of-use)
- [ss_SysUserInfo](#sssysuserinfo)

## 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
-----------------------------------------------------------------
```

![](https://downloads.intercomcdn.com/i/o/907763748/d213a6f95a1d98c31a128e35/image.png?expires=1783620000&signature=805564bd8559234886af8e0b5c788ac4746dceea98dedbcad33e31ab4840f200&req=fSAgEc99moVXFb4V1XW4gfRt%2B819rCUCecUroxffUSD3uSKmHGs6VtttUo9D%0ALU65PuPmOUGvbspTYot6zJEN2g%3D%3D%0A)

## 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)