User Data Extract

The first time the User Data Extract job runs it creates a snapshot of user events from the day prior to the day the job runs. (User accounts created or updated from 00:00:00 to 23:59:59, FlexNet Operations server time, on the previous day are captured when the job runs). Subsequently, when this job runs, it creates a snapshot from the end time of the last successful run to the current time.

A successful run of this job creates a comma-separated value (CSV) file. The job output is a snapshot of user accounts created or updated; it does not include historical data.

The first line of the job output contains the header information for the table described by the CSV. If no users were created or updated in the job period, the CSV output includes only the header row content. When a user is assigned multiple roles in a given account, the output lists all the user’s assigned roles and separates roles with a pipe character (|). Custom attributes, if any, are displayed in columns following the Type column.

The expiry date will display in the template if the Enable User Expiration is checked in the system configuration.

Note:The date/time format of the data extract is controlled by the Use ISO 8601 time format in extracts configuration option. For more information, see Configuring System Settings | General Options in the FlexNet Operations User Guide.

Sample Output: User Data Extract Job

FirstName, LastName, EmailAddress, UserName, Role, Status, AccountID, AccountName, SharedLogin, PortalLogin, Street, City, State, ZipCode, Country, TimeZone, Locale, PhoneNumber, FaxNumber, ReceiveEmail, RecieveExpiringEmails, SelfRegisteredUser, CreateDate, LastLoginDate, Type, ExpiryDate, CA[USER|UserType], CA[USER|SSN]

John, Smith, user-a@flexerasoftware.com, user-a@flexerasoftware.com, Portal User Role|Portal Admin User Role, Yes, 0814Account1, 0814Acct1, No, Yes, ,,,, US, GMT-8.0DST60, en_US, ,, No, No, No, ,, CUSTOMER,12/22/2018 0:00,,

Chandra, Smith, user1_extract@gmail.com, user1_extract@gmail.com, Portal User Role|Portal User Role, Yes, Bravo, bravo_subacct, Yes, Yes, 101 Metro drive, San Jose, CA, 95123, US, GMT-8.0DST60, en_US, 408-0000, 408-909-0000, Yes, No, ,,, CUSTOMER, Customer, , 123

,,, user1_extract@gmail.com, Portal User Role, , Charlie's Chocolates, Charlie's Chocolates, ,,,,,,,,,,,,,,,,,,,

,,, user1_extract@gmail.com, Portal Admin User Role, , Acme, Acme Software Corporation, ,,,,,,,,,,,,,,,,,,,

Samuel, cust, user-c@flexerasoftware.com, user-c@flexerasoftware.com, Portal Admin User Role, Yes, Aberdeen Golf, Aberdeen Golf, No, Yes, ,,,, US, GMT-8.0DST60, en_US, ,, No, No, No, ,, CUSTOMER,,,

...

Notice that, for users that belong to multiple accounts, FlexNet Operations structures the CSV output so that a new row appears for each additional account. On these extra rows, the UserName of the user is repeated. along with that user’s assigned roles in that account and the additional account name. Other details are left empty. (See “Example for Users Linked to Multiple Accounts,” below.)

Example for Users Linked to Multiple Accounts

FirstName, LastName, EmailAddress, UserName, Role, Status, AccountID, AccountName, ...

Manuel, Enblach, menblach@MIB.com, menblach@MIB.com, Portal User Role, Yes, MIB, MIB, ...

Theresa, Cullen, tcullen@delos.com, tcullen@delos.com, Portal Admin User Role, No, Delos, Delos, ...

Robert, Ford, rford@delos.com, rford@delos.com, Portal Admin User Role, Yes, Delos, Delos, ...

,,, rford@delos.com, Portal Admin User Role|Portal User Role,, Sweetwater, Sweetwater, ...

,,, rford@delos.com, Portal Admin User Role|Portal User Role,, Confederatos, Confederatos, ...

Elsie, Hughes, ehughes@delos.com, ehughes@delos.com, Portal Admin User Role, Yes, Delos, Delos, ...

R, Mistice, armistice@westwrld.com, armistice@westwrld.com, Portal User Role, Yes, Sweetwater, Sweetwater, ...

...

Above, rford@delos.com is linked to three accounts: Delos, Sweetwater, and Confederatos. The other users are each linked to only one account. In the accounts, Sweetwater and Confederatos, rford@delos.com has both portal administrator and portal user roles.