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:

  • 0 - disabled,

  • 1 - enabled.

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