3 Importing Entity Data to OIRI Database
You can configure OIRI to load entity data, including custom attributes, from Oracle Identity Governance database or flat files, and then run the data import process.
This section contains the following topics:
3.1 About Data Import
Data import, also called data ingestion, is the process of importing entity data from
a source to the Oracle Identity Role Intelligence (OIRI) database. OIRI uses a data
ingestion command-line tool (DING CLI) to fetch and load entity data
from third-party sources, namely Oracle Identity Governance (OIG) database or flat
files.
As part of the data import process, data from the source, such as OIG database or flat files, is loaded into the following tables of the OIRI database:
USERS, APPLICATIONS, ACCOUNTS, ENTITLEMENTS, ASSIGNED_ENTS, ROLES, ROLE_USER_MSHIP, ROLE_ENT_COMPOSI, ROLE_HIERARCHY, ORGANIZATIONS
You can run the data import process in the following modes:
Full: You run data import in full mode when you first install OIRI and want to load all the data from the source to the OIRI database. This is called Day 0 data import. If you run data import in full mode after Day 0, which is referred to as Day N data import, when the OIRI database already contains entity data, the existing data is truncated and new data from the sources is loaded.
Incremental: You run data import in incremental mode on Day N, which matches the data in OIRI and the source, and loads only the data that has been added, updated, or deleted in the source after the last data import run.
When you install OIRI, the default configuration sets data import in full mode with OIG database as the source. You can provide the details of the source OIG database, such as database name, port, and service name. Otherwise, if you want flat files to be the source for the data import, then you can provide the details of the flat files. See the subsequent topics for more information on Day 0 and Day N data import configuration when the source is OIG database or flat files.
3.2 Importing Data from Oracle Identity Governance Database
You can import entity data from Oracle Identity Governance database on Day 0 and Day N scenarios.
This section contains the following topics:
3.2.1 Configuring Day 0 Data Import from Oracle Identity Governance Database
Day 0 data import is when you run data load for importing entity data into the OIRI
database for the first time. Because you want to import all entity data from the Oracle
Identity Governance (OIG) database to the OIRI database, you must run the data import in
full mode. When you install OIRI, the default configuration sets
data import in full mode with OIG database as the source. You can
provide the details of the source OIG database, such as database name, port, and service
name. See Setting Up the Configuration Files for information about data import configuration.
To configure Day 0 data import, make sure that the ding-cli
container is running, and then perform the following steps:
-
If you want to change any default data import configuration, run the
updateDataIngestionConfig.shcommand in the following format:$ docker exec -it ding-cli bash $ ./updateDataIngestionConfig.sh --parameter_name_1 parameter_value_1 --parameter_name_2 parameter_value_2 ...... --parameter_name_n parameter_value_nFor example, if you want to update the OIG database host to
myoigdband port to12345, then run the following command:$ docker exec -it ding-cli bash $ ./updateDataIngestionConfig.sh --oigdbhost myoigdb --oigdbport 12345
Note:
By running the
updateDataIngestionConfig.shscript, you can update the values of data import configuration parameters, such as for entity parameters. To view all the parameters of theupdateDataIngestionConfig.shscript, run the following command:$ ./updateDataIngestionConfig.sh --help
See Arguments of the updateDataIngestionConfig.sh Script for information about all the parameters that you can set by running the
updateDataIngestionConfig.shscript.You can update some other parameter values for OIRI microservice by running the
updateConfig.sh. To view all the parameters of theupdaConfig.sh script, run the following command:$ ./updateConfig.sh --help
See Arguments of the updateConfig.sh Script for information about all the parameters that you can set by running the
updateConfig.shscript. -
Verify the
data-ingestion-config.yamlby running the following command:$ docker exec -it oiri-cli bash $ cat /app/data/conf/data-ingestion-config.yaml
Note:
-
To update the values in the
data-ingestion-config.yamlfile, run theupdateDataIngestionConfig.shscript. -
See Tuning Performance for information about all entity configuration parameters and their meaning, such as how to configure lowerbound, upperbound, and numpartition values for optimal performance of the data import.
-
You can now run the data import process, as described in Running the Data Import Dry Run Process and Running the Data Import Process.
3.2.2 Configuring Day N Data Import from Oracle Identity Governance Database
On Day N, you want to sync the entity data in the OIRI database to bring in the
modifications made to the source. Therefore, you can run the data import in incremental
mode by specifying the value of the syncMode parameter to
incremental for each entity by running the
updateDataIngestionConfig.sh script. For example, if you want to
specify that incremental data import takes place for the user, application, and
entitlement entities, then run the following command:
$ ./updateDataIngestionConfig.sh --entityusersenabled true --entityuserssyncmode incremental --entityapplicationsenabled true --entityapplicationssyncmode incremental --entityentitlementsenabled true --entityentitlementssyncmode incremental
See Entity Parameters for Data Import for information about the parameters for each entity that you can update by running
the updateDataIngestionConfig.sh script.
In addition, if you want to specify any other changes to the data import
configuration parameter values, then run the
updateDataIngestionConfig.sh command. For example, if you want to
change the source OIG database details, then run the following command:
$ ./updateDataIngestionConfig.sh --useoigdbforetl true --oigdbhost host2.example.com --oigdbport 12345 --oigdbsname oigdb.example.com
See Parameters Required for Source Configuration for information about the source configuration parameters for data import.
Note:
if OIG contains roles/entitlements which are no longer associated with any users, then you should also run the delete ETL operation to ensure there are no inconsistencies in the data synchronized to OIRI.You can now run the data import process, as described in Running the Data Import Dry Run Process and Running the Data Import Process.
3.3 Importing Data from Flat Files
You can import entity data from flat files on Day 0 and Day N scenarios.
This section contains the following topics:
3.3.1 Configuring Day 0 Data Import from Flat Files
You can import entity data to OIRI database from flat files, which is data in CSV format. For each entity, such as user, account, or application, you must specify a separate flat file.
The first line of each flat file is a fixed header that specifies the attributes to be imported. For example, for a flat file for account data, the header can be:
“EXT_ACCOUNT_ID”,”ACCOUNT_NAME”, “ACCOUNT_TYPE”, “USER_NAME”, “APPLICATION_NAME”
For applications, the header can be:
“EXT_APP_ID”, “NAME”, “DISPLAY_NAME”, “TYPE”, “DESCRIPTION”, “RISK_SCORE”
After the header, specify the comma-separated attribute values that you want
to load into the OIRI database. The data in the flat files is comma-separated by
default. However, you can configure to use any other separator by setting the value of
the -–flatfileseparator parameter to : for colon or
| for vertical bar when running the
./updateDataIngestionConfig.sh command.
The following is the header and contents of a sample CSV file for the application entity:
“EXT_APP_ID”,“NAME”,“DISPLAY_NAME”,“TYPE”,“DESCRIPTION”,“RISK_SCORE” 47,"ebs1","ebs1","Disconnected","ebs1",3 48,"EBS2","EBS2","Disconnected","EBS2",3 1,"myapp","myapp","Disconnected:,"mytestapplication",1 41,"Laptop","Laptop","Disconnected","Laptop",3 44,"activeb","activeb","Disconnected","activeb",3 45,"ActiveD","ActiveD","Disconnected","ActiveD",3 46,"ActiveE","ActiveE","Disconnected","ActiveE",3 5,"myapp1","myapp1","Disconnected","",3 43,"mobile","mobile","Disconnected","mobile",3 49,"DB1","DB1","Disconnected","DB1",3 2,"VISDU1","VISDU1","DOBBased","VISDU1",7 3,"VISDU2","VISDU2",,"DOCBased","VISDU2",7 4,"VISDU3","VISDU3","DOBBased","VISDU3",7 23,"JIRAApp","JIRAApp","Disconnected","JIRAApp",3 42,"Badge","Badge","Disconnected","Badge",3 50,"DB2","DB2","Disconnected","DB2",3
Save the .CSV file in a directory. In the same way, create the .CSV files for all entities for which you want to import the data to OIRI database. See Sample CSV Files for All Entities for the headers and contents of sample CSV files for the user, application, account, entitlement, assigned entitlement, role, role hierarchy, role user membership, and role entitlement composition entities.
Save the files in a directory. Then, update the parameter for specifying
flat files as the source for data load by running the
updateDataIngestionConfig.sh script, as shown:
$ ./updateDataIngestionConfig.sh --useoigdbforetl false --useflatfileforetl true --format csv
You can now run the data import process, as described in Running the Data Import Dry Run Process and Running the Data Import Process.
3.3.2 Configuring Day N Data Import from Flat Files
On Day N, you want to sync the entity data in the OIRI database to bring in the
modifications made to the source. Therefore, you can run the data import in incremental
mode by specifying the value of the syncMode parameter to
incremental for each entity. In addition, if you want to specify
any other changes to the data import configuration parameter values, then run the
updateDataIngestionConfig.sh command. For example, if you want to
change the attribute values in the source flat files and specify that incremental data
load takes place for the user, application, and entitlement entities, then run the
following commands:
For users:
$ ./updateDataIngestionConfig.sh --useoigdbforetl false --useflatfileforetl true --flatfileformat csv --entityuserssyncmode incremental
For applications:
$ ./updateDataIngestionConfig.sh --useoigdbforetl false --useflatfileforetl true --flatfileformat csv --entityapplicationssyncmode incremental
For entitlements:
$ ./updateDataIngestionConfig.sh --useflatfileforetl true --flatfileformat csv --entityentitlementssyncmode incremental
You can now run the data load process, as described in Running the Data Import Dry Run Process and Running the Data Import Process.
3.3.3 Sample CSV Files for All Entities
This topic shows the headers and contents of sample CSV files for the user, application, account, entitlement, assigned entitlement, role, role hierarchy, role user membership, and role entitlement composition entities. It also lists the mandatory and optional attributes of these entities for importing data from flat files.
It contains the following topics:
3.3.3.1 Sample users.csv File
The following table lists the mandatory and optional user attributes for data import from flat files.
| OIRI Attribute | Mandatory/Optional |
|---|---|
| EXT_USER_ID | Optional |
| USER_NAME | Mandatory |
| LAST_NAME | Optional |
| FIRST_NAME | Optional |
| MIDDLE_NAME | Optional |
| DISPLAY_NAME | Mandatory |
| TITLE | Optional |
| LOCALE | Optional |
| PREFERRED_LANGUAGE | Optional |
| STATUS | Optional |
| WORK_EMAIL | Optional |
| HOME_EMAIL | Optional |
| PRIMARY_EMAIL_TYPE | Optional |
| WORK_STATE | Optional |
| WORK_POSTAL_CODE | Optional |
| WORK_COUNTRY | Optional |
| EMPLOYEE_NUMBER | Optional |
| EMPLOYEE_TYPE | Mandatory |
| JOB_CODE | Optional |
| COST_CENTER | Optional |
| ORGANIZATION | Mandatory |
| PARENT_ORG_NAME | Optional |
| DIVISION | Optional |
| DEPARTMENT | Optional |
| MANAGER_NAME | Optional |
| MANAGER_DISPLAY_NAME | Optional |
| DEPROVISIONED_DATE | Optional |
| DEPROVISIONING_DATE | Optional |
| DESCRIPTION | Optional |
| FULL_NAME | Optional |
| OFFICE_NAME | Optional |
| TERRITORY | Optional |
| RISK_SCORE | Optional |
The following is a sample users.csv file:
EXT_USER_ID,USER_NAME,LAST_NAME,FIRST_NAME,MIDDLE_NAME,DISPLAY_NAME,TITLE,LOCALE,PREFERRED_LANGUAGE,STATUS,WORK_EMAIL,HOME_EMAIL,PRIMARY_EMAIL_TYPE,WORK_STATE,WORK_POSTAL_CODE,WORK_COUNTRY,EMPLOYEE_NUMBER,EMPLOYEE_TYPE,JOB_CODE,COST_CENTER,ORGANIZATION,PARENT_ORG_NAME,DIVISION,DEPARTMENT,MANAGER_NAME,MANAGER_DISPLAY_NAME,DEPROVISIONED_DATE,DEPROVISIONING_DATE,DESCRIPTION,FULL_NAME,OFFICE_NAME,TERRITORY,RISK_SCORE 70,AuditAdmin,Admin,Audit,,Identity Audit Admin Without Hier,,,,Active,audit.admin.without.hier@example.com,,Work,,,,,CONTRACTOR,,,Xellerate Users,,,,,,,,,,,,0 71,IDENTITY_AUDIT_VIEWER_WITH_HIER,Viewer,Audit,,Identity Audit Viewer With Hier,,,,Active,audit.viewer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 72,IDENTITY_AUDIT_VIEWER_WITHOUT_HIER,Viewer,Audit,,Identity Audit Viewer Without Hier,,,,Active,audit.viewer.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 73,HOME_ORG_USER,Org,Home,,UserMgmt Home Org User,,,,Active,usermgmt.home.org.user@example.com,,Work,,,,,Full-Time,,,user_mgmt_org,,,,,,,,,,,,0 74,MGMT_CHAIN_MGR_LVL_1,Level1,UserMgmt,Manager,UserMgmt Manager User Level 1,,,,Active,usermgmt.manager.level.1@example.com,,Work,,,,,Full-Time,,,user_mgmt_org,,,,,,,,,,,,0 75,MGMT_CHAIN_MGR_LVL_2,Level2,UserMgmt,Manager,UserMgmt Manager User Level 2,,,,Active,usermgmt.manager.level.2@example.com,,Work,,,,,Full-Time,,,user_mgmt_org_child,user_mgmt_org,,,MGMT_CHAIN_MGR_LVL_1,UserMgmt Manager User Level 1,,,,,,,0 76,MGMT_CHAIN_DIR_REP_1_LVL_1,Level1,UserMgmt,DirectReport1,UserMgmt Direct Report 1 Level 1,,,,Active,usermgmt.direct.report.1.level.1@example.com,,Work,,,,,Full-Time,,,user_mgmt_org,,,,MGMT_CHAIN_MGR_LVL_1,UserMgmt Manager User Level 1,,,,,,,0 77,MGMT_CHAIN_DIR_REP_2_LVL_1,Level1,UserMgmt,DirectReport2,UserMgmt Direct Report 2 Level 1,,,,Active,usermgmt.direct.report.2.level.1@example.com,,Work,,,,,Full-Time,,,user_mgmt_org,,,,MGMT_CHAIN_MGR_LVL_1,UserMgmt Manager User Level 1,,,,,,,0 78,MGMT_CHAIN_DIR_REP_1_LVL_2,Level2,UserMgmt,DirectReport1,UserMgmt Direct Report 1 Level 2,,,,Active,usermgmt.direct.report.1.level.2@example.com,,Work,,,,,Full-Time,,,user_mgmt_org_child,user_mgmt_org,,,MGMT_CHAIN_MGR_LVL_1,UserMgmt Manager User Level 1,,,,,,,0 79,MGMT_CHAIN_DIR_REP_2_LVL_2,Level2,UserMgmt,DirectReport2,UserMgmt Direct Report 2 Level 2,,,,Active,usermgmt.direct.report.2.level.2@example.com,,Work,,,,,Full-Time,,,user_mgmt_org_child,user_mgmt_org,,,MGMT_CHAIN_MGR_LVL_1,UserMgmt Manager User Level 1,,,,,,,0 80,MGMT_CHAIN_DIR_REP_3_LVL_2,Level2,UserMgmt,DirectReport3,UserMgmt Direct Report 3 Level 2,,,,Active,usermgmt.direct.report.3.level.2@example.com,,Work,,,,,Full-Time,,,user_mgmt_org_child,user_mgmt_org,,,MGMT_CHAIN_MGR_LVL_2,UserMgmt Manager User Level 2,,,,,,,0 81,MGMT_CHAIN_DIR_REP_4_LVL_2,Level2,UserMgmt,DirectReport4,UserMgmt Direct Report 4 Level 2,,,,Active,usermgmt.direct.report.4.level.2@example.com,,Work,,,,,Full-Time,,,user_mgmt_org_child,user_mgmt_org,,,MGMT_CHAIN_MGR_LVL_2,UserMgmt Manager User Level 2,,,,,,,0 82,CERTIFICATIONADMINISTRATOR,ln_certificationAdministrator,fn_certificationAdministrator,,fn_certificationAdministrator ln_certificationAdministrator,,,,Active,certificationAdministrator@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 83,CERTIFICATIONVIEWER,ln_certificationViewer,fn_certificationViewer,,fn_certificationViewer ln_certificationViewer,,,,Active,certificationViewer@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 84,CERTIFIEREXORG,ln_certifierExOrg,fn_certifierExOrg,,fn_certifierExOrg ln_certifierExOrg,,,,Active,certifierExOrg@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 85,CERTIFICATIONCONFIGURATIONADMINISTRATOR,ln_certificationConfigurationAdministrator,fn_certificationConfigurationAdministrator,,fn_certificationConfigurationAdministrator ln_certificationConfigurationAdministrator,,,,Active,certificationConfigurationAdministrator@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 86,ACERTUSER1,ln_ACERTUSER1,fn_ACERTUSER1,,fn_ACERTUSER1 ln_ACERTUSER1,,,,Active,fn_acertuser1.ln_acertuser1@avicertorg.com,,Work,,,,,Full-Time,,,AviCertOrg,,,,,,,,,,,,0 87,ACERTUSER2,ln_ACERTUSER2,fn_ACERTUSER2,,fn_ACERTUSER2 ln_ACERTUSER2,,,,Active,fn_acertuser2.ln_acertuser2@avicertorg.com,,Work,,,,,Full-Time,,,AviCertOrg,,,,ACERTUSER1,fn_ACERTUSER1 ln_ACERTUSER1,,,,,,,0 88,ACERTUSER3,ln_ACERTUSER3,fn_ACERTUSER3,,fn_ACERTUSER3 ln_ACERTUSER3,,,,Active,fn_acertuser3.ln_acertuser3@avicertorg.com,,Work,,,,,Full-Time,,,AviCertOrg,,,,ACERTUSER1,fn_ACERTUSER1 ln_ACERTUSER1,,,,,,,0 89,ACERTUSER4,ln_ACERTUSER4,fn_ACERTUSER4,,fn_ACERTUSER4 ln_ACERTUSER4,,,,Active,fn_acertuser4.ln_acertuser4@avicertorg.com,,Work,,,,,Full-Time,,,AviCertOrg,,,,ACERTUSER1,fn_ACERTUSER1 ln_ACERTUSER1,,,,,,,0 6,SPALMENTIERI,Palmentieri,Sonny,,Sonny Palmentieri,,,,Active,sonny.palmentieri@avitek.com,,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0 90,VCERTUSER1,ln_VCERTUSER1,fn_VCERTUSER1,,fn_VCERTUSER1 ln_VCERTUSER1,,,,Active,fn_vcertuser1.ln_vcertuser1@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,,,,,,,,,0 91,VCERTUSER2,ln_VCERTUSER2,fn_VCERTUSER2,,fn_VCERTUSER2 ln_VCERTUSER2,,,,Active,fn_vcertuser2.ln_vcertuser2@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER1,fn_VCERTUSER1 ln_VCERTUSER1,,,,,,,0 92,VCERTUSER3,ln_VCERTUSER3,fn_VCERTUSER3,,fn_VCERTUSER3 ln_VCERTUSER3,,,,Active,fn_vcertuser3.ln_vcertuser3@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER1,fn_VCERTUSER1 ln_VCERTUSER1,,,,,,,0 93,VCERTUSER4,ln_VCERTUSER4,fn_VCERTUSER4,,fn_VCERTUSER4 ln_VCERTUSER4,,,,Active,fn_vcertuser4.ln_vcertuser4@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER2,fn_VCERTUSER2 ln_VCERTUSER2,,,,,,,0 94,VCERTUSER5,ln_VCERTUSER5,fn_VCERTUSER5,,fn_VCERTUSER5 ln_VCERTUSER5,,,,Active,fn_vcertuser5.ln_vcertuser5@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER2,fn_VCERTUSER2 ln_VCERTUSER2,,,,,,,0 95,VCERTUSER6,ln_VCERTUSER6,fn_VCERTUSER6,,fn_VCERTUSER6 ln_VCERTUSER6,,,,Active,fn_vcertuser6.ln_vcertuser6@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER2,fn_VCERTUSER2 ln_VCERTUSER2,,,,,,,0 96,VCERTUSER7,ln_VCERTUSER7,fn_VCERTUSER7,,fn_VCERTUSER7 ln_VCERTUSER7,,,,Active,fn_vcertuser7.ln_vcertuser7@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER2,fn_VCERTUSER2 ln_VCERTUSER2,,,,,,,0 97,VCERTUSER8,ln_VCERTUSER8,fn_VCERTUSER8,,fn_VCERTUSER8 ln_VCERTUSER8,,,,Active,fn_vcertuser8.ln_vcertuser8@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER3,fn_VCERTUSER3 ln_VCERTUSER3,,,,,,,0 98,VCERTUSER9,ln_VCERTUSER9,fn_VCERTUSER9,,fn_VCERTUSER9 ln_VCERTUSER9,,,,Active,fn_vcertuser9.ln_vcertuser9@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER3,fn_VCERTUSER3 ln_VCERTUSER3,,,,,,,0 99,VCERTUSER10,ln_VCERTUSER10,fn_VCERTUSER10,,fn_VCERTUSER10 ln_VCERTUSER10,,,,Active,fn_vcertuser10.ln_vcertuser10@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER3,fn_VCERTUSER3 ln_VCERTUSER3,,,,,,,0 100,VCERTUSER11,ln_VCERTUSER11,fn_VCERTUSER11,,fn_VCERTUSER11 ln_VCERTUSER11,,,,Active,fn_vcertuser11.ln_vcertuser11@viscertorg.com,,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER3,fn_VCERTUSER3 ln_VCERTUSER3,,,,,,,0 1001,BOB.MILLER@example.com,Miller,Bob,,Bob Miller,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0 1002,TIM.COOK@example.com,Cook,Tim,,Tim Cook,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0 1003,ALISTER.COOK@example.com,Cook,Alister,,Alister Cook,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0 1004,MARK.WILCOX@example.com,Wilcox,Mark,,Mark Wilcox,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0 1005,ALAN.BORDER@example.com,Border,Alan,,Alan Border,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0 1006,DONALD.TRUMP@example.com,Trump,Donald,,Donald Trump,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0 2002,USR_5,Usr_5,Usr_5,,Usr_5 Usr_5,,,,Active,Usr_5@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 2004,KARNOLD,Arnold,Kari,,Kari Arnold,,,,Active,karnold@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2006,DLEWIS,Lewis,Donald,,Donald Lewis,,,,Active,Dlewis@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2007,MSANDOVAL,Sandoval,Molly,,Molly Sandoval,,,,Active,msandoval@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2008,CDELGADO,Delgado,Carol,,Carol Delgado,,,,Active,cdelgado@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 5,ELANGOVAN.SUBRAMANIAN@example.com,Subramanian,Elangovan,,Elangovan Subramanian,,,,Active,,,,,,,,Full-Time,,,vision,,,,,,,,,,,,0 7,HHANZO,Hanzo,Hattori,,Hattori Hanzo,,,,Active,hattori.hanzo@avitek.com,,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0 8,PQUITO,Quito,Paulo,,Paulo Quito,,,,Active,paulo.quito@avitek.com,,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0 9,DBAJAJ,Bajaj,Deepak,,Deepak Bajaj,,,,Active,deepak.bajaj@avitek.com,,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0 10,GKELLY,Kelly,Grace,,Grace Kelly,,,,Active,grace.kelly@avitek.com,,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0 11,STOLER,Toler,Sydney,,Sydney Toler,,,,Active,sydney.toler@avitek.com,,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0 12,MSTARR,Starr,Manny,,Manny Starr,,,,Active,manny.starr@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 13,RKLEIN,Klein,Robert,,Robert Klein,,,,Active,robert.klein@vision.com,,Work,,,,,Full-Time,,,vision,,,,MSTARR,Manny Starr,,,,,,,0 14,MSMITH,Smith,Mark,,Mark Smith,,,,Active,mark.smith@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 15,PDEVRIES,DeVries,Peter,,Peter DeVries,,,,Active,peter.devries@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 16,JLONG,Long,Junki,,Junki Long,,,,Active,junki.long@vision.com,,Work,,,,,Full-Time,,,vision,,,,RKLEIN,Robert Klein,,,,,,,0 17,AARORA,Arora,Ajay,,Ajay Arora,,,,Active,ajay.arora@vision.com,,Work,,,,,Full-Time,,,vision,,,,MSMITH,Mark Smith,,,,,,,0 18,HSMITH,Smith,Howard,,Howard Smith,,,,Active,howard.smith@vision.com,,Work,,,,,Full-Time,,,vision,,,,RKLEIN,Robert Klein,,,,,,,0 19,YTANAWA,Tanawa,Yuki,,Yuki Tanawa,,,,Active,yuki.tanawa@vision.com,,Work,,,,,Full-Time,,,vision,,,,RKLEIN,Robert Klein,,,,,,,0 20,PBENCHLEY,Benchley,Peter,,Peter Benchley,,,,Active,peter.benchley@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 21,THILL,Hill,Terence,,Terence Hill,,,,Active,terence.hill@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 22,BSPENCER,Spencer,Bud,,Bud Spencer,,,,Active,bud.spencer@vision.com,,Work,,,,,Full-Time,,,vision,,,,AARORA,Ajay Arora,,,,,,,0 23,PMEI,Mei,Pai,,Pai Mei,,,,Active,pai.mei@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 24,BKIDDO,Kiddo,Beatrix,,Beatrix Kiddo,,,,Active,beatrix.kiddo@vision.com,,Work,,,,,Full-Time,,,vision,,,,AARORA,Ajay Arora,,,,,,,0 25,GYUBARI,Yubari,Gogo,,Gogo Yubari,,,,Active,gogo.yubari@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 26,KGHEEWALA,Gheewala,Kurush,,Kurush Gheewala,,,,Active,kurush.gheewala@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 27,JUDHAS,Udhas,Jagjit,,Jagjit Udhas,,,,Active,jagjit.udhas@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 28,NGALIL,Galil,Noah,,Noah Galil,,,,Active,noah.galil@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 29,UNAOT,Naot,Uzi,,Uzi Naot,,,,Active,uzi.naot@vision.com,,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0 30,USER_ADMIN_WITH_HIER,Admin,User,,User Admin With Hier,,,,Active,user.admin.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 31,USER_ADMIN_WITHOUT_HIER,Admin,User,,User Admin Without Hier,,,,Active,user.admin.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 32,USER_VIEWER_WITH_HIER,Viewer,User,,User Viewer With Hier,,,,Active,user.viewer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 33,USER_VIEWER_WITHOUT_HIER,Viewer,User,,User Viewer Without Hier,,,,Active,user.viewer.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 34,HELP_DESK_ADMIN_WITH_HIER,Admin,Helpdesk,,Help Desk Admin With Hier,,,,Active,helpdesk.admin.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 35,HELP_DESK_ADMIN_WITHOUT_HIER,Admin,Helpdesk,,Help Desk Admin Without Hier,,,,Active,helpdesk.admin.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 36,ORG_ADMIN_WITH_HIER,Admin,Org,,Org Admin With Hier,,,,Active,org.admin.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 37,ORG_ADMIN_WITHOUT_HIER,Admin,Org,,Org Admin Without Hier,,,,Active,org.admin.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 38,ORG_ADMIN_USER_VIEWER_WITH_HIER,UserViewer,OrgAdmin,,Org Admin User Viewer With Hier,,,,Active,org.admin.user.viewer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 39,ORG_VIEWER_WITH_HIER,Viewer,Org,,Org Viewer With Hier,,,,Active,org.viewer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 40,ORG_VIEWER_WITHOUT_HIER,Viewer,Org,,Org Viewer Without Hier,,,,Active,org.viewer.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 41,ROLE_ADMIN_WITH_HIER,Admin,Role,,Role Admin With Hier,,,,Active,role.admin.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 42,ROLE_ADMIN_WITHOUT_HIER,Admin,Role,,Role Admin Without Hier,,,,Active,role.admin.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 43,ROLE_VIEWER_WITH_HIER,Viewer,Role,,Role Viewer With Hier,,,,Active,role.viewer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 44,ROLE_VIEWER_WITHOUT_HIER,Viewer,Role,,Role Viewer Without Hier,,,,Active,role.viewer.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 45,ROLE_AUTHORIZER_WITH_HIER,Authorizer,Role,,Role Authorizer With Hier,,,,Active,role.authorizer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 46,ROLE_AUTHORIZER_WITHOUT_HIER,Authorizer,Role,,Role Authorizer Without Hier,,,,Active,role.authorizer.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 47,APP_INST_ADMIN_WITH_HIER,Admin,Appinst,,Appinst Admin With Hier,,,,Active,appinst.admin.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 48,APP_INST_ADMIN_WITHOUT_HIER,Admin,Appinst,,Appinst Admin Without Hier,,,,Active,appinst.admin.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 49,APP_INST_VIEWER_WITH_HIER,Viewer,Appinst,,Appinst Viewer With Hier,,,,Active,appinst.viewer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 50,APP_INST_VIEWER_WITHOUT_HIER,Viewer,Appinst,,Appinst Viewer Without Hier,,,,Active,appinst.viewer.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 51,APP_INST_AUTHORIZER_WITH_HIER,Authorizer,Appinst,,Appinst Authorizer With Hier,,,,Active,appinst.authorizer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 52,APP_INST_AUTHORIZER_WITHOUT_HIER,Authorizer,Appinst,,Appinst Authorizer Without Hier,,,,Active,appinst.authorizer.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 1,XELSYSADM,Administrator,System,,System Administrator,,,,Active,donotreply@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 2,XELOPERATOR,Group,Operator,,System Operator,,,,Deleted,,,,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 3,WEBLOGIC,WEBLOGIC,WEBLOGIC,,Weblogic User,,,,Active,,,,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 4,OIMINTERNAL,OIMINTERNAL,OIMINTERNAL,,Internal User,,,,Active,,,,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 53,ENTITLEMENT_ADMIN_WITH_HIER,Admin,Entitlement,,Entitlement Admin With Hier,,,,Active,entitlement.admin.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 54,ENTITLEMENT_ADMIN_WITHOUT_HIER,Admin,Entitlement,,Entitlement Admin Without Hier,,,,Active,entitlement.admin.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 55,ENTITLEMENT_VIEWER_WITH_HIER,Viewer,Entitlement,,Entitlement Viewer With Hier,,,,Active,entitlement.viewer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 56,ENTITLEMENT_VIEWER_WITHOUT_HIER,Viewer,Entitlement,,Entitlement Viewer Without Hier,,,,Active,entitlement.viewer.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 57,ENTITLEMENT_AUTHORIZER_WITH_HIER,Authorizer,Entitlement,,Entitlement Authorizer With Hier,,,,Active,entitlement.authorizer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 58,ENTITLEMENT_AUTHORIZER_WITHOUT_HIER,Authorizer,Entitlement,,Entitlement Authorizer Without Hier,,,,Active,entitlement.authorizer.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 59,SYSTEM_ADMIN_WITH_HIER,Admin,System,,System Admin With Hier,,,,Active,system.admin.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 60,SYSTEM_ADMIN_WITHOUT_HIER,Admin,System,,System Admin Without Hier,,,,Active,system.admin.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 61,SYSTEM_CONFIGURATOR_WITH_HIER,Configurator,System,,System Configurator With Hier,,,,Active,system.configurator.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 62,SYSTEM_CONFIGURATOR_WITHOUT_HIER,Configurator,System,,System Configurator Without Hier,,,,Active,system.configurator.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 63,CATALOG_ADMIN_WITH_HIER,Admin,Catalog,,Catalog Admin With Hier,,,,Active,catalog.admin.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 64,CATALOG_ADMIN_WITHOUT_HIER,Admin,Catalog,,Catalog Admin Without Hier,,,,Active,catalog.admin.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 65,CERTIFICATION_ADMIN_WITH_HIER,Admin,Certification,,Certification Admin With Hier,,,,Active,certification.admin.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 66,CERTIFICATION_ADMIN_WITHOUT_HIER,Admin,Certification,,Certification Admin Without Hier,,,,Active,certification.admin.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 67,CERTIFICATION_VIEWER_WITH_HIER,Reviewer,Certification,,Certification Reviewer With Hier,,,,Active,certification.reviewer.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 68,CERTIFICATION_VIEWER_WITHOUT_HIER,Reviewer,Certification,,Certification Reviewer Without Hier,,,,Active,certification.reviewer.without.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 69,IDENTITY_AUDIT_ADMIN_WITH_HIER,Admin,Audit,,Identity Audit Admin With Hier,,,,Active,audit.admin.with.hier@example.com,,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0 2009,KGILL,Gill,Katie,,Katie Gill,,,,Active,kgill@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2010,JNEWTON,Newton,Jose,,Jose Newton,,,,Active,jnewton@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2011,AMEYER,Meyer,Amanda,,Amanda Meyer,,,,Active,ameyer@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2012,LBATES,Bates,Laurie,,Laurie Bates,,,,Active,lbates@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2013,VMORALES,Morales,Vera,,Vera Morales,,,,Active,vmorales@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2014,KPOOLE,Poole,Kristen,,Kristen Poole,,,,Active,kpoole@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2015,WOLIVER,Oliver,Winifred,,Winifred Oliver,,,,Active,woliver@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2016,DSCHULTZ,Schultz,Deanna,,Deanna Schultz,,,,Active,dSchultz@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2017,PGOODMAN,Goodman,Patricia,,Patricia Goodman,,,,Active,pgoodman@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2018,JMULLINS,Mullins,Julio,,Julio Mullins,,,,Active,jmullins@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2019,RWALTON,Walton,Rodney,,Rodney Walton,,,,Active,rwalton@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2020,ECROSS,Cross,Elijah,,Elijah Cross,,,,Active,ecross@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2021,SROBERTSON,Robertson,Sheldon,,Sheldon Robertson,,,,Active,srobertson@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2022,MHALL,Hall,Maria,,Maria Hall,,,,Active,mhall@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2023,CMCKINNEY,Mckinney,Clark,,Clark Mckinney,,,,Active,cmckinney@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2024,WWHEELER,Wheeler,Wendy,,Wendy Wheeler,,,,Active,wwheeler@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2025,JRYAN,Ryan,Jerome,,Jerome Ryan,,,,Active,jryan@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2026,CMARSH,Marsh,Catherine,,Catherine Marsh,,,,Active,cmarsh@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2027,ECOLEMAN,Coleman,Elvira,,Elvira Coleman,,,,Active,ecoleman@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2028,SMORAN,Moran,Shawna,,Shawna Moran,,,,Active,smoran@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2029,VCARPENTER,Carpenter,Victor,,Victor Carpenter,,,,Active,vcarpenter@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2030,TGOMEZ,Gomez,Teri,,Teri Gomez,,,,Active,tgomez@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2031,EMUNOZ,Munoz,Elizabeth,,Elizabeth Munoz,,,,Active,emunoz@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2032,YWATKINS,Watkins,Yvonne,,Yvonne Watkins,,,,Active,ywatkins@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2033,SKELLER,Keller,Steve,,Steve Keller,,,,Active,skeller@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2034,SKING,King,Saul,,Saul King,,,,Active,sking@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2036,DHOWELL,Howell,Dawn,,Dawn Howell,,,,Active,dHowell@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2038,HBROCK,Brock,Hazel,,Hazel Brock,,,,Active,hBrock@example.com,,Work,,,,,Full-Time,,,Starlight,,,,DHOWELL,Dawn Howell,,,,,,,0 2039,EPATTON,Patton,Erick,,Erick Patton,,,,Active,ePatton@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2040,VANDERSON,Anderson,Verna,,Verna Anderson,,,,Active,vAnderson@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2041,AREYES,Reyes,Archie,,Archie Reyes,,,,Active,aReyes@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2042,ISAUNDERS,Saunders,van,,van Saunders,,,,Active,ISaunders@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2043,SWEBER,Weber,Saul,,Saul Weber,,,,Active,sWeber@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2044,JWATERS,Waters,Jo,,Jo Waters,,,,Active,jWaters@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2045,WJOSEPH,Joseph,Wilbur,,Wilbur Joseph,,,,Active,wJoseph@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2046,ACOOK,Cook,Aaron,,Aaron Cook,,,,Active,aCook@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2047,BBECKER,Becker,Beulah,,Beulah Becker,,,,Active,bBecker@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2048,BNICHOLS,Nichols,Bethany,,Bethany Nichols,,,,Active,bNichols@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2049,CCHAVEZ,Chavez,Cathy,,Cathy Chavez,,,,Active,cChavez@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2050,GHANSON,Hanson,Gertrude,,Gertrude Hanson,,,,Active,gHanson@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2051,MROY,Roy,May,,May Roy,,,,Active,mRoy@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2052,SWILLIS,Willis,Shelia,,Shelia Willis,,,,Active,sWillis@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2053,TWILKINS,Wilkins,Toby,,Toby Wilkins,,,,Active,tWilkins@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2054,CPAGE,Page,Connie,,Connie Page,,,,Active,cPage@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2055,TDANIELS,Daniels,Tommie,,Tommie Daniels,,,,Active,tDaniels@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2056,TORTIZ,Ortiz,Theodore,,Theodore Ortiz,,,,Active,tOrtiz@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2057,FLAMB,Lamb,Florence,,Florence Lamb,,,,Active,fLamb@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2058,SABBOTT,Abbott,Sherry,,Sherry Abbott,,,,Active,sAbbott@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2059,AQUINN,Quinn,Austin,,Austin Quinn,,,,Active,aQuinn@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2060,FWHEELER,Wheeler,Freda,,Freda Wheeler,,,,Active,fWheeler@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2061,ENEWTON,Newton,Evelyn,,Evelyn Newton,,,,Active,eNewton@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2062,RROBERSON,Roberson,Rick,,Rick Roberson,,,,Active,rRoberson@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2063,JNORMAN,Norman,Jerald,,Jerald Norman,,,,Active,jNorman@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2064,AWILKINS,Wilkins,Alfred,,Alfred Wilkins,,,,Active,aWilkins@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2065,AMUNOZ,Munoz,Alyssa,,Alyssa Munoz,,,,Active,aMunoz@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2066,AWONG,Wong,April,,April Wong,,,,Active,aWong@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2067,NMYERS,Myers,Nelson,,Nelson Myers,,,,Active,nMyers@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2068,PFRANCIS,Francis,Patti,,Patti Francis,,,,Active,pFrancis@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2069,BBARBER,Barber,Bert,,Bert Barber,,,,Active,bBarber@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2070,RCHAMBERS,Chambers,Randolph,,Randolph Chambers,,,,Active,rChambers@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2071,VORTIZ,Ortiz,Vernon,,Vernon Ortiz,,,,Active,vOrtiz@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2072,ICALDWELL,Caldwell,Inez,,Inez Caldwell,,,,Active,ICaldwell@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2073,KMYERS,Myers,Karla,,Karla Myers,,,,Active,kMyers@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2074,LMULLINS,Mullins,Lowell,,Lowell Mullins,,,,Active,lMullins@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2075,CHOPKINS,Hopkins,Crystal,,Crystal Hopkins,,,,Active,cHopkins@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2076,NRICE,Rice,Nichole,,Nichole Rice,,,,Active,nRice@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2077,LVEGA,Vega,Luke,,Luke Vega,,,,Active,lVega@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2078,MBAKER,Baker,Mable,,Mable Baker,,,,Active,mBaker@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2079,OGONZALES,Gonzales,Ollie,,Ollie Gonzales,,,,Active,oGonzales@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2080,TARMSTRONG,Armstrong,Toby,,Toby Armstrong,,,,Active,tArmstrong@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2081,GABBOTT,Abbott,Gerard,,Gerard Abbott,,,,Active,gAbbott@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2082,LDAWSON,Dawson,Leah,,Leah Dawson,,,,Active,lDawson@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2083,NROMERO,Romero,Noel,,Noel Romero,,,,Active,nRomero@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2084,ACANNON,Cannon,Austin,,Austin Cannon,,,,Active,aCannon@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2085,TMALDONADO,Maldonado,Terry,,Terry Maldonado,,,,Active,tMaldonado@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2086,CGREGORY,Gregory,Cora,,Cora Gregory,,,,Active,cGregory@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2087,SCORTEZ,Cortez,Shannon,,Shannon Cortez,,,,Active,sCortez@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2088,SMCDONALD,Mcdonald,Sharon,,Sharon Mcdonald,,,,Active,sMcdonald@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2089,FGOODMAN,Goodman,Fredrick,,Fredrick Goodman,,,,Active,fGoodman@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2090,SRICHARDSON,Richardson,Sherman,,Sherman Richardson,,,,Active,sRichardson@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2091,RPETERSON,Peterson,Russell,,Russell Peterson,,,,Active,rPeterson@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2092,LPITTMAN,Pittman,Lora,,Lora Pittman,,,,Active,lPittman@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2093,CORTEGA,Ortega,Chester,,Chester Ortega,,,,Active,cOrtega@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2094,NTHOMPSON,Thompson,Nicole,,Nicole Thompson,,,,Active,nThompson@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2095,JFREEMAN,Freeman,Jill,,Jill Freeman,,,,Active,jFreeman@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2096,DWASHINGTON,Washington,Danny,,Danny Washington,,,,Active,dWashington@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2097,CALEXANDER,Alexander,Carmen,,Carmen Alexander,,,,Active,cAlexander@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2098,PBARTON,Barton,Patsy,,Patsy Barton,,,,Active,pBarton@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2099,JMOODY,Moody,Jo,,Jo Moody,,,,Active,jMoody@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2100,DELLIOTT,Elliott,Doyle,,Doyle Elliott,,,,Active,dElliott@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2101,DFOWLER,Fowler,Dwayne,,Dwayne Fowler,,,,Active,dFowler@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2102,VCALDWELL,Caldwell,Virginia,,Virginia Caldwell,,,,Active,vCaldwell@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2103,LBLAKE,Blake,Lynn,,Lynn Blake,,,,Active,lBlake@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2104,JLARSON,Larson,Jermaine,,Jermaine Larson,,,,Active,jLarson@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2105,GOSBORNE,Osborne,Gloria,,Gloria Osborne,,,,Active,gOsborne@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2106,TMORENO,Moreno,Tanya,,Tanya Moreno,,,,Active,tMoreno@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0 2107,KADAMS,Adams,Kristina,,Kristina Adams,,,,Active,kAdams@example.com,,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
3.3.3.2 Sample applications.csv File
The following table lists the mandatory and optional application attributes for data import from flat files.
| OIRI Attribute | Mandatory/Optional |
|---|---|
| EXT_APP_ID | Optional |
| NAME | Mandatory |
| DISPLAY_NAME | Optional |
| TYPE | Mandatory |
| DESCRIPTION | Optional |
| RISK_SCORE | Optional |
The following is a sample applications.csv file:
"EXT_APP_ID","NAME","DISPLAY_NAME","TYPE","DESCRIPTION","RISK_SCORE" 47,"ebs1","ebs1","Disconnected","ebs1",3 48,"EBS2","EBS2","Disconnected","EBS2",3 1,"myapp","myapp","Disconnected","my test application",1 41,"LapTop","LapTop","Disconnected","Laptop",3 44,"activeb","activeb","Disconnected","activeb",3 45,"ActiveD","ActiveD","Disconnected","ActiveD",3 46,"ActiveE","ActiveE","Disconnected","ActiveE",3 5,"myapp1","myapp1","Disconnected","",3 43,"mobile","mobile","Disconnected","mobile",3 49,"DB1","DB1","Disconnected","DB1",3 2,"VISDU1","VISDU1","DOBBased","VISDU1",7 3,"VISDU2","VISDU2","DOBBased","VISDU2",7 4,"VISDU3","VISDU3","DOBBased","VISDU3",7 23,"JIRAApp","JIRAApp","Disconnected","JIRAApp",3 42,"Badge","Badge","Disconnected","Badge",3 50,"DB2","DB2","Disconnected","DB2",3
3.3.3.3 Sample accounts.csv File
The following table lists the mandatory and optional account attributes for data import from flat files.
| OIRI Attribute | Mandatory/Optional |
|---|---|
| EXT_ACCOUNT_ID | Optional |
| ACCOUNT_NAME | Mandatory |
| ACCOUNT_TYPE | Mandatory |
| USER_NAME | Mandatory |
| APPLICATION_NAME | Mandatory |
The following is a sample accounts.csv file:
"EXT_ACCOUNT_ID","ACCOUNT_NAME","ACCOUNT_TYPE","USER_NAME","APPLICATION_NAME" 238,"VCERTUSER1","primary","VCERTUSER1","VISDU1" 239,"VCERTUSER2","primary","VCERTUSER2","VISDU1" 240,"VCERTUSER3","primary","VCERTUSER3","VISDU1" 241,"VCERTUSER4","primary","VCERTUSER4","VISDU1" 242,"VCERTUSER5","primary","VCERTUSER5","VISDU1" 243,"VCERTUSER6","primary","VCERTUSER6","VISDU1" 244,"VCERTUSER7","primary","VCERTUSER7","VISDU1" 245,"VCERTUSER8","primary","VCERTUSER8","VISDU1" 246,"VCERTUSER9","primary","VCERTUSER9","VISDU1" 247,"VCERTUSER10","primary","VCERTUSER10","VISDU1" 248,"VCERTUSER11","primary","VCERTUSER11","VISDU1" 249,"VCERTUSER1","primary","VCERTUSER1","VISDU2" 250,"VCERTUSER2","primary","VCERTUSER2","VISDU2" 251,"VCERTUSER3","primary","VCERTUSER3","VISDU2" 252,"VCERTUSER4","primary","VCERTUSER4","VISDU2" 253,"VCERTUSER5","primary","VCERTUSER5","VISDU2" 254,"VCERTUSER6","primary","VCERTUSER6","VISDU2" 255,"VCERTUSER7","primary","VCERTUSER7","VISDU2" 256,"VCERTUSER8","primary","VCERTUSER8","VISDU2" 257,"VCERTUSER9","primary","VCERTUSER9","VISDU2" 258,"VCERTUSER10","primary","VCERTUSER10","VISDU2" 259,"VCERTUSER11","primary","VCERTUSER11","VISDU2" 260,"VCERTUSER1","primary","VCERTUSER1","VISDU3" 261,"VCERTUSER2","primary","VCERTUSER2","VISDU3" 262,"VCERTUSER3","primary","VCERTUSER3","VISDU3" 263,"VCERTUSER4","primary","VCERTUSER4","VISDU3" 264,"VCERTUSER5","primary","VCERTUSER5","VISDU3" 265,"VCERTUSER6","primary","VCERTUSER6","VISDU3" 266,"VCERTUSER7","primary","VCERTUSER7","VISDU3" 267,"VCERTUSER8","primary","VCERTUSER8","VISDU3" 268,"VCERTUSER9","primary","VCERTUSER9","VISDU3" 269,"VCERTUSER10","primary","VCERTUSER10","VISDU3" 270,"VCERTUSER11","primary","VCERTUSER11","VISDU3" 271,"test","primary","XELSYSADM","myapp1" 303,"303","other","USR_5","LapTop" 304,"304","primary","USR_5","LapTop" 561,"561","primary","JNORMAN","Badge" 562,"562","primary","AMUNOZ","Badge" 563,"563","primary","AWONG","Badge" 564,"564","primary","NMYERS","Badge" 565,"565","primary","BBARBER","Badge" 566,"566","primary","RCHAMBERS","Badge" 567,"567","primary","VORTIZ","Badge" 568,"568","primary","ICALDWELL","Badge" 569,"569","primary","KMYERS","Badge" 570,"570","primary","LMULLINS","Badge" 571,"571","primary","CHOPKINS","Badge" 572,"572","primary","NRICE","Badge" 573,"573","primary","LVEGA","Badge" 574,"574","primary","MBAKER","Badge" 575,"575","primary","OGONZALES","Badge" 576,"576","primary","TARMSTRONG","Badge" 577,"577","primary","GABBOTT","Badge" 578,"578","primary","LDAWSON","Badge" 579,"579","primary","NROMERO","Badge" 580,"580","primary","ACANNON","Badge" 581,"581","primary","TMALDONADO","Badge" 582,"582","primary","CGREGORY","Badge" 583,"583","primary","SCORTEZ","Badge" 584,"584","primary","SMCDONALD","Badge" 585,"585","primary","FGOODMAN","Badge" 586,"586","primary","SRICHARDSON","Badge" 587,"587","primary","RPETERSON","Badge" 588,"588","primary","LPITTMAN","Badge" 589,"589","primary","CORTEGA","Badge" 590,"590","primary","NTHOMPSON","Badge" 591,"591","primary","JFREEMAN","Badge" 592,"592","primary","DWASHINGTON","Badge" 593,"593","primary","CALEXANDER","Badge" 594,"594","primary","PBARTON","Badge" 595,"595","primary","JMOODY","Badge" 596,"596","primary","DELLIOTT","Badge" 597,"597","primary","DFOWLER","Badge" 598,"598","primary","VCALDWELL","Badge" 599,"599","primary","LBLAKE","Badge" 600,"600","primary","JLARSON","Badge" 601,"601","primary","GOSBORNE","Badge" 602,"602","primary","TMORENO","Badge" 603,"603","primary","KADAMS","Badge" 604,"604","primary","HBROCK","mobile" 605,"605","primary","EPATTON","mobile" 606,"606","primary","VANDERSON","mobile" 607,"607","primary","AREYES","mobile" 608,"608","primary","ISAUNDERS","mobile" 609,"609","primary","SWEBER","mobile" 610,"610","primary","JWATERS","mobile" 611,"611","primary","WJOSEPH","mobile" 612,"612","primary","ACOOK","mobile" 613,"613","primary","BBECKER","mobile" 614,"614","primary","BNICHOLS","mobile" 615,"615","primary","CCHAVEZ","mobile" 616,"616","primary","GHANSON","mobile" 617,"617","primary","MROY","mobile" 618,"618","primary","SWILLIS","mobile" 619,"619","primary","TWILKINS","mobile" 620,"620","primary","CPAGE","mobile" 621,"621","primary","TDANIELS","mobile" 622,"622","primary","TORTIZ","mobile" 623,"623","primary","FLAMB","mobile" 624,"624","primary","SABBOTT","mobile" 625,"625","primary","AQUINN","mobile" 626,"626","primary","FWHEELER","mobile" 627,"627","primary","RROBERSON","mobile" 713,"713","primary","NROMERO","activeb" 714,"714","primary","ACANNON","activeb" 715,"715","primary","TMALDONADO","activeb" 716,"716","primary","CGREGORY","activeb" 717,"717","primary","SCORTEZ","activeb" 718,"718","primary","SMCDONALD","activeb" 719,"719","primary","FGOODMAN","activeb" 720,"720","primary","SRICHARDSON","activeb" 721,"721","primary","RPETERSON","activeb" 722,"722","primary","LPITTMAN","activeb" 723,"723","primary","CORTEGA","activeb" 724,"724","primary","NTHOMPSON","activeb" 725,"725","primary","JFREEMAN","activeb" 726,"726","primary","DWASHINGTON","activeb" 727,"727","primary","CALEXANDER","activeb" 728,"728","primary","PBARTON","activeb" 729,"729","primary","JMOODY","activeb" 730,"730","primary","DELLIOTT","activeb" 731,"731","primary","DFOWLER","activeb" 732,"732","primary","VCALDWELL","activeb" 733,"733","primary","LBLAKE","activeb" 734,"734","primary","JLARSON","activeb" 735,"735","primary","GOSBORNE","activeb" 736,"736","primary","TMORENO","activeb" 737,"737","primary","KADAMS","activeb" 741,"second1","other","CALEXANDER","Badge" 628,"628","primary","JNORMAN","mobile" 629,"629","primary","AMUNOZ","mobile" 630,"630","primary","AWONG","mobile" 631,"631","primary","NMYERS","mobile" 632,"632","primary","BBARBER","mobile" 633,"633","primary","RCHAMBERS","mobile" 634,"634","primary","VORTIZ","mobile" 635,"635","primary","ICALDWELL","mobile" 636,"636","primary","KMYERS","mobile" 637,"637","primary","LMULLINS","mobile" 638,"638","primary","CHOPKINS","mobile" 639,"639","primary","NRICE","mobile" 640,"640","primary","LVEGA","mobile" 641,"641","primary","MBAKER","mobile" 642,"642","primary","OGONZALES","mobile" 643,"643","primary","TARMSTRONG","mobile" 644,"644","primary","GABBOTT","mobile" 645,"645","primary","LDAWSON","mobile" 646,"646","primary","NROMERO","mobile" 647,"647","primary","ACANNON","mobile" 648,"648","primary","TMALDONADO","mobile" 649,"649","primary","CGREGORY","mobile" 650,"650","primary","SCORTEZ","mobile" 651,"651","primary","SMCDONALD","mobile" 652,"652","primary","FGOODMAN","mobile" 653,"653","primary","SRICHARDSON","mobile" 654,"654","primary","RPETERSON","mobile" 655,"655","primary","LPITTMAN","mobile" 656,"656","primary","CORTEGA","mobile" 657,"657","primary","NTHOMPSON","mobile" 658,"658","primary","JFREEMAN","mobile" 659,"659","primary","DWASHINGTON","mobile" 660,"660","primary","CALEXANDER","mobile" 661,"661","primary","PBARTON","mobile" 662,"662","primary","JMOODY","mobile" 663,"663","primary","DELLIOTT","mobile" 664,"664","primary","DFOWLER","mobile" 665,"665","primary","VCALDWELL","mobile" 666,"666","primary","LBLAKE","mobile" 667,"667","primary","JLARSON","mobile" 668,"668","primary","GOSBORNE","mobile" 669,"669","primary","TMORENO","mobile" 670,"670","primary","KADAMS","mobile" 671,"671","primary","HBROCK","activeb" 672,"672","primary","EPATTON","activeb" 673,"673","primary","VANDERSON","activeb" 674,"674","primary","AREYES","activeb" 675,"675","primary","ISAUNDERS","activeb" 676,"676","primary","SWEBER","activeb" 677,"677","primary","JWATERS","activeb" 678,"678","primary","WJOSEPH","activeb" 679,"679","primary","ACOOK","activeb" 680,"680","primary","BBECKER","activeb" 681,"681","primary","BNICHOLS","activeb" 682,"682","primary","CCHAVEZ","activeb" 683,"683","primary","GHANSON","activeb" 684,"684","primary","MROY","activeb" 685,"685","primary","SWILLIS","activeb" 686,"686","primary","TWILKINS","activeb" 687,"687","primary","CPAGE","activeb" 688,"688","primary","TDANIELS","activeb" 689,"689","primary","TORTIZ","activeb" 690,"690","primary","FLAMB","activeb" 691,"691","primary","SABBOTT","activeb" 692,"692","primary","AQUINN","activeb" 693,"693","primary","FWHEELER","activeb" 694,"694","primary","RROBERSON","activeb" 695,"695","primary","JNORMAN","activeb" 696,"696","primary","AMUNOZ","activeb" 697,"697","primary","AWONG","activeb" 698,"698","primary","NMYERS","activeb" 699,"699","primary","BBARBER","activeb" 700,"700","primary","RCHAMBERS","activeb" 701,"701","primary","VORTIZ","activeb" 702,"702","primary","ICALDWELL","activeb" 703,"703","primary","KMYERS","activeb" 704,"704","primary","LMULLINS","activeb" 705,"705","primary","CHOPKINS","activeb" 706,"706","primary","NRICE","activeb" 707,"707","primary","LVEGA","activeb" 708,"708","primary","MBAKER","activeb" 709,"709","primary","OGONZALES","activeb" 710,"710","primary","TARMSTRONG","activeb" 711,"711","primary","GABBOTT","activeb" 712,"712","primary","LDAWSON","activeb" 366,"366","primary","DLEWIS","LapTop" 367,"367","primary","MSANDOVAL","LapTop" 368,"368","primary","CDELGADO","LapTop" 369,"369","primary","KGILL","LapTop" 370,"370","primary","JNEWTON","LapTop" 371,"371","primary","AMEYER","LapTop" 372,"372","primary","LBATES","LapTop" 373,"373","primary","VMORALES","LapTop" 374,"374","primary","KPOOLE","LapTop" 375,"375","primary","WOLIVER","LapTop" 376,"376","primary","DSCHULTZ","LapTop" 377,"377","primary","PGOODMAN","LapTop" 378,"378","primary","JMULLINS","LapTop" 379,"379","primary","RWALTON","LapTop" 380,"380","primary","ECROSS","LapTop" 381,"381","primary","SROBERTSON","LapTop" 382,"382","primary","MHALL","LapTop" 383,"383","primary","CMCKINNEY","LapTop" 384,"384","primary","WWHEELER","LapTop" 385,"385","primary","JRYAN","LapTop" 386,"386","primary","CMARSH","LapTop" 387,"387","primary","ECOLEMAN","LapTop" 388,"388","primary","SMORAN","LapTop" 389,"389","primary","VCARPENTER","LapTop" 390,"390","primary","TGOMEZ","LapTop" 391,"391","primary","EMUNOZ","LapTop" 392,"392","primary","YWATKINS","LapTop" 393,"393","primary","SKELLER","LapTop" 394,"394","primary","SKING","LapTop" 537,"537","primary","HBROCK","Badge" 538,"538","primary","EPATTON","Badge" 539,"539","primary","VANDERSON","Badge" 540,"540","primary","AREYES","Badge" 541,"541","primary","ISAUNDERS","Badge" 542,"542","primary","SWEBER","Badge" 543,"543","primary","JWATERS","Badge" 544,"544","primary","WJOSEPH","Badge" 545,"545","primary","ACOOK","Badge" 546,"546","primary","BBECKER","Badge" 547,"547","primary","BNICHOLS","Badge" 548,"548","primary","CCHAVEZ","Badge" 549,"549","primary","GHANSON","Badge" 550,"550","primary","MROY","Badge" 551,"551","primary","SWILLIS","Badge" 552,"552","primary","TWILKINS","Badge" 553,"553","primary","CPAGE","Badge" 554,"554","primary","TDANIELS","Badge" 555,"555","primary","TORTIZ","Badge" 556,"556","primary","FLAMB","Badge" 557,"557","primary","SABBOTT","Badge" 558,"558","primary","AQUINN","Badge" 559,"559","primary","FWHEELER","Badge" 560,"560","primary","RROBERSON","Badge"
3.3.3.4 Sample entitlements.csv File
The following table lists the mandatory and optional entitlement attributes for data import from flat files.
| OIRI Attribute | Mandatory/Optional |
|---|---|
| EXT_ENT_ID | Optional |
| NAME | Mandatory |
| DISPLAY_NAME | Optional |
| APPLICATION_NAME | Mandatory |
| GRANTEE_TYPE | Optional |
| EXT_GRANTEE_ID | Optional |
| GRANTEE_NAME | Optional |
| RISK_SCORE | Optional |
The following is a sample entitlements.csv file:
"EXT_ENT_ID","NAME","DISPLAY_NAME","APPLICATION_NAME","GRANTEE_TYPE","EXT_GRANTEE_ID","GRANTEE_NAME","RISK_SCORE" 9,"EntTestDB~CN=VISDU33,DC=abc,DC=com","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form",7,"VISDU3 lookup",3 8,"EntTestDB~CN=VISDU32,DC=abc,DC=com","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form",7,"VISDU3 lookup",3 7,"EntTestDB~CN=VISDU31,DC=abc,DC=com","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form",7,"VISDU3 lookup",3 11,"Dell","Dell","myapp1","myapp1 child form",8,"ID",3 10,"Mac","Mac","myapp1","myapp1 child form",8,"ID",3 3,"EntTestDB~CN=VISDU13,DC=abc,DC=com","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form",5,"VISDU1 lookup",3 2,"EntTestDB~CN=VISDU12,DC=abc,DC=com","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form",5,"VISDU1 lookup",3 1,"EntTestDB~CN=VISDU11,DC=abc,DC=com","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form",5,"VISDU1 lookup",3 6,"EntTestDB~CN=VISDU23,DC=abc,DC=com","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form",6,"VISDU2 lookup",3 5,"EntTestDB~CN=VISDU22,DC=abc,DC=com","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form",6,"VISDU2 lookup",3 4,"EntTestDB~CN=VISDU21,DC=abc,DC=com","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form",6,"VISDU2 lookup",3 110,"EBS1_6","EBS1_6","ebs1","ebs1 child form",67,"entitlements",3 109,"EBS1_2","EBS1_2","ebs1","ebs1 child form",67,"entitlements",3 108,"EBS1_10","EBS1_10","ebs1","ebs1 child form",67,"entitlements",3 107,"EBS1_3","EBS1_3","ebs1","ebs1 child form",67,"entitlements",3 106,"EBS1_1","EBS1_1","ebs1","ebs1 child form",67,"entitlements",3 105,"EBS1_9","EBS1_9","ebs1","ebs1 child form",67,"entitlements",3 104,"EBS1_5","EBS1_5","ebs1","ebs1 child form",67,"entitlements",3 103,"EBS1_4","EBS1_4","ebs1","ebs1 child form",67,"entitlements",3 102,"EBS1_8","EBS1_8","ebs1","ebs1 child form",67,"entitlements",3 101,"EBS1_7","EBS1_7","ebs1","ebs1 child form",67,"entitlements",3 130,"DB1_2","DB1_2","DB1","DB1 child form",69,"entitlements",3 129,"DB1_6","DB1_6","DB1","DB1 child form",69,"entitlements",3 128,"DB1_10","DB1_10","DB1","DB1 child form",69,"entitlements",3 127,"DB1_5","DB1_5","DB1","DB1 child form",69,"entitlements",3 126,"DB1_4","DB1_4","DB1","DB1 child form",69,"entitlements",3 125,"DB1_1","DB1_1","DB1","DB1 child form",69,"entitlements",3 124,"DB1_7","DB1_7","DB1","DB1 child form",69,"entitlements",3 123,"DB1_9","DB1_9","DB1","DB1 child form",69,"entitlements",3 122,"DB1_8","DB1_8","DB1","DB1 child form",69,"entitlements",3 121,"DB1_3","DB1_3","DB1","DB1 child form",69,"entitlements",3 140,"DB2_8","DB2_8","DB2","DB2 child form",70,"entitlements",3 139,"DB2_7","DB2_7","DB2","DB2 child form",70,"entitlements",3 138,"DB2_6","DB2_6","DB2","DB2 child form",70,"entitlements",3 137,"DB2_10","DB2_10","DB2","DB2 child form",70,"entitlements",3 136,"DB2_2","DB2_2","DB2","DB2 child form",70,"entitlements",3 135,"DB2_4","DB2_4","DB2","DB2 child form",70,"entitlements",3 134,"DB2_3","DB2_3","DB2","DB2 child form",70,"entitlements",3 133,"DB2_9","DB2_9","DB2","DB2 child form",70,"entitlements",3 132,"DB2_1","DB2_1","DB2","DB2 child form",70,"entitlements",3 131,"DB2_5","DB2_5","DB2","DB2 child form",70,"entitlements",3 44,"Store","Store","Badge","Badge Types",62,"type",3 43,"Access","Access","Badge","Badge Types",62,"type",3 60,"reception","reception","Badge","Badge Types",62,"type",3 59,"warehouse","warehouse","Badge","Badge Types",62,"type",3 55,"Conference","Conference","Badge","Badge Types",62,"type",3 54,"Cafteria","Cafteria","Badge","Badge Types",62,"type",3 53,"Office","Office","Badge","Badge Types",62,"type",3 51,"Printer","Printer","Badge","Badge Types",62,"type",3 50,"ACRoom","ACRoom","Badge","Badge Types",62,"type",3 45,"generator","generator","Badge","Badge Types",62,"type",1 80,"ActiveB9","ActiveB9","activeb","activeb child form",64,"entitlements",3 79,"ActiveB8","ActiveB8","activeb","activeb child form",64,"entitlements",3 78,"ActiveB3","ActiveB3","activeb","activeb child form",64,"entitlements",3 77,"ActiveB2","ActiveB2","activeb","activeb child form",64,"entitlements",3 76,"ActiveB10","ActiveB10","activeb","activeb child form",64,"entitlements",3 75,"ActiveB7","ActiveB7","activeb","activeb child form",64,"entitlements",3 74,"ActiveB1","ActiveB1","activeb","activeb child form",64,"entitlements",3 73,"ActiveB6","ActiveB6","activeb","activeb child form",64,"entitlements",3 72,"ActiveB5","ActiveB5","activeb","activeb child form",64,"entitlements",3 71,"ActiveB4","ActiveB4","activeb","activeb child form",64,"entitlements",3 42,"DELL","DELL","LapTop","LapTop child form",61,"model",3 41,"HP","HP","LapTop","LapTop child form",61,"model",3 58,"Toshiba","Toshiba","LapTop","LapTop child form",61,"model",3 57,"Compaq","Compaq","LapTop","LapTop child form",61,"model",3 56,"Lenovo","Lenovo","LapTop","LapTop child form",61,"model",3 52,"Zenith","Zenith","LapTop","LapTop child form",61,"model",3 49,"MI","MI","LapTop","LapTop child form",61,"model",3 48,"Mac","Mac","LapTop","LapTop child form",61,"model",3 47,"HCL","HCL","LapTop","LapTop child form",61,"model",3 46,"Asus","Asus","LapTop","LapTop child form",61,"model",3 70,"realme","samsung","mobile","mobile child form",63,"company",3 69,"apple","apple","mobile","mobile child form",63,"company",3 68,"micromax","micromax","mobile","mobile child form",63,"company",3 67,"HTC","HTC","mobile","mobile child form",63,"company",3 66,"Nokia","Nokia","mobile","mobile child form",63,"company",3 65,"celeron","celeron","mobile","mobile child form",63,"company",3 64,"Lenovo","Lenovo","mobile","mobile child form",63,"company",3 63,"Oppo","Oppo","mobile","mobile child form",63,"company",3 62,"MI","MI","mobile","mobile child form",63,"company",3 61,"samsung","samsung","mobile","mobile child form",63,"company",3 90,"ActiveD8","ActiveD8","ActiveD","ActiveD child form",65,"entitlements",3 89,"ActiveD4","ActiveD4","ActiveD","ActiveD child form",65,"entitlements",3 88,"ActiveD1","ActiveD1","ActiveD","ActiveD child form",65,"entitlements",3 87,"ActiveD9","ActiveD9","ActiveD","ActiveD child form",65,"entitlements",3 86,"ActiveD10","ActiveD10","ActiveD","ActiveD child form",65,"entitlements",3 85,"ActiveD3","ActiveD3","ActiveD","ActiveD child form",65,"entitlements",3 84,"ActiveD5","ActiveD5","ActiveD","ActiveD child form",65,"entitlements",3 83,"ActiveD7","ActiveD7","ActiveD","ActiveD child form",65,"entitlements",3 82,"ActiveD6","ActiveD6","ActiveD","ActiveD child form",65,"entitlements",3 81,"ActiveD2","ActiveD2","ActiveD","ActiveD child form",65,"entitlements",3 100,"ActiveE7","ActiveE7","ActiveE","ActiveE child form",66,"entitlements",3 99,"ActiveE8","ActiveE8","ActiveE","ActiveE child form",66,"entitlements",3 98,"ActiveE6","ActiveE6","ActiveE","ActiveE child form",66,"entitlements",3 97,"ActiveE1","ActiveE1","ActiveE","ActiveE child form",66,"entitlements",3 96,"ActiveE4","ActiveE4","ActiveE","ActiveE child form",66,"entitlements",3 95,"ActiveE5","ActiveE5","ActiveE","ActiveE child form",66,"entitlements",3 94,"ActiveE3","ActiveE3","ActiveE","ActiveE child form",66,"entitlements",3 93,"ActiveE2","ActiveE2","ActiveE","ActiveE child form",66,"entitlements",3 92,"ActiveE10","ActiveE10","ActiveE","ActiveE child form",66,"entitlements",3 91,"ActiveE9","ActiveE9","ActiveE","ActiveE child form",66,"entitlements",3 120,"EBS2_9","EBS2_9","EBS2","EBS2 child form",68,"entitlements",3 119,"EBS2_1","EBS2_1","EBS2","EBS2 child form",68,"entitlements",3 118,"EBS2_4","EBS2_4","EBS2","EBS2 child form",68,"entitlements",3 117,"EBS2_7","EBS2_7","EBS2","EBS2 child form",68,"entitlements",3 116,"EBS2_8","EBS2_8","EBS2","EBS2 child form",68,"entitlements",3 115,"EBS2_5","EBS2_5","EBS2","EBS2 child form",68,"entitlements",3 114,"EBS2_2","EBS2_2","EBS2","EBS2 child form",68,"entitlements",3 113,"EBS2_6","EBS2_6","EBS2","EBS2 child form",68,"entitlements",3 112,"EBS2_10","EBS2_10","EBS2","EBS2 child form",68,"entitlements",3 111,"EBS2_3","EBS2_3","EBS2","EBS2 child form",68,"entitlements",3
3.3.3.5 Sample assignedEntitlements.csv File
The following table lists the mandatory and optional assignedEntitlements attributes for data import from flat files.
| OIRI Attribute | Mandatory/Optional |
|---|---|
| EXT_USER_ID | Optional |
| USER_NAME | Mandatory |
| ENTITLEMENT_NAME | Mandatory |
| APPLICATION_NAME | Mandatory |
| GRANTEE_TYPE | Mandatory |
| GRANTEE_NAME | Mandatory |
The following is a sample assignedEntitlements.csv file:
"EXT_USER_ID","USER_NAME","ENTITLEMENT_NAME","APPLICATION_NAME","GRANTEE_TYPE","GRANTEE_NAME" 100,"VCERTUSER11","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2006,"DLEWIS","Lenovo","LapTop","LapTop child form","model" 2007,"MSANDOVAL","Mac","LapTop","LapTop child form","model" 2008,"CDELGADO","HCL","LapTop","LapTop child form","model" 2009,"KGILL","Lenovo","LapTop","LapTop child form","model" 90,"VCERTUSER1","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 94,"VCERTUSER5","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 97,"VCERTUSER8","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 99,"VCERTUSER10","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 2026,"CMARSH","Mac","LapTop","LapTop child form","model" 2026,"CMARSH","Compaq","LapTop","LapTop child form","model" 2026,"CMARSH","MI","LapTop","LapTop child form","model" 2027,"ECOLEMAN","Compaq","LapTop","LapTop child form","model" 2028,"SMORAN","Zenith","LapTop","LapTop child form","model" 2011,"AMEYER","Toshiba","LapTop","LapTop child form","model" 2012,"LBATES","Mac","LapTop","LapTop child form","model" 2013,"VMORALES","Asus","LapTop","LapTop child form","model" 2014,"KPOOLE","HP","LapTop","LapTop child form","model" 2014,"KPOOLE","Toshiba","LapTop","LapTop child form","model" 2016,"DSCHULTZ","Mac","LapTop","LapTop child form","model" 2017,"PGOODMAN","HP","LapTop","LapTop child form","model" 2017,"PGOODMAN","Toshiba","LapTop","LapTop child form","model" 2017,"PGOODMAN","MI","LapTop","LapTop child form","model" 1,"XELSYSADM","Dell","myapp1","myapp1 child form","ID" 2018,"JMULLINS","HP","LapTop","LapTop child form","model" 2018,"JMULLINS","Lenovo","LapTop","LapTop child form","model" 2020,"ECROSS","MI","LapTop","LapTop child form","model" 2021,"SROBERTSON","Compaq","LapTop","LapTop child form","model" 2023,"CMCKINNEY","HP","LapTop","LapTop child form","model" 2025,"JRYAN","Zenith","LapTop","LapTop child form","model" 2025,"JRYAN","Lenovo","LapTop","LapTop child form","model" 2026,"CMARSH","DELL","LapTop","LapTop child form","model" 90,"VCERTUSER1","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 91,"VCERTUSER2","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 93,"VCERTUSER4","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 94,"VCERTUSER5","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 98,"VCERTUSER9","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 98,"VCERTUSER9","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 99,"VCERTUSER10","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 90,"VCERTUSER1","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 93,"VCERTUSER4","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 94,"VCERTUSER5","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 95,"VCERTUSER6","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 97,"VCERTUSER8","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2057,"FLAMB","reception","Badge","Badge Types","type" 2059,"AQUINN","Store","Badge","Badge Types","type" 2060,"FWHEELER","Printer","Badge","Badge Types","type" 2060,"FWHEELER","warehouse","Badge","Badge Types","type" 2060,"FWHEELER","generator","Badge","Badge Types","type" 2062,"RROBERSON","warehouse","Badge","Badge Types","type" 2063,"JNORMAN","reception","Badge","Badge Types","type" 2065,"AMUNOZ","warehouse","Badge","Badge Types","type" 2065,"AMUNOZ","reception","Badge","Badge Types","type" 2066,"AWONG","Printer","Badge","Badge Types","type" 2078,"MBAKER","Store","Badge","Badge Types","type" 2078,"MBAKER","Office","Badge","Badge Types","type" 2079,"OGONZALES","generator","Badge","Badge Types","type" 2080,"TARMSTRONG","Store","Badge","Badge Types","type" 2080,"TARMSTRONG","Printer","Badge","Badge Types","type" 2080,"TARMSTRONG","Office","Badge","Badge Types","type" 2080,"TARMSTRONG","generator","Badge","Badge Types","type" 2081,"GABBOTT","Store","Badge","Badge Types","type" 2081,"GABBOTT","Cafteria","Badge","Badge Types","type" 2082,"LDAWSON","warehouse","Badge","Badge Types","type" 2084,"ACANNON","warehouse","Badge","Badge Types","type" 2084,"ACANNON","generator","Badge","Badge Types","type" 2086,"CGREGORY","ACRoom","Badge","Badge Types","type" 2086,"CGREGORY","Printer","Badge","Badge Types","type" 2086,"CGREGORY","Office","Badge","Badge Types","type" 2086,"CGREGORY","warehouse","Badge","Badge Types","type" 2087,"SCORTEZ","warehouse","Badge","Badge Types","type" 2089,"FGOODMAN","Store","Badge","Badge Types","type" 2089,"FGOODMAN","generator","Badge","Badge Types","type" 2091,"RPETERSON","Access","Badge","Badge Types","type" 2091,"RPETERSON","Conference","Badge","Badge Types","type" 2092,"LPITTMAN","reception","Badge","Badge Types","type" 2093,"CORTEGA","Conference","Badge","Badge Types","type" 2094,"NTHOMPSON","Conference","Badge","Badge Types","type" 2094,"NTHOMPSON","generator","Badge","Badge Types","type" 2095,"JFREEMAN","ACRoom","Badge","Badge Types","type" 2095,"JFREEMAN","Cafteria","Badge","Badge Types","type" 2096,"DWASHINGTON","Printer","Badge","Badge Types","type" 2096,"DWASHINGTON","Conference","Badge","Badge Types","type" 2097,"CALEXANDER","reception","Badge","Badge Types","type" 2099,"JMOODY","Cafteria","Badge","Badge Types","type" 2101,"DFOWLER","Conference","Badge","Badge Types","type" 2102,"VCALDWELL","Access","Badge","Badge Types","type" 2067,"NMYERS","Access","Badge","Badge Types","type" 2067,"NMYERS","reception","Badge","Badge Types","type" 2071,"VORTIZ","Access","Badge","Badge Types","type" 2072,"ICALDWELL","Office","Badge","Badge Types","type" 2072,"ICALDWELL","Conference","Badge","Badge Types","type" 2074,"LMULLINS","generator","Badge","Badge Types","type" 2075,"CHOPKINS","Printer","Badge","Badge Types","type" 2029,"VCARPENTER","DELL","LapTop","LapTop child form","model" 2029,"VCARPENTER","Zenith","LapTop","LapTop child form","model" 2030,"TGOMEZ","HP","LapTop","LapTop child form","model" 2033,"SKELLER","HP","LapTop","LapTop child form","model" 2033,"SKELLER","HCL","LapTop","LapTop child form","model" 2039,"EPATTON","Cafteria","Badge","Badge Types","type" 2039,"EPATTON","generator","Badge","Badge Types","type" 2040,"VANDERSON","Store","Badge","Badge Types","type" 2040,"VANDERSON","generator","Badge","Badge Types","type" 2042,"ISAUNDERS","Store","Badge","Badge Types","type" 2043,"SWEBER","Store","Badge","Badge Types","type" 2043,"SWEBER","Cafteria","Badge","Badge Types","type" 2049,"CCHAVEZ","Cafteria","Badge","Badge Types","type" 2051,"MROY","generator","Badge","Badge Types","type" 2055,"TDANIELS","Cafteria","Badge","Badge Types","type" 2077,"LVEGA","samsung","mobile","mobile child form","company" 2078,"MBAKER","Oppo","mobile","mobile child form","company" 2078,"MBAKER","celeron","mobile","mobile child form","company" 2079,"OGONZALES","micromax","mobile","mobile child form","company" 2081,"GABBOTT","samsung","mobile","mobile child form","company" 2082,"LDAWSON","MI","mobile","mobile child form","company" 2084,"ACANNON","Nokia","mobile","mobile child form","company" 2084,"ACANNON","Lenovo","mobile","mobile child form","company" 2084,"ACANNON","celeron","mobile","mobile child form","company" 2086,"CGREGORY","Nokia","mobile","mobile child form","company" 2088,"SMCDONALD","MI","mobile","mobile child form","company" 2090,"SRICHARDSON","micromax","mobile","mobile child form","company" 2092,"LPITTMAN","apple","mobile","mobile child form","company" 2092,"LPITTMAN","celeron","mobile","mobile child form","company" 2093,"CORTEGA","apple","mobile","mobile child form","company" 2093,"CORTEGA","Nokia","mobile","mobile child form","company" 2093,"CORTEGA","HTC","mobile","mobile child form","company" 2042,"ISAUNDERS","samsung","mobile","mobile child form","company" 2042,"ISAUNDERS","celeron","mobile","mobile child form","company" 2043,"SWEBER","HTC","mobile","mobile child form","company" 2045,"WJOSEPH","Oppo","mobile","mobile child form","company" 2046,"ACOOK","Nokia","mobile","mobile child form","company" 2102,"VCALDWELL","ACRoom","Badge","Badge Types","type" 2102,"VCALDWELL","warehouse","Badge","Badge Types","type" 2106,"TMORENO","Office","Badge","Badge Types","type" 2047,"BBECKER","Oppo","mobile","mobile child form","company" 2047,"BBECKER","samsung","mobile","mobile child form","company" 2048,"BNICHOLS","celeron","mobile","mobile child form","company" 2049,"CCHAVEZ","samsung","mobile","mobile child form","company" 2050,"GHANSON","micromax","mobile","mobile child form","company" 2052,"SWILLIS","celeron","mobile","mobile child form","company" 2054,"CPAGE","celeron","mobile","mobile child form","company" 2055,"TDANIELS","HTC","mobile","mobile child form","company" 2056,"TORTIZ","MI","mobile","mobile child form","company" 2059,"AQUINN","Lenovo","mobile","mobile child form","company" 2059,"AQUINN","micromax","mobile","mobile child form","company" 2062,"RROBERSON","apple","mobile","mobile child form","company" 2062,"RROBERSON","HTC","mobile","mobile child form","company" 2063,"JNORMAN","micromax","mobile","mobile child form","company" 2065,"AMUNOZ","apple","mobile","mobile child form","company" 2065,"AMUNOZ","HTC","mobile","mobile child form","company" 2069,"BBARBER","Lenovo","mobile","mobile child form","company" 2071,"VORTIZ","Nokia","mobile","mobile child form","company" 2073,"KMYERS","samsung","mobile","mobile child form","company" 2074,"LMULLINS","micromax","mobile","mobile child form","company" 2075,"CHOPKINS","Nokia","mobile","mobile child form","company" 2077,"LVEGA","Lenovo","mobile","mobile child form","company" 2051,"MROY","ActiveB9","activeb","activeb child form","entitlements" 2052,"SWILLIS","ActiveB9","activeb","activeb child form","entitlements" 2054,"CPAGE","ActiveB9","activeb","activeb child form","entitlements" 2056,"TORTIZ","ActiveB6","activeb","activeb child form","entitlements" 2058,"SABBOTT","ActiveB2","activeb","activeb child form","entitlements" 2058,"SABBOTT","ActiveB6","activeb","activeb child form","entitlements" 2059,"AQUINN","ActiveB2","activeb","activeb child form","entitlements" 2059,"AQUINN","ActiveB3","activeb","activeb child form","entitlements" 2079,"OGONZALES","ActiveB4","activeb","activeb child form","entitlements" 2080,"TARMSTRONG","ActiveB2","activeb","activeb child form","entitlements" 2082,"LDAWSON","ActiveB4","activeb","activeb child form","entitlements" 2083,"NROMERO","ActiveB5","activeb","activeb child form","entitlements" 2085,"TMALDONADO","ActiveB9","activeb","activeb child form","entitlements" 2086,"CGREGORY","ActiveB2","activeb","activeb child form","entitlements" 2087,"SCORTEZ","ActiveB10","activeb","activeb child form","entitlements" 2089,"FGOODMAN","ActiveB3","activeb","activeb child form","entitlements" 2091,"RPETERSON","ActiveB5","activeb","activeb child form","entitlements" 2093,"CORTEGA","ActiveB4","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","ActiveB1","activeb","activeb child form","entitlements" 2060,"FWHEELER","ActiveB8","activeb","activeb child form","entitlements" 2063,"JNORMAN","ActiveB3","activeb","activeb child form","entitlements" 2063,"JNORMAN","ActiveB4","activeb","activeb child form","entitlements" 2063,"JNORMAN","ActiveB8","activeb","activeb child form","entitlements" 2065,"AMUNOZ","ActiveB1","activeb","activeb child form","entitlements" 2065,"AMUNOZ","ActiveB2","activeb","activeb child form","entitlements" 2066,"AWONG","ActiveB9","activeb","activeb child form","entitlements" 2071,"VORTIZ","ActiveB1","activeb","activeb child form","entitlements" 2071,"VORTIZ","ActiveB5","activeb","activeb child form","entitlements" 2072,"ICALDWELL","ActiveB9","activeb","activeb child form","entitlements" 2074,"LMULLINS","ActiveB10","activeb","activeb child form","entitlements" 2075,"CHOPKINS","ActiveB1","activeb","activeb child form","entitlements" 2075,"CHOPKINS","ActiveB5","activeb","activeb child form","entitlements" 2075,"CHOPKINS","ActiveB9","activeb","activeb child form","entitlements" 2075,"CHOPKINS","ActiveB10","activeb","activeb child form","entitlements" 2077,"LVEGA","ActiveB2","activeb","activeb child form","entitlements" 2095,"JFREEMAN","samsung","mobile","mobile child form","company" 2096,"DWASHINGTON","Oppo","mobile","mobile child form","company" 2096,"DWASHINGTON","Lenovo","mobile","mobile child form","company" 2097,"CALEXANDER","HTC","mobile","mobile child form","company" 2101,"DFOWLER","Nokia","mobile","mobile child form","company" 2101,"DFOWLER","HTC","mobile","mobile child form","company" 2102,"VCALDWELL","Oppo","mobile","mobile child form","company" 2103,"LBLAKE","micromax","mobile","mobile child form","company" 2105,"GOSBORNE","Oppo","mobile","mobile child form","company" 2105,"GOSBORNE","Lenovo","mobile","mobile child form","company" 2105,"GOSBORNE","HTC","mobile","mobile child form","company" 2105,"GOSBORNE","samsung","mobile","mobile child form","company" 2038,"HBROCK","ActiveB6","activeb","activeb child form","entitlements" 2039,"EPATTON","ActiveB4","activeb","activeb child form","entitlements" 2040,"VANDERSON","ActiveB4","activeb","activeb child form","entitlements" 2041,"AREYES","ActiveB5","activeb","activeb child form","entitlements" 2041,"AREYES","ActiveB10","activeb","activeb child form","entitlements" 2043,"SWEBER","ActiveB10","activeb","activeb child form","entitlements" 2044,"JWATERS","ActiveB9","activeb","activeb child form","entitlements" 2045,"WJOSEPH","ActiveB2","activeb","activeb child form","entitlements" 2046,"ACOOK","ActiveB3","activeb","activeb child form","entitlements" 2046,"ACOOK","ActiveB7","activeb","activeb child form","entitlements" 2046,"ACOOK","ActiveB9","activeb","activeb child form","entitlements" 2050,"GHANSON","ActiveB8","activeb","activeb child form","entitlements" 2095,"JFREEMAN","ActiveB9","activeb","activeb child form","entitlements" 2097,"CALEXANDER","ActiveB2","activeb","activeb child form","entitlements" 2097,"CALEXANDER","ActiveB5","activeb","activeb child form","entitlements" 2100,"DELLIOTT","ActiveB2","activeb","activeb child form","entitlements" 2103,"LBLAKE","ActiveB7","activeb","activeb child form","entitlements" 2104,"JLARSON","ActiveB4","activeb","activeb child form","entitlements" 2104,"JLARSON","ActiveB7","activeb","activeb child form","entitlements" 2104,"JLARSON","ActiveB8","activeb","activeb child form","entitlements" 2106,"TMORENO","ActiveB2","activeb","activeb child form","entitlements" 2106,"TMORENO","ActiveB9","activeb","activeb child form","entitlements" 2006,"DLEWIS","Asus","LapTop","LapTop child form","model" 2008,"CDELGADO","Zenith","LapTop","LapTop child form","model" 2008,"CDELGADO","HP","LapTop","LapTop child form","model" 2008,"CDELGADO","Mac","LapTop","LapTop child form","model" 91,"VCERTUSER2","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 96,"VCERTUSER7","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 99,"VCERTUSER10","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 2026,"CMARSH","Zenith","LapTop","LapTop child form","model" 2011,"AMEYER","Compaq","LapTop","LapTop child form","model" 2011,"AMEYER","Lenovo","LapTop","LapTop child form","model" 2011,"AMEYER","HCL","LapTop","LapTop child form","model" 2013,"VMORALES","MI","LapTop","LapTop child form","model" 2015,"WOLIVER","MI","LapTop","LapTop child form","model" 2018,"JMULLINS","Zenith","LapTop","LapTop child form","model" 2018,"JMULLINS","Mac","LapTop","LapTop child form","model" 2018,"JMULLINS","HCL","LapTop","LapTop child form","model" 2018,"JMULLINS","Toshiba","LapTop","LapTop child form","model" 2019,"RWALTON","DELL","LapTop","LapTop child form","model" 2019,"RWALTON","Zenith","LapTop","LapTop child form","model" 2019,"RWALTON","MI","LapTop","LapTop child form","model" 2021,"SROBERTSON","Mac","LapTop","LapTop child form","model" 2023,"CMCKINNEY","Lenovo","LapTop","LapTop child form","model" 2025,"JRYAN","Asus","LapTop","LapTop child form","model" 91,"VCERTUSER2","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 94,"VCERTUSER5","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 96,"VCERTUSER7","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 2058,"SABBOTT","Office","Badge","Badge Types","type" 2059,"AQUINN","generator","Badge","Badge Types","type" 2063,"JNORMAN","Printer","Badge","Badge Types","type" 2063,"JNORMAN","generator","Badge","Badge Types","type" 2065,"AMUNOZ","Printer","Badge","Badge Types","type" 2078,"MBAKER","ACRoom","Badge","Badge Types","type" 2079,"OGONZALES","Store","Badge","Badge Types","type" 2079,"OGONZALES","ACRoom","Badge","Badge Types","type" 2089,"FGOODMAN","Conference","Badge","Badge Types","type" 2089,"FGOODMAN","reception","Badge","Badge Types","type" 2095,"JFREEMAN","Printer","Badge","Badge Types","type" 2095,"JFREEMAN","warehouse","Badge","Badge Types","type" 2096,"DWASHINGTON","Access","Badge","Badge Types","type" 2099,"JMOODY","Conference","Badge","Badge Types","type" 2099,"JMOODY","generator","Badge","Badge Types","type" 2100,"DELLIOTT","Office","Badge","Badge Types","type" 2101,"DFOWLER","Cafteria","Badge","Badge Types","type" 2066,"AWONG","reception","Badge","Badge Types","type" 2067,"NMYERS","Cafteria","Badge","Badge Types","type" 2071,"VORTIZ","generator","Badge","Badge Types","type" 2074,"LMULLINS","Printer","Badge","Badge Types","type" 2074,"LMULLINS","Office","Badge","Badge Types","type" 2028,"SMORAN","Mac","LapTop","LapTop child form","model" 2028,"SMORAN","Lenovo","LapTop","LapTop child form","model" 2029,"VCARPENTER","Mac","LapTop","LapTop child form","model" 2029,"VCARPENTER","Lenovo","LapTop","LapTop child form","model" 2031,"EMUNOZ","Mac","LapTop","LapTop child form","model" 2031,"EMUNOZ","Asus","LapTop","LapTop child form","model" 2032,"YWATKINS","HP","LapTop","LapTop child form","model" 2032,"YWATKINS","Mac","LapTop","LapTop child form","model" 2032,"YWATKINS","Lenovo","LapTop","LapTop child form","model" 2075,"CHOPKINS","reception","Badge","Badge Types","type" 2076,"NRICE","ACRoom","Badge","Badge Types","type" 2039,"EPATTON","Conference","Badge","Badge Types","type" 2042,"ISAUNDERS","Office","Badge","Badge Types","type" 2042,"ISAUNDERS","reception","Badge","Badge Types","type" 2043,"SWEBER","Conference","Badge","Badge Types","type" 2043,"SWEBER","reception","Badge","Badge Types","type" 2044,"JWATERS","Store","Badge","Badge Types","type" 2044,"JWATERS","Printer","Badge","Badge Types","type" 2047,"BBECKER","Cafteria","Badge","Badge Types","type" 2052,"SWILLIS","Access","Badge","Badge Types","type" 2052,"SWILLIS","Conference","Badge","Badge Types","type" 2052,"SWILLIS","reception","Badge","Badge Types","type" 2079,"OGONZALES","apple","mobile","mobile child form","company" 2082,"LDAWSON","Nokia","mobile","mobile child form","company" 2084,"ACANNON","HTC","mobile","mobile child form","company" 2084,"ACANNON","micromax","mobile","mobile child form","company" 2085,"TMALDONADO","Oppo","mobile","mobile child form","company" 2090,"SRICHARDSON","Lenovo","mobile","mobile child form","company" 2092,"LPITTMAN","Oppo","mobile","mobile child form","company" 2093,"CORTEGA","samsung","mobile","mobile child form","company" 2093,"CORTEGA","Lenovo","mobile","mobile child form","company" 2093,"CORTEGA","micromax","mobile","mobile child form","company" 2039,"EPATTON","Oppo","mobile","mobile child form","company" 2042,"ISAUNDERS","Lenovo","mobile","mobile child form","company" 2044,"JWATERS","HTC","mobile","mobile child form","company" 2102,"VCALDWELL","Printer","Badge","Badge Types","type" 2103,"LBLAKE","reception","Badge","Badge Types","type" 2106,"TMORENO","Access","Badge","Badge Types","type" 2047,"BBECKER","HTC","mobile","mobile child form","company" 2051,"MROY","samsung","mobile","mobile child form","company" 2052,"SWILLIS","Nokia","mobile","mobile child form","company" 2052,"SWILLIS","Oppo","mobile","mobile child form","company" 2052,"SWILLIS","HTC","mobile","mobile child form","company" 2054,"CPAGE","micromax","mobile","mobile child form","company" 2056,"TORTIZ","apple","mobile","mobile child form","company" 2056,"TORTIZ","Nokia","mobile","mobile child form","company" 2056,"TORTIZ","HTC","mobile","mobile child form","company" 2057,"FLAMB","Lenovo","mobile","mobile child form","company" 2057,"FLAMB","samsung","mobile","mobile child form","company" 2060,"FWHEELER","Oppo","mobile","mobile child form","company" 2060,"FWHEELER","Lenovo","mobile","mobile child form","company" 2062,"RROBERSON","Lenovo","mobile","mobile child form","company" 2063,"JNORMAN","samsung","mobile","mobile child form","company" 2069,"BBARBER","Oppo","mobile","mobile child form","company" 2070,"RCHAMBERS","Lenovo","mobile","mobile child form","company" 2072,"ICALDWELL","apple","mobile","mobile child form","company" 2072,"ICALDWELL","samsung","mobile","mobile child form","company" 2073,"KMYERS","HTC","mobile","mobile child form","company" 2074,"LMULLINS","HTC","mobile","mobile child form","company" 2074,"LMULLINS","celeron","mobile","mobile child form","company" 2051,"MROY","ActiveB7","activeb","activeb child form","entitlements" 2052,"SWILLIS","ActiveB7","activeb","activeb child form","entitlements" 2053,"TWILKINS","ActiveB9","activeb","activeb child form","entitlements" 2054,"CPAGE","ActiveB6","activeb","activeb child form","entitlements" 2054,"CPAGE","ActiveB8","activeb","activeb child form","entitlements" 2055,"TDANIELS","ActiveB2","activeb","activeb child form","entitlements" 2055,"TDANIELS","ActiveB3","activeb","activeb child form","entitlements" 2055,"TDANIELS","ActiveB9","activeb","activeb child form","entitlements" 2055,"TDANIELS","ActiveB10","activeb","activeb child form","entitlements" 2056,"TORTIZ","ActiveB7","activeb","activeb child form","entitlements" 2059,"AQUINN","ActiveB4","activeb","activeb child form","entitlements" 2079,"OGONZALES","ActiveB5","activeb","activeb child form","entitlements" 2079,"OGONZALES","ActiveB8","activeb","activeb child form","entitlements" 2080,"TARMSTRONG","ActiveB1","activeb","activeb child form","entitlements" 2080,"TARMSTRONG","ActiveB6","activeb","activeb child form","entitlements" 2084,"ACANNON","ActiveB4","activeb","activeb child form","entitlements" 2084,"ACANNON","ActiveB8","activeb","activeb child form","entitlements" 2085,"TMALDONADO","ActiveB1","activeb","activeb child form","entitlements" 2086,"CGREGORY","ActiveB6","activeb","activeb child form","entitlements" 2089,"FGOODMAN","ActiveB4","activeb","activeb child form","entitlements" 2091,"RPETERSON","ActiveB1","activeb","activeb child form","entitlements" 2091,"RPETERSON","ActiveB4","activeb","activeb child form","entitlements" 2091,"RPETERSON","ActiveB9","activeb","activeb child form","entitlements" 2092,"LPITTMAN","ActiveB9","activeb","activeb child form","entitlements" 2093,"CORTEGA","ActiveB5","activeb","activeb child form","entitlements" 2060,"FWHEELER","ActiveB4","activeb","activeb child form","entitlements" 2060,"FWHEELER","ActiveB9","activeb","activeb child form","entitlements" 2062,"RROBERSON","ActiveB1","activeb","activeb child form","entitlements" 2063,"JNORMAN","ActiveB5","activeb","activeb child form","entitlements" 2066,"AWONG","ActiveB10","activeb","activeb child form","entitlements" 2071,"VORTIZ","ActiveB7","activeb","activeb child form","entitlements" 2072,"ICALDWELL","ActiveB7","activeb","activeb child form","entitlements" 2073,"KMYERS","ActiveB3","activeb","activeb child form","entitlements" 2074,"LMULLINS","ActiveB1","activeb","activeb child form","entitlements" 2075,"CHOPKINS","ActiveB2","activeb","activeb child form","entitlements" 2076,"NRICE","ActiveB10","activeb","activeb child form","entitlements" 2078,"MBAKER","ActiveB2","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","Nokia","mobile","mobile child form","company" 2095,"JFREEMAN","Oppo","mobile","mobile child form","company" 2096,"DWASHINGTON","apple","mobile","mobile child form","company" 2096,"DWASHINGTON","HTC","mobile","mobile child form","company" 2097,"CALEXANDER","Oppo","mobile","mobile child form","company" 2098,"PBARTON","Oppo","mobile","mobile child form","company" 2099,"JMOODY","celeron","mobile","mobile child form","company" 2101,"DFOWLER","samsung","mobile","mobile child form","company" 2104,"JLARSON","HTC","mobile","mobile child form","company" 2040,"VANDERSON","ActiveB2","activeb","activeb child form","entitlements" 2041,"AREYES","ActiveB7","activeb","activeb child form","entitlements" 2042,"ISAUNDERS","ActiveB4","activeb","activeb child form","entitlements" 2043,"SWEBER","ActiveB3","activeb","activeb child form","entitlements" 2045,"WJOSEPH","ActiveB5","activeb","activeb child form","entitlements" 2048,"BNICHOLS","ActiveB6","activeb","activeb child form","entitlements" 2050,"GHANSON","ActiveB9","activeb","activeb child form","entitlements" 2096,"DWASHINGTON","ActiveB10","activeb","activeb child form","entitlements" 2099,"JMOODY","ActiveB2","activeb","activeb child form","entitlements" 2099,"JMOODY","ActiveB8","activeb","activeb child form","entitlements" 2101,"DFOWLER","ActiveB7","activeb","activeb child form","entitlements" 2101,"DFOWLER","ActiveB8","activeb","activeb child form","entitlements" 2101,"DFOWLER","ActiveB9","activeb","activeb child form","entitlements" 2102,"VCALDWELL","ActiveB4","activeb","activeb child form","entitlements" 2102,"VCALDWELL","ActiveB7","activeb","activeb child form","entitlements" 2102,"VCALDWELL","ActiveB8","activeb","activeb child form","entitlements" 2103,"LBLAKE","ActiveB3","activeb","activeb child form","entitlements" 2103,"LBLAKE","ActiveB4","activeb","activeb child form","entitlements" 2103,"LBLAKE","ActiveB10","activeb","activeb child form","entitlements" 99,"VCERTUSER10","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 100,"VCERTUSER11","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2006,"DLEWIS","Zenith","LapTop","LapTop child form","model" 2008,"CDELGADO","Toshiba","LapTop","LapTop child form","model" 2009,"KGILL","Asus","LapTop","LapTop child form","model" 2009,"KGILL","Toshiba","LapTop","LapTop child form","model" 2009,"KGILL","MI","LapTop","LapTop child form","model" 2010,"JNEWTON","HP","LapTop","LapTop child form","model" 2011,"AMEYER","DELL","LapTop","LapTop child form","model" 91,"VCERTUSER2","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 92,"VCERTUSER3","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 93,"VCERTUSER4","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 94,"VCERTUSER5","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 94,"VCERTUSER5","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 95,"VCERTUSER6","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 97,"VCERTUSER8","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 99,"VCERTUSER10","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 100,"VCERTUSER11","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 2011,"AMEYER","Zenith","LapTop","LapTop child form","model" 2011,"AMEYER","HP","LapTop","LapTop child form","model" 2012,"LBATES","HP","LapTop","LapTop child form","model" 2012,"LBATES","Asus","LapTop","LapTop child form","model" 2012,"LBATES","Toshiba","LapTop","LapTop child form","model" 2013,"VMORALES","HP","LapTop","LapTop child form","model" 2013,"VMORALES","Lenovo","LapTop","LapTop child form","model" 2019,"RWALTON","Mac","LapTop","LapTop child form","model" 2020,"ECROSS","Mac","LapTop","LapTop child form","model" 2022,"MHALL","Lenovo","LapTop","LapTop child form","model" 90,"VCERTUSER1","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 92,"VCERTUSER3","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 92,"VCERTUSER3","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 93,"VCERTUSER4","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2058,"SABBOTT","warehouse","Badge","Badge Types","type" 2059,"AQUINN","ACRoom","Badge","Badge Types","type" 2062,"RROBERSON","Office","Badge","Badge Types","type" 2066,"AWONG","Access","Badge","Badge Types","type" 2077,"LVEGA","Access","Badge","Badge Types","type" 2077,"LVEGA","reception","Badge","Badge Types","type" 2079,"OGONZALES","Conference","Badge","Badge Types","type" 2080,"TARMSTRONG","warehouse","Badge","Badge Types","type" 2081,"GABBOTT","generator","Badge","Badge Types","type" 2082,"LDAWSON","Printer","Badge","Badge Types","type" 2082,"LDAWSON","Office","Badge","Badge Types","type" 2082,"LDAWSON","Conference","Badge","Badge Types","type" 2082,"LDAWSON","reception","Badge","Badge Types","type" 2085,"TMALDONADO","Printer","Badge","Badge Types","type" 2087,"SCORTEZ","Access","Badge","Badge Types","type" 2087,"SCORTEZ","Cafteria","Badge","Badge Types","type" 2087,"SCORTEZ","reception","Badge","Badge Types","type" 2088,"SMCDONALD","Office","Badge","Badge Types","type" 2092,"LPITTMAN","Printer","Badge","Badge Types","type" 2093,"CORTEGA","Cafteria","Badge","Badge Types","type" 2093,"CORTEGA","warehouse","Badge","Badge Types","type" 2095,"JFREEMAN","Access","Badge","Badge Types","type" 2097,"CALEXANDER","Cafteria","Badge","Badge Types","type" 2101,"DFOWLER","Store","Badge","Badge Types","type" 2069,"BBARBER","warehouse","Badge","Badge Types","type" 2070,"RCHAMBERS","Store","Badge","Badge Types","type" 2071,"VORTIZ","Store","Badge","Badge Types","type" 2073,"KMYERS","Store","Badge","Badge Types","type" 2073,"KMYERS","reception","Badge","Badge Types","type" 2074,"LMULLINS","Access","Badge","Badge Types","type" 2028,"SMORAN","MI","LapTop","LapTop child form","model" 2029,"VCARPENTER","HP","LapTop","LapTop child form","model" 2029,"VCARPENTER","HCL","LapTop","LapTop child form","model" 2030,"TGOMEZ","HCL","LapTop","LapTop child form","model" 2031,"EMUNOZ","DELL","LapTop","LapTop child form","model" 2031,"EMUNOZ","Compaq","LapTop","LapTop child form","model" 2032,"YWATKINS","MI","LapTop","LapTop child form","model" 2033,"SKELLER","Toshiba","LapTop","LapTop child form","model" 2076,"NRICE","Conference","Badge","Badge Types","type" 2038,"HBROCK","Store","Badge","Badge Types","type" 2041,"AREYES","Access","Badge","Badge Types","type" 2043,"SWEBER","Access","Badge","Badge Types","type" 2043,"SWEBER","generator","Badge","Badge Types","type" 2044,"JWATERS","Conference","Badge","Badge Types","type" 2045,"WJOSEPH","Cafteria","Badge","Badge Types","type" 2046,"ACOOK","Printer","Badge","Badge Types","type" 2049,"CCHAVEZ","Store","Badge","Badge Types","type" 2053,"TWILKINS","Store","Badge","Badge Types","type" 2053,"TWILKINS","Conference","Badge","Badge Types","type" 2053,"TWILKINS","generator","Badge","Badge Types","type" 2079,"OGONZALES","Lenovo","mobile","mobile child form","company" 2080,"TARMSTRONG","MI","mobile","mobile child form","company" 2080,"TARMSTRONG","Oppo","mobile","mobile child form","company" 2081,"GABBOTT","Lenovo","mobile","mobile child form","company" 2081,"GABBOTT","micromax","mobile","mobile child form","company" 2082,"LDAWSON","samsung","mobile","mobile child form","company" 2087,"SCORTEZ","apple","mobile","mobile child form","company" 2087,"SCORTEZ","HTC","mobile","mobile child form","company" 2089,"FGOODMAN","Oppo","mobile","mobile child form","company" 2092,"LPITTMAN","micromax","mobile","mobile child form","company" 2038,"HBROCK","celeron","mobile","mobile child form","company" 2043,"SWEBER","Nokia","mobile","mobile child form","company" 2044,"JWATERS","micromax","mobile","mobile child form","company" 2105,"GOSBORNE","ACRoom","Badge","Badge Types","type" 2106,"TMORENO","reception","Badge","Badge Types","type" 2107,"KADAMS","Access","Badge","Badge Types","type" 2048,"BNICHOLS","Oppo","mobile","mobile child form","company" 2049,"CCHAVEZ","micromax","mobile","mobile child form","company" 2050,"GHANSON","Nokia","mobile","mobile child form","company" 2051,"MROY","Nokia","mobile","mobile child form","company" 2051,"MROY","celeron","mobile","mobile child form","company" 2052,"SWILLIS","samsung","mobile","mobile child form","company" 2053,"TWILKINS","Nokia","mobile","mobile child form","company" 2054,"CPAGE","samsung","mobile","mobile child form","company" 2054,"CPAGE","HTC","mobile","mobile child form","company" 2055,"TDANIELS","Nokia","mobile","mobile child form","company" 2057,"FLAMB","Oppo","mobile","mobile child form","company" 2059,"AQUINN","apple","mobile","mobile child form","company" 2059,"AQUINN","celeron","mobile","mobile child form","company" 2060,"FWHEELER","MI","mobile","mobile child form","company" 2060,"FWHEELER","apple","mobile","mobile child form","company" 2067,"NMYERS","Lenovo","mobile","mobile child form","company" 2069,"BBARBER","apple","mobile","mobile child form","company" 2070,"RCHAMBERS","MI","mobile","mobile child form","company" 2071,"VORTIZ","HTC","mobile","mobile child form","company" 2072,"ICALDWELL","Lenovo","mobile","mobile child form","company" 2074,"LMULLINS","MI","mobile","mobile child form","company" 2075,"CHOPKINS","Oppo","mobile","mobile child form","company" 2052,"SWILLIS","ActiveB3","activeb","activeb child form","entitlements" 2052,"SWILLIS","ActiveB4","activeb","activeb child form","entitlements" 2053,"TWILKINS","ActiveB8","activeb","activeb child form","entitlements" 2054,"CPAGE","ActiveB4","activeb","activeb child form","entitlements" 2057,"FLAMB","ActiveB3","activeb","activeb child form","entitlements" 2079,"OGONZALES","ActiveB3","activeb","activeb child form","entitlements" 2080,"TARMSTRONG","ActiveB3","activeb","activeb child form","entitlements" 2080,"TARMSTRONG","ActiveB9","activeb","activeb child form","entitlements" 2081,"GABBOTT","ActiveB4","activeb","activeb child form","entitlements" 2081,"GABBOTT","ActiveB10","activeb","activeb child form","entitlements" 2082,"LDAWSON","ActiveB6","activeb","activeb child form","entitlements" 2082,"LDAWSON","ActiveB9","activeb","activeb child form","entitlements" 2083,"NROMERO","ActiveB7","activeb","activeb child form","entitlements" 2085,"TMALDONADO","ActiveB10","activeb","activeb child form","entitlements" 2086,"CGREGORY","ActiveB7","activeb","activeb child form","entitlements" 2086,"CGREGORY","ActiveB9","activeb","activeb child form","entitlements" 2087,"SCORTEZ","ActiveB1","activeb","activeb child form","entitlements" 2091,"RPETERSON","ActiveB10","activeb","activeb child form","entitlements" 2092,"LPITTMAN","ActiveB4","activeb","activeb child form","entitlements" 2092,"LPITTMAN","ActiveB7","activeb","activeb child form","entitlements" 2093,"CORTEGA","ActiveB9","activeb","activeb child form","entitlements" 2060,"FWHEELER","ActiveB1","activeb","activeb child form","entitlements" 2063,"JNORMAN","ActiveB9","activeb","activeb child form","entitlements" 2063,"JNORMAN","ActiveB10","activeb","activeb child form","entitlements" 2066,"AWONG","ActiveB6","activeb","activeb child form","entitlements" 2067,"NMYERS","ActiveB5","activeb","activeb child form","entitlements" 2069,"BBARBER","ActiveB4","activeb","activeb child form","entitlements" 2069,"BBARBER","ActiveB8","activeb","activeb child form","entitlements" 2070,"RCHAMBERS","ActiveB3","activeb","activeb child form","entitlements" 2070,"RCHAMBERS","ActiveB6","activeb","activeb child form","entitlements" 2071,"VORTIZ","ActiveB10","activeb","activeb child form","entitlements" 2073,"KMYERS","ActiveB4","activeb","activeb child form","entitlements" 2073,"KMYERS","ActiveB9","activeb","activeb child form","entitlements" 2077,"LVEGA","ActiveB1","activeb","activeb child form","entitlements" 2077,"LVEGA","ActiveB5","activeb","activeb child form","entitlements" 2078,"MBAKER","ActiveB6","activeb","activeb child form","entitlements" 2078,"MBAKER","ActiveB8","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","samsung","mobile","mobile child form","company" 2095,"JFREEMAN","apple","mobile","mobile child form","company" 2100,"DELLIOTT","MI","mobile","mobile child form","company" 2100,"DELLIOTT","Lenovo","mobile","mobile child form","company" 2103,"LBLAKE","Lenovo","mobile","mobile child form","company" 2104,"JLARSON","Nokia","mobile","mobile child form","company" 2038,"HBROCK","ActiveB1","activeb","activeb child form","entitlements" 2038,"HBROCK","ActiveB2","activeb","activeb child form","entitlements" 2040,"VANDERSON","ActiveB6","activeb","activeb child form","entitlements" 2042,"ISAUNDERS","ActiveB10","activeb","activeb child form","entitlements" 2043,"SWEBER","ActiveB8","activeb","activeb child form","entitlements" 2044,"JWATERS","ActiveB4","activeb","activeb child form","entitlements" 2046,"ACOOK","ActiveB6","activeb","activeb child form","entitlements" 2047,"BBECKER","ActiveB2","activeb","activeb child form","entitlements" 2048,"BNICHOLS","ActiveB2","activeb","activeb child form","entitlements" 2049,"CCHAVEZ","ActiveB4","activeb","activeb child form","entitlements" 2096,"DWASHINGTON","ActiveB2","activeb","activeb child form","entitlements" 2096,"DWASHINGTON","ActiveB6","activeb","activeb child form","entitlements" 2100,"DELLIOTT","ActiveB6","activeb","activeb child form","entitlements" 2100,"DELLIOTT","ActiveB9","activeb","activeb child form","entitlements" 2101,"DFOWLER","ActiveB10","activeb","activeb child form","entitlements" 2103,"LBLAKE","ActiveB9","activeb","activeb child form","entitlements" 2105,"GOSBORNE","ActiveB1","activeb","activeb child form","entitlements" 2105,"GOSBORNE","ActiveB10","activeb","activeb child form","entitlements" 2106,"TMORENO","ActiveB3","activeb","activeb child form","entitlements" 2106,"TMORENO","ActiveB7","activeb","activeb child form","entitlements" 99,"VCERTUSER10","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 99,"VCERTUSER10","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2007,"MSANDOVAL","MI","LapTop","LapTop child form","model" 2009,"KGILL","Compaq","LapTop","LapTop child form","model" 2009,"KGILL","HCL","LapTop","LapTop child form","model" 2010,"JNEWTON","DELL","LapTop","LapTop child form","model" 92,"VCERTUSER3","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 96,"VCERTUSER7","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 91,"VCERTUSER2","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 2014,"KPOOLE","HCL","LapTop","LapTop child form","model" 2015,"WOLIVER","HCL","LapTop","LapTop child form","model" 2015,"WOLIVER","Toshiba","LapTop","LapTop child form","model" 2016,"DSCHULTZ","Zenith","LapTop","LapTop child form","model" 2017,"PGOODMAN","Zenith","LapTop","LapTop child form","model" 2017,"PGOODMAN","Lenovo","LapTop","LapTop child form","model" 2019,"RWALTON","HP","LapTop","LapTop child form","model" 2019,"RWALTON","HCL","LapTop","LapTop child form","model" 2020,"ECROSS","HP","LapTop","LapTop child form","model" 2020,"ECROSS","Compaq","LapTop","LapTop child form","model" 2020,"ECROSS","HCL","LapTop","LapTop child form","model" 2022,"MHALL","HCL","LapTop","LapTop child form","model" 2022,"MHALL","MI","LapTop","LapTop child form","model" 2025,"JRYAN","HCL","LapTop","LapTop child form","model" 94,"VCERTUSER5","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 95,"VCERTUSER6","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 100,"VCERTUSER11","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 100,"VCERTUSER11","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 91,"VCERTUSER2","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 92,"VCERTUSER3","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 92,"VCERTUSER3","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 96,"VCERTUSER7","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2056,"TORTIZ","reception","Badge","Badge Types","type" 2057,"FLAMB","Cafteria","Badge","Badge Types","type" 2058,"SABBOTT","Store","Badge","Badge Types","type" 2060,"FWHEELER","ACRoom","Badge","Badge Types","type" 2060,"FWHEELER","reception","Badge","Badge Types","type" 2062,"RROBERSON","ACRoom","Badge","Badge Types","type" 2063,"JNORMAN","Store","Badge","Badge Types","type" 2063,"JNORMAN","Conference","Badge","Badge Types","type" 2065,"AMUNOZ","Cafteria","Badge","Badge Types","type" 2066,"AWONG","ACRoom","Badge","Badge Types","type" 2078,"MBAKER","warehouse","Badge","Badge Types","type" 2083,"NROMERO","generator","Badge","Badge Types","type" 2084,"ACANNON","Conference","Badge","Badge Types","type" 2090,"SRICHARDSON","Office","Badge","Badge Types","type" 2092,"LPITTMAN","Store","Badge","Badge Types","type" 2092,"LPITTMAN","Access","Badge","Badge Types","type" 2093,"CORTEGA","Access","Badge","Badge Types","type" 2093,"CORTEGA","Printer","Badge","Badge Types","type" 2094,"NTHOMPSON","Store","Badge","Badge Types","type" 2094,"NTHOMPSON","warehouse","Badge","Badge Types","type" 2095,"JFREEMAN","reception","Badge","Badge Types","type" 2096,"DWASHINGTON","warehouse","Badge","Badge Types","type" 2097,"CALEXANDER","ACRoom","Badge","Badge Types","type" 2098,"PBARTON","ACRoom","Badge","Badge Types","type" 2098,"PBARTON","Office","Badge","Badge Types","type" 2099,"JMOODY","Store","Badge","Badge Types","type" 2100,"DELLIOTT","Store","Badge","Badge Types","type" 2101,"DFOWLER","warehouse","Badge","Badge Types","type" 2102,"VCALDWELL","Store","Badge","Badge Types","type" 2066,"AWONG","warehouse","Badge","Badge Types","type" 2069,"BBARBER","Conference","Badge","Badge Types","type" 2069,"BBARBER","generator","Badge","Badge Types","type" 2070,"RCHAMBERS","Printer","Badge","Badge Types","type" 2070,"RCHAMBERS","Office","Badge","Badge Types","type" 2072,"ICALDWELL","Access","Badge","Badge Types","type" 2030,"TGOMEZ","Lenovo","LapTop","LapTop child form","model" 2030,"TGOMEZ","Toshiba","LapTop","LapTop child form","model" 2030,"TGOMEZ","MI","LapTop","LapTop child form","model" 2031,"EMUNOZ","Toshiba","LapTop","LapTop child form","model" 2032,"YWATKINS","Asus","LapTop","LapTop child form","model" 2039,"EPATTON","Store","Badge","Badge Types","type" 2040,"VANDERSON","ACRoom","Badge","Badge Types","type" 2040,"VANDERSON","Printer","Badge","Badge Types","type" 2040,"VANDERSON","Office","Badge","Badge Types","type" 2041,"AREYES","Conference","Badge","Badge Types","type" 2041,"AREYES","generator","Badge","Badge Types","type" 2042,"ISAUNDERS","Access","Badge","Badge Types","type" 2042,"ISAUNDERS","Conference","Badge","Badge Types","type" 2042,"ISAUNDERS","warehouse","Badge","Badge Types","type" 2044,"JWATERS","Access","Badge","Badge Types","type" 2044,"JWATERS","Office","Badge","Badge Types","type" 2045,"WJOSEPH","ACRoom","Badge","Badge Types","type" 2045,"WJOSEPH","reception","Badge","Badge Types","type" 2047,"BBECKER","ACRoom","Badge","Badge Types","type" 2048,"BNICHOLS","ACRoom","Badge","Badge Types","type" 2050,"GHANSON","reception","Badge","Badge Types","type" 2051,"MROY","Access","Badge","Badge Types","type" 2051,"MROY","Printer","Badge","Badge Types","type" 2051,"MROY","Conference","Badge","Badge Types","type" 2052,"SWILLIS","ACRoom","Badge","Badge Types","type" 2054,"CPAGE","Access","Badge","Badge Types","type" 2054,"CPAGE","Office","Badge","Badge Types","type" 2055,"TDANIELS","Access","Badge","Badge Types","type" 2056,"TORTIZ","Printer","Badge","Badge Types","type" 2077,"LVEGA","HTC","mobile","mobile child form","company" 2078,"MBAKER","Lenovo","mobile","mobile child form","company" 2079,"OGONZALES","celeron","mobile","mobile child form","company" 2080,"TARMSTRONG","Nokia","mobile","mobile child form","company" 2081,"GABBOTT","Nokia","mobile","mobile child form","company" 2084,"ACANNON","MI","mobile","mobile child form","company" 2085,"TMALDONADO","HTC","mobile","mobile child form","company" 2085,"TMALDONADO","samsung","mobile","mobile child form","company" 2088,"SMCDONALD","Oppo","mobile","mobile child form","company" 2089,"FGOODMAN","apple","mobile","mobile child form","company" 2090,"SRICHARDSON","apple","mobile","mobile child form","company" 2091,"RPETERSON","micromax","mobile","mobile child form","company" 2092,"LPITTMAN","MI","mobile","mobile child form","company" 2040,"VANDERSON","apple","mobile","mobile child form","company" 2041,"AREYES","micromax","mobile","mobile child form","company" 2042,"ISAUNDERS","apple","mobile","mobile child form","company" 2043,"SWEBER","apple","mobile","mobile child form","company" 2043,"SWEBER","samsung","mobile","mobile child form","company" 2043,"SWEBER","celeron","mobile","mobile child form","company" 2044,"JWATERS","Nokia","mobile","mobile child form","company" 2045,"WJOSEPH","samsung","mobile","mobile child form","company" 2046,"ACOOK","apple","mobile","mobile child form","company" 2103,"LBLAKE","Store","Badge","Badge Types","type" 2103,"LBLAKE","Conference","Badge","Badge Types","type" 2104,"JLARSON","Conference","Badge","Badge Types","type" 2105,"GOSBORNE","Access","Badge","Badge Types","type" 2049,"CCHAVEZ","celeron","mobile","mobile child form","company" 2050,"GHANSON","MI","mobile","mobile child form","company" 2052,"SWILLIS","micromax","mobile","mobile child form","company" 2054,"CPAGE","Nokia","mobile","mobile child form","company" 2058,"SABBOTT","celeron","mobile","mobile child form","company" 2059,"AQUINN","samsung","mobile","mobile child form","company" 2062,"RROBERSON","Nokia","mobile","mobile child form","company" 2062,"RROBERSON","Oppo","mobile","mobile child form","company" 2062,"RROBERSON","celeron","mobile","mobile child form","company" 2065,"AMUNOZ","Oppo","mobile","mobile child form","company" 2066,"AWONG","samsung","mobile","mobile child form","company" 2066,"AWONG","Lenovo","mobile","mobile child form","company" 2069,"BBARBER","samsung","mobile","mobile child form","company" 2069,"BBARBER","micromax","mobile","mobile child form","company" 2070,"RCHAMBERS","Nokia","mobile","mobile child form","company" 2070,"RCHAMBERS","micromax","mobile","mobile child form","company" 2072,"ICALDWELL","MI","mobile","mobile child form","company" 2072,"ICALDWELL","HTC","mobile","mobile child form","company" 2074,"LMULLINS","samsung","mobile","mobile child form","company" 2075,"CHOPKINS","Lenovo","mobile","mobile child form","company" 2075,"CHOPKINS","HTC","mobile","mobile child form","company" 2076,"NRICE","Oppo","mobile","mobile child form","company" 2052,"SWILLIS","ActiveB10","activeb","activeb child form","entitlements" 2053,"TWILKINS","ActiveB3","activeb","activeb child form","entitlements" 2053,"TWILKINS","ActiveB4","activeb","activeb child form","entitlements" 2056,"TORTIZ","ActiveB2","activeb","activeb child form","entitlements" 2057,"FLAMB","ActiveB1","activeb","activeb child form","entitlements" 2057,"FLAMB","ActiveB5","activeb","activeb child form","entitlements" 2057,"FLAMB","ActiveB10","activeb","activeb child form","entitlements" 2058,"SABBOTT","ActiveB8","activeb","activeb child form","entitlements" 2082,"LDAWSON","ActiveB10","activeb","activeb child form","entitlements" 2084,"ACANNON","ActiveB1","activeb","activeb child form","entitlements" 2085,"TMALDONADO","ActiveB2","activeb","activeb child form","entitlements" 2085,"TMALDONADO","ActiveB5","activeb","activeb child form","entitlements" 2088,"SMCDONALD","ActiveB8","activeb","activeb child form","entitlements" 2091,"RPETERSON","ActiveB7","activeb","activeb child form","entitlements" 2093,"CORTEGA","ActiveB1","activeb","activeb child form","entitlements" 2060,"FWHEELER","ActiveB3","activeb","activeb child form","entitlements" 2060,"FWHEELER","ActiveB6","activeb","activeb child form","entitlements" 2062,"RROBERSON","ActiveB2","activeb","activeb child form","entitlements" 2062,"RROBERSON","ActiveB9","activeb","activeb child form","entitlements" 2063,"JNORMAN","ActiveB7","activeb","activeb child form","entitlements" 2066,"AWONG","ActiveB3","activeb","activeb child form","entitlements" 2066,"AWONG","ActiveB7","activeb","activeb child form","entitlements" 2067,"NMYERS","ActiveB10","activeb","activeb child form","entitlements" 2070,"RCHAMBERS","ActiveB4","activeb","activeb child form","entitlements" 2072,"ICALDWELL","ActiveB1","activeb","activeb child form","entitlements" 2072,"ICALDWELL","ActiveB2","activeb","activeb child form","entitlements" 2073,"KMYERS","ActiveB5","activeb","activeb child form","entitlements" 2074,"LMULLINS","ActiveB6","activeb","activeb child form","entitlements" 2075,"CHOPKINS","ActiveB3","activeb","activeb child form","entitlements" 2076,"NRICE","ActiveB1","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","celeron","mobile","mobile child form","company" 2095,"JFREEMAN","HTC","mobile","mobile child form","company" 2096,"DWASHINGTON","samsung","mobile","mobile child form","company" 2099,"JMOODY","apple","mobile","mobile child form","company" 2099,"JMOODY","samsung","mobile","mobile child form","company" 2102,"VCALDWELL","MI","mobile","mobile child form","company" 2102,"VCALDWELL","micromax","mobile","mobile child form","company" 2102,"VCALDWELL","celeron","mobile","mobile child form","company" 2103,"LBLAKE","apple","mobile","mobile child form","company" 2106,"TMORENO","HTC","mobile","mobile child form","company" 2107,"KADAMS","Oppo","mobile","mobile child form","company" 2107,"KADAMS","samsung","mobile","mobile child form","company" 2039,"EPATTON","ActiveB3","activeb","activeb child form","entitlements" 2039,"EPATTON","ActiveB5","activeb","activeb child form","entitlements" 2040,"VANDERSON","ActiveB9","activeb","activeb child form","entitlements" 2041,"AREYES","ActiveB8","activeb","activeb child form","entitlements" 2042,"ISAUNDERS","ActiveB9","activeb","activeb child form","entitlements" 2043,"SWEBER","ActiveB7","activeb","activeb child form","entitlements" 2044,"JWATERS","ActiveB8","activeb","activeb child form","entitlements" 2046,"ACOOK","ActiveB2","activeb","activeb child form","entitlements" 2046,"ACOOK","ActiveB10","activeb","activeb child form","entitlements" 2047,"BBECKER","ActiveB3","activeb","activeb child form","entitlements" 2047,"BBECKER","ActiveB10","activeb","activeb child form","entitlements" 2051,"MROY","ActiveB4","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","ActiveB9","activeb","activeb child form","entitlements" 2095,"JFREEMAN","ActiveB2","activeb","activeb child form","entitlements" 2095,"JFREEMAN","ActiveB10","activeb","activeb child form","entitlements" 2098,"PBARTON","ActiveB8","activeb","activeb child form","entitlements" 2099,"JMOODY","ActiveB3","activeb","activeb child form","entitlements" 2099,"JMOODY","ActiveB4","activeb","activeb child form","entitlements" 2099,"JMOODY","ActiveB7","activeb","activeb child form","entitlements" 2100,"DELLIOTT","ActiveB4","activeb","activeb child form","entitlements" 2100,"DELLIOTT","ActiveB8","activeb","activeb child form","entitlements" 2101,"DFOWLER","ActiveB5","activeb","activeb child form","entitlements" 2102,"VCALDWELL","ActiveB6","activeb","activeb child form","entitlements" 2103,"LBLAKE","ActiveB8","activeb","activeb child form","entitlements" 2104,"JLARSON","ActiveB1","activeb","activeb child form","entitlements" 2104,"JLARSON","ActiveB6","activeb","activeb child form","entitlements" 2107,"KADAMS","ActiveB3","activeb","activeb child form","entitlements" 98,"VCERTUSER9","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 100,"VCERTUSER11","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2007,"MSANDOVAL","Compaq","LapTop","LapTop child form","model" 2008,"CDELGADO","DELL","LapTop","LapTop child form","model" 2009,"KGILL","HP","LapTop","LapTop child form","model" 2010,"JNEWTON","Mac","LapTop","LapTop child form","model" 92,"VCERTUSER3","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 96,"VCERTUSER7","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 98,"VCERTUSER9","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 2026,"CMARSH","Asus","LapTop","LapTop child form","model" 2027,"ECOLEMAN","HP","LapTop","LapTop child form","model" 2027,"ECOLEMAN","Mac","LapTop","LapTop child form","model" 2027,"ECOLEMAN","Lenovo","LapTop","LapTop child form","model" 2028,"SMORAN","DELL","LapTop","LapTop child form","model" 2011,"AMEYER","MI","LapTop","LapTop child form","model" 2012,"LBATES","DELL","LapTop","LapTop child form","model" 2012,"LBATES","Zenith","LapTop","LapTop child form","model" 2013,"VMORALES","Compaq","LapTop","LapTop child form","model" 2013,"VMORALES","HCL","LapTop","LapTop child form","model" 2015,"WOLIVER","DELL","LapTop","LapTop child form","model" 2015,"WOLIVER","Zenith","LapTop","LapTop child form","model" 2016,"DSCHULTZ","Compaq","LapTop","LapTop child form","model" 2016,"DSCHULTZ","Asus","LapTop","LapTop child form","model" 2017,"PGOODMAN","Asus","LapTop","LapTop child form","model" 2020,"ECROSS","Toshiba","LapTop","LapTop child form","model" 2021,"SROBERTSON","Asus","LapTop","LapTop child form","model" 2021,"SROBERTSON","Toshiba","LapTop","LapTop child form","model" 2022,"MHALL","HP","LapTop","LapTop child form","model" 2025,"JRYAN","DELL","LapTop","LapTop child form","model" 2025,"JRYAN","MI","LapTop","LapTop child form","model" 90,"VCERTUSER1","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 92,"VCERTUSER3","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 93,"VCERTUSER4","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 95,"VCERTUSER6","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 99,"VCERTUSER10","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 100,"VCERTUSER11","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 90,"VCERTUSER1","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 94,"VCERTUSER5","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2056,"TORTIZ","Conference","Badge","Badge Types","type" 2057,"FLAMB","Access","Badge","Badge Types","type" 2057,"FLAMB","ACRoom","Badge","Badge Types","type" 2058,"SABBOTT","ACRoom","Badge","Badge Types","type" 2063,"JNORMAN","Access","Badge","Badge Types","type" 2077,"LVEGA","ACRoom","Badge","Badge Types","type" 2077,"LVEGA","Cafteria","Badge","Badge Types","type" 2079,"OGONZALES","Cafteria","Badge","Badge Types","type" 2080,"TARMSTRONG","reception","Badge","Badge Types","type" 2081,"GABBOTT","Conference","Badge","Badge Types","type" 2081,"GABBOTT","warehouse","Badge","Badge Types","type" 2083,"NROMERO","Printer","Badge","Badge Types","type" 2083,"NROMERO","Conference","Badge","Badge Types","type" 2084,"ACANNON","Office","Badge","Badge Types","type" 2085,"TMALDONADO","reception","Badge","Badge Types","type" 2089,"FGOODMAN","warehouse","Badge","Badge Types","type" 2090,"SRICHARDSON","ACRoom","Badge","Badge Types","type" 2092,"LPITTMAN","Conference","Badge","Badge Types","type" 2093,"CORTEGA","Store","Badge","Badge Types","type" 2093,"CORTEGA","generator","Badge","Badge Types","type" 2093,"CORTEGA","reception","Badge","Badge Types","type" 2094,"NTHOMPSON","Access","Badge","Badge Types","type" 2101,"DFOWLER","Printer","Badge","Badge Types","type" 2067,"NMYERS","ACRoom","Badge","Badge Types","type" 2070,"RCHAMBERS","warehouse","Badge","Badge Types","type" 2072,"ICALDWELL","Store","Badge","Badge Types","type" 2072,"ICALDWELL","ACRoom","Badge","Badge Types","type" 2073,"KMYERS","Conference","Badge","Badge Types","type" 2074,"LMULLINS","warehouse","Badge","Badge Types","type" 2029,"VCARPENTER","Toshiba","LapTop","LapTop child form","model" 2030,"TGOMEZ","Compaq","LapTop","LapTop child form","model" 2031,"EMUNOZ","HP","LapTop","LapTop child form","model" 2075,"CHOPKINS","Cafteria","Badge","Badge Types","type" 2076,"NRICE","Printer","Badge","Badge Types","type" 2076,"NRICE","warehouse","Badge","Badge Types","type" 2038,"HBROCK","ACRoom","Badge","Badge Types","type" 2038,"HBROCK","warehouse","Badge","Badge Types","type" 2039,"EPATTON","ACRoom","Badge","Badge Types","type" 2039,"EPATTON","reception","Badge","Badge Types","type" 2040,"VANDERSON","reception","Badge","Badge Types","type" 2041,"AREYES","Store","Badge","Badge Types","type" 2043,"SWEBER","Printer","Badge","Badge Types","type" 2045,"WJOSEPH","Access","Badge","Badge Types","type" 2046,"ACOOK","reception","Badge","Badge Types","type" 2047,"BBECKER","warehouse","Badge","Badge Types","type" 2048,"BNICHOLS","Store","Badge","Badge Types","type" 2048,"BNICHOLS","Office","Badge","Badge Types","type" 2050,"GHANSON","generator","Badge","Badge Types","type" 2052,"SWILLIS","Store","Badge","Badge Types","type" 2053,"TWILKINS","Printer","Badge","Badge Types","type" 2054,"CPAGE","Printer","Badge","Badge Types","type" 2054,"CPAGE","Conference","Badge","Badge Types","type" 2054,"CPAGE","generator","Badge","Badge Types","type" 2055,"TDANIELS","reception","Badge","Badge Types","type" 2056,"TORTIZ","Access","Badge","Badge Types","type" 2056,"TORTIZ","ACRoom","Badge","Badge Types","type" 2079,"OGONZALES","Oppo","mobile","mobile child form","company" 2081,"GABBOTT","HTC","mobile","mobile child form","company" 2081,"GABBOTT","celeron","mobile","mobile child form","company" 2082,"LDAWSON","HTC","mobile","mobile child form","company" 2083,"NROMERO","Nokia","mobile","mobile child form","company" 2083,"NROMERO","HTC","mobile","mobile child form","company" 2084,"ACANNON","samsung","mobile","mobile child form","company" 2086,"CGREGORY","MI","mobile","mobile child form","company" 2090,"SRICHARDSON","celeron","mobile","mobile child form","company" 2091,"RPETERSON","samsung","mobile","mobile child form","company" 2091,"RPETERSON","Nokia","mobile","mobile child form","company" 2091,"RPETERSON","celeron","mobile","mobile child form","company" 2039,"EPATTON","celeron","mobile","mobile child form","company" 2042,"ISAUNDERS","HTC","mobile","mobile child form","company" 2102,"VCALDWELL","Office","Badge","Badge Types","type" 2102,"VCALDWELL","Conference","Badge","Badge Types","type" 2103,"LBLAKE","Printer","Badge","Badge Types","type" 2104,"JLARSON","Store","Badge","Badge Types","type" 2104,"JLARSON","Access","Badge","Badge Types","type" 2104,"JLARSON","Printer","Badge","Badge Types","type" 2104,"JLARSON","warehouse","Badge","Badge Types","type" 2105,"GOSBORNE","reception","Badge","Badge Types","type" 2106,"TMORENO","ACRoom","Badge","Badge Types","type" 2106,"TMORENO","Conference","Badge","Badge Types","type" 2047,"BBECKER","apple","mobile","mobile child form","company" 2048,"BNICHOLS","MI","mobile","mobile child form","company" 2051,"MROY","micromax","mobile","mobile child form","company" 2052,"SWILLIS","Lenovo","mobile","mobile child form","company" 2054,"CPAGE","MI","mobile","mobile child form","company" 2056,"TORTIZ","Oppo","mobile","mobile child form","company" 2060,"FWHEELER","Nokia","mobile","mobile child form","company" 2066,"AWONG","Nokia","mobile","mobile child form","company" 2067,"NMYERS","Oppo","mobile","mobile child form","company" 2069,"BBARBER","celeron","mobile","mobile child form","company" 2076,"NRICE","MI","mobile","mobile child form","company" 2076,"NRICE","samsung","mobile","mobile child form","company" 2076,"NRICE","Nokia","mobile","mobile child form","company" 2077,"LVEGA","apple","mobile","mobile child form","company" 2057,"FLAMB","ActiveB2","activeb","activeb child form","entitlements" 2058,"SABBOTT","ActiveB1","activeb","activeb child form","entitlements" 2059,"AQUINN","ActiveB7","activeb","activeb child form","entitlements" 2079,"OGONZALES","ActiveB7","activeb","activeb child form","entitlements" 2080,"TARMSTRONG","ActiveB8","activeb","activeb child form","entitlements" 2081,"GABBOTT","ActiveB1","activeb","activeb child form","entitlements" 2081,"GABBOTT","ActiveB9","activeb","activeb child form","entitlements" 2082,"LDAWSON","ActiveB1","activeb","activeb child form","entitlements" 2082,"LDAWSON","ActiveB7","activeb","activeb child form","entitlements" 2082,"LDAWSON","ActiveB8","activeb","activeb child form","entitlements" 2083,"NROMERO","ActiveB1","activeb","activeb child form","entitlements" 2083,"NROMERO","ActiveB3","activeb","activeb child form","entitlements" 2084,"ACANNON","ActiveB6","activeb","activeb child form","entitlements" 2084,"ACANNON","ActiveB7","activeb","activeb child form","entitlements" 2085,"TMALDONADO","ActiveB3","activeb","activeb child form","entitlements" 2087,"SCORTEZ","ActiveB3","activeb","activeb child form","entitlements" 2089,"FGOODMAN","ActiveB2","activeb","activeb child form","entitlements" 2089,"FGOODMAN","ActiveB8","activeb","activeb child form","entitlements" 2090,"SRICHARDSON","ActiveB2","activeb","activeb child form","entitlements" 2092,"LPITTMAN","ActiveB3","activeb","activeb child form","entitlements" 2062,"RROBERSON","ActiveB3","activeb","activeb child form","entitlements" 2062,"RROBERSON","ActiveB7","activeb","activeb child form","entitlements" 2062,"RROBERSON","ActiveB8","activeb","activeb child form","entitlements" 2066,"AWONG","ActiveB1","activeb","activeb child form","entitlements" 2069,"BBARBER","ActiveB2","activeb","activeb child form","entitlements" 2069,"BBARBER","ActiveB7","activeb","activeb child form","entitlements" 2070,"RCHAMBERS","ActiveB1","activeb","activeb child form","entitlements" 2071,"VORTIZ","ActiveB8","activeb","activeb child form","entitlements" 2072,"ICALDWELL","ActiveB6","activeb","activeb child form","entitlements" 2073,"KMYERS","ActiveB7","activeb","activeb child form","entitlements" 2074,"LMULLINS","ActiveB7","activeb","activeb child form","entitlements" 2074,"LMULLINS","ActiveB9","activeb","activeb child form","entitlements" 2076,"NRICE","ActiveB2","activeb","activeb child form","entitlements" 2076,"NRICE","ActiveB3","activeb","activeb child form","entitlements" 2076,"NRICE","ActiveB6","activeb","activeb child form","entitlements" 2079,"OGONZALES","ActiveB1","activeb","activeb child form","entitlements" 2096,"DWASHINGTON","Nokia","mobile","mobile child form","company" 2097,"CALEXANDER","apple","mobile","mobile child form","company" 2100,"DELLIOTT","micromax","mobile","mobile child form","company" 2100,"DELLIOTT","celeron","mobile","mobile child form","company" 2101,"DFOWLER","micromax","mobile","mobile child form","company" 2102,"VCALDWELL","apple","mobile","mobile child form","company" 2102,"VCALDWELL","Nokia","mobile","mobile child form","company" 2102,"VCALDWELL","Lenovo","mobile","mobile child form","company" 2102,"VCALDWELL","HTC","mobile","mobile child form","company" 2104,"JLARSON","samsung","mobile","mobile child form","company" 2106,"TMORENO","MI","mobile","mobile child form","company" 2106,"TMORENO","apple","mobile","mobile child form","company" 2106,"TMORENO","Oppo","mobile","mobile child form","company" 2039,"EPATTON","ActiveB8","activeb","activeb child form","entitlements" 2042,"ISAUNDERS","ActiveB3","activeb","activeb child form","entitlements" 2042,"ISAUNDERS","ActiveB8","activeb","activeb child form","entitlements" 2043,"SWEBER","ActiveB5","activeb","activeb child form","entitlements" 2044,"JWATERS","ActiveB6","activeb","activeb child form","entitlements" 2095,"JFREEMAN","ActiveB3","activeb","activeb child form","entitlements" 2096,"DWASHINGTON","ActiveB3","activeb","activeb child form","entitlements" 2096,"DWASHINGTON","ActiveB7","activeb","activeb child form","entitlements" 2097,"CALEXANDER","ActiveB3","activeb","activeb child form","entitlements" 2097,"CALEXANDER","ActiveB10","activeb","activeb child form","entitlements" 2098,"PBARTON","ActiveB6","activeb","activeb child form","entitlements" 2100,"DELLIOTT","ActiveB1","activeb","activeb child form","entitlements" 2100,"DELLIOTT","ActiveB3","activeb","activeb child form","entitlements" 2102,"VCALDWELL","ActiveB1","activeb","activeb child form","entitlements" 2102,"VCALDWELL","ActiveB9","activeb","activeb child form","entitlements" 2104,"JLARSON","ActiveB9","activeb","activeb child form","entitlements" 2105,"GOSBORNE","ActiveB2","activeb","activeb child form","entitlements" 97,"VCERTUSER8","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 98,"VCERTUSER9","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2002,"USR_5","HP","LapTop","LapTop child form","model" 2006,"DLEWIS","DELL","LapTop","LapTop child form","model" 2006,"DLEWIS","MI","LapTop","LapTop child form","model" 2008,"CDELGADO","Lenovo","LapTop","LapTop child form","model" 2008,"CDELGADO","Asus","LapTop","LapTop child form","model" 2009,"KGILL","Mac","LapTop","LapTop child form","model" 2010,"JNEWTON","HCL","LapTop","LapTop child form","model" 90,"VCERTUSER1","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 93,"VCERTUSER4","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 98,"VCERTUSER9","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 2027,"ECOLEMAN","HCL","LapTop","LapTop child form","model" 2012,"LBATES","Compaq","LapTop","LapTop child form","model" 2014,"KPOOLE","Lenovo","LapTop","LapTop child form","model" 2015,"WOLIVER","Asus","LapTop","LapTop child form","model" 2017,"PGOODMAN","Compaq","LapTop","LapTop child form","model" 2018,"JMULLINS","Compaq","LapTop","LapTop child form","model" 2018,"JMULLINS","Asus","LapTop","LapTop child form","model" 2021,"SROBERTSON","Zenith","LapTop","LapTop child form","model" 2022,"MHALL","Compaq","LapTop","LapTop child form","model" 2022,"MHALL","Asus","LapTop","LapTop child form","model" 2023,"CMCKINNEY","Asus","LapTop","LapTop child form","model" 96,"VCERTUSER7","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 93,"VCERTUSER4","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 95,"VCERTUSER6","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 97,"VCERTUSER8","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2056,"TORTIZ","warehouse","Badge","Badge Types","type" 2059,"AQUINN","Cafteria","Badge","Badge Types","type" 2062,"RROBERSON","Store","Badge","Badge Types","type" 2062,"RROBERSON","Conference","Badge","Badge Types","type" 2065,"AMUNOZ","ACRoom","Badge","Badge Types","type" 2077,"LVEGA","warehouse","Badge","Badge Types","type" 2080,"TARMSTRONG","ACRoom","Badge","Badge Types","type" 2081,"GABBOTT","Printer","Badge","Badge Types","type" 2082,"LDAWSON","generator","Badge","Badge Types","type" 2083,"NROMERO","Access","Badge","Badge Types","type" 2085,"TMALDONADO","ACRoom","Badge","Badge Types","type" 2086,"CGREGORY","reception","Badge","Badge Types","type" 2089,"FGOODMAN","ACRoom","Badge","Badge Types","type" 2090,"SRICHARDSON","Printer","Badge","Badge Types","type" 2090,"SRICHARDSON","generator","Badge","Badge Types","type" 2091,"RPETERSON","Store","Badge","Badge Types","type" 2091,"RPETERSON","warehouse","Badge","Badge Types","type" 2091,"RPETERSON","generator","Badge","Badge Types","type" 2094,"NTHOMPSON","Printer","Badge","Badge Types","type" 2094,"NTHOMPSON","Office","Badge","Badge Types","type" 2096,"DWASHINGTON","reception","Badge","Badge Types","type" 2097,"CALEXANDER","Access","Badge","Badge Types","type" 2100,"DELLIOTT","ACRoom","Badge","Badge Types","type" 2100,"DELLIOTT","warehouse","Badge","Badge Types","type" 2069,"BBARBER","Store","Badge","Badge Types","type" 2069,"BBARBER","ACRoom","Badge","Badge Types","type" 2069,"BBARBER","Cafteria","Badge","Badge Types","type" 2069,"BBARBER","reception","Badge","Badge Types","type" 2072,"ICALDWELL","Printer","Badge","Badge Types","type" 2074,"LMULLINS","Store","Badge","Badge Types","type" 2030,"TGOMEZ","DELL","LapTop","LapTop child form","model" 2033,"SKELLER","Lenovo","LapTop","LapTop child form","model" 2033,"SKELLER","Asus","LapTop","LapTop child form","model" 2076,"NRICE","Office","Badge","Badge Types","type" 2076,"NRICE","reception","Badge","Badge Types","type" 2041,"AREYES","Printer","Badge","Badge Types","type" 2042,"ISAUNDERS","Printer","Badge","Badge Types","type" 2042,"ISAUNDERS","generator","Badge","Badge Types","type" 2047,"BBECKER","reception","Badge","Badge Types","type" 2049,"CCHAVEZ","generator","Badge","Badge Types","type" 2050,"GHANSON","Store","Badge","Badge Types","type" 2051,"MROY","Store","Badge","Badge Types","type" 2051,"MROY","Cafteria","Badge","Badge Types","type" 2052,"SWILLIS","Office","Badge","Badge Types","type" 2052,"SWILLIS","warehouse","Badge","Badge Types","type" 2053,"TWILKINS","Access","Badge","Badge Types","type" 2078,"MBAKER","MI","mobile","mobile child form","company" 2080,"TARMSTRONG","apple","mobile","mobile child form","company" 2082,"LDAWSON","Oppo","mobile","mobile child form","company" 2085,"TMALDONADO","apple","mobile","mobile child form","company" 2085,"TMALDONADO","Nokia","mobile","mobile child form","company" 2086,"CGREGORY","Lenovo","mobile","mobile child form","company" 2087,"SCORTEZ","Lenovo","mobile","mobile child form","company" 2088,"SMCDONALD","celeron","mobile","mobile child form","company" 2089,"FGOODMAN","micromax","mobile","mobile child form","company" 2091,"RPETERSON","Lenovo","mobile","mobile child form","company" 2092,"LPITTMAN","Nokia","mobile","mobile child form","company" 2092,"LPITTMAN","Lenovo","mobile","mobile child form","company" 2092,"LPITTMAN","HTC","mobile","mobile child form","company" 2093,"CORTEGA","celeron","mobile","mobile child form","company" 2038,"HBROCK","Oppo","mobile","mobile child form","company" 2038,"HBROCK","Lenovo","mobile","mobile child form","company" 2039,"EPATTON","samsung","mobile","mobile child form","company" 2039,"EPATTON","micromax","mobile","mobile child form","company" 2040,"VANDERSON","Oppo","mobile","mobile child form","company" 2041,"AREYES","celeron","mobile","mobile child form","company" 2043,"SWEBER","micromax","mobile","mobile child form","company" 2044,"JWATERS","samsung","mobile","mobile child form","company" 2103,"LBLAKE","Cafteria","Badge","Badge Types","type" 2103,"LBLAKE","warehouse","Badge","Badge Types","type" 2103,"LBLAKE","generator","Badge","Badge Types","type" 2107,"KADAMS","reception","Badge","Badge Types","type" 2050,"GHANSON","apple","mobile","mobile child form","company" 2052,"SWILLIS","MI","mobile","mobile child form","company" 2053,"TWILKINS","celeron","mobile","mobile child form","company" 2055,"TDANIELS","Oppo","mobile","mobile child form","company" 2056,"TORTIZ","Lenovo","mobile","mobile child form","company" 2057,"FLAMB","apple","mobile","mobile child form","company" 2058,"SABBOTT","Oppo","mobile","mobile child form","company" 2058,"SABBOTT","Lenovo","mobile","mobile child form","company" 2060,"FWHEELER","micromax","mobile","mobile child form","company" 2060,"FWHEELER","celeron","mobile","mobile child form","company" 2062,"RROBERSON","samsung","mobile","mobile child form","company" 2063,"JNORMAN","apple","mobile","mobile child form","company" 2063,"JNORMAN","Nokia","mobile","mobile child form","company" 2065,"AMUNOZ","Nokia","mobile","mobile child form","company" 2066,"AWONG","MI","mobile","mobile child form","company" 2066,"AWONG","apple","mobile","mobile child form","company" 2067,"NMYERS","HTC","mobile","mobile child form","company" 2070,"RCHAMBERS","apple","mobile","mobile child form","company" 2071,"VORTIZ","samsung","mobile","mobile child form","company" 2071,"VORTIZ","Lenovo","mobile","mobile child form","company" 2073,"KMYERS","apple","mobile","mobile child form","company" 2073,"KMYERS","Nokia","mobile","mobile child form","company" 2073,"KMYERS","celeron","mobile","mobile child form","company" 2051,"MROY","ActiveB10","activeb","activeb child form","entitlements" 2052,"SWILLIS","ActiveB8","activeb","activeb child form","entitlements" 2053,"TWILKINS","ActiveB5","activeb","activeb child form","entitlements" 2053,"TWILKINS","ActiveB7","activeb","activeb child form","entitlements" 2053,"TWILKINS","ActiveB10","activeb","activeb child form","entitlements" 2056,"TORTIZ","ActiveB10","activeb","activeb child form","entitlements" 2059,"AQUINN","ActiveB8","activeb","activeb child form","entitlements" 2079,"OGONZALES","ActiveB2","activeb","activeb child form","entitlements" 2081,"GABBOTT","ActiveB7","activeb","activeb child form","entitlements" 2083,"NROMERO","ActiveB9","activeb","activeb child form","entitlements" 2083,"NROMERO","ActiveB10","activeb","activeb child form","entitlements" 2084,"ACANNON","ActiveB9","activeb","activeb child form","entitlements" 2084,"ACANNON","ActiveB10","activeb","activeb child form","entitlements" 2087,"SCORTEZ","ActiveB5","activeb","activeb child form","entitlements" 2088,"SMCDONALD","ActiveB2","activeb","activeb child form","entitlements" 2089,"FGOODMAN","ActiveB1","activeb","activeb child form","entitlements" 2090,"SRICHARDSON","ActiveB3","activeb","activeb child form","entitlements" 2090,"SRICHARDSON","ActiveB4","activeb","activeb child form","entitlements" 2090,"SRICHARDSON","ActiveB8","activeb","activeb child form","entitlements" 2091,"RPETERSON","ActiveB8","activeb","activeb child form","entitlements" 2092,"LPITTMAN","ActiveB1","activeb","activeb child form","entitlements" 2093,"CORTEGA","ActiveB3","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","ActiveB4","activeb","activeb child form","entitlements" 2062,"RROBERSON","ActiveB6","activeb","activeb child form","entitlements" 2062,"RROBERSON","ActiveB10","activeb","activeb child form","entitlements" 2065,"AMUNOZ","ActiveB10","activeb","activeb child form","entitlements" 2067,"NMYERS","ActiveB1","activeb","activeb child form","entitlements" 2069,"BBARBER","ActiveB1","activeb","activeb child form","entitlements" 2069,"BBARBER","ActiveB3","activeb","activeb child form","entitlements" 2069,"BBARBER","ActiveB5","activeb","activeb child form","entitlements" 2070,"RCHAMBERS","ActiveB2","activeb","activeb child form","entitlements" 2071,"VORTIZ","ActiveB4","activeb","activeb child form","entitlements" 2072,"ICALDWELL","ActiveB3","activeb","activeb child form","entitlements" 2072,"ICALDWELL","ActiveB4","activeb","activeb child form","entitlements" 2072,"ICALDWELL","ActiveB8","activeb","activeb child form","entitlements" 2073,"KMYERS","ActiveB8","activeb","activeb child form","entitlements" 2073,"KMYERS","ActiveB10","activeb","activeb child form","entitlements" 2074,"LMULLINS","ActiveB4","activeb","activeb child form","entitlements" 2077,"LVEGA","ActiveB3","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","micromax","mobile","mobile child form","company" 2098,"PBARTON","MI","mobile","mobile child form","company" 2099,"JMOODY","micromax","mobile","mobile child form","company" 2101,"DFOWLER","Lenovo","mobile","mobile child form","company" 2101,"DFOWLER","celeron","mobile","mobile child form","company" 2104,"JLARSON","celeron","mobile","mobile child form","company" 2105,"GOSBORNE","Nokia","mobile","mobile child form","company" 2106,"TMORENO","samsung","mobile","mobile child form","company" 2106,"TMORENO","Nokia","mobile","mobile child form","company" 2039,"EPATTON","ActiveB2","activeb","activeb child form","entitlements" 2040,"VANDERSON","ActiveB8","activeb","activeb child form","entitlements" 2041,"AREYES","ActiveB9","activeb","activeb child form","entitlements" 2042,"ISAUNDERS","ActiveB1","activeb","activeb child form","entitlements" 2044,"JWATERS","ActiveB10","activeb","activeb child form","entitlements" 2045,"WJOSEPH","ActiveB3","activeb","activeb child form","entitlements" 2045,"WJOSEPH","ActiveB10","activeb","activeb child form","entitlements" 2048,"BNICHOLS","ActiveB8","activeb","activeb child form","entitlements" 2050,"GHANSON","ActiveB4","activeb","activeb child form","entitlements" 2050,"GHANSON","ActiveB6","activeb","activeb child form","entitlements" 2095,"JFREEMAN","ActiveB1","activeb","activeb child form","entitlements" 2095,"JFREEMAN","ActiveB5","activeb","activeb child form","entitlements" 2096,"DWASHINGTON","ActiveB1","activeb","activeb child form","entitlements" 2098,"PBARTON","ActiveB2","activeb","activeb child form","entitlements" 2099,"JMOODY","ActiveB5","activeb","activeb child form","entitlements" 2101,"DFOWLER","ActiveB1","activeb","activeb child form","entitlements" 2102,"VCALDWELL","ActiveB2","activeb","activeb child form","entitlements" 2103,"LBLAKE","ActiveB1","activeb","activeb child form","entitlements" 2104,"JLARSON","ActiveB10","activeb","activeb child form","entitlements" 2105,"GOSBORNE","ActiveB3","activeb","activeb child form","entitlements" 2107,"KADAMS","ActiveB10","activeb","activeb child form","entitlements" 2006,"DLEWIS","HCL","LapTop","LapTop child form","model" 2006,"DLEWIS","Toshiba","LapTop","LapTop child form","model" 2007,"MSANDOVAL","Zenith","LapTop","LapTop child form","model" 2008,"CDELGADO","Compaq","LapTop","LapTop child form","model" 2009,"KGILL","Zenith","LapTop","LapTop child form","model" 2010,"JNEWTON","Zenith","LapTop","LapTop child form","model" 2010,"JNEWTON","Compaq","LapTop","LapTop child form","model" 2010,"JNEWTON","Toshiba","LapTop","LapTop child form","model" 2010,"JNEWTON","MI","LapTop","LapTop child form","model" 93,"VCERTUSER4","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 95,"VCERTUSER6","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 97,"VCERTUSER8","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 98,"VCERTUSER9","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 100,"VCERTUSER11","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 100,"VCERTUSER11","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 2027,"ECOLEMAN","DELL","LapTop","LapTop child form","model" 2027,"ECOLEMAN","Zenith","LapTop","LapTop child form","model" 2011,"AMEYER","Mac","LapTop","LapTop child form","model" 2015,"WOLIVER","Lenovo","LapTop","LapTop child form","model" 2016,"DSCHULTZ","DELL","LapTop","LapTop child form","model" 2017,"PGOODMAN","DELL","LapTop","LapTop child form","model" 2019,"RWALTON","Toshiba","LapTop","LapTop child form","model" 2020,"ECROSS","DELL","LapTop","LapTop child form","model" 2020,"ECROSS","Zenith","LapTop","LapTop child form","model" 2020,"ECROSS","Lenovo","LapTop","LapTop child form","model" 2021,"SROBERTSON","DELL","LapTop","LapTop child form","model" 2021,"SROBERTSON","HP","LapTop","LapTop child form","model" 2022,"MHALL","Mac","LapTop","LapTop child form","model" 2023,"CMCKINNEY","HCL","LapTop","LapTop child form","model" 93,"VCERTUSER4","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 95,"VCERTUSER6","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 96,"VCERTUSER7","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 97,"VCERTUSER8","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 97,"VCERTUSER8","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 97,"VCERTUSER8","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 98,"VCERTUSER9","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 91,"VCERTUSER2","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 91,"VCERTUSER2","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 95,"VCERTUSER6","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 96,"VCERTUSER7","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 96,"VCERTUSER7","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2056,"TORTIZ","Office","Badge","Badge Types","type" 2057,"FLAMB","warehouse","Badge","Badge Types","type" 2059,"AQUINN","warehouse","Badge","Badge Types","type" 2059,"AQUINN","reception","Badge","Badge Types","type" 2062,"RROBERSON","Access","Badge","Badge Types","type" 2062,"RROBERSON","Printer","Badge","Badge Types","type" 2062,"RROBERSON","generator","Badge","Badge Types","type" 2062,"RROBERSON","reception","Badge","Badge Types","type" 2063,"JNORMAN","Cafteria","Badge","Badge Types","type" 2065,"AMUNOZ","Access","Badge","Badge Types","type" 2082,"LDAWSON","Store","Badge","Badge Types","type" 2082,"LDAWSON","Access","Badge","Badge Types","type" 2082,"LDAWSON","ACRoom","Badge","Badge Types","type" 2083,"NROMERO","warehouse","Badge","Badge Types","type" 2083,"NROMERO","reception","Badge","Badge Types","type" 2084,"ACANNON","Access","Badge","Badge Types","type" 2085,"TMALDONADO","Access","Badge","Badge Types","type" 2085,"TMALDONADO","Cafteria","Badge","Badge Types","type" 2086,"CGREGORY","Access","Badge","Badge Types","type" 2086,"CGREGORY","Conference","Badge","Badge Types","type" 2089,"FGOODMAN","Cafteria","Badge","Badge Types","type" 2090,"SRICHARDSON","Store","Badge","Badge Types","type" 2090,"SRICHARDSON","warehouse","Badge","Badge Types","type" 2090,"SRICHARDSON","reception","Badge","Badge Types","type" 2092,"LPITTMAN","ACRoom","Badge","Badge Types","type" 2092,"LPITTMAN","Office","Badge","Badge Types","type" 2096,"DWASHINGTON","ACRoom","Badge","Badge Types","type" 2096,"DWASHINGTON","Office","Badge","Badge Types","type" 2099,"JMOODY","reception","Badge","Badge Types","type" 2100,"DELLIOTT","Printer","Badge","Badge Types","type" 2101,"DFOWLER","generator","Badge","Badge Types","type" 2070,"RCHAMBERS","ACRoom","Badge","Badge Types","type" 2070,"RCHAMBERS","generator","Badge","Badge Types","type" 2070,"RCHAMBERS","reception","Badge","Badge Types","type" 2071,"VORTIZ","Cafteria","Badge","Badge Types","type" 2073,"KMYERS","generator","Badge","Badge Types","type" 2075,"CHOPKINS","Access","Badge","Badge Types","type" 2075,"CHOPKINS","ACRoom","Badge","Badge Types","type" 2028,"SMORAN","Asus","LapTop","LapTop child form","model" 2028,"SMORAN","Toshiba","LapTop","LapTop child form","model" 2029,"VCARPENTER","MI","LapTop","LapTop child form","model" 2031,"EMUNOZ","Zenith","LapTop","LapTop child form","model" 2076,"NRICE","Access","Badge","Badge Types","type" 2038,"HBROCK","Office","Badge","Badge Types","type" 2041,"AREYES","Cafteria","Badge","Badge Types","type" 2045,"WJOSEPH","Printer","Badge","Badge Types","type" 2046,"ACOOK","Access","Badge","Badge Types","type" 2046,"ACOOK","ACRoom","Badge","Badge Types","type" 2046,"ACOOK","Office","Badge","Badge Types","type" 2048,"BNICHOLS","warehouse","Badge","Badge Types","type" 2049,"CCHAVEZ","reception","Badge","Badge Types","type" 2050,"GHANSON","ACRoom","Badge","Badge Types","type" 2050,"GHANSON","Printer","Badge","Badge Types","type" 2050,"GHANSON","Office","Badge","Badge Types","type" 2052,"SWILLIS","Printer","Badge","Badge Types","type" 2052,"SWILLIS","generator","Badge","Badge Types","type" 2054,"CPAGE","Store","Badge","Badge Types","type" 2079,"OGONZALES","samsung","mobile","mobile child form","company" 2080,"TARMSTRONG","micromax","mobile","mobile child form","company" 2080,"TARMSTRONG","celeron","mobile","mobile child form","company" 2082,"LDAWSON","apple","mobile","mobile child form","company" 2082,"LDAWSON","Lenovo","mobile","mobile child form","company" 2083,"NROMERO","apple","mobile","mobile child form","company" 2083,"NROMERO","micromax","mobile","mobile child form","company" 2083,"NROMERO","celeron","mobile","mobile child form","company" 2086,"CGREGORY","apple","mobile","mobile child form","company" 2086,"CGREGORY","Oppo","mobile","mobile child form","company" 2087,"SCORTEZ","Oppo","mobile","mobile child form","company" 2089,"FGOODMAN","celeron","mobile","mobile child form","company" 2090,"SRICHARDSON","Nokia","mobile","mobile child form","company" 2039,"EPATTON","apple","mobile","mobile child form","company" 2040,"VANDERSON","micromax","mobile","mobile child form","company" 2041,"AREYES","samsung","mobile","mobile child form","company" 2041,"AREYES","Nokia","mobile","mobile child form","company" 2042,"ISAUNDERS","MI","mobile","mobile child form","company" 2042,"ISAUNDERS","Oppo","mobile","mobile child form","company" 2045,"WJOSEPH","HTC","mobile","mobile child form","company" 2046,"ACOOK","MI","mobile","mobile child form","company" 2046,"ACOOK","samsung","mobile","mobile child form","company" 2046,"ACOOK","Oppo","mobile","mobile child form","company" 2104,"JLARSON","Office","Badge","Badge Types","type" 2104,"JLARSON","generator","Badge","Badge Types","type" 2105,"GOSBORNE","Printer","Badge","Badge Types","type" 2105,"GOSBORNE","Cafteria","Badge","Badge Types","type" 2106,"TMORENO","Printer","Badge","Badge Types","type" 2046,"ACOOK","HTC","mobile","mobile child form","company" 2048,"BNICHOLS","Lenovo","mobile","mobile child form","company" 2050,"GHANSON","celeron","mobile","mobile child form","company" 2051,"MROY","HTC","mobile","mobile child form","company" 2053,"TWILKINS","HTC","mobile","mobile child form","company" 2055,"TDANIELS","apple","mobile","mobile child form","company" 2056,"TORTIZ","samsung","mobile","mobile child form","company" 2062,"RROBERSON","MI","mobile","mobile child form","company" 2062,"RROBERSON","micromax","mobile","mobile child form","company" 2066,"AWONG","Oppo","mobile","mobile child form","company" 2067,"NMYERS","apple","mobile","mobile child form","company" 2070,"RCHAMBERS","Oppo","mobile","mobile child form","company" 2071,"VORTIZ","micromax","mobile","mobile child form","company" 2072,"ICALDWELL","micromax","mobile","mobile child form","company" 2072,"ICALDWELL","celeron","mobile","mobile child form","company" 2074,"LMULLINS","Lenovo","mobile","mobile child form","company" 2076,"NRICE","apple","mobile","mobile child form","company" 2052,"SWILLIS","ActiveB1","activeb","activeb child form","entitlements" 2052,"SWILLIS","ActiveB2","activeb","activeb child form","entitlements" 2052,"SWILLIS","ActiveB6","activeb","activeb child form","entitlements" 2055,"TDANIELS","ActiveB5","activeb","activeb child form","entitlements" 2056,"TORTIZ","ActiveB1","activeb","activeb child form","entitlements" 2080,"TARMSTRONG","ActiveB4","activeb","activeb child form","entitlements" 2081,"GABBOTT","ActiveB5","activeb","activeb child form","entitlements" 2081,"GABBOTT","ActiveB8","activeb","activeb child form","entitlements" 2082,"LDAWSON","ActiveB2","activeb","activeb child form","entitlements" 2082,"LDAWSON","ActiveB3","activeb","activeb child form","entitlements" 2086,"CGREGORY","ActiveB1","activeb","activeb child form","entitlements" 2086,"CGREGORY","ActiveB3","activeb","activeb child form","entitlements" 2087,"SCORTEZ","ActiveB2","activeb","activeb child form","entitlements" 2089,"FGOODMAN","ActiveB5","activeb","activeb child form","entitlements" 2089,"FGOODMAN","ActiveB7","activeb","activeb child form","entitlements" 2090,"SRICHARDSON","ActiveB1","activeb","activeb child form","entitlements" 2090,"SRICHARDSON","ActiveB6","activeb","activeb child form","entitlements" 2092,"LPITTMAN","ActiveB2","activeb","activeb child form","entitlements" 2092,"LPITTMAN","ActiveB6","activeb","activeb child form","entitlements" 2092,"LPITTMAN","ActiveB10","activeb","activeb child form","entitlements" 2093,"CORTEGA","ActiveB8","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","ActiveB6","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","ActiveB7","activeb","activeb child form","entitlements" 2060,"FWHEELER","ActiveB2","activeb","activeb child form","entitlements" 2065,"AMUNOZ","ActiveB5","activeb","activeb child form","entitlements" 2065,"AMUNOZ","ActiveB9","activeb","activeb child form","entitlements" 2067,"NMYERS","ActiveB2","activeb","activeb child form","entitlements" 2070,"RCHAMBERS","ActiveB8","activeb","activeb child form","entitlements" 2070,"RCHAMBERS","ActiveB9","activeb","activeb child form","entitlements" 2071,"VORTIZ","ActiveB9","activeb","activeb child form","entitlements" 2074,"LMULLINS","ActiveB8","activeb","activeb child form","entitlements" 2076,"NRICE","ActiveB7","activeb","activeb child form","entitlements" 2077,"LVEGA","ActiveB10","activeb","activeb child form","entitlements" 2078,"MBAKER","ActiveB1","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","Lenovo","mobile","mobile child form","company" 2095,"JFREEMAN","Lenovo","mobile","mobile child form","company" 2098,"PBARTON","celeron","mobile","mobile child form","company" 2100,"DELLIOTT","apple","mobile","mobile child form","company" 2102,"VCALDWELL","samsung","mobile","mobile child form","company" 2103,"LBLAKE","samsung","mobile","mobile child form","company" 2103,"LBLAKE","celeron","mobile","mobile child form","company" 2104,"JLARSON","MI","mobile","mobile child form","company" 2104,"JLARSON","Lenovo","mobile","mobile child form","company" 2107,"KADAMS","apple","mobile","mobile child form","company" 2107,"KADAMS","HTC","mobile","mobile child form","company" 2040,"VANDERSON","ActiveB3","activeb","activeb child form","entitlements" 2042,"ISAUNDERS","ActiveB2","activeb","activeb child form","entitlements" 2042,"ISAUNDERS","ActiveB6","activeb","activeb child form","entitlements" 2044,"JWATERS","ActiveB7","activeb","activeb child form","entitlements" 2050,"GHANSON","ActiveB2","activeb","activeb child form","entitlements" 2051,"MROY","ActiveB5","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","ActiveB10","activeb","activeb child form","entitlements" 2096,"DWASHINGTON","ActiveB9","activeb","activeb child form","entitlements" 2101,"DFOWLER","ActiveB4","activeb","activeb child form","entitlements" 2102,"VCALDWELL","ActiveB3","activeb","activeb child form","entitlements" 2102,"VCALDWELL","ActiveB10","activeb","activeb child form","entitlements" 2103,"LBLAKE","ActiveB5","activeb","activeb child form","entitlements" 2105,"GOSBORNE","ActiveB9","activeb","activeb child form","entitlements" 2106,"TMORENO","ActiveB10","activeb","activeb child form","entitlements" 2107,"KADAMS","ActiveB2","activeb","activeb child form","entitlements" 98,"VCERTUSER9","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2007,"MSANDOVAL","Asus","LapTop","LapTop child form","model" 2008,"CDELGADO","MI","LapTop","LapTop child form","model" 2009,"KGILL","DELL","LapTop","LapTop child form","model" 2010,"JNEWTON","Lenovo","LapTop","LapTop child form","model" 95,"VCERTUSER6","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 2027,"ECOLEMAN","Asus","LapTop","LapTop child form","model" 2027,"ECOLEMAN","Toshiba","LapTop","LapTop child form","model" 2027,"ECOLEMAN","MI","LapTop","LapTop child form","model" 90,"VCERTUSER1","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 2013,"VMORALES","Mac","LapTop","LapTop child form","model" 2014,"KPOOLE","Asus","LapTop","LapTop child form","model" 2016,"DSCHULTZ","MI","LapTop","LapTop child form","model" 2017,"PGOODMAN","Mac","LapTop","LapTop child form","model" 2017,"PGOODMAN","HCL","LapTop","LapTop child form","model" 2018,"JMULLINS","DELL","LapTop","LapTop child form","model" 2018,"JMULLINS","MI","LapTop","LapTop child form","model" 2019,"RWALTON","Compaq","LapTop","LapTop child form","model" 2019,"RWALTON","Lenovo","LapTop","LapTop child form","model" 2023,"CMCKINNEY","Toshiba","LapTop","LapTop child form","model" 2025,"JRYAN","Toshiba","LapTop","LapTop child form","model" 91,"VCERTUSER2","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 92,"VCERTUSER3","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 99,"VCERTUSER10","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 90,"VCERTUSER1","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 94,"VCERTUSER5","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 2059,"AQUINN","Conference","Badge","Badge Types","type" 2060,"FWHEELER","Store","Badge","Badge Types","type" 2060,"FWHEELER","Office","Badge","Badge Types","type" 2066,"AWONG","Office","Badge","Badge Types","type" 2066,"AWONG","Conference","Badge","Badge Types","type" 2079,"OGONZALES","warehouse","Badge","Badge Types","type" 2079,"OGONZALES","reception","Badge","Badge Types","type" 2081,"GABBOTT","Access","Badge","Badge Types","type" 2083,"NROMERO","Store","Badge","Badge Types","type" 2083,"NROMERO","Cafteria","Badge","Badge Types","type" 2084,"ACANNON","Store","Badge","Badge Types","type" 2084,"ACANNON","Printer","Badge","Badge Types","type" 2085,"TMALDONADO","warehouse","Badge","Badge Types","type" 2087,"SCORTEZ","ACRoom","Badge","Badge Types","type" 2088,"SMCDONALD","Store","Badge","Badge Types","type" 2088,"SMCDONALD","ACRoom","Badge","Badge Types","type" 2091,"RPETERSON","Printer","Badge","Badge Types","type" 2091,"RPETERSON","Cafteria","Badge","Badge Types","type" 2092,"LPITTMAN","warehouse","Badge","Badge Types","type" 2092,"LPITTMAN","generator","Badge","Badge Types","type" 2098,"PBARTON","Store","Badge","Badge Types","type" 2099,"JMOODY","ACRoom","Badge","Badge Types","type" 2100,"DELLIOTT","generator","Badge","Badge Types","type" 2100,"DELLIOTT","reception","Badge","Badge Types","type" 2101,"DFOWLER","Access","Badge","Badge Types","type" 2067,"NMYERS","warehouse","Badge","Badge Types","type" 2071,"VORTIZ","Printer","Badge","Badge Types","type" 2071,"VORTIZ","Conference","Badge","Badge Types","type" 2071,"VORTIZ","warehouse","Badge","Badge Types","type" 2072,"ICALDWELL","warehouse","Badge","Badge Types","type" 2072,"ICALDWELL","generator","Badge","Badge Types","type" 2072,"ICALDWELL","reception","Badge","Badge Types","type" 2073,"KMYERS","Access","Badge","Badge Types","type" 2073,"KMYERS","Printer","Badge","Badge Types","type" 2073,"KMYERS","Cafteria","Badge","Badge Types","type" 2074,"LMULLINS","Conference","Badge","Badge Types","type" 2028,"SMORAN","HP","LapTop","LapTop child form","model" 2028,"SMORAN","Compaq","LapTop","LapTop child form","model" 2028,"SMORAN","HCL","LapTop","LapTop child form","model" 2029,"VCARPENTER","Compaq","LapTop","LapTop child form","model" 2030,"TGOMEZ","Zenith","LapTop","LapTop child form","model" 2030,"TGOMEZ","Mac","LapTop","LapTop child form","model" 2032,"YWATKINS","HCL","LapTop","LapTop child form","model" 2075,"CHOPKINS","warehouse","Badge","Badge Types","type" 2042,"ISAUNDERS","ACRoom","Badge","Badge Types","type" 2044,"JWATERS","generator","Badge","Badge Types","type" 2046,"ACOOK","Conference","Badge","Badge Types","type" 2047,"BBECKER","Access","Badge","Badge Types","type" 2053,"TWILKINS","Cafteria","Badge","Badge Types","type" 2053,"TWILKINS","reception","Badge","Badge Types","type" 2055,"TDANIELS","ACRoom","Badge","Badge Types","type" 2055,"TDANIELS","Printer","Badge","Badge Types","type" 2080,"TARMSTRONG","Lenovo","mobile","mobile child form","company" 2082,"LDAWSON","micromax","mobile","mobile child form","company" 2082,"LDAWSON","celeron","mobile","mobile child form","company" 2083,"NROMERO","samsung","mobile","mobile child form","company" 2083,"NROMERO","Lenovo","mobile","mobile child form","company" 2085,"TMALDONADO","Lenovo","mobile","mobile child form","company" 2086,"CGREGORY","HTC","mobile","mobile child form","company" 2087,"SCORTEZ","samsung","mobile","mobile child form","company" 2089,"FGOODMAN","samsung","mobile","mobile child form","company" 2089,"FGOODMAN","Lenovo","mobile","mobile child form","company" 2090,"SRICHARDSON","MI","mobile","mobile child form","company" 2090,"SRICHARDSON","Oppo","mobile","mobile child form","company" 2091,"RPETERSON","HTC","mobile","mobile child form","company" 2092,"LPITTMAN","samsung","mobile","mobile child form","company" 2038,"HBROCK","MI","mobile","mobile child form","company" 2040,"VANDERSON","MI","mobile","mobile child form","company" 2040,"VANDERSON","Nokia","mobile","mobile child form","company" 2040,"VANDERSON","celeron","mobile","mobile child form","company" 2041,"AREYES","HTC","mobile","mobile child form","company" 2042,"ISAUNDERS","Nokia","mobile","mobile child form","company" 2042,"ISAUNDERS","micromax","mobile","mobile child form","company" 2044,"JWATERS","MI","mobile","mobile child form","company" 2044,"JWATERS","celeron","mobile","mobile child form","company" 2045,"WJOSEPH","apple","mobile","mobile child form","company" 2045,"WJOSEPH","Nokia","mobile","mobile child form","company" 2102,"VCALDWELL","generator","Badge","Badge Types","type" 2102,"VCALDWELL","reception","Badge","Badge Types","type" 2103,"LBLAKE","Access","Badge","Badge Types","type" 2105,"GOSBORNE","warehouse","Badge","Badge Types","type" 2107,"KADAMS","ACRoom","Badge","Badge Types","type" 2107,"KADAMS","Cafteria","Badge","Badge Types","type" 2047,"BBECKER","Lenovo","mobile","mobile child form","company" 2049,"CCHAVEZ","Oppo","mobile","mobile child form","company" 2050,"GHANSON","Oppo","mobile","mobile child form","company" 2052,"SWILLIS","apple","mobile","mobile child form","company" 2053,"TWILKINS","apple","mobile","mobile child form","company" 2053,"TWILKINS","samsung","mobile","mobile child form","company" 2053,"TWILKINS","micromax","mobile","mobile child form","company" 2055,"TDANIELS","samsung","mobile","mobile child form","company" 2057,"FLAMB","HTC","mobile","mobile child form","company" 2058,"SABBOTT","MI","mobile","mobile child form","company" 2059,"AQUINN","Oppo","mobile","mobile child form","company" 2063,"JNORMAN","HTC","mobile","mobile child form","company" 2063,"JNORMAN","celeron","mobile","mobile child form","company" 2065,"AMUNOZ","Lenovo","mobile","mobile child form","company" 2065,"AMUNOZ","samsung","mobile","mobile child form","company" 2066,"AWONG","HTC","mobile","mobile child form","company" 2067,"NMYERS","samsung","mobile","mobile child form","company" 2070,"RCHAMBERS","celeron","mobile","mobile child form","company" 2071,"VORTIZ","celeron","mobile","mobile child form","company" 2072,"ICALDWELL","Nokia","mobile","mobile child form","company" 2072,"ICALDWELL","Oppo","mobile","mobile child form","company" 2073,"KMYERS","micromax","mobile","mobile child form","company" 2074,"LMULLINS","Nokia","mobile","mobile child form","company" 2075,"CHOPKINS","apple","mobile","mobile child form","company" 2075,"CHOPKINS","samsung","mobile","mobile child form","company" 2076,"NRICE","Lenovo","mobile","mobile child form","company" 2076,"NRICE","HTC","mobile","mobile child form","company" 2077,"LVEGA","Oppo","mobile","mobile child form","company" 2051,"MROY","ActiveB8","activeb","activeb child form","entitlements" 2054,"CPAGE","ActiveB7","activeb","activeb child form","entitlements" 2054,"CPAGE","ActiveB10","activeb","activeb child form","entitlements" 2056,"TORTIZ","ActiveB3","activeb","activeb child form","entitlements" 2056,"TORTIZ","ActiveB9","activeb","activeb child form","entitlements" 2059,"AQUINN","ActiveB1","activeb","activeb child form","entitlements" 2059,"AQUINN","ActiveB5","activeb","activeb child form","entitlements" 2083,"NROMERO","ActiveB4","activeb","activeb child form","entitlements" 2083,"NROMERO","ActiveB8","activeb","activeb child form","entitlements" 2086,"CGREGORY","ActiveB10","activeb","activeb child form","entitlements" 2088,"SMCDONALD","ActiveB6","activeb","activeb child form","entitlements" 2090,"SRICHARDSON","ActiveB9","activeb","activeb child form","entitlements" 2092,"LPITTMAN","ActiveB8","activeb","activeb child form","entitlements" 2093,"CORTEGA","ActiveB7","activeb","activeb child form","entitlements" 2093,"CORTEGA","ActiveB10","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","ActiveB8","activeb","activeb child form","entitlements" 2062,"RROBERSON","ActiveB4","activeb","activeb child form","entitlements" 2065,"AMUNOZ","ActiveB3","activeb","activeb child form","entitlements" 2066,"AWONG","ActiveB2","activeb","activeb child form","entitlements" 2067,"NMYERS","ActiveB3","activeb","activeb child form","entitlements" 2072,"ICALDWELL","ActiveB10","activeb","activeb child form","entitlements" 2076,"NRICE","ActiveB9","activeb","activeb child form","entitlements" 2094,"NTHOMPSON","MI","mobile","mobile child form","company" 2094,"NTHOMPSON","HTC","mobile","mobile child form","company" 2095,"JFREEMAN","Nokia","mobile","mobile child form","company" 2096,"DWASHINGTON","MI","mobile","mobile child form","company" 2097,"CALEXANDER","samsung","mobile","mobile child form","company" 2099,"JMOODY","Oppo","mobile","mobile child form","company" 2100,"DELLIOTT","Nokia","mobile","mobile child form","company" 2100,"DELLIOTT","Oppo","mobile","mobile child form","company" 2103,"LBLAKE","Nokia","mobile","mobile child form","company" 2103,"LBLAKE","HTC","mobile","mobile child form","company" 2104,"JLARSON","micromax","mobile","mobile child form","company" 2105,"GOSBORNE","apple","mobile","mobile child form","company" 2038,"HBROCK","ActiveB8","activeb","activeb child form","entitlements" 2039,"EPATTON","ActiveB7","activeb","activeb child form","entitlements" 2041,"AREYES","ActiveB4","activeb","activeb child form","entitlements" 2042,"ISAUNDERS","ActiveB7","activeb","activeb child form","entitlements" 2043,"SWEBER","ActiveB4","activeb","activeb child form","entitlements" 2043,"SWEBER","ActiveB9","activeb","activeb child form","entitlements" 2045,"WJOSEPH","ActiveB9","activeb","activeb child form","entitlements" 2047,"BBECKER","ActiveB1","activeb","activeb child form","entitlements" 2047,"BBECKER","ActiveB5","activeb","activeb child form","entitlements" 2048,"BNICHOLS","ActiveB1","activeb","activeb child form","entitlements" 2049,"CCHAVEZ","ActiveB3","activeb","activeb child form","entitlements" 2050,"GHANSON","ActiveB3","activeb","activeb child form","entitlements" 2105,"GOSBORNE","ActiveB5","activeb","activeb child form","entitlements" 2106,"TMORENO","ActiveB6","activeb","activeb child form","entitlements" 2107,"KADAMS","ActiveB5","activeb","activeb child form","entitlements" 75,"MGMT_CHAIN_MGR_LVL_2","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 75,"MGMT_CHAIN_MGR_LVL_2","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 75,"MGMT_CHAIN_MGR_LVL_2","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 75,"MGMT_CHAIN_MGR_LVL_2","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 75,"MGMT_CHAIN_MGR_LVL_2","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 75,"MGMT_CHAIN_MGR_LVL_2","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 75,"MGMT_CHAIN_MGR_LVL_2","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 78,"MGMT_CHAIN_DIR_REP_1_LVL_2","Lenovo","LapTop","LapTop child form","model" 78,"MGMT_CHAIN_DIR_REP_1_LVL_2","Asus","LapTop","LapTop child form","model" 78,"MGMT_CHAIN_DIR_REP_1_LVL_2","Zenith","LapTop","LapTop child form","model" 78,"MGMT_CHAIN_DIR_REP_1_LVL_2","DELL","LapTop","LapTop child form","model" 78,"MGMT_CHAIN_DIR_REP_1_LVL_2","MI","LapTop","LapTop child form","model" 78,"MGMT_CHAIN_DIR_REP_1_LVL_2","HCL","LapTop","LapTop child form","model" 81,"MGMT_CHAIN_DIR_REP_4_LVL_2","Mac","LapTop","LapTop child form","model" 81,"MGMT_CHAIN_DIR_REP_4_LVL_2","MI","LapTop","LapTop child form","model" 81,"MGMT_CHAIN_DIR_REP_4_LVL_2","Compaq","LapTop","LapTop child form","model" 81,"MGMT_CHAIN_DIR_REP_4_LVL_2","Zenith","LapTop","LapTop child form","model" 80,"MGMT_CHAIN_DIR_REP_3_LVL_2","ActiveB2","activeb","activeb child form","entitlements" 80,"MGMT_CHAIN_DIR_REP_3_LVL_2","ACRoom","Badge","Badge Types","type" 80,"MGMT_CHAIN_DIR_REP_3_LVL_2","generator","Badge","Badge Types","type" 80,"MGMT_CHAIN_DIR_REP_3_LVL_2","reception","Badge","Badge Types","type" 80,"MGMT_CHAIN_DIR_REP_3_LVL_2","Oppo","mobile","mobile child form","company" 80,"MGMT_CHAIN_DIR_REP_3_LVL_2","ActiveB8","activeb","activeb child form","entitlements" 80,"MGMT_CHAIN_DIR_REP_3_LVL_2","ActiveB9","activeb","activeb child form","entitlements" 80,"MGMT_CHAIN_DIR_REP_3_LVL_2","ActiveB3","activeb","activeb child form","entitlements" 80,"MGMT_CHAIN_DIR_REP_3_LVL_2","ActiveB6","activeb","activeb child form","entitlements" 79,"MGMT_CHAIN_DIR_REP_2_LVL_2","Access","Badge","Badge Types","type" 79,"MGMT_CHAIN_DIR_REP_2_LVL_2","Printer","Badge","Badge Types","type" 79,"MGMT_CHAIN_DIR_REP_2_LVL_2","Conference","Badge","Badge Types","type" 79,"MGMT_CHAIN_DIR_REP_2_LVL_2","ActiveB4","activeb","activeb child form","entitlements" 79,"MGMT_CHAIN_DIR_REP_2_LVL_2","Store","Badge","Badge Types","type" 79,"MGMT_CHAIN_DIR_REP_2_LVL_2","Cafteria","Badge","Badge Types","type" 79,"MGMT_CHAIN_DIR_REP_2_LVL_2","ActiveB5","activeb","activeb child form","entitlements" 79,"MGMT_CHAIN_DIR_REP_2_LVL_2","ActiveB8","activeb","activeb child form","entitlements"
3.3.3.6 Sample roles.csv File
The following table lists the mandatory and optional role attributes for data import from flat files.
| OIRI Attribute | Mandatory/Optional |
|---|---|
| EXT_ROLE_ID | Optional |
| NAME | Mandatory |
| DISPLAY_NAME | Optional |
| DESCRIPTION | Optional |
| RISK_SCORE | Optional |
The following is a sample roles.csv file:
"EXT_ROLE_ID","NAME","DISPLAY_NAME","DESCRIPTION","RISK_SCORE" 8,"Fraud Analyst","Fraud Analyst","",5 10,"Fraud Supervisor","Fraud Supervisor","",7 11,"Chargeback Supervisor","Chargeback Supervisor","",7 13,"Bankcard Services Analyst","Bankcard Services Analyst","",5 14,"Customer Service Supervisor - Midwest","Customer Service Supervisor - Midwest","",5 15,"Customer Service Analyst - Midwest","Customer Service Analyst - Midwest","",3 16,"Customer Service Analyst - West Coast","Customer Service Analyst - West Coast","",3 18,"Item Analyst","Item Analyst","",3 20,"AP Expense Approver","AP Expense Approver","",5 17,"External Auditor","External Auditor","",7 19,"Retail Buyer","Retail Buyer","",3 21,"AP Merchandise Vendor Approver","AP Merchandise Vendor Approver","",5 9,"Customer Service Supervisor - West Coast","Customer Service Supervisor - West Coast","",5 12,"Bankcard Services Lead","Bankcard Services Lead","",5 61,"Candidate Role 4","Candidate Role 4","Candidate Role 4",3 62,"test rule","test rule","",3 63,"Candidate Role 3","Candidate Role 3","Candidate Role 3",3 81,"Candidate Role 1","Candidate Role 1","Candidate Role 1",3 82,"Candidate Role 7","Candidate Role 7","Candidate Role 7",3 22,"aCertRole1","aCertRole1","Description for role aCertRole1",3 23,"aCertRole2","aCertRole2","Description for role aCertRole2",3 24,"aCertRole3","aCertRole3","Description for role aCertRole3",3 25,"aCertRole4","aCertRole4","Description for role aCertRole4",3 26,"aCertRole5","aCertRole5","Description for role aCertRole5",3 27,"aCertRole6","aCertRole6","Description for role aCertRole6",3 28,"vCertRole1","vCertRole1","Description for role vCertRole1",3 29,"vCertRole2","vCertRole2","Description for role vCertRole2",3 30,"vCertRole3","vCertRole3","Description for role vCertRole3",3 31,"vCertRole4","vCertRole4","Description for role vCertRole4",3 32,"vCertRole5","vCertRole5","Description for role vCertRole5",3 33,"vCertRole6","vCertRole6","Description for role vCertRole6",3 34,"vCertRole7","vCertRole7","Description for role vCertRole7",3 35,"vCertRole8","vCertRole8","Description for role vCertRole8",3 36,"vCertRole9","vCertRole9","Description for role vCertRole9",3 37,"vCertRole10","vCertRole10","Description for role vCertRole10",3 38,"vCertRole11","vCertRole11","Description for role vCertRole11",3 39,"vCertRole12","vCertRole12","Description for role vCertRole12",3 40,"vCertRole13","vCertRole13","Description for role vCertRole13",3 41,"vCertRole14","vCertRole14","Description for role vCertRole14",3 42,"vCertRole15","vCertRole15","Description for role vCertRole15",3 43,"vCertRole16","vCertRole16","Description for role vCertRole16",3 44,"vCertRole17","vCertRole17","Description for role vCertRole17",3 45,"vCertRole18","vCertRole18","Description for role vCertRole18",3 46,"vCertRole19","vCertRole19","Description for role vCertRole19",3 47,"vCertRole20","vCertRole20","Description for role vCertRole20",3 48,"vCertRole21","vCertRole21","Description for role vCertRole21",3 49,"vCertRole22","vCertRole22","Description for role vCertRole22",3
3.3.3.7 Sample roleHierarchy.csv File
The following table lists the mandatory and optional roleHierarchy attributes for data import from flat files.
| OIRI Attribute | Mandatory/Optional |
|---|---|
| ROLE_NAME | Mandatory |
| NESTED_ROLE_NAME | Mandatory |
The following is a sample roleHierarchy.csv file:
ROLE_NAME,NESTED_ROLE_NAME aCertRole2,Fraud Analyst aCertRole1,Fraud Analyst aCertRole3,vCertRole16 aCertRole6,aCertRole3 aCertRole5,vCertRole16 aCertRole2,vCertRole10 Fraud Analyst,Item Analyst Item Analyst,aCertRole6 vCertRole16,vCertRole10 vCertRole16,vCertRole17
3.3.3.8 Sample roleUserMembership.csv File
The following table lists the mandatory and optional roleUserMembership attributes for data import from flat files.
| OIRI Attribute | Mandatory/Optional |
|---|---|
| EXT_ROLE_ID | Optional |
| ROLE_NAME | Mandatory |
| USER_NAME | Mandatory |
The following is a sample roleUserMembership.csv file:
"EXT_ROLE_ID","ROLE_NAME","USER_NAME" 23,"aCertRole2","ACERTUSER1" 22,"aCertRole1","ACERTUSER1" 25,"aCertRole4","ACERTUSER2" 24,"aCertRole3","ACERTUSER2" 27,"aCertRole6","ACERTUSER3" 26,"aCertRole5","ACERTUSER3" 81,"Candidate Role 1","VCERTUSER1" 29,"vCertRole2","VCERTUSER1" 28,"vCertRole1","VCERTUSER1" 81,"Candidate Role 1","VCERTUSER2" 31,"vCertRole4","VCERTUSER2" 30,"vCertRole3","VCERTUSER2" 81,"Candidate Role 1","VCERTUSER3" 33,"vCertRole6","VCERTUSER3" 32,"vCertRole5","VCERTUSER3" 81,"Candidate Role 1","VCERTUSER4" 35,"vCertRole8","VCERTUSER4" 34,"vCertRole7","VCERTUSER4" 81,"Candidate Role 1","VCERTUSER5" 37,"vCertRole10","VCERTUSER5" 36,"vCertRole9","VCERTUSER5" 81,"Candidate Role 1","VCERTUSER6" 39,"vCertRole12","VCERTUSER6" 38,"vCertRole11","VCERTUSER6" 81,"Candidate Role 1","VCERTUSER7" 41,"vCertRole14","VCERTUSER7" 40,"vCertRole13","VCERTUSER7" 81,"Candidate Role 1","VCERTUSER8" 43,"vCertRole16","VCERTUSER8" 42,"vCertRole15","VCERTUSER8" 81,"Candidate Role 1","VCERTUSER9" 45,"vCertRole18","VCERTUSER9" 44,"vCertRole17","VCERTUSER9" 81,"Candidate Role 1","VCERTUSER10" 47,"vCertRole20","VCERTUSER10" 46,"vCertRole19","VCERTUSER10" 81,"Candidate Role 1","VCERTUSER11" 49,"vCertRole22","VCERTUSER11" 48,"vCertRole21","VCERTUSER11" 63,"Candidate Role 3","KPOOLE" 63,"Candidate Role 3","CMCKINNEY" 63,"Candidate Role 3","SKELLER" 61,"Candidate Role 4","HBROCK" 82,"Candidate Role 7","EPATTON" 82,"Candidate Role 7","AREYES" 82,"Candidate Role 7","SWEBER" 82,"Candidate Role 7","WJOSEPH" 82,"Candidate Role 7","BBECKER" 61,"Candidate Role 4","BNICHOLS" 82,"Candidate Role 7","CCHAVEZ" 82,"Candidate Role 7","MROY" 82,"Candidate Role 7","TWILKINS" 82,"Candidate Role 7","TDANIELS" 82,"Candidate Role 7","FLAMB" 61,"Candidate Role 4","SABBOTT" 82,"Candidate Role 7","AQUINN" 82,"Candidate Role 7","JNORMAN" 82,"Candidate Role 7","AMUNOZ" 82,"Candidate Role 7","NMYERS" 82,"Candidate Role 7","BBARBER" 82,"Candidate Role 7","VORTIZ" 82,"Candidate Role 7","KMYERS" 82,"Candidate Role 7","CHOPKINS" 82,"Candidate Role 7","LVEGA" 61,"Candidate Role 4","MBAKER" 82,"Candidate Role 7","OGONZALES" 82,"Candidate Role 7","GABBOTT" 82,"Candidate Role 7","NROMERO" 82,"Candidate Role 7","TMALDONADO" 82,"Candidate Role 7","SCORTEZ" 61,"Candidate Role 4","SMCDONALD" 82,"Candidate Role 7","FGOODMAN" 82,"Candidate Role 7","RPETERSON" 82,"Candidate Role 7","CORTEGA" 82,"Candidate Role 7","JFREEMAN" 82,"Candidate Role 7","CALEXANDER" 61,"Candidate Role 4","PBARTON" 82,"Candidate Role 7","JMOODY" 82,"Candidate Role 7","DFOWLER" 82,"Candidate Role 7","LBLAKE" 82,"Candidate Role 7","GOSBORNE" 82,"Candidate Role 7","KADAMS"
3.3.3.9 Sample roleEntitlementComposition.csv File
The following table lists the mandatory and optional roleEntitlementComposition attributes for data import from flat files.
| OIRI Attribute | Mandatory/Optional |
|---|---|
| EXT_ROLE_ID | Optional |
| ROLE_NAME | Mandatory |
| ENTITLEMENT_NAME | Mandatory |
| APPLICATION_NAME | Mandatory |
| GRANTEE_TYPE | Mandatory |
| GRANTEE_NAME | Mandatory |
The following is a sample roleEntitlementComposition.csv file:
"EXT_ROLE_ID","ROLE_NAME","ENTITLEMENT_NAME","APPLICATION_NAME","GRANTEE_TYPE","GRANTEE_NAME" 46,"vCertRole19","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 28,"vCertRole1","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 28,"vCertRole1","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 46,"vCertRole19","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 81,"Candidate Role 1","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 44,"vCertRole17","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 41,"vCertRole14","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 37,"vCertRole10","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 46,"vCertRole19","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 42,"vCertRole15","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 41,"vCertRole14","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 40,"vCertRole13","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 81,"Candidate Role 1","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 42,"vCertRole15","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 41,"vCertRole14","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 40,"vCertRole13","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 39,"vCertRole12","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 38,"vCertRole11","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 38,"vCertRole11","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 37,"vCertRole10","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 28,"vCertRole1","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 45,"vCertRole18","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 42,"vCertRole15","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 40,"vCertRole13","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 45,"vCertRole18","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 43,"vCertRole16","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 41,"vCertRole14","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 45,"vCertRole18","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 43,"vCertRole16","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 38,"vCertRole11","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 46,"vCertRole19","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 43,"vCertRole16","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 28,"vCertRole1","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 81,"Candidate Role 1","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 46,"vCertRole19","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 45,"vCertRole18","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 43,"vCertRole16","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 43,"vCertRole16","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 42,"vCertRole15","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 38,"vCertRole11","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 38,"vCertRole11","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 37,"vCertRole10","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 28,"vCertRole1","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 42,"vCertRole15","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 42,"vCertRole15","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 41,"vCertRole14","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 40,"vCertRole13","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 39,"vCertRole12","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 41,"vCertRole14","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 45,"vCertRole18","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 42,"vCertRole15","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 40,"vCertRole13","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 39,"vCertRole12","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 81,"Candidate Role 1","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 46,"vCertRole19","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 40,"vCertRole13","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 39,"vCertRole12","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 28,"vCertRole1","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 45,"vCertRole18","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 42,"vCertRole15","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 39,"vCertRole12","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 38,"vCertRole11","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 38,"vCertRole11","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 38,"vCertRole11","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 44,"vCertRole17","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 40,"vCertRole13","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 81,"Candidate Role 1","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 44,"vCertRole17","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 43,"vCertRole16","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 37,"vCertRole10","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 46,"vCertRole19","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 46,"vCertRole19","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 43,"vCertRole16","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 40,"vCertRole13","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 39,"vCertRole12","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 37,"vCertRole10","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 28,"vCertRole1","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 44,"vCertRole17","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 39,"vCertRole12","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 38,"vCertRole11","EntTestDB~CN=VISDU31,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 37,"vCertRole10","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 37,"vCertRole10","EntTestDB~CN=VISDU33,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 46,"vCertRole19","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 45,"vCertRole18","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 44,"vCertRole17","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 41,"vCertRole14","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 81,"Candidate Role 1","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 45,"vCertRole18","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 44,"vCertRole17","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 44,"vCertRole17","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 42,"vCertRole15","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 41,"vCertRole14","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 40,"vCertRole13","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 44,"vCertRole17","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 41,"vCertRole14","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 39,"vCertRole12","EntTestDB~CN=VISDU32,DC=abc,DC=com","VISDU3","VISDU3 child form","VISDU3 lookup" 45,"vCertRole18","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 44,"vCertRole17","EntTestDB~CN=VISDU12,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 43,"vCertRole16","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 37,"vCertRole10","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 28,"vCertRole1","EntTestDB~CN=VISDU13,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 81,"Candidate Role 1","EntTestDB~CN=VISDU11,DC=abc,DC=com","VISDU1","VISDU1 child form","VISDU1 lookup" 43,"vCertRole16","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 39,"vCertRole12","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 37,"vCertRole10","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 28,"vCertRole1","EntTestDB~CN=VISDU23,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 81,"Candidate Role 1","EntTestDB~CN=VISDU22,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup" 81,"Candidate Role 1","EntTestDB~CN=VISDU21,DC=abc,DC=com","VISDU2","VISDU2 child form","VISDU2 lookup"
3.4 Arguments of the updateDataIngestionConfig.sh Script
Arguments of the updateDataIngestionConfig.sh Script lists the parameters that you can update by running the
updateDataIngestionConfig.sh script.
Table 3-1 Arguments of the updateDataIngestionConfig.sh Command
| Short argument | Option | Description |
|---|---|---|
| -eacbs | --entityaccountsbatchsize | Entity accounts batch size. |
| -eace | --entityaccountsenabled | Determines whether the entity will be
enabled/disabled during data import. Default value is
true.
|
| -eaclb | --entityaccountsslowerbound | The minimum value of partitionColumn
used to decide partition stride. Default value is
0.
|
| -eacnop | --entityaccountsnumberofpartitions | The number of partitions, This, along with
lowerBound (inclusive),
upperBound (exclusive), form partition strides
for generated WHERE clause expressions used to split the column
partitionColumn evenly. Default value is
3.
|
| -eacsm | --entityaccountssyncmode | For Day 0, full mode is used. For Day N, incremental mode is used. In full mode, all the data is loaded in OIRI database, but for incremental mode, the delta data is fetched from the source and updated/inserted accordingly. Default value is full. |
| -eacub | --entityaccountsupperbound | The maximum value of partitionColumn used to decide partition stride. Default value is 10000. |
| -eabs | --entityapplicationsbatchsize | Entity applications batch size |
| -eae | --entityapplicationsenabled | Determines whether the entity will be enabled/disabled during data import. Default value is true. |
| -eaebs | --entityassignedentitlementsbatchsize | Entity assigned entitlements batch size |
| -eaee | --entityassignedentitlementsenabled | Determines whether the entity will be enabled/disabled during data import. Default value is true. |
| -eaelb | --entityassignedentitlementslowerbound | The minimum value of partitionColumn used to decide partition stride. Default value is 0. |
| -eaenop | --entityassignedentitlementsnumberofpartitions | The number of partitions, This, along with lowerBound (inclusive) and upperBound (exclusive), form partition strides for the generated WHERE clause expressions used to split the column partitionColumn evenly. Default value is 3. |
| -eaesm | --entityassignedentitlementssyncmode | Incremental is used. In full mode, all the data is fetched and loaded in OIRI database. For incremental mode, only the delta data is fetched from the source and updated/inserted accordingly. |
| -eaeub | --entityassignedentitlementssupperbound | The maximum value of partitionColumn used to decide partition stride. Default value is 10000. |
| -ealb | --entityapplicationslowerbound | The minimum value of partitionColumn used to decide partition stride. Default value is 0. |
| -eanop | --entityapplicationsnumberofpartitions | The number of partitions, This, along with lowerBound (inclusive) and upperBound (exclusive), form partition strides for the generated WHERE clause expressions used to split the column partitionColumn evenly. Default value is 3. |
| -easm | --entityapplicationssyncmode | For Day 0, full mode is used. For Day N, incremental mode is used. In full mode, all the data is fetched and loaded in OIRI database. For incremental mode, only the delta data is fetched from the source and updated/inserted accordingly. |
| -eaub | --entityapplicationsupperbound | The maximum value of partitionColumn used to decide partition stride. Default value is 10000. |
| -eebs | --entityentitlementsbatchsize | Entity entitlements batch size |
| -eee | --entityentitlementsenabled | Determines whether the entity will be enabled/disabled during data import. Default value is true. |
| -eelb | --entityentitlementslowerbound | The minimum value of partitionColumn used to decide partition stride. Default value is 0. |
| -eenop | --entityentitlementsnumberofpartitions | The number of partitions, This, along with lowerBound (inclusive) and upperBound (exclusive), form partition strides for the generated WHERE clause expressions used to split the column partitionColumn evenly. Default value is 3. |
| -eesm | --entityentitlementssyncmode | For Day 0, full mode is used. For Day N, incremental mode is used. In full mode, all the data is fetched and loaded in OIRI database. For incremental mode, only the delta data is fetched from the source and updated/inserted accordingly. Default value is full. |
| -eeub | --entityentitlementsupperbound | The maximum value of partitionColumn used to decide partition stride. Default value is 10000. |
| -erbs | --entityrolesbatchsize | Entity roles batch size |
| -ere | --entityrolessenabled | Determines whether the entity will be enabled/disabled during ETL. Default value is true. |
| -erecbs | --entityroleentitlementcompositionsbatchsize | Entity role entitlement compositions batch size |
| -erece | --entityroleentitlementcompositionsenabled | Determines whether the entity will be enabled/disabled during ETL. Default value is true. |
| -ereclb | --entityroleentitlementcompositionslowerbound | The minimum value of partitionColumn used to decide partition stride. Default value is 0. |
| -erecnop | --entityroleentitlementcompositionsnumberofpartitions | The number of partitions, This, along with lowerBound (inclusive) and upperBound (exclusive), form partition strides for the generated WHERE clause expressions used to split the column partitionColumn evenly. Default value is 3. |
| -erecsm | --entityroleentitlementcompositionssyncmode | For Day 0, full mode is used. For Day N, incremental mode is used. In full mode, all the data is fetched and loaded in OIRI database. For incremental mode, only the delta data is fetched from the source and updated/inserted accordingly. Default value is full. |
| -erecub | --entityroleentitlementcompositionsupperbound | The maximum value of partitionColumn used to decide partition stride. Default value is 10000. |
| -erhbs | --entityrolehierarchybatchsize | Entity role hierarchy batch size. |
| -erhe | --entityrolehierarchyenabled | Determines whether the entity will be enabled/disabled during ETL. Default value is true. |
| -erhnop | --entityrolehierarchynumberofpartitions | The number of partitions, This, along with lowerBound (inclusive) and upperBound (exclusive), form partition strides for the generated WHERE clause expressions used to split the column partitionColumn evenly. Default value is 3. |
| -erhsm | --entityrolehierarchysyncmode | For Day 0, full mode is used. For Day N, incremental mode is used. In full mode, all the data is fetched and loaded in OIRI database. For incremental mode, only the delta data is fetched from the source and updated/inserted accordingly. |
| -erlb | --entityroleslowerbound | The minimum value of partitionColumn used to decide partition stride. Default value is 0. |
| -ernop | --entityrolesnumberofpartitions | The number of partitions, This, along with lowerBound (inclusive) and upperBound (exclusive), form partition strides for the generated WHERE clause expressions used to split the column partitionColumn evenly. Default value is 3. |
| -ersm | --entityrolessyncmode | For Day 0, full mode is used. For Day N, incremental mode is used. In full mode, all the data is fetched and loaded in OIRI database. For incremental mode, only the delta data is fetched from the source and updated/inserted accordingly. |
| -erub | --entityrolesupperbound | The maximum value of partitionColumn used to decide partition stride. Default value is 10000. |
| -erumbs | --entityroleusermembershipsbatchsize | Entity role user memberships batch size |
| -erume | --entityroleusermembershipssenabled | Determines whether the entity will be enabled/disabled during ETL. Default value is true. |
| -erumlb | --entityroleusermembershipsowerbound | The minimum value of partitionColumn used to decide partition stride. Default value is 0. |
| -erumnop | --entityroleusermembershipsnumberofpartitions | The number of partitions, This, along with lowerBound (inclusive) and upperBound (exclusive), form partition strides for the generated WHERE clause expressions used to split the column partitionColumn evenly. Default value is 3. |
| -erumsm | --entityroleusermembershipssyncmode | For Day 0, full mode is used. For Day N, incremental mode is used. In full mode, all the data is fetched and loaded in OIRI database. For incremental mode, only the delta data is fetched from the source and updated/inserted accordingly. Default value is full. |
| -erumub | --entityroleusermembershipsupperbound | The maximum value of partitionColumn used to decide partition stride. Default value is 10000. |
| -eubs | --entityusersbatchsize | Entity user batch size |
| -eue | --entityusersenabled | Determines whether the entity will be enabled/disabled during ETL. Default value is true. |
| -eulb | --entityuserslowerbound | The minimum value of partitionColumn used to decide partition stride. Default value is 0. |
| -eunop | --entityusersnumberofpartitions | The number of partitions, This, along with lowerBound (inclusive) and upperBound (exclusive), form partition strides for the generated WHERE clause expressions used to split the column partitionColumn evenly. Default value is 3. |
| -eusm | --entityuserssyncmode | For Day 0, full mode is used. For Day N, incremental mode is used. In full mode, all the data is fetched and loaded in OIRI database. For incremental mode, only the delta data is fetched from the source and updated/inserted accordingly. Default value is full. |
| -euub | --entityusersupperbound | The maximum value of partitionColumn used to decide partition stride. Default value is 10000. |
| -fff | --flatfileformat | Format of the flat file. Default value is csv. |
| -ffs | --flatfileseparator | Data Separator in the rows of the flat files. It can be , : or |. Default value is ,. |
| -fftsf | --flatfiletimestampformat | TimeStamp format. Default value is yyyy-MM-dd. |
| -kcfn | --k8scertificatefilename | Name of the Kubernetes Certificate to be used for securely communicating with the K8S API Server. |
| -oigdbh | --oigdbhost | Host name of OIG database. |
| -oigdbp | --oigdbport | Port of OIG database. |
| -oigdbs | --oigdbsname | Service name of OIG Database. |
| d-uff | --useflatfileforetl | Use flat file as the data import source. Value is true or false. |
| -uoigdb | --useoigdbforetl | Use OIG database as the data import source. Value is true or false. |
3.5 Arguments of the updateConfig.sh Script
Arguments of the updateConfig.sh Script lists the parameters that you can update by running the
updateConfig.sh script.
Table 3-2 Arguments of the updateConfig.sh Script
| Short Argument | Argument | Description |
|---|---|---|
| ap | --authprovider | Authentication provider. Supported value is OIG. |
| ar | --authroles | Comma-separated roles required for authentication with OIG. |
| ata | --accesstokenaudience | OIRI access token audience |
| atacs | --accesstokenallowedclockskew | OIRI access token allowed clock skew in seconds |
| atet | --accesstokenexpirationtime | OIRI access token expiration time in minutes |
| ati | --accesstokenissuer | OIRI access token issuer |
| cd | --cookiedomain | OIRI cookie domain |
| csf | --cookiesecureflag | OIRI cookie secure flag |
| css | --cookiesamesite | OIRI cookie same site |
| di | --dingimage | Data Ingestion Image name:tag |
| dlc | --driverlimitcores | Hard CPU limit for the driver pod |
| dm | --drivermemory | Amount of memory to use for the driver process where SparkContext is initialized in the same format as JVM memory strings with a size unit suffix (k, m, g or t). For example, 512m,2g. |
| dmo | --drivermemoryoverhead | Amount of non-heap memory to be allocated per driver process in cluster mode in MiB unless otherwise specified. It accounts for VM overheads, interned strings, and so on. This tends to grow with the container size (typically 6-10%). |
| dns | --dingnamespace | Namespace for the spark driver and executor pods for data import jobs. |
| drc | --driverrequestcores | Specify the CPU request for each driver pod. Values conform to the K8S convention. Sample values are 0.1, 500m, 1.5, and 5. |
| elc | --executorlimitcores | Hard CPU limit for each executor pod launched for the Spark application. |
| em | --executormemory | Amount of memory to use per executor process in the same format as JVM memory strings with a size unit suffix (k, m, g or t). For example, 512m,2g. |
| emo | --executormemoryoverhead | Amount of additional memory to be allocated per executor process in cluster mode, in MiB unless otherwise specified. It accounts for VM overheads, interned strings, and so on. This tends to grow with the executor size (typically 6-10%). |
| erc | --executorrequestcores | Specify the CPU request for each executor pod. Values conform to the K8S convention. Sample values are 0.1, 500m, 1.5, and 5. |
| ips | --imagepullsecret | Kubernetes secret name to pull the ding image from the registry. |
| ist | --idlesessiontimeout | OIRI Idle Session Timeout in minutes. |
| ksn | --keystorename | File name of the keystore containing the OIRI keys. |
| noe | --numberofexecutors | Number of executor instances to be run in the Kubernetes cluster to complete a data import job. |
| oigati | --oigaccesstokenissuer | OIG access token issuer. |
| oigcpmx | --oigconnectionpoolmax | OIG maximum number of connections in the pool. |
| oigcpmr | --oigconnectionpoolmaxroute | OIG maximum number of connections per route. |
| oigct | --oigconnectiontimeout | OIG connection timeout interval in milliseconds. |
| oigkat | --oigkeepalivetimeout | OIG keep alive timeout (in seconds) is used in keep alive strategy. This strategy will first try to apply the host's Keep-Alive Policy stated in the header. If that information is not present in the response header, it will keep alive connections for the period of keepAliveTimeout. |
| oigpp | --oigproxypassword | OIG proxy password. |
| oigpuri | --oigproxyuri | OIG proxy URI. |
| oigpu | --oigproxyusername | OIG proxy username |
| oigrt | --oigreadtimeout | OIG Read timeout interval in milliseconds. |
| oigsu | --oigserverurl | OIG server URL |
| oiridbh | --oiridbhost | Host name of OIRI database |
| oiridbp | --oiridbport | Port of OIRI database |
| oiridbs | --oiridbsname | Service name of OIRI database |
| sele | --sparkeventlogsenabled | true/false to enable/disable Spark event logs |
| st | --sessiontimeout | OIRI session timeout in minutes |
| skmu | --sparkk8smasterurl | URL of Kubernetes API server in the format: k8s://https://{K8S_API_SERVER_URL} |
3.6 Importing Data from OIG Database and Flat Files
You can import entity data from OIG database and flat files at the same time. This topic describes the Day 0 and Day N configurations for importing data from both the sources.
Day 0 Configuration
For Day 0 configuration, you can specify the data import to be in full mode for both
the sources. For example, to configure importing user and application data in full
mode from both OIG database and flat files, run the
updateDataIngestionConfig.sh command with the following
arguments:
$ ./updateDataIngestionConfig.sh --useoigdbforetl true --entityusersenabled true --entityuserssyncmode full --entityapplicationsenabled true --entityapplicationssyncmode full --useflatfileforetl true
When you run the data import process, OIRI first imports the data from OIG database in full mode by truncating the existing data in the OIRI database. Then, the data is imported from flat files without truncating the data that has been loaded from OIG database. If there is the same user or application record in the flat files, then those records from the flat files do not replace the records in the OIRI database, but updates them.
Day N Configuration
For Day N configuration, you can specify the data import to be in incremental mode
for both the sources. For example, to configure importing user and application data
in incremental mode from both OIG database and flat files, run the
updateDataIngestionConfig.sh command with the following
arguments:
$ ./updateDataIngestionConfig.sh --useoigdbforetl true --entityusersenabled true --entityuserssyncmode incremental --entityapplicationsenabled true --entityapplicationssyncmode incremental --useflatfileforetl true
When you run the data import process, OIRI first updates the existing data in the OIRI database from the OIG database, and then updates the data from the flat files.
3.7 Importing Custom Attributes to OIRI Database
OIRI supports managing custom attributes for the user entity along with the default attributes. You can populate the custom attribute values by using OIRI data ingestion service (data import) for using them in role mining operations.
Note:
See Attribute Mapping of Entities for information about the default attributes of the user entity, which are fetched from a specified data source and saved in OIRI database table during data import, and their mapping with OIG user attributes.
In addition to the default attributes, you can add a maximum of 40
custom attributes to OIRI, out of which, 20 can be of string data
type, 10 can be of number data type, and 10 can be of
date data type.
This section contains the following topics:
3.7.2 Custom Attributes Definition
Table 3-3 lists the parameters for the custom attributes definition.
Table 3-3 Parameters for Custom Attributes Definition
| Parameter | Mandatory | Sample Value | Description |
|---|---|---|---|
|
entityType |
Yes |
user |
The entity type of the custom attribute. OIRI supports importing custom attributes only of the user entity type. |
|
attributeName |
Yes |
USER_STATUS |
The name of the custom attribute. OIRI supports a maximum length of 20 characters. All characters must be in upper case. The value must be alpha numeric and must start with a letter. The only allowed special character is under score (_). |
|
displayName |
Yes |
User Status |
The display name of the custom attribute. OIRI supports a maximum length of 100 characters. |
|
dataType |
Yes |
String |
The data type of the custom attribute. OIRI supports string, number, and date data types. The value must match the literalsstring,
number, or date.
|
|
searchable |
Yes |
true |
Whether or not the attribute is shown in the user filter operation. |
|
displayable |
Yes |
true |
Whether or not the attribute is returned by user search operation. |
|
required |
Yes |
false |
Whether or not null value is allowed. OIRI supports only false as the value of this parameter, which means that null value cannot be specified. |
|
indexed |
Yes |
false |
Whether or not the attribute can be indexed. OIRI supports only false as the value of this parameter, which means that the attribute cannot be indexed. |
|
uniqueness |
Yes |
false |
Whether or not duplicate value is allowed. OIRI supports only false as the value of this parameter, which means that duplicate values of the attribute is allowed. |
|
caseExact |
Yes |
false |
Whether or not case is ignored for user filter operation. |
|
supportAnalytics |
No |
false |
Whether or not the attribute is allowed for analytics. |
|
userMembershipRule |
Yes |
true|false |
Whether or not the attribute is allowed for userMembershipRule generation. |
|
oigAttributeName |
Yes |
Status |
OIG attribute name that will be used in the user membership rule. |
|
oigTableColumnName |
Yes for OIG as the data source |
usr.USER_STATUS |
For OIG database as the data source, this is the SQL
select clause used for this column. OIRI supports only the USER
table with table alias value as |
|
csvHeaderColumnOrder |
Yes for flat files as the data source |
1 |
For flat files in CSV format as the data source, this is the position of the attribute in the CSV custom attributes column list. Custom attribute columns must be added to the end of default attributes. For example, when the header is: “EXT_USER_ID”, “USER_NAME”, ... , “MANAGER_NAME”, “RISK_SCORE”, "USER_STATUS", "PROVISIONED_DATE", "LOCKOUT_DURATION" The value 1 for this parameter indicates the USER_STATUS custom attribute. |
|
oiriTableColumnName |
Yes |
CUST_ATTR_VC_1 |
The fixed column name of the target OIRI database table where the custom attribute will be populated. You must use the following columns for the supported data types:
|
3.7.3 Parameters of the custom-attributes.yaml File
The following is the contents of a sample custom-attributes.yaml
file.
## Oracle Identity Intelligence - Data Ingestion Service - Custom Attributes version: 1.0 walletDirectory: __DING__WALLET__DIRECTORY__ databaseConfiguration: url: jdbc:oracle:thin:@__OIRI__DB__HOSTNAME__:__OIRI__DB__HOSTPORT__/__OIRI__DB__SERVICENAME__ driver: oracle.jdbc.driver.OracleDriver queryTimeout: 300 fetchSize: 50 customAttributesMetadataFilePath: /app/data/metadata/customattributes/custom-attributes-metadata.yaml
Table 3-4 lists the parameters of the custom-attributes.yaml file.
Table 3-4 Parameters of the custom-attributes.yaml File
| Parameter | Description |
|---|---|
| walletDirectory | The name of the wallet directory. |
| url | The OIRI database URL. |
| driver | The JDBC driver. |
| queryTimeout | The query timeout value in seconds. |
| fetchSize | The number of records to be fetched. |
| customAttributesMetadataFilePath | The path to the custom-attributes-metadata.yaml
file, which is the custom attributes schema definition file.
|
3.8 Running the Data Import Dry Run Process
Before data import (or data ingestion), perform a dry run to validate if the data fits into the OIRI database. This will fetch data from the source, such as Oracle Identity Governance database or flat files, and validate it against the metadata of the OIRI database. For example, in OIRI database, the user name cannot be more than 50 characters, or duplicate data will not be populated in OIRI.
To run the data import dry run process:
3.10 Running the Data Import Process
After reviewing the dry run summary and fixing all errors, perform the
following steps to run the data import process:
3.11 Deleting Imported Entity Data
To delete data from the OIRI database:
-
List the data to be deleted in a file by running the following command:
ding-cli --config=/app/data/conf/config.yaml data-ingestion list-data-to-be-deleted /app/data/conf/data-ingestion-config.yaml
When the source of the data is OIG database, running this command identifies the data deleted form OIG but is still present in OIRI database. This is done by comparing both the databases. Then, this command lists the data to be deleted for each entity in a generated
oig_list_data_to_be_deleted.propertiesfile. Click here to see a sample file.The
list-data-to-be-deletedutility lists the data to be deleted for the following OIG source entities in theoig_list_data_to_be_deleted.propertiesfile:-
Users: Fetches all the users having
usr_statusasDeletedfrom OIG, checks the OIRI database, and lists the users to be deleted from OIRI users table. -
Applications: Fetches all the applications data from OIG having
app_instance_is_soft_delete = 1, checks the OIRI database, and lists the applications to be deleted from OIRI applications table. -
Accounts: Fetches all the accounts data from OIG and OIRI, and lists the accounts data to be deleted from the OIRI accounts table.
-
Entitlements: Fetches all the entitlements data from OIG and OIRI, and lists the entitlements data to be deleted from the OIRI entitlements table.
-
Roles: Fetches all the roles data from OIG and OIRI, and lists the roles data to be deleted from the OIRI roles table.
-
RoleHierarchy: Fetches all the role hierarchy data from OIG and OIRI, and lists the role hierarchy data to be deleted.
-
AssignedEntitlements: Fetches all the assignedEntitlements data from OIG and OIRI, and lists the entitlements that have not been assigned to any user in OIG.
-
RoleUserMembership: Fetches all the roleUserMembership data from OIG and OIRI, and lists the roles data that have not been assigned to any user in OIG.
-
RoleEntitlementComposition: Fetches all the roleEntitlementComposition data from OIG and OIRI,and lists the roles data that have not been linked with any entitlement.
When the source of the data is flat files, the
list-data-to-be-deletedutility cannot be used because there is no consolidated list of records. Manually specify the records for each entity that are to be deleted in thefile_list_data_to_be_deleted.propertiesfile. Click here to see a sample file.Note:
The location of the properties files is determined by the following parameters in the
data-ingestion-config.yamlfile:-
For data from OIG:
toBeDeletedOigDataDirectory: <DIRECTORY_PATH> -
For data from flat files:
toBeDeletedFileDataDirectory: <DIRECTORY_PATH>
Here, <DIRECOTRY_PATH> is the location of the properties file.
-
-
Validate the data to be deleted from OIRI database (specified in the properties files) by specifying the source parameter as an argument, as shown:
-
For data from OIG:
ding-cli --config=/app/data/conf/config.yaml data-ingestion delete-dry-run -s OIG /app/data/conf/data-ingestion-config.yaml
-
For data from flat files:
ding-cli --config=/app/data/conf/config.yaml data-ingestion delete-dry-run -s File /app/data/conf/data-ingestion-config.yaml
Note:
The View Results window for the data import dry run task in the Identity Role Intelligence user interface displays the invalid data count and invalid error details for each entity. See Reviewing Data Import Task Result for information about how to review the delete dry run task result.
After resolving all issues reported by delete dry run, you can run the delete operation.
-
-
Delete data from OIRI database by specifying the source parameter as an argument in the following command:
For OIG database as the source:
ding-cli --config=/app/data/conf/config.yaml data-ingestion delete -s OIG /app/data/conf/data-ingestion-config.yaml
For flat files as the source:
ding-cli --config=/app/data/conf/config.yaml data-ingestion delete -s File /app/data/conf/data-ingestion-config.yaml
This command reads the data for each entity in the properties file and deletes the records for those entities from the OIRI database.
Note:
If the delete process fails, then the data will be in inconsistent state, and you must rerun the delete process.
3.12 Data Import Scenarios
This topic describes the following data import scenarios.
Data Import of Indirect Role-User Membership
Based on the role hierarchy imported into OIRI from OIG database or flat files, the indirect role user memberships is determined and populated in the OIRI database tables. Because a nested role inherits permissions from its parent roles, a user being a member of a nested role is made indirect member of all its parent roles in OIRI. Both the direct and indirect role user memberships are taken into consideration for role mining.
Data Import of Organization Hierarchy
OIRI does not support separate data import for organizations. After the user data in loaded in OIRI, based on the user's association with an organization, the organization hierarchy is dynamically generated in OIRI. The organizations details are populated in the OIRI organizations table, and the organization hierarchy path is generated and populated in the organizations and users tables.
Partial Data Deleted by Data Import
You perform data import from both OIG database and flat files in full mode, create role mining task with file data, mine roles, and publish the candidate roles. If you again perform data import only from OIG database in full mode, then the new data is loaded by truncating all the existing data in the OIRI database. In the Identity Role Intelligence user interface, the users, applications, and entitlements count is displayed correctly in the candidate role and published candidate role. However, the actual data is not displayed because the users, applications, and entitlements data has been deleted from the respective database tables.
Data Import by Retaining EXT_IDs
You perform data import from flat files, create role mining task, mine roles, and publish the candidate roles. Then you modify the users, applications, and entitlements data by retaining the same EXT_ID in the flat files, and again perform data import in full mode. Here, the master data for users, applications, and entitlements have changed, but their EXT_IDs have not changed. Therefore, the users, applications, and entitlements count is displayed correctly in the candidate role and published candidate role, but the changed user, application, and entitlement names are displayed on the Identity Role Intelligence user interface for the existing candidate role and published candidate role.