Account Data Extract

The first time the Account Data Extract job runs it creates a snapshot of account events from the day prior to the day the job runs. (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 accounts created or updated; it does not include historical account data.

The first line of the job output contains the header information for the table described by the CSV. If no accounts were created or updated in the job period, the CSV output includes only the header row content. If there are custom attributes, they appear in the columns following the AccountDescription column. Although the extract does not support hierarchies, it does list the parent accounts if applicable. If more than one parent account exists, they are separated by a pipe (|).

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: Account Data Extract Job

AccountID,AccountName,AccountType,ParentAccount,Address1,Address2,City,State,PostalCode,Country,
Visible,Region,AccountDescription,CA[ACCT|CUSTOM_ACCT2222],CA[ACCT|CUSTOM3],CA[ACCT|CUSTOM_ACCT]

MYACCT,My Account,PUBLISHER,,aaaaa,dddd,ccc,ssss,333,US,true,dssd,dddd,,,231

PORTAL_ACCT_UNIT,Portal Account,CUSTOMER,,,,,,,,true,,,,,

UNKNOWN_ACCT_UNIT,Information Not Available,UNKNOWN,,,,,,,,true,,,,,

TEST1,TEST2,CUSTOMER,,add1,add2,cc,sss,6666,US,true,dddd,descrip,789,AAA,197

TEST1_SUB1,TEST1_SUB1,CUSTOMER,TEST1,,,,,,US,true,,,,,

TEST1_PARTNER1,TEST1_PARTNER1,CHANNEL_PARTNER,,,,,,,US,true,,,,,

TEST1_PARTNER1_SUB1,TEST1_PARTNER1_SUB1,CHANNEL_PARTNER,TEST1_PARTNER1,,,,,,US,true,,,,,

MYACCT_SUB1,MYACCTSUB1,PUBLISHER,MYACCT,,,,,,US,true,,,,,

user-n@flexerasoftware.com-FLEX1000,FLEX1000,SELF_REGISTERED,,,,,,,,true,,,,,

TEST1_SUB1_SUB2,TEST1_SUB1_SUB2,CUSTOMER,TEST1_SUB1,TEST1_SUB1_SUB2,TEST1_SUB1_SUB2,

TEST1_SUB1_SUB2,TEST1_SUB1_SUB2,,US,true,TEST1_SUB1_SUB2,TEST1_SUB1_SUB2,,,23

TWOPARENTS,TWOPARENTS,CUSTOMER,TEST1|TEST1_SUB1,TWOPARENTS,TWOPARENTS,TWOPARENTS,TWOPARENTS,,US,

true,TWOPARENTS,TWOPARENTS,,,12

...