Fields in the Service Users Data Set
Important: You must enable the respective additional data set to generate this report type.
This report provides detailed information about all service users of a user and the user's sub-accounts that were created in a chosen period.
Field Description
The table below describes fields available in this report data set.
Field name | Type | Description | Example |
---|---|---|---|
SU_RESELLER_ACCOUNT_ID |
integer |
The unique identifier of a reseller account. |
1000001 |
SU_ACCOUNT_ID |
integer |
The unique identifier of an account. |
1000001 |
SU_ACCOUNT_NAME |
text |
The company name of an account. |
Company Inc |
SU_SUBSCRIPTION_ID |
integer |
Subscriptions assigned to a user. |
1000001 |
SU_LICENSE_ID |
integer |
The license ID assigned to a user. |
JSON |
SU_SUBSCRIPTION_NAME |
text |
The service plan assigned to a subscription. |
O2 UK Office 365 Medium Business (fakemail.onmicrosoft.com) |
SU_USER_ID |
integer |
The unique identifier of a service user. |
324 |
SU_LOGIN_NAME |
text |
The name of a service user. |
staff@example.com |
SU_FNAME |
text |
The first name of a service user. |
John |
SU_LNAME |
text |
the last name of a service user. |
Smith |
SU_EMAIL |
text |
The staff member's email address. |
su@example.com |
SU_PHONE |
text |
The staff member's telephone number. |
79261234567 |
SU_STATUS |
integer |
The status can have one of the following values:
|
1 |
SU_CREATION_DATE |
datetime |
The date when the user was created. The format is YYYY-MM-DD HH:mm:ss. |
2014-02-29 15:06:30 |
SU_CANCELLATION_DATE |
datetime |
The date when the user account was removed. The format is YYYY-MM-DD HH:mm:ss. |
2014-09-24 18:12:34 |