User CSV

A user is a person linked to a computer who uses the software installed on it. Do not confuse a user with an operator, who is a person registered to use IT Asset Management interactively.

Table 1. Spreadsheet columns for User DDI

Column

Details

AccountName

Type: String. Mandatory. Maximum: 64

The primary SAM account name for the user.

Address_City

Type: String. Optional. Maximum: 200

The city of the user.

Address_Country

Type: String. Optional. Maximum: 100

The country of the user.

Address_State

Type: String. Optional. Maximum: 200

The state of the user.

Address_Street

Type: String. Optional. Maximum: 200

The street of the user.

Address_Zip

Type: String. Optional. Maximum: 20

The zip of the user.

BusinessUnit

Type: String. Optional. Maximum: 500 (64)

The business unit of the user: the name of the last level or some of the last levels or all levels. Level and sub levels must be separated by the forward slash [/] character. The maximum size for each level is 64 characters.

CostCenter

Type: String. Optional. Maximum: 500 (64)

The cost center of the user: the name of the last level or some of the last levels or all levels. Level and sub levels must be separated by the forward slash [/] character. The maximum size for each level is 64 characters.

DomainName

Type: String. Mandatory. Maximum: 32

The primary domain name (flat name).

Email

Type: String. Optional. Maximum: 200

The email address of the user

EmployeeNo

Type: String. Key. Mandatory. Maximum: 128

The employee number of the user.

EmploymentStatus

Type: String. Optional. Maximum: 256

The employment relationship between this user and the enterprise. Values must match the DefaultValue column of the EmploymentStatus table in the compliance database. Standard values include:
  • Employee
  • Consultant
  • Temporary
  • Part time
  • Casual.
If no value is specified for a new user, the Employee value is used.

For a single tenant on-premises implementation, custom employment status values are created for non-existing values imported from the data source. (Custom values are not supported for multi-tenant implementations for managed service providers, nor for cloud implementations.)

FaxNo

Type: String. Optional. Maximum: 30

The fax number of the user.

FirstName

Type: String. Optional. Maximum: 128

The first name of the user. If not provided, this value will be extracted from the FullName property.

FullName

Type: String. Optional. Maximum: 64

The full name of the user. If provided, this value will be split during the import into the FirstName, LastName and MiddleName fields. If not provided, it will be built from the values found in FirstName, LastName and MiddleName properties.

InventorySource

Type: String. Optional. Maximum: 64

If this user is reported in inventory, the name of the person or tool that performed the last inventory.

JobTitle

Type: String. Optional. Maximum: 128

The job title of the user.

LastName

Type: String. Optional. Maximum: 128

The last name of the user. If not provided, this value will be extracted from the FullName property.

Location

Type: String. Optional. Maximum: 500 (64)

The location of the user: the name of the last level or some of the last levels or all levels. Level and sub levels must be separated by the forward slash [/] character. The maximum size for each level is 64 characters.

ManagerEmployeeNo

Type: String. Optional. Maximum: 128

The manager employee number. The manager must already exist in the database; if not, the value is discarded.

MiddleName

Type: String. Optional. Maximum: 128

The middle name of the user. If not provided, this value will be extracted from the FullName property.

MobileNo

Type: String. Optional. Maximum: 30

The mobile phone number of the user.

PhoneNo

Type: String. Optional. Maximum: 30

The business phone number of the user.

UserStatus

Type: String. Optional. Maximum: 256

The status of the user. Standard values include:
  • Active
  • Inactive
  • Retired
  • On Leave
  • Pending.
If no value is specified for a new user, the Active value is used.

For a single tenant on-premises implementation, custom user status values are created for non-existing values imported from the data source. Users with these custom status values are assumed to be “active” (able to consume licenses) for the purposes of compliance calculations. (Custom values are not supported for multi-tenant implementations for managed service providers, nor for cloud implementations.)

UserSuffix

Type: String. Optional. Maximum: 100

The suffix to the name of the user. Standard suffixes include:
  • Jr.
  • Sr.
  • I
  • II
  • III
For a single tenant on-premises implementation, custom user suffixes are created for non-existing values imported from the data source. (Custom values are not supported for multi-tenant implementations for managed service providers, nor for cloud implementations.)
UserTitle

Type: String. Optional. Maximum: 100

The title of the user. Standard titles include:
  • Mr.
  • Miss
  • Mrs.
  • Ms.
  • Dr.
  • Prof.
For a single tenant on-premises implementation, custom user titles are created for non-existing values imported from the data source. (Custom values are not supported for multi-tenant implementations for managed service providers, nor for cloud implementations.)

IT Asset Management (Cloud)

Current