3 OIRIデータベースへのエンティティ・データのインポート

OIRIを構成して、Oracle Identity Governanceデータベースまたはフラット・ファイルからカスタム属性を含むエンティティ・データをロードし、データ・インポート・プロセスを実行できます。

この項には次の情報が含まれます:

• データ・インポートについて

• Oracle Identity Governanceデータベースからのデータのインポート

• フラット・ファイルからのデータのインポート

• updateDataIngestionConfig.shスクリプトの引数

• updateConfig.shスクリプトの引数

• OIGデータベースおよびフラット・ファイルからのデータのインポート

• OIRIデータベースへのカスタム属性のインポート

• データ・インポートのテスト実行プロセスの実行

• データ・インポート・タスク結果の確認

• データ・インポート・プロセスの実行

• インポートされたエンティティ・データの削除

• データ・インポート・シナリオ

3.1 データ・インポートについて

データ・インポートは、データ取込みとも呼ばれ、ソースからOracle Identity Role Intelligence (OIRI)データベースにエンティティ・データをインポートするプロセスです。OIRIでは、データ取込みコマンドライン・ツール(DING CLI)を使用して、サード・パーティのソース(Oracle Identity Governance (OIG)データベースまたはフラット・ファイル)からエンティティ・データをフェッチおよびロードします。

データ・インポート・プロセスの一環として、OIGデータベースやフラット・ファイルなどのソースのデータは、OIRIデータベースの次の表にロードされます:

USERS、APPLICATIONS、ACCOUNTS、ENTITLEMENTS、ASSIGNED_ENTS、ROLES、ROLE_USER_MSHIP、ROLE_ENT_COMPOSI、ROLE_HIERARCHY、ORGANIZATIONS

データ・インポート・プロセスは、次のモードで実行できます:

完全: OIRIを最初にインストールし、すべてのデータをソースからOIRIデータベースにロードする場合は、完全モードでデータ・インポートを実行します。これは、0日目のデータ・インポートと呼ばれます。N日目より後に完全モードでデータ・インポートを実行する場合(N日目のデータ・インポートと呼ばれます)、OIRIデータベースにエンティティ・データがすでに含まれていると、既存のデータは切り捨てられ、ソースからの新しいデータがロードされます。

増分: データ・インポートをN日目に増分モードで実行します。これは、OIRIとソースのデータを照合し、前回のデータ・インポートの実行後にソースで追加、更新または削除されたデータのみをロードします。

OIRIをインストールすると、デフォルトの構成では、ソースとしてOIGデータベースを使用する完全モードでのデータ・インポートが設定されます。ソースOIGデータベースの詳細(データベース名、ポート、サービス名など)を指定できます。それ以外の場合で、フラット・ファイルをデータ・インポートのソースにする場合は、フラット・ファイルの詳細を指定できます。ソースがOIGデータベースまたはフラット・ファイルの場合、0日目およびN日目のデータ・インポート構成の詳細は、後続のトピックを参照してください。

3.2 Oracle Identity Governanceデータベースからのデータのインポート

0日目およびN日目のシナリオで、Oracle Identity Governanceデータベースからエンティティ・データをインポートできます。

この項には次の情報が含まれます:

• Oracle Identity Governanceデータベースからの0日目のデータ・インポートの構成

• Oracle Identity GovernanceデータベースからのN日目のデータ・インポートの構成

3.2.1 Oracle Identity Governanceデータベースからの0日目のデータ・インポートの構成

0日目のデータ・インポートは、エンティティ・データをOIRIデータベースに初めてインポートするためにデータ・ロードを実行することです。すべてのエンティティ・データをOracle Identity Governance (OIG)データベースからOIRIデータベースにインポートするため、データ・インポートを完全モードで実行する必要があります。OIRIをインストールすると、デフォルトの構成では、ソースとしてOIGデータベースを使用する完全モードでのデータ・インポートが設定されます。ソースOIGデータベースの詳細(データベース名、ポート、サービス名など)を指定できます。データ・インポート構成の詳細は、「構成ファイルの設定」を参照してください。

0日目のデータ・インポートを構成するには、ding-cliコンテナが実行中であることを確認してから、次のステップを実行します:

1. デフォルトのデータ・インポート構成を変更する場合は、次の形式でupdateDataIngestionConfig.shコマンドを実行します:

   $ 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_n

   たとえば、OIGデータベース・ホストをmyoigdbに、ポートを12345に更新する場合は、次のコマンドを実行します:

   $ docker exec -it ding-cli bash
   
   $ ./updateDataIngestionConfig.sh --oigdbhost myoigdb --oigdbport 12345

   ノート:

   updateDataIngestionConfig.shスクリプトを実行すると、エンティティ・パラメータなど、データ・インポート構成パラメータの値を更新できます。updateDataIngestionConfig.shスクリプトのすべてのパラメータを表示するには、次のコマンドを実行します:

   $ ./updateDataIngestionConfig.sh --help

   updateDataIngestionConfig.shスクリプトを実行することで設定できるすべてのパラメータの詳細は、「updateDataIngestionConfig.shスクリプトの引数」を参照してください。

   OIRIマイクロサービスの他のパラメータ値は、updateConfig.shを実行して更新できます。updaConfig.shスクリプトのすべてのパラメータを表示するには、次のコマンドを実行します:

   $ ./updateConfig.sh --help

   updateConfig.shスクリプトを実行することで設定できるすべてのパラメータの詳細は、「updateConfig.shスクリプトの引数」を参照してください。

2. 次のコマンドを実行して、data-ingestion-config.yamlを確認します:

   $ docker exec -it oiri-cli bash
   
   $ cat /app/data/conf/data-ingestion-config.yaml

   ノート:

   • data-ingestion-config.yamlファイルの値を更新するには、updateDataIngestionConfig.shスクリプトを実行します。

   • データ・インポートのパフォーマンスを最適化するためにlowerbound、upperboundおよびnumpartitionの値を構成する方法など、すべてのエンティティ構成パラメータとその意味については、「パフォーマンスのチューニング」を参照してください。

「データ・インポートのテスト実行プロセスの実行」および「データ・インポート・プロセスの実行」の説明に従って、データ・インポート・プロセスを実行できるようになりました。

3.2.2 Oracle Identity GovernanceデータベースからのN日目のデータ・インポートの構成

N日目では、OIRIデータベース内のエンティティ・データを同期して、ソースに加えられた変更を反映します。したがって、updateDataIngestionConfig.shスクリプトを実行して、エンティティごとにincrementalにsyncModeパラメータの値を指定することで、データ・インポートを増分モードで実行できます。たとえば、ユーザー、アプリケーションおよび権限エンティティに対して増分データ・インポートが実行されるように指定する場合は、次のコマンドを実行します:

$ ./updateDataIngestionConfig.sh --entityusersenabled true --entityuserssyncmode incremental --entityapplicationsenabled true --entityapplicationssyncmode incremental --entityentitlementsenabled true --entityentitlementssyncmode incremental

updateDataIngestionConfig.shスクリプトを実行して更新できる各エンティティのパラメータの詳細は、「データ・インポートのエンティティ・パラメータ」を参照してください。

また、データ・インポート構成パラメータ値にその他の変更を指定する場合は、updateDataIngestionConfig.shコマンドを実行します。たとえば、ソースOIGデータベースの詳細を変更する場合は、次のコマンドを実行します:

$ ./updateDataIngestionConfig.sh --useoigdbforetl true --oigdbhost host2.example.com --oigdbport 12345 --oigdbsname oigdb.example.com

データ・インポートのソース構成パラメータの詳細は、「ソース構成に必要なパラメータ」を参照してください。

ノート:

どのユーザーにも関連付けられていないロール/権限がOIGに含まれている場合は、ETLの削除操作も実行して、OIRIに同期されたデータに不整合がないことを確認する必要があります。

「データ・インポートのテスト実行プロセスの実行」および「データ・インポート・プロセスの実行」の説明に従って、データ・インポート・プロセスを実行できるようになりました。

3.3 フラット・ファイルからのデータのインポート

0日目およびN日目のシナリオで、フラット・ファイルからエンティティ・データをインポートできます。

この項には次の情報が含まれます:

• フラット・ファイルからの0日目のデータ・インポートの構成

• フラット・ファイルからのN日目のデータ・インポートの構成

• すべてのエンティティのCSVファイルのサンプル

3.3.1 フラット・ファイルからの0日目のデータ・インポートの構成

CSV形式のデータであるフラット・ファイルからOIRIデータベースにエンティティ・データをインポートできます。ユーザー、アカウント、アプリケーションなどのエンティティごとに、個別のフラット・ファイルを指定する必要があります。

各フラット・ファイルの最初の行は、インポートする属性を指定する固定ヘッダーです。たとえば、アカウント・データのフラット・ファイルの場合、ヘッダーは次のようになります:

“EXT_ACCOUNT_ID”,”ACCOUNT_NAME”, “ACCOUNT_TYPE”, “USER_NAME”, “APPLICATION_NAME”

アプリケーションの場合、ヘッダーは次のようになります:

“EXT_APP_ID”, “NAME”, “DISPLAY_NAME”, “TYPE”, “DESCRIPTION”, “RISK_SCORE”

ヘッダーの後に、OIRIデータベースにロードするカンマ区切りの属性値を指定します。フラット・ファイル内のデータは、デフォルトでカンマで区切られます。ただし、./updateDataIngestionConfig.shコマンドの実行時に、-–flatfileseparatorパラメータの値を、コロンの場合は:、縦棒の場合は|に設定することで、他のセパレータを使用するように構成できます。

アプリケーション・エンティティのサンプルCSVファイルのヘッダーとコンテンツは次のとおりです:

“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

.CSVファイルをディレクトリに保存します。同様に、OIRIデータベースにデータをインポートするすべてのエンティティについて、.CSVファイルを作成します。ユーザー、アプリケーション、アカウント、権限、割り当てられた権限、ロール、ロール階層、ロール・ユーザー・メンバーシップおよびロール権限構成のエンティティのサンプルCSVファイルのヘッダーとコンテンツについては、「すべてのエンティティのCSVファイルのサンプル」を参照してください。

ファイルをディレクトリに保存します。次に、次に示すようにupdateDataIngestionConfig.shスクリプトを実行して、フラット・ファイルをデータ・ロードのソースとして指定するためのパラメータを更新します:

$ ./updateDataIngestionConfig.sh --useoigdbforetl false --useflatfileforetl true --format csv

「データ・インポートのテスト実行プロセスの実行」および「データ・インポート・プロセスの実行」の説明に従って、データ・インポート・プロセスを実行できるようになりました。

3.3.2 フラット・ファイルからのN日目のデータ・インポートの構成

N日目では、OIRIデータベース内のエンティティ・データを同期して、ソースに加えられた変更を反映します。したがって、エンティティごとにincrementalにsyncModeパラメータの値を指定することで、データ・インポートを増分モードで実行できます。また、データ・インポート構成パラメータ値にその他の変更を指定する場合は、updateDataIngestionConfig.shコマンドを実行します。たとえば、ソース・フラット・ファイルの属性値を変更し、ユーザー、アプリケーションおよび権限エンティティに対して増分データ・ロードが実行されるように指定する場合は、次のコマンドを実行します:

ユーザーの場合:

$ ./updateDataIngestionConfig.sh --useoigdbforetl false --useflatfileforetl true --flatfileformat csv --entityuserssyncmode incremental

アプリケーションの場合:

$ ./updateDataIngestionConfig.sh --useoigdbforetl false --useflatfileforetl true --flatfileformat csv --entityapplicationssyncmode incremental

権限の場合:

$ ./updateDataIngestionConfig.sh --useflatfileforetl true --flatfileformat csv --entityentitlementssyncmode incremental

「データ・インポートのテスト実行プロセスの実行」および「データ・インポート・プロセスの実行」の説明に従って、データ・ロード・プロセスを実行できるようになりました。

3.3.3 すべてのエンティティのCSVファイルのサンプル

このトピックでは、ユーザー、アプリケーション、アカウント、権限、割り当てられた権限、ロール、ロール階層、ロール・ユーザー・メンバーシップおよびロール権限構成のエンティティのサンプルCSVファイルのヘッダーとコンテンツを示します。また、フラット・ファイルからデータをインポートするためのこれらのエンティティの必須属性とオプション属性も示します。

次の項目が含まれます。

• users.csvファイルのサンプル

• applications.csvファイルのサンプル

• accounts.csvファイルのサンプル

• entitlements.csvファイルのサンプル

• assignedEntitlements.csvファイルのサンプル

• roles.csvファイルのサンプル

• roleHierarchy.csvファイルのサンプル

• roleUserMembership.csvファイルのサンプル

• roleEntitlementComposition.csvファイルのサンプル

3.3.3.1 users.csvファイルのサンプル

次の表は、フラット・ファイルからのデータ・インポートの必須およびオプションのuser属性を示しています。

OIRIの属性	必須/オプション
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	オプション

users.csvファイルのサンプルを次に示します:

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,[e-mail],,Work,,,,,CONTRACTOR,,,Xellerate Users,,,,,,,,,,,,0
71,IDENTITY_AUDIT_VIEWER_WITH_HIER,Viewer,Audit,,Identity Audit Viewer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
72,IDENTITY_AUDIT_VIEWER_WITHOUT_HIER,Viewer,Audit,,Identity Audit Viewer Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
73,HOME_ORG_USER,Org,Home,,UserMgmt Home Org User,,,,Active,[e-mail],,Work,,,,,Full-Time,,,user_mgmt_org,,,,,,,,,,,,0
74,MGMT_CHAIN_MGR_LVL_1,Level1,UserMgmt,Manager,UserMgmt Manager User Level 1,,,,Active,[e-mail],,Work,,,,,Full-Time,,,user_mgmt_org,,,,,,,,,,,,0
75,MGMT_CHAIN_MGR_LVL_2,Level2,UserMgmt,Manager,UserMgmt Manager User Level 2,,,,Active,[e-mail],,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,[e-mail],,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,[e-mail],,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,[e-mail],,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,[e-mail],,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,[e-mail],,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,[e-mail],,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,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
83,CERTIFICATIONVIEWER,ln_certificationViewer,fn_certificationViewer,,fn_certificationViewer ln_certificationViewer,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
84,CERTIFIEREXORG,ln_certifierExOrg,fn_certifierExOrg,,fn_certifierExOrg ln_certifierExOrg,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
85,CERTIFICATIONCONFIGURATIONADMINISTRATOR,ln_certificationConfigurationAdministrator,fn_certificationConfigurationAdministrator,,fn_certificationConfigurationAdministrator ln_certificationConfigurationAdministrator,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
86,ACERTUSER1,ln_ACERTUSER1,fn_ACERTUSER1,,fn_ACERTUSER1 ln_ACERTUSER1,,,,Active,[e-mail],,Work,,,,,Full-Time,,,AviCertOrg,,,,,,,,,,,,0
87,ACERTUSER2,ln_ACERTUSER2,fn_ACERTUSER2,,fn_ACERTUSER2 ln_ACERTUSER2,,,,Active,[e-mail],,Work,,,,,Full-Time,,,AviCertOrg,,,,ACERTUSER1,fn_ACERTUSER1 ln_ACERTUSER1,,,,,,,0
88,ACERTUSER3,ln_ACERTUSER3,fn_ACERTUSER3,,fn_ACERTUSER3 ln_ACERTUSER3,,,,Active,[e-mail],,Work,,,,,Full-Time,,,AviCertOrg,,,,ACERTUSER1,fn_ACERTUSER1 ln_ACERTUSER1,,,,,,,0
89,ACERTUSER4,ln_ACERTUSER4,fn_ACERTUSER4,,fn_ACERTUSER4 ln_ACERTUSER4,,,,Active,[e-mail],,Work,,,,,Full-Time,,,AviCertOrg,,,,ACERTUSER1,fn_ACERTUSER1 ln_ACERTUSER1,,,,,,,0
6,SPALMENTIERI,Palmentieri,Sonny,,Sonny Palmentieri,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0
90,VCERTUSER1,ln_VCERTUSER1,fn_VCERTUSER1,,fn_VCERTUSER1 ln_VCERTUSER1,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,,,,,,,,,0
91,VCERTUSER2,ln_VCERTUSER2,fn_VCERTUSER2,,fn_VCERTUSER2 ln_VCERTUSER2,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER1,fn_VCERTUSER1 ln_VCERTUSER1,,,,,,,0
92,VCERTUSER3,ln_VCERTUSER3,fn_VCERTUSER3,,fn_VCERTUSER3 ln_VCERTUSER3,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER1,fn_VCERTUSER1 ln_VCERTUSER1,,,,,,,0
93,VCERTUSER4,ln_VCERTUSER4,fn_VCERTUSER4,,fn_VCERTUSER4 ln_VCERTUSER4,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER2,fn_VCERTUSER2 ln_VCERTUSER2,,,,,,,0
94,VCERTUSER5,ln_VCERTUSER5,fn_VCERTUSER5,,fn_VCERTUSER5 ln_VCERTUSER5,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER2,fn_VCERTUSER2 ln_VCERTUSER2,,,,,,,0
95,VCERTUSER6,ln_VCERTUSER6,fn_VCERTUSER6,,fn_VCERTUSER6 ln_VCERTUSER6,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER2,fn_VCERTUSER2 ln_VCERTUSER2,,,,,,,0
96,VCERTUSER7,ln_VCERTUSER7,fn_VCERTUSER7,,fn_VCERTUSER7 ln_VCERTUSER7,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER2,fn_VCERTUSER2 ln_VCERTUSER2,,,,,,,0
97,VCERTUSER8,ln_VCERTUSER8,fn_VCERTUSER8,,fn_VCERTUSER8 ln_VCERTUSER8,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER3,fn_VCERTUSER3 ln_VCERTUSER3,,,,,,,0
98,VCERTUSER9,ln_VCERTUSER9,fn_VCERTUSER9,,fn_VCERTUSER9 ln_VCERTUSER9,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER3,fn_VCERTUSER3 ln_VCERTUSER3,,,,,,,0
99,VCERTUSER10,ln_VCERTUSER10,fn_VCERTUSER10,,fn_VCERTUSER10 ln_VCERTUSER10,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER3,fn_VCERTUSER3 ln_VCERTUSER3,,,,,,,0
100,VCERTUSER11,ln_VCERTUSER11,fn_VCERTUSER11,,fn_VCERTUSER11 ln_VCERTUSER11,,,,Active,[e-mail],,Work,,,,,Full-Time,,,VisCertOrg,,,,VCERTUSER3,fn_VCERTUSER3 ln_VCERTUSER3,,,,,,,0
1001,[e-mail],Miller,Bob,,Bob Miller,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0
1002,[e-mail],Cook,Tim,,Tim Cook,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0
1003,[e-mail],Cook,Alister,,Alister Cook,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0
1004,[e-mail],Wilcox,Mark,,Mark Wilcox,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0
1005,[e-mail],Border,Alan,,Alan Border,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0
1006,[e-mail],Trump,Donald,,Donald Trump,,,,Active,,,,,,,,Full-Time,,,Demoorg,,,,,,,,,,,,0
2002,USR_5,Usr_5,Usr_5,,Usr_5 Usr_5,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
2004,KARNOLD,Arnold,Kari,,Kari Arnold,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2006,DLEWIS,Lewis,Donald,,Donald Lewis,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2007,MSANDOVAL,Sandoval,Molly,,Molly Sandoval,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2008,CDELGADO,Delgado,Carol,,Carol Delgado,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
5,[e-mail],Subramanian,Elangovan,,Elangovan Subramanian,,,,Active,,,,,,,,Full-Time,,,vision,,,,,,,,,,,,0
7,HHANZO,Hanzo,Hattori,,Hattori Hanzo,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0
8,PQUITO,Quito,Paulo,,Paulo Quito,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0
9,DBAJAJ,Bajaj,Deepak,,Deepak Bajaj,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0
10,GKELLY,Kelly,Grace,,Grace Kelly,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0
11,STOLER,Toler,Sydney,,Sydney Toler,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Avitek,,,,,,,,,,,,0
12,MSTARR,Starr,Manny,,Manny Starr,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
13,RKLEIN,Klein,Robert,,Robert Klein,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,MSTARR,Manny Starr,,,,,,,0
14,MSMITH,Smith,Mark,,Mark Smith,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
15,PDEVRIES,DeVries,Peter,,Peter DeVries,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
16,JLONG,Long,Junki,,Junki Long,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,RKLEIN,Robert Klein,,,,,,,0
17,AARORA,Arora,Ajay,,Ajay Arora,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,MSMITH,Mark Smith,,,,,,,0
18,HSMITH,Smith,Howard,,Howard Smith,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,RKLEIN,Robert Klein,,,,,,,0
19,YTANAWA,Tanawa,Yuki,,Yuki Tanawa,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,RKLEIN,Robert Klein,,,,,,,0
20,PBENCHLEY,Benchley,Peter,,Peter Benchley,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
21,THILL,Hill,Terence,,Terence Hill,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
22,BSPENCER,Spencer,Bud,,Bud Spencer,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,AARORA,Ajay Arora,,,,,,,0
23,PMEI,Mei,Pai,,Pai Mei,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
24,BKIDDO,Kiddo,Beatrix,,Beatrix Kiddo,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,AARORA,Ajay Arora,,,,,,,0
25,GYUBARI,Yubari,Gogo,,Gogo Yubari,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
26,KGHEEWALA,Gheewala,Kurush,,Kurush Gheewala,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
27,JUDHAS,Udhas,Jagjit,,Jagjit Udhas,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
28,NGALIL,Galil,Noah,,Noah Galil,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
29,UNAOT,Naot,Uzi,,Uzi Naot,,,,Active,[e-mail],,Work,,,,,Full-Time,,,vision,,,,,,,,,,,,0
30,USER_ADMIN_WITH_HIER,Admin,User,,User Admin With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
31,USER_ADMIN_WITHOUT_HIER,Admin,User,,User Admin Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
32,USER_VIEWER_WITH_HIER,Viewer,User,,User Viewer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
33,USER_VIEWER_WITHOUT_HIER,Viewer,User,,User Viewer Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
34,HELP_DESK_ADMIN_WITH_HIER,Admin,Helpdesk,,Help Desk Admin With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
35,HELP_DESK_ADMIN_WITHOUT_HIER,Admin,Helpdesk,,Help Desk Admin Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
36,ORG_ADMIN_WITH_HIER,Admin,Org,,Org Admin With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
37,ORG_ADMIN_WITHOUT_HIER,Admin,Org,,Org Admin Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
38,ORG_ADMIN_USER_VIEWER_WITH_HIER,UserViewer,OrgAdmin,,Org Admin User Viewer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
39,ORG_VIEWER_WITH_HIER,Viewer,Org,,Org Viewer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
40,ORG_VIEWER_WITHOUT_HIER,Viewer,Org,,Org Viewer Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
41,ROLE_ADMIN_WITH_HIER,Admin,Role,,Role Admin With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
42,ROLE_ADMIN_WITHOUT_HIER,Admin,Role,,Role Admin Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
43,ROLE_VIEWER_WITH_HIER,Viewer,Role,,Role Viewer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
44,ROLE_VIEWER_WITHOUT_HIER,Viewer,Role,,Role Viewer Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
45,ROLE_AUTHORIZER_WITH_HIER,Authorizer,Role,,Role Authorizer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
46,ROLE_AUTHORIZER_WITHOUT_HIER,Authorizer,Role,,Role Authorizer Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
47,APP_INST_ADMIN_WITH_HIER,Admin,Appinst,,Appinst Admin With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
48,APP_INST_ADMIN_WITHOUT_HIER,Admin,Appinst,,Appinst Admin Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
49,APP_INST_VIEWER_WITH_HIER,Viewer,Appinst,,Appinst Viewer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
50,APP_INST_VIEWER_WITHOUT_HIER,Viewer,Appinst,,Appinst Viewer Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
51,APP_INST_AUTHORIZER_WITH_HIER,Authorizer,Appinst,,Appinst Authorizer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
52,APP_INST_AUTHORIZER_WITHOUT_HIER,Authorizer,Appinst,,Appinst Authorizer Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
1,XELSYSADM,Administrator,System,,System Administrator,,,,Active,[e-mail],,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,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
54,ENTITLEMENT_ADMIN_WITHOUT_HIER,Admin,Entitlement,,Entitlement Admin Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
55,ENTITLEMENT_VIEWER_WITH_HIER,Viewer,Entitlement,,Entitlement Viewer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
56,ENTITLEMENT_VIEWER_WITHOUT_HIER,Viewer,Entitlement,,Entitlement Viewer Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
57,ENTITLEMENT_AUTHORIZER_WITH_HIER,Authorizer,Entitlement,,Entitlement Authorizer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
58,ENTITLEMENT_AUTHORIZER_WITHOUT_HIER,Authorizer,Entitlement,,Entitlement Authorizer Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
59,SYSTEM_ADMIN_WITH_HIER,Admin,System,,System Admin With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
60,SYSTEM_ADMIN_WITHOUT_HIER,Admin,System,,System Admin Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
61,SYSTEM_CONFIGURATOR_WITH_HIER,Configurator,System,,System Configurator With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
62,SYSTEM_CONFIGURATOR_WITHOUT_HIER,Configurator,System,,System Configurator Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
63,CATALOG_ADMIN_WITH_HIER,Admin,Catalog,,Catalog Admin With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
64,CATALOG_ADMIN_WITHOUT_HIER,Admin,Catalog,,Catalog Admin Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
65,CERTIFICATION_ADMIN_WITH_HIER,Admin,Certification,,Certification Admin With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
66,CERTIFICATION_ADMIN_WITHOUT_HIER,Admin,Certification,,Certification Admin Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
67,CERTIFICATION_VIEWER_WITH_HIER,Reviewer,Certification,,Certification Reviewer With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
68,CERTIFICATION_VIEWER_WITHOUT_HIER,Reviewer,Certification,,Certification Reviewer Without Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
69,IDENTITY_AUDIT_ADMIN_WITH_HIER,Admin,Audit,,Identity Audit Admin With Hier,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Xellerate Users,,,,,,,,,,,,0
2009,KGILL,Gill,Katie,,Katie Gill,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2010,JNEWTON,Newton,Jose,,Jose Newton,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2011,AMEYER,Meyer,Amanda,,Amanda Meyer,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2012,LBATES,Bates,Laurie,,Laurie Bates,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2013,VMORALES,Morales,Vera,,Vera Morales,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2014,KPOOLE,Poole,Kristen,,Kristen Poole,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2015,WOLIVER,Oliver,Winifred,,Winifred Oliver,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2016,DSCHULTZ,Schultz,Deanna,,Deanna Schultz,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2017,PGOODMAN,Goodman,Patricia,,Patricia Goodman,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2018,JMULLINS,Mullins,Julio,,Julio Mullins,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2019,RWALTON,Walton,Rodney,,Rodney Walton,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2020,ECROSS,Cross,Elijah,,Elijah Cross,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2021,SROBERTSON,Robertson,Sheldon,,Sheldon Robertson,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2022,MHALL,Hall,Maria,,Maria Hall,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2023,CMCKINNEY,Mckinney,Clark,,Clark Mckinney,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2024,WWHEELER,Wheeler,Wendy,,Wendy Wheeler,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2025,JRYAN,Ryan,Jerome,,Jerome Ryan,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2026,CMARSH,Marsh,Catherine,,Catherine Marsh,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2027,ECOLEMAN,Coleman,Elvira,,Elvira Coleman,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2028,SMORAN,Moran,Shawna,,Shawna Moran,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2029,VCARPENTER,Carpenter,Victor,,Victor Carpenter,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2030,TGOMEZ,Gomez,Teri,,Teri Gomez,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2031,EMUNOZ,Munoz,Elizabeth,,Elizabeth Munoz,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2032,YWATKINS,Watkins,Yvonne,,Yvonne Watkins,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2033,SKELLER,Keller,Steve,,Steve Keller,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2034,SKING,King,Saul,,Saul King,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2036,DHOWELL,Howell,Dawn,,Dawn Howell,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2038,HBROCK,Brock,Hazel,,Hazel Brock,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,DHOWELL,Dawn Howell,,,,,,,0
2039,EPATTON,Patton,Erick,,Erick Patton,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2040,VANDERSON,Anderson,Verna,,Verna Anderson,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2041,AREYES,Reyes,Archie,,Archie Reyes,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2042,ISAUNDERS,Saunders,van,,van Saunders,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2043,SWEBER,Weber,Saul,,Saul Weber,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2044,JWATERS,Waters,Jo,,Jo Waters,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2045,WJOSEPH,Joseph,Wilbur,,Wilbur Joseph,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2046,ACOOK,Cook,Aaron,,Aaron Cook,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2047,BBECKER,Becker,Beulah,,Beulah Becker,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2048,BNICHOLS,Nichols,Bethany,,Bethany Nichols,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2049,CCHAVEZ,Chavez,Cathy,,Cathy Chavez,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2050,GHANSON,Hanson,Gertrude,,Gertrude Hanson,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2051,MROY,Roy,May,,May Roy,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2052,SWILLIS,Willis,Shelia,,Shelia Willis,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2053,TWILKINS,Wilkins,Toby,,Toby Wilkins,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2054,CPAGE,Page,Connie,,Connie Page,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2055,TDANIELS,Daniels,Tommie,,Tommie Daniels,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2056,TORTIZ,Ortiz,Theodore,,Theodore Ortiz,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2057,FLAMB,Lamb,Florence,,Florence Lamb,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2058,SABBOTT,Abbott,Sherry,,Sherry Abbott,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2059,AQUINN,Quinn,Austin,,Austin Quinn,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2060,FWHEELER,Wheeler,Freda,,Freda Wheeler,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2061,ENEWTON,Newton,Evelyn,,Evelyn Newton,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2062,RROBERSON,Roberson,Rick,,Rick Roberson,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2063,JNORMAN,Norman,Jerald,,Jerald Norman,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2064,AWILKINS,Wilkins,Alfred,,Alfred Wilkins,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2065,AMUNOZ,Munoz,Alyssa,,Alyssa Munoz,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2066,AWONG,Wong,April,,April Wong,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2067,NMYERS,Myers,Nelson,,Nelson Myers,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2068,PFRANCIS,Francis,Patti,,Patti Francis,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2069,BBARBER,Barber,Bert,,Bert Barber,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2070,RCHAMBERS,Chambers,Randolph,,Randolph Chambers,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2071,VORTIZ,Ortiz,Vernon,,Vernon Ortiz,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2072,ICALDWELL,Caldwell,Inez,,Inez Caldwell,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2073,KMYERS,Myers,Karla,,Karla Myers,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2074,LMULLINS,Mullins,Lowell,,Lowell Mullins,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2075,CHOPKINS,Hopkins,Crystal,,Crystal Hopkins,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2076,NRICE,Rice,Nichole,,Nichole Rice,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2077,LVEGA,Vega,Luke,,Luke Vega,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2078,MBAKER,Baker,Mable,,Mable Baker,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2079,OGONZALES,Gonzales,Ollie,,Ollie Gonzales,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2080,TARMSTRONG,Armstrong,Toby,,Toby Armstrong,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2081,GABBOTT,Abbott,Gerard,,Gerard Abbott,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2082,LDAWSON,Dawson,Leah,,Leah Dawson,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2083,NROMERO,Romero,Noel,,Noel Romero,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2084,ACANNON,Cannon,Austin,,Austin Cannon,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2085,TMALDONADO,Maldonado,Terry,,Terry Maldonado,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2086,CGREGORY,Gregory,Cora,,Cora Gregory,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2087,SCORTEZ,Cortez,Shannon,,Shannon Cortez,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2088,SMCDONALD,Mcdonald,Sharon,,Sharon Mcdonald,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2089,FGOODMAN,Goodman,Fredrick,,Fredrick Goodman,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2090,SRICHARDSON,Richardson,Sherman,,Sherman Richardson,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2091,RPETERSON,Peterson,Russell,,Russell Peterson,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2092,LPITTMAN,Pittman,Lora,,Lora Pittman,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2093,CORTEGA,Ortega,Chester,,Chester Ortega,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2094,NTHOMPSON,Thompson,Nicole,,Nicole Thompson,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2095,JFREEMAN,Freeman,Jill,,Jill Freeman,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2096,DWASHINGTON,Washington,Danny,,Danny Washington,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2097,CALEXANDER,Alexander,Carmen,,Carmen Alexander,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2098,PBARTON,Barton,Patsy,,Patsy Barton,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2099,JMOODY,Moody,Jo,,Jo Moody,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2100,DELLIOTT,Elliott,Doyle,,Doyle Elliott,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2101,DFOWLER,Fowler,Dwayne,,Dwayne Fowler,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2102,VCALDWELL,Caldwell,Virginia,,Virginia Caldwell,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2103,LBLAKE,Blake,Lynn,,Lynn Blake,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2104,JLARSON,Larson,Jermaine,,Jermaine Larson,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2105,GOSBORNE,Osborne,Gloria,,Gloria Osborne,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2106,TMORENO,Moreno,Tanya,,Tanya Moreno,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0
2107,KADAMS,Adams,Kristina,,Kristina Adams,,,,Active,[e-mail],,Work,,,,,Full-Time,,,Starlight,,,,,,,,,,,,0

3.3.3.2 applications.csvファイルのサンプル

次の表は、フラット・ファイルからのデータ・インポートの必須およびオプションのapplication属性を示しています。

OIRIの属性	必須/オプション
EXT_APP_ID	オプション
NAME	必須
DISPLAY_NAME	オプション
TYPE	必須
DESCRIPTION	オプション
RISK_SCORE	オプション

applications.csvファイルのサンプルを次に示します:

"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 accounts.csvファイルのサンプル

次の表は、フラット・ファイルからのデータ・インポートの必須およびオプションのaccount属性を示しています。

OIRIの属性	必須/オプション
EXT_ACCOUNT_ID	オプション
ACCOUNT_NAME	必須
ACCOUNT_TYPE	必須
USER_NAME	必須
APPLICATION_NAME	必須

accounts.csvファイルのサンプルを次に示します:

"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 entitlements.csvファイルのサンプル

次の表は、フラット・ファイルからのデータ・インポートの必須およびオプションのentitlement属性を示しています。

OIRIの属性	必須/オプション
EXT_ENT_ID	オプション
NAME	必須
DISPLAY_NAME	オプション
APPLICATION_NAME	必須
GRANTEE_TYPE	オプション
EXT_GRANTEE_ID	オプション
GRANTEE_NAME	オプション
RISK_SCORE	オプション

entitlements.csvファイルのサンプルを次に示します:

"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 assignedEntitlements.csvファイルのサンプル

次の表は、フラット・ファイルからのデータ・インポートの必須およびオプションのassignedEntitlements属性を示しています。

OIRIの属性	必須/オプション
EXT_USER_ID	オプション
USER_NAME	必須
ENTITLEMENT_NAME	必須
APPLICATION_NAME	必須
GRANTEE_TYPE	必須
GRANTEE_NAME	必須

assignedEntitlements.csvファイルのサンプルを次に示します:

"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 roles.csvファイルのサンプル

次の表は、フラット・ファイルからのデータ・インポートの必須およびオプションのrole属性を示しています。

OIRIの属性	必須/オプション
EXT_ROLE_ID	オプション
NAME	必須
DISPLAY_NAME	オプション
DESCRIPTION	オプション
RISK_SCORE	オプション

roles.csvファイルのサンプルを次に示します:

"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 roleHierarchy.csvファイルのサンプル

次の表は、フラット・ファイルからのデータ・インポートの必須およびオプションのroleHierarchy属性を示しています。

OIRIの属性	必須/オプション
ROLE_NAME	必須
NESTED_ROLE_NAME	必須

roleHierarchy.csvファイルのサンプルを次に示します:

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 roleUserMembership.csvファイルのサンプル

次の表は、フラット・ファイルからのデータ・インポートの必須およびオプションのroleUserMembership属性を示しています。

OIRIの属性	必須/オプション
EXT_ROLE_ID	オプション
ROLE_NAME	必須
USER_NAME	必須

roleUserMembership.csvファイルのサンプルを次に示します:

"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 roleEntitlementComposition.csvファイルのサンプル

次の表は、フラット・ファイルからのデータ・インポートの必須およびオプションのroleEntitlementComposition属性を示しています。

OIRIの属性	必須/オプション
EXT_ROLE_ID	オプション
ROLE_NAME	必須
ENTITLEMENT_NAME	必須
APPLICATION_NAME	必須
GRANTEE_TYPE	必須
GRANTEE_NAME	必須

roleEntitlementComposition.csvファイルのサンプルを次に示します:

"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 updateDataIngestionConfig.shスクリプトの引数

「updateDataIngestionConfig.shスクリプトの引数」は、updateDataIngestionConfig.shスクリプトを実行して更新できるパラメータを示しています。

表3-1 updateDataIngestionConfig.shコマンドの引数

引数短縮形	オプション	説明
-eacbs	--entityaccountsbatchsize	エンティティ・アカウントのバッチ・サイズ。
-eace	--entityaccountsenabled	データ・インポート中にエンティティを有効/無効にするかを決定します。デフォルト値はtrue
-eaclb	--entityaccountsslowerbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最小値。デフォルト値は0です。
-eacnop	--entityaccountsnumberofpartitions	パーティションの数。これにより、lowerBound (包含)、upperBound (除外)とともに、列partitionColumnを均等に分割するために使用される、生成されたWHERE句式のパーティション・ストライドが形成されます。デフォルト値は3です。
-eacsm	--entityaccountssyncmode	0日目の場合、完全モードが使用されます。N日目の場合、増分モードが使用されます。完全モードでは、すべてのデータがOIRIデータベースにロードされますが、増分モードでは、デルタ・データがソースからフェッチされ、それに応じて更新/挿入されます。デフォルト値は完全です。
-eacub	--entityaccountsupperbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最大値。デフォルト値は10000です。
-eabs	--entityapplicationsbatchsize	エンティティ・アプリケーションのバッチ・サイズ
-eae	--entityapplicationsenabled	データ・インポート中にエンティティを有効/無効にするかを決定します。デフォルト値はtrueです。
-eaebs	--entityassignedentitlementsbatchsize	エンティティ割当て済権限のバッチ・サイズ
-eaee	--entityassignedentitlementsenabled	データ・インポート中にエンティティを有効/無効にするかを決定します。デフォルト値はtrueです。
-eaelb	--entityassignedentitlementslowerbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最小値。デフォルト値は0です。
-eaenop	--entityassignedentitlementsnumberofpartitions	パーティションの数。これにより、lowerBound (包含)およびupperBound (除外)とともに、列partitionColumnを均等に分割するために使用される、生成されたWHERE句式のパーティション・ストライドが形成されます。デフォルト値は3です。
-eaesm	--entityassignedentitlementssyncmode	増分が使用されます。完全モードでは、すべてのデータがフェッチされ、OIRIデータベースにロードされます。増分モードでは、デルタ・データのみがソースからフェッチされ、それに応じて更新/挿入されます。
-eaeub	--entityassignedentitlementssupperbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最大値。デフォルト値は10000です。
-ealb	--entityapplicationslowerbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最小値。デフォルト値は0です。
-eanop	--entityapplicationsnumberofpartitions	パーティションの数。これにより、lowerBound (包含)およびupperBound (除外)とともに、列partitionColumnを均等に分割するために使用される、生成されたWHERE句式のパーティション・ストライドが形成されます。デフォルト値は3です。
-easm	--entityapplicationssyncmode	0日目の場合、完全モードが使用されます。N日目の場合、増分モードが使用されます。完全モードでは、すべてのデータがフェッチされ、OIRIデータベースにロードされます。増分モードでは、デルタ・データのみがソースからフェッチされ、それに応じて更新/挿入されます。
-eaub	--entityapplicationsupperbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最大値。デフォルト値は10000です。
-eebs	--entityentitlementsbatchsize	エンティティ権限のバッチ・サイズ
-eee	--entityentitlementsenabled	データ・インポート中にエンティティを有効/無効にするかを決定します。デフォルト値はtrueです。
-eelb	--entityentitlementslowerbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最小値。デフォルト値は0です。
-eenop	--entityentitlementsnumberofpartitions	パーティションの数。これにより、lowerBound (包含)およびupperBound (除外)とともに、列partitionColumnを均等に分割するために使用される、生成されたWHERE句式のパーティション・ストライドが形成されます。デフォルト値は3です。
-eesm	--entityentitlementssyncmode	0日目の場合、完全モードが使用されます。N日目の場合、増分モードが使用されます。完全モードでは、すべてのデータがフェッチされ、OIRIデータベースにロードされます。増分モードでは、デルタ・データのみがソースからフェッチされ、それに応じて更新/挿入されます。デフォルト値は完全です。
-eeub	--entityentitlementsupperbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最大値。デフォルト値は10000です。
-erbs	--entityrolesbatchsize	エンティティ・ロールのバッチ・サイズ
-ere	--entityrolessenabled	ETL中にエンティティを有効/無効にするかを決定します。デフォルト値はtrueです。
-erecbs	--entityroleentitlementcompositionsbatchsize	エンティティ・ロール権限構成のバッチ・サイズ
-erece	--entityroleentitlementcompositionsenabled	ETL中にエンティティを有効/無効にするかを決定します。デフォルト値はtrueです。
-ereclb	--entityroleentitlementcompositionslowerbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最小値。デフォルト値は0です。
-erecnop	--entityroleentitlementcompositionsnumberofpartitions	パーティションの数。これにより、lowerBound (包含)およびupperBound (除外)とともに、列partitionColumnを均等に分割するために使用される、生成されたWHERE句式のパーティション・ストライドが形成されます。デフォルト値は3です。
-erecsm	--entityroleentitlementcompositionssyncmode	0日目の場合、完全モードが使用されます。N日目の場合、増分モードが使用されます。完全モードでは、すべてのデータがフェッチされ、OIRIデータベースにロードされます。増分モードでは、デルタ・データのみがソースからフェッチされ、それに応じて更新/挿入されます。デフォルト値は完全です。
-erecub	--entityroleentitlementcompositionsupperbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最大値。デフォルト値は10000です。
-erhbs	--entityrolehierarchybatchsize	エンティティ・ロール階層のバッチ・サイズ。
-erhe	--entityrolehierarchyenabled	ETL中にエンティティを有効/無効にするかを決定します。デフォルト値はtrueです。
-erhnop	--entityrolehierarchynumberofpartitions	パーティションの数。これにより、lowerBound (包含)およびupperBound (除外)とともに、列partitionColumnを均等に分割するために使用される、生成されたWHERE句式のパーティション・ストライドが形成されます。デフォルト値は3です。
-erhsm	--entityrolehierarchysyncmode	0日目の場合、完全モードが使用されます。N日目の場合、増分モードが使用されます。完全モードでは、すべてのデータがフェッチされ、OIRIデータベースにロードされます。増分モードでは、デルタ・データのみがソースからフェッチされ、それに応じて更新/挿入されます。
-erlb	--entityroleslowerbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最小値。デフォルト値は0です。
-ernop	--entityrolesnumberofpartitions	パーティションの数。これにより、lowerBound (包含)およびupperBound (除外)とともに、列partitionColumnを均等に分割するために使用される、生成されたWHERE句式のパーティション・ストライドが形成されます。デフォルト値は3です。
-ersm	--entityrolessyncmode	0日目の場合、完全モードが使用されます。N日目の場合、増分モードが使用されます。完全モードでは、すべてのデータがフェッチされ、OIRIデータベースにロードされます。増分モードでは、デルタ・データのみがソースからフェッチされ、それに応じて更新/挿入されます。
-erub	--entityrolesupperbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最大値。デフォルト値は10000です。
-erumbs	--entityroleusermembershipsbatchsize	エンティティ・ロール・ユーザー・メンバーシップのバッチ・サイズ
-erume	--entityroleusermembershipssenabled	ETL中にエンティティを有効/無効にするかを決定します。デフォルト値はtrueです。
-erumlb	--entityroleusermembershipsowerbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最小値。デフォルト値は0です。
-erumnop	--entityroleusermembershipsnumberofpartitions	パーティションの数。これにより、lowerBound (包含)およびupperBound (除外)とともに、列partitionColumnを均等に分割するために使用される、生成されたWHERE句式のパーティション・ストライドが形成されます。デフォルト値は3です。
-erumsm	--entityroleusermembershipssyncmode	0日目の場合、完全モードが使用されます。N日目の場合、増分モードが使用されます。完全モードでは、すべてのデータがフェッチされ、OIRIデータベースにロードされます。増分モードでは、デルタ・データのみがソースからフェッチされ、それに応じて更新/挿入されます。デフォルト値は完全です。
-erumub	--entityroleusermembershipsupperbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最大値。デフォルト値は10000です。
-eubs	--entityusersbatchsize	エンティティ・ユーザーのバッチ・サイズ
-eue	--entityusersenabled	ETL中にエンティティを有効/無効にするかを決定します。デフォルト値はtrueです。
-eulb	--entityuserslowerbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最小値。デフォルト値は0です。
-eunop	--entityusersnumberofpartitions	パーティションの数。これにより、lowerBound (包含)およびupperBound (除外)とともに、列partitionColumnを均等に分割するために使用される、生成されたWHERE句式のパーティション・ストライドが形成されます。デフォルト値は3です。
-eusm	--entityuserssyncmode	0日目の場合、完全モードが使用されます。N日目の場合、増分モードが使用されます。完全モードでは、すべてのデータがフェッチされ、OIRIデータベースにロードされます。増分モードでは、デルタ・データのみがソースからフェッチされ、それに応じて更新/挿入されます。デフォルト値は完全です。
-euub	--entityusersupperbound	パーティション・ストライドを決定するために使用されるpartitionColumnの最大値。デフォルト値は10000です。
-fff	--flatfileformat	フラット・ファイルの形式。デフォルト値はcsvです。
-ffs	--flatfileseparator	フラット・ファイルの行のデータ・セパレータ。,、:または|のいずれかです。デフォルト値は,です。
-fftsf	--flatfiletimestampformat	タイムスタンプの書式。デフォルト値はyyyy-MM-ddです。
-kcfn	--k8scertificatefilename	K8S APIサーバーと安全に通信するために使用するKubernetes証明書の名前。
-oigdbh	--oigdbhost	OIGデータベースのホスト名。
-oigdbp	--oigdbport	OIGデータベースのポート。
-oigdbs	--oigdbsname	OIGデータベースのサービス名。
d-uff	--useflatfileforetl	データ・インポート・ソースとしてフラット・ファイルを使用します。値はtrueまたはfalseです。
-uoigdb	--useoigdbforetl	データ・インポート・ソースとしてOIGデータベースを使用します。値はtrueまたはfalseです。

3.5 updateConfig.shスクリプトの引数

「updateConfig.shスクリプトの引数」は、updateConfig.shスクリプトを実行して更新できるパラメータを示しています。

表3-2 updateConfig.shスクリプトの引数

引数短縮形	引数	説明
ap	--authprovider	認証プロバイダ。サポートされている値はOIGです。
ar	--authroles	OIGを使用した認証に必要なカンマ区切りのロール。
ata	--accesstokenaudience	OIRIアクセス・トークン・オーディエンス
atacs	--accesstokenallowedclockskew	OIRIアクセス・トークンで許可されるクロック・スキュー(秒)
atet	--accesstokenexpirationtime	OIRIアクセス・トークン有効期限(分)
ati	--accesstokenissuer	OIRIアクセス・トークン発行者
cd	--cookiedomain	OIRI cookieドメイン
csf	--cookiesecureflag	OIRI cookieセキュア・フラグ
css	--cookiesamesite	OIRI cookie同一サイト
di	--dingimage	データ取込みイメージ名:タグ
dlc	--driverlimitcores	ドライバ・ポッドのハードCPU制限
dm	--drivermemory	SparkContextが初期化されるドライバ・プロセスに使用するメモリーの量で、サイズ単位接尾辞(k、m、gまたはt)が付いたJVMメモリー文字列と同じ形式です。たとえば、512m、2gです。
dmo	--drivermemoryoverhead	クラスタ・モードのドライバ・プロセスごとに割り当てられるヒープ以外のメモリーの量で、特に指定されていないかぎりMiB単位です。VMオーバーヘッド、インターン化された文字列などを考慮します。これは、コンテナのサイズとともに大きくなる傾向があります(通常は6から10%)。
dns	--dingnamespace	データ・インポート・ジョブのSparkドライバおよびエグゼキュータ・ポッドのネームスペース。
drc	--driverrequestcores	各ドライバ・ポッドのCPUリクエストを指定します。値は、K8Sの規則に準拠しています。サンプル値は、0.1、500m、1.5および5です。
elc	--executorlimitcores	Sparkアプリケーション用に起動された各エグゼキュータ・ポッドのハードCPU制限。
em	--executormemory	エグゼキュータ・プロセスごとに使用するメモリーの量で、サイズ単位接尾辞(k、m、gまたはt)が付いたJVMメモリー文字列と同じ形式です。たとえば、512m、2gです。
emo	--executormemoryoverhead	クラスタ・モードのエグゼキュータ・プロセスごとに割り当てられる追加メモリーの量で、特に指定されていないかぎりMiB単位です。VMオーバーヘッド、インターン化された文字列などを考慮します。これは、エグゼキュータのサイズとともに大きくなる傾向があります(通常は6から10%)。
erc	--executorrequestcores	各エグゼキュータ・ポッドのCPUリクエストを指定します。値は、K8Sの規則に準拠しています。サンプル値は、0.1、500m、1.5および5です。
ips	--imagepullsecret	レジストリからdingイメージをプルするKubernetesシークレット名。
ist	--idlesessiontimeout	OIRIアイドル・セッション・タイムアウト(分)。
ksn	--keystorename	OIRIキーを含むキーストアのファイル名。
noe	--numberofexecutors	データ・インポート・ジョブを完了するためにKubernetesクラスタで実行されるエグゼキュータ・インスタンスの数。
oigati	--oigaccesstokenissuer	OIGアクセス・トークン発行者。
oigcpmx	--oigconnectionpoolmax	OIGのプール内の最大接続数。
oigcpmr	--oigconnectionpoolmaxroute	OIGのルート当たりの最大接続数。
oigct	--oigconnectiontimeout	OIG接続タイムアウト間隔(ミリ秒)。
oigkat	--oigkeepalivetimeout	OIGのキープ・アライブのタイムアウト(秒)はキープ・アライブ戦略で使用されます。この戦略では、まずヘッダーに記載されているホストのキープ・アライブ・ポリシーを適用しようとします。その情報がレスポンス・ヘッダーに存在しない場合、keepAliveTimeoutの期間、キープ・アライブ接続が行われます。
oigpp	--oigproxypassword	OIGプロキシ・パスワード。
oigpuri	--oigproxyuri	OIGプロキシURI。
oigpu	--oigproxyusername	OIGプロキシ・ユーザー名
oigrt	--oigreadtimeout	OIG読取りタイムアウト間隔(ミリ秒)。
oigsu	--oigserverurl	OIGサーバーURL
oiridbh	--oiridbhost	OIRIデータベースのホスト名
oiridbp	--oiridbport	OIRIデータベースのポート
oiridbs	--oiridbsname	OIRIデータベースのサービス名
sele	--sparkeventlogsenabled	Sparkイベント・ログを有効化/無効化する場合にtrue/falseを設定します
st	--sessiontimeout	OIRIセッション・タイムアウト(分)
skmu	--sparkk8smasterurl	次の形式のKubernetes APIサーバーのURL: k8s://https://{K8S_API_SERVER_URL}

3.6 OIGデータベースおよびフラット・ファイルからのデータのインポート

OIGデータベースおよびフラット・ファイルからエンティティ・データを同時にインポートできます。このトピックでは、両方のソースからデータをインポートするための0日目およびN日目の構成について説明します。

0日目の構成

0日目の構成では、両方のソースに対してデータ・インポートを完全モードとして指定できます。たとえば、OIGデータベースとフラット・ファイルの両方から完全モードでユーザーおよびアプリケーション・データのインポートを構成するには、次の引数を指定してupdateDataIngestionConfig.shコマンドを実行します:

$ ./updateDataIngestionConfig.sh --useoigdbforetl true --entityusersenabled true --entityuserssyncmode full --entityapplicationsenabled true --entityapplicationssyncmode full --useflatfileforetl true

データ・インポート・プロセスを実行すると、OIRIはまずOIRIデータベース内の既存のデータを切り捨てて、完全モードでOIGデータベースからデータをインポートします。その後、データは、OIGデータベースからロードされたデータを切り捨てずにフラット・ファイルからインポートされます。フラット・ファイルに同じユーザーまたはアプリケーション・レコードがある場合、フラット・ファイルのそれらのレコードはOIRIデータベース内のレコードを置換するのではなく、更新します。

N日目の構成

N日目の構成では、両方のソースに対してデータ・インポートを増分モードとして指定できます。たとえば、OIGデータベースとフラット・ファイルの両方から増分モードでユーザーおよびアプリケーション・データのインポートを構成するには、次の引数を指定してupdateDataIngestionConfig.shコマンドを実行します:

$ ./updateDataIngestionConfig.sh --useoigdbforetl true --entityusersenabled true --entityuserssyncmode incremental --entityapplicationsenabled true --entityapplicationssyncmode incremental --useflatfileforetl true

データ・インポート・プロセスを実行すると、OIRIはまずOIGデータベースからOIRIデータベース内の既存のデータを更新してから、フラット・ファイルのデータを更新します。

3.7 OIRIデータベースへのカスタム属性のインポート

OIRIでは、デフォルト属性とともにユーザー・エンティティのカスタム属性の管理がサポートされます。OIRIデータ取込みサービス(データ・インポート)を使用してカスタム属性値を移入し、ロール・マイニング操作で使用できます。

ノート:

データ・インポート時に指定したデータ・ソースからフェッチされ、OIRIデータベース表に保存されるユーザー・エンティティのデフォルト属性と、それらのOIGユーザー属性とのマッピングについては、「エンティティの属性マッピング」を参照してください。

デフォルト属性に加えて、OIRIには最大40個のカスタム属性を追加でき、そのうち20個はstringデータ型、10個はnumberデータ型、10個はdateデータ型にすることができます。

この項には次の情報が含まれます:

• カスタム属性のインポート

• カスタム属性定義

• custom-attributes.yamlファイルのパラメータ

3.7.1 カスタム属性のインポート

カスタム属性をOIRIデータベースにインポートするには:

1. サンプルのcustom-attributes-metadata.yamlファイルを/ding-cli/samples/custom-attributes/から/nfs/ding/data/metadata/customattributes/にコピーします。

   custom-attributes-metadata.yamlファイルのサンプルには、次のようにカスタム属性定義が含まれています:

   customAttributes:
     - entityType: user
       attributeName: USER_STATUS
       displayName: User Status
       dataType: string
       searchable: true
       displayable: true
       required: false
       uniqueness: false
       caseExact: false
       supportAnalytics: false
       userMembershipRule: false
       oigAttributeName: Status
       oigTableColumnName: usr.USR_STATUS
       csvHeaderColumnOrder: 1
       oiriTableColumnName: CUST_ATTR_VC_1
     - entityType: user
       attributeName: PROVISIONED_DATE
       displayName: Provisioned Date
       dataType: date
       searchable: true
       displayable: true
       required: false
       uniqueness: false
       caseExact: false
       supportAnalytics: false
       userMembershipRule: false
       oigAttributeName: Provisioned_Date
       oigTableColumnName: usr.USR_PROVISIONED_DATE
       csvHeaderColumnOrder: 2
       oiriTableColumnName: CUST_ATTR_DT_1
     - entityType: user
       attributeName: LOCKOUT_DURATION
       displayName: Lockout Duration
       dataType: number
       searchable: false
       displayable: true
       required: false
       uniqueness: false
       caseExact: false
       supportAnalytics: false
       userMembershipRule: false
       oigAttributeName: Lockout_Duration
       oigTableColumnName: usr.USR_LOCKOUT_DURATION
       csvHeaderColumnOrder: 3
       oiriTableColumnName: CUST_ATTR_NB_1

   custom-attributes-metadata.yamlファイルのパラメータの詳細は、「カスタム属性定義」を参照してください。

   または、独自のcustom-attributes-metadata.yamlファイルを作成することもできます。

2. custom-attributes-metadata.yamlファイルを編集して、インポートするユーザー・エンティティのカスタム属性を指定します。
3. データ・インポートのソースがフラット・ファイルのときにカスタム属性をインポートする場合:

   1. custom-attributes-metadata.yamlファイルを編集して、oigTableColumnNameパラメータの値を空白に変更します。

   2. ユーザー・エンティティのフラット・ファイル(Users.csv)にカスタム属性を追加します。たとえば、ユーザー・エンティティのカスタム属性「ユーザー・ステータス」、「プロビジョニング日」および「ロックアウト期間」を追加するには、ヘッダーに"USER_STATUS", "PROVISIONED_DATE", "LOCKOUT_DURATION"を追加します。Users.csvファイルのヘッダーのサンプルを次に示します:

      “EXT_USER_ID”, “USER_NAME”, “LAST_NAME”, “FIRST_NAME”, “MIDDLE_NAME”, “DISPLAY_NAME”, “TITLE”, “USER_TYPE”, “LOCALE”, “PREFERRED_LANDUAGE”, “TIMEZONE”, “STATUS”, “WORK_EMAIL”, “HOME_EMAIL”, “PRIMARY_EMAIL_TYPE”, “WORK_PHONE”, “MOBILE_NO”, “WORK_STREET”, “WORK_CITY”, “WORK_STATE”, “WORK_POSTAL_CODE”, “WORK_COUNTRY”, “EMPLOYEE_NUMBER”, “EMPLOYEE_TYPE”, “JOB_CODE”, “COST_CENTER”, “ORGANIZATION”, PARENT_ORG_NAME”, “DIVISION”, “DEPARTMENT”, “MANAGER_NAME”, “RISK_SCORE”, "USER_STATUS", "PROVISIONED_DATE", "LOCKOUT_DURATION"

   3. カスタム属性の値を追加し、Users.csvファイルを保存します。

      ノート:

      サンプルの/ding-cli/samples/etl/users_with_ca.csvファイルのコピー、カスタム属性の追加または変更、およびデータ・インポート用のファイルの使用も可能です。

4. 次のコマンドを実行して、OIRIスキーマ定義からカスタム属性定義をリストします:

   ding-cli --config=/app/data/conf/config.yaml custom-attributes list /app/data/conf/custom-attributes.yaml

   ここで、config.yamlおよびcustom-attributes.yamlは、「構成ファイルの設定」のステップ5で生成されたファイルです。

   OIRIデータベースの詳細を含むcustom-attributes.yamlファイルでは、customAttributesMetadataFilePathパラメータは、カスタム属性スキーマ定義ファイルへのパス(/nfs/ding/data/metadata/customattributes/custom-attributes-metadata.yaml)を指します。custom-attributes.yamlファイルのパラメータの詳細は、「custom-attributes.yamlファイルのパラメータ」を参照してください。

5. 次のコマンドを実行して、特定のカスタム属性定義をOIRIスキーマ定義に挿入または更新します:

   $ ding-cli --config=/app/data/conf/config.yaml custom-attributes manage /app/data/conf/custom-attributes.yaml

   出力は次のようになります:

   The given User entity custom attributes {user,PROVISIONED_DATE={entity_type=user, attribute_name=PROVISIONED_DATE, display_name=Provisioned Date, data_type=date, searchable=true, displayable=true, is_required=false, uniqueness=false, case_exact=false, support_analytics=false, custom=true, target_column_name=CUST_ATTR_DT_1, oig_table_column_name=USR.USR_PROVISIONED_DATE, csv_header_column_order=2, expr_attr_name=provisionedDate, user_membership_rule=false, oig_attribute_name=Provisioned_Date}, user,LOCKOUT_DURATION={entity_type=user, attribute_name=LOCKOUT_DURATION, display_name=Lockout Duration, data_type=number, searchable=false, displayable=true, is_required=false, uniqueness=false, case_exact=false, support_analytics=false, custom=true, target_column_name=CUST_ATTR_NB_1, oig_table_column_name=USR.USR_LOCKOUT_DURATION, csv_header_column_order=3, expr_attr_name=lockoutDuration, user_membership_rule=false, oig_attribute_name=Lockout_Duration}, user,USER_STATUS={entity_type=user, attribute_name=USER_STATUS, display_name=User Status, data_type=string, searchable=true, displayable=true, is_required=false, uniqueness=false, case_exact=false, support_analytics=false, custom=true, target_column_name=CUST_ATTR_VC_1, oig_table_column_name=USR.USR_STATUS, csv_header_column_order=1, expr_attr_name=userStatus, user_membership_rule=false, oig_attribute_name=Status}} has been successfully created/updated in the OIRI schema definition
   SUCCESS: manage custom attributes.

   サンプル・カスタム属性「ユーザー・ステータス」、「プロビジョニング日」および「ロックアウト期間」の定義がOIRIデータベースで更新されました。

   ノート:

   ユーザー割当てルールから特定のカスタム属性を削除する必要がある場合は、userMembershipRule属性値をfalseに設定して、custom-attributes manageコマンドを実行する必要があります。

   custom-attributes manage CLIを実行してカスタム属性定義から1つ以上の属性を削除すると、次の影響があります:

   • 削除されたカスタム属性は、ロール・マイニング・タスクの作成/変更ページの「選択した基準」タイルに表示されなくなります。

   • 削除されたカスタム属性を含むタスクでロールをマイニングしようとすると、次のエラーで失敗します:

     Invalid <DELETED_CUSTOM_ATTRIBUTE_NAME>

     したがって、削除されたカスタム属性を持つ現在のタスクをコピーして、新しいタスクを作成します。コピー操作では、使用可能な属性のみがコピーされます。これにより、コピーされたタスクに対するロール・マイニング操作が可能になります。

6. ステップ3に示すように、custom-attributes listコマンドを実行して、OIRIスキーマ定義からカスタム属性定義をリストした場合、出力は次のようになります:

   List the custom attribute definitions from OIRI schema definition
   OIRI User Custom Attributes list ............
   =============================================
   [{entity_type=user, attribute_name=PROVISIONED_DATE, display_name=Provisioned Date, data_type=date, searchable=true, displayable=true, is_required=false, is_indexed=false, uniqueness=false, case_exact=false, support_analytics=false, custom=true, target_column_name=CUST_ATTR_DT_1, oig_table_column_name=USR.USR_PROVISIONED_DATE, csv_header_column_order=2, expr_attr_name=provisionedDate}, {entity_type=user, attribute_name=LOCKOUT_DURATION, display_name=Lockout Duration, data_type=number, searchable=false, displayable=true, is_required=false, is_indexed=false, uniqueness=false, case_exact=false, support_analytics=false, custom=true, target_column_name=CUST_ATTR_NB_1, oig_table_column_name=USR.USR_LOCKOUT_DURATION, csv_header_column_order=3, expr_attr_name=lockoutDuration}, {entity_type=user, attribute_name=USER_STATUS, display_name=User Status, data_type=string, searchable=true, displayable=true, is_required=false, is_indexed=false, uniqueness=false, case_exact=false, support_analytics=false, custom=true, target_column_name=CUST_ATTR_VC_1, oig_table_column_name=USR.USR_STATUS, csv_header_column_order=1, expr_attr_name=userStatus}]
   SUCCESS: custom attributes listing.

7. 次のように、データ・インポートを実行します:

   $ ding-cli --config=/app/data/conf/config.yaml data-ingestion start /app/data/conf/data-ingestion-config.yaml

   SCHEMA_DEF表でカスタム属性メタデータをシードした後、data-ingestion startコマンドを実行すると、Users表でカスタム属性データがシードされます。

   カスタム属性データは、custom-attributes manageコマンドの実行後に、OIRIデータベースのSCHEMA_DEF表に移入されます。
8. OIRIコンソールにログインし、次のブラウザAPIをコールして、OIRIサーバーのユーザー・エンティティ・メタデータ・キャッシュをリフレッシュします。

   http://<host>:<port>/oiri/api/v1/entity/refresh-user-entity-metadata-cache

3.7.2 カスタム属性定義

表3-3は、カスタム属性定義のパラメータを示しています。

表3-3 カスタム属性定義のパラメータ

パラメータ	必須	サンプル値	説明
entityType	はい	user	カスタム属性のエンティティ・タイプ。 OIRIでは、ユーザー・エンティティ・タイプのカスタム属性のみのインポートがサポートされます。
attributeName	はい	USER_STATUS	カスタム属性の名前。 OIRIでは、最大20文字の長さをサポートしています。すべての文字は大文字にする必要があります。値は英数字で、文字で始まる必要があります。許可される特殊文字はアンダースコア(_)のみです。
displayName	はい	ユーザー・ステータス	カスタム属性の表示名。 OIRIでは、最大100文字の長さをサポートしています。
dataType	はい	文字列	カスタム属性のデータ型。 OIRIでは、文字列、数値および日付のデータ型がサポートされます。値は、リテラルstring、numberまたはdateと一致する必要があります。
searchable	はい	true	属性をユーザー・フィルタ操作に表示するかどうか。
displayable	はい	true	属性がユーザー検索操作によって返されるかどうか。
required	はい	false	null値を許可するかどうか。 OIRIでは、このパラメータの値としてfalseのみがサポートされています。つまり、null値は指定できません。
indexed	はい	false	属性を索引付けできるかどうか。 OIRIでは、このパラメータの値としてfalseのみがサポートされています。つまり、属性は索引付けできません。
uniqueness	はい	false	重複値を許可するかどうか。 OIRIでは、このパラメータの値としてfalseのみがサポートされています。つまり、属性の重複値は許可されきません。
caseExact	はい	false	ユーザー・フィルタ操作で大/小文字を無視するかどうか。
supportAnalytics	いいえ	false	分析用の属性を許可するかどうか。
userMembershipRule	はい	true|false	userMembershipRule生成に属性を許可するかどうか。
oigAttributeName	はい	Status	ユーザー・メンバーシップ・ルールで使用されるOIG属性名。
oigTableColumnName	はい(データ・ソースとしてOIGを使用する場合)	usr.USER_STATUS	データ・ソースとしてOIGデータベースを使用する場合、これはこの列に使用されるSQL select句です。OIRIでは、表の別名値がusrのUSER表のみがサポートされます。
csvHeaderColumnOrder	はい(データ・ソースとしてフラット・ファイルを使用する場合)	1	データ・ソースとしてCSV形式のフラット・ファイルを使用する場合、これはCSVカスタム属性列リスト内の属性の位置です。カスタム属性列は、デフォルト属性の末尾に追加する必要があります。たとえば、ヘッダーが次の場合: “EXT_USER_ID”, “USER_NAME”, ... , “MANAGER_NAME”, “RISK_SCORE”, "USER_STATUS", "PROVISIONED_DATE", "LOCKOUT_DURATION" このパラメータの値1は、USER_STATUSカスタム属性を示します。
oiriTableColumnName	はい	CUST_ATTR_VC_1	カスタム属性が移入されるターゲットOIRIデータベース表の固定列名。 サポートされているデータ型に対して、次の列を使用する必要があります: 文字列の場合: CUST_ATTR_VC* 数値の場合: CUST_ATTR_NB* 日付の場合: CUST_ATTR_DT*

3.7.3 custom-attributes.yamlファイルのパラメータ

サンプルのcustom-attributes.yamlファイルの内容を次に示します。

## 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

表3-4は、custom-attributes.yamlファイルのパラメータを示しています。

表3-4 custom-attributes.yamlファイルのパラメータ

パラメータ	説明
walletDirectory	ウォレット・ディレクトリの名前。
url	OIRIデータベースURL。
driver	JDBCドライバ。
queryTimeout	問合せタイムアウト値(秒)。
fetchSize	フェッチされるレコードの数。
customAttributesMetadataFilePath	カスタム属性スキーマ定義ファイルであるcustom-attributes-metadata.yamlファイルへのパス。

3.8 データ・インポートのテスト実行プロセスの実行

データ・インポート(またはデータ取込み)の前に、テスト実行を行って、データがOIRIデータベースに適合しているかどうかを検証します。これにより、Oracle Identity Governanceデータベースやフラット・ファイルなどのソースからデータがフェッチされ、OIRIデータベースのメタデータに対して検証されます。たとえば、OIRIデータベースでは、ユーザー名が50文字を超えることはできません。そうしないと、OIRIに重複データが移入されません。

データ・インポートのテスト実行プロセスを実行するには:

1. CLIコマンドラインで、データ・インポートのテスト実行のための次のコマンドを実行します:

   $ docker exec -it ding-cli bash
   $ ding-cli --config=/app/data/conf/config.yaml data-ingestion dry-run /app/data/conf/data-ingestion-config.yaml

   このコマンドは、各エンティティを1つずつ選択し、OIGデータベース・インスタンスまたはフラット・ファイルからデータをフェッチし、OIRIデータベースで定義されたメタデータを使用して検証します。
2. 「データ・インポート・タスク結果の確認」の説明に従って、テスト実行のサマリーを確認し、エラーを修正します。

3.9 データ・インポート・タスク結果の確認

データ・ロード・タスクの結果を確認するには:

1. 「Identity Role Intelligenceへのサインイン」の説明に従って、Identity Role Intelligenceユーザー・インタフェースにサインインします。
2. ホーム・ページで、次のいずれかのステップを実行します:
   • ページの左上にある「アプリケーション・ナビゲーション」メニュー・アイコンをクリックし、「データのインポート」をクリックして、すべてのデータ・インポート・タスクのリストが示された「データ・インポートの管理」ページを開きます。
   • 「過去24時間のアクティビティを確認」タイルで、「データのインポート」をクリックして、過去24時間に実行されたデータ・インポート・タスクのリストが示された「データ・インポートの管理」ページを開きます。
   • 「タスクとロールの探索」タイルで、「データのインポート」をクリックして、すべてのデータ・インポート・タスクのリストが示された「データ・インポートの管理」ページを開きます。

   「データ・インポートの管理」ページに、データ・インポート・タスクごとに次の情報が表示されます:

   • テスト実行かどうか
   • 開始日時
   • 完了日および時刻
3. データ・インポート・タスクをフィルタして、確認するタスクを検索します。これを行うには:
   1. 「検索」フィールドで、データ・インポート・タスクの名前の全部または一部を入力し、[Enter]を押します。

      ノート:

      OIRIでは、SCIMフィルタを使用してデータを検索します。デフォルトでは、contains検索が実行されます。したがって、%や*などのワイルドカード文字を指定する必要はありません。検索ボックスに%を指定する必要はありませんが、OIRIは%検索を使用したデータを返します。たとえば、組織VisCertOrgを検索するには、visまたはcertと入力し、[Enter]を押します。

      OIRIは、*検索ではデータを返しません。また、OIRIでは、アンダースコア(_)の特殊文字を使用した検索はサポートされていません。たとえば、組織dev_orgを検索する場合、フィルタ値はdevまたはorgになります。_文字で検索すると、dev_orgが返され、_文字を含まない他の組織も返されます。これは、基礎となるOracleデータベースでは、アンダースコア文字_がパターン一致文字として処理されるためです。

      この検索機能は、Identity Role Intelligenceユーザー・インタフェースのすべてのテキスト・ボックス検索に適用されます。

   2. 「最終更新」リストから、「すべて」、「1日」、「7日」、「1か月」、「6か月」のいずれかのオプションを選択し、データ・インポート・タスクが実行された期間を指定します。
   3. 「ステータス」フィールドで、1つ以上のタスク・ステータス(「実行中」、「成功」、「失敗」など)を入力または削除します。
4. 確認するデータ・インポート・タスクについて、「結果の表示」をクリックします。または、データ・インポート・タスク名をクリックすることもできます。「結果の表示」ウィンドウが表示され、Oracle Identity Governanceデータベースおよびフラット・ファイルからのデータ・インポートの結果が表示されます。

   テスト実行操作では、次のデータ関連の問題が取得されます:

   • データが有効かどうか

   • 必要なスキーマ

   • 実際のスキーマ

   • 無効なデータの数

   • 無効なデータ・エラーの詳細

   • 欠落している必須データの数

   • 欠落している必須データ・エラーの詳細

   • 無効なデータ型の数

   • 無効なデータ型エラーの詳細

   • 無効なデータ長countInvalidデータ長エラーの詳細

   • 重複データの数

   • 重複データ・エラーdetailsInvalidユーザー・データの数

   • 無効なユーザー・データ・エラーの詳細

   • 無効な権限データの数

   • 無効な権限エラーの詳細

   • 無効なアプリケーション・データの数

   • 無効なアプリケーション・エラーの詳細

5. Oracle Identity Governanceデータベースからデータをインポートする場合、「OIGからインポート」がまだ展開されていなければ、展開します。OIGデータベースからインポートされたエンティティごとに、データ・インポート結果がリストされます。
6. 各エンティティを展開して、重複データ数、データセットが有効かどうか、無効なデータ型の数など、そのエンティティのデータ・インポートの詳細を確認します。

   ノート:

   データ・インポートのテスト実行の結果を確認する場合は、「結果の表示」ページに表示される不一致を修正し、データ・インポートのテスト実行を再度実行します。
7. フラット・ファイルからデータをインポートする場合、「ファイルからインポート」がまだ展開されていなければ、展開します。フラット・ファイルからインポートされたエンティティごとに、データ・インポート結果がリストされます。
8. 各エンティティを展開して、重複データ数、データセットが有効かどうか、無効なデータ型の数など、そのエンティティのデータ・インポートの詳細を確認します。

   ノート:

   データ・インポートのテスト実行の結果を確認する場合は、「結果の表示」ページに表示される不一致を修正し、データ・インポートのテスト実行を再度実行します。
9. 「取消」をクリックして、「結果の表示」ウィンドウを閉じます。

3.10 データ・インポート・プロセスの実行

テスト実行サマリーを確認してすべてのエラーを修正した後、次のステップを実行してデータ・インポート・プロセスを実行します:

1. 次のように、データ・インポートのコマンドを実行します:

   1. 次のコマンドを実行して、ca.crtをK8Sマスター(/etc/kubernetes/pki/)から/nfs/ding/にコピーします:

      $ cp/etc/kubernetes/pki/ca.crt /nfs/ding/

   2. 次のコマンドを実行して、データ・インポートを開始します:

      $ docker exec -it ding-cli bash
      $ ding-cli --config=/app/data/conf/config.yaml data-ingestion start /app/data/conf/data-ingestion-config.yaml

   ノート:

   • データ・インポートのテスト実行で修正されていない問題がある状態でdata-ingestion-startコマンドを実行すると、インポート・プロセスは失敗します。実際のデータ・インポートを実行する前に、テスト実行で報告されたすべての問題を修正する必要があります。

   • ネットワークの問題やソースDBサービスが停止または応答しないなどの異常な状態のため、データ・インポート・プロセスが終了し、OIRIデータベース表のデータが一貫性のない状態になっている可能性があります。この場合、データ・インポート・プロセスを再実行します。

   • OIRIは、接続が失われたためにスタックしたジョブなど、長時間実行されているデータ・インポート・ジョブに失敗としてマークします。データ・インポート・ジョブが失敗とマークされるまでの最大時間は、6時間です。これは、/app/data/conf/application.yamlファイルのmaxEtlJobRunningTimeInMinuteパラメータのデフォルト値である360を分単位で設定します。

   このコマンドは、OIGデータベースまたはフラット・ファイルからエンティティ・データを抽出し、OIRIデータベース表にロードします。
2. 「データ・インポート・タスク結果の確認」の説明に従って、データ・インポート・サマリーを確認し、エラーがないことを確認します。
3. データがOIRIデータベース表にロードされていることを確認します。

   OIRIデータベースのUSERS表では、ユーザー・レコードがOIGからインポートされたことを示すために、USER_IDフィールドの値の前にGが付けられています。たとえば、OIGのユーザーIDが2103で、これがOIRI USERS表のEXT_USER_IDフィールドに移入されている場合、USER_IDフィールドの値はG2103になります。同様に、ユーザー・エンティティがフラット・ファイルからインポートされている場合、USER_IDフィールドの値はF2103になります。

3.11 インポートされたエンティティ・データの削除

OIRIデータベースからデータを削除するには:

1. 次のコマンドを実行して、ファイルで削除するデータをリストします:

   ding-cli --config=/app/data/conf/config.yaml data-ingestion list-data-to-be-deleted /app/data/conf/data-ingestion-config.yaml

   データのソースがOIGデータベースの場合、このコマンドを実行すると、OIGから削除されたがOIRIデータベースにはまだ存在するデータが特定されます。これは、両方のデータベースを比較することによって行われます。次に、このコマンドは、生成されたoig_list_data_to_be_deleted.propertiesファイルの各エンティティについて、削除するデータをリストします。サンプル・ファイルを表示するには、ここをクリックします。

   list-data-to-be-deletedユーティリティは、oig_list_data_to_be_deleted.propertiesファイル内の次のOIGソース・エンティティについて、削除するデータをリストします。

   • Users: usr_statusがDeletedであるすべてのユーザーをOIGからフェッチし、OIRIデータベースをチェックし、OIRIユーザー表から削除するユーザーをリストします。

   • Applications: app_instance_is_soft_delete = 1であるすべてのアプリケーション・データをOIGからフェッチし、OIRIデータベースをチェックし、OIRIアプリケーション表から削除するアプリケーションをリストします。

   • Accounts: OIGおよびOIRIからすべてのアカウント・データをフェッチし、OIRIアカウント表から削除するアカウント・データをリストします。

   • Entitlements: OIGおよびOIRIからすべての権限データをフェッチし、OIRI権限表から削除する権限データをリストします。

   • Roles: OIGおよびOIRIからすべてのロール・データをフェッチし、OIRIロール表から削除するロール・データをリストします。

   • RoleHierarchy: OIGおよびOIRIからすべてのロール階層データをフェッチし、削除するロール階層データをリストします。

   • AssignedEntitlements: OIGおよびOIRIからすべての割当て済権限データをフェッチし、OIGでユーザーに割り当てられていない権限をリストします。

   • RoleUserMembership: OIGおよびOIRIからすべてのロール・ユーザー・メンバーシップ・データをフェッチし、OIGでユーザーに割り当てられていないロール・データをリストします。

   • RoleEntitlementComposition: OIGおよびOIRIからすべてのロール権限構成データをフェッチし、権限にリンクされていないロール・データをリストします。

   データのソースがフラット・ファイルの場合、レコードの統合リストがないため、list-data-to-be-deletedユーティリティは使用できません。file_list_data_to_be_deleted.propertiesファイルで削除するエンティティごとに、レコードを手動で指定します。サンプル・ファイルを表示するには、ここをクリックします。

   ノート:

   プロパティ・ファイルの場所は、data-ingestion-config.yamlファイル内の次のパラメータによって決まります:

   • OIGのデータの場合:

     toBeDeletedOigDataDirectory: <DIRECTORY_PATH>

   • フラット・ファイルのデータの場合:

     toBeDeletedFileDataDirectory: <DIRECTORY_PATH>

   ここで、<DIRECOTRY_PATH>はプロパティ・ファイルの場所です。

2. 次に示すように、引数としてソース・パラメータを指定して、OIRIデータベースから削除するデータ(プロパティ・ファイルで指定)を検証します。

   • OIGのデータの場合:

     ding-cli --config=/app/data/conf/config.yaml data-ingestion delete-dry-run -s OIG /app/data/conf/data-ingestion-config.yaml

   • フラット・ファイルのデータの場合:

     ding-cli --config=/app/data/conf/config.yaml data-ingestion delete-dry-run -s File /app/data/conf/data-ingestion-config.yaml

   ノート:

   Identity Role Intelligenceユーザー・インタフェースのデータ・インポートのテスト実行タスクの「結果の表示」ウィンドウには、各エンティティの無効なデータ数と無効なエラーの詳細が表示されます。削除のテスト実行タスクの結果を確認する方法の詳細は、「データ・インポート・タスク結果の確認」を参照してください。

   削除のテスト実行によって報告されたすべての問題を解決したら、削除操作を実行できます。

3. 次のコマンドでソース・パラメータを引数として指定して、OIRIデータベースからデータを削除します:

   ソースとしてのOIGデータベースの場合:

   ding-cli --config=/app/data/conf/config.yaml data-ingestion delete -s OIG /app/data/conf/data-ingestion-config.yaml

   ソースとしてのフラット・ファイルの場合:

   ding-cli --config=/app/data/conf/config.yaml data-ingestion delete -s File /app/data/conf/data-ingestion-config.yaml

   このコマンドは、プロパティ・ファイル内の各エンティティのデータを読み取り、それらのエンティティのレコードをOIRIデータベースから削除します。

   ノート:

   削除プロセスが失敗した場合、データは一貫性のない状態になり、削除プロセスを再実行する必要があります。

3.12 データ・インポート・シナリオ

このトピックでは、次のデータ・インポート・シナリオについて説明します。

間接ロール・ユーザー・メンバーシップのデータ・インポート

OIGデータベースまたはフラット・ファイルからOIRIにインポートされたロール階層に基づいて、間接ロール・ユーザー・メンバーシップが決定され、OIRIデータベース表に移入されます。ネストされたロールは親ロールから権限を継承するため、ネストされたロールのメンバーであるユーザーは、OIRI内のすべての親ロールの間接メンバーになります。直接と間接の両方のロール・ユーザー・メンバーシップが、ロール・マイニングについて検討されます。

組織階層のデータ・インポート

OIRIでは、組織の個別のデータ・インポートはサポートされていません。ユーザー・データがOIRIにロードされた後、ユーザーの組織との関連付けに基づいて、組織階層がOIRIで動的に生成されます。組織の詳細はOIRI組織表に移入され、組織階層パスが生成されて、組織およびユーザー表に移入されます。

データ・インポートによって削除された一部のデータ

OIGデータベースとフラット・ファイルの両方からの完全モードでのデータ・インポートの実行、ファイル・データを使用したロール・マイニング・タスクの作成、ロールのマイニングおよび候補ロールの発行を行います。データ・インポートをOIGデータベースからのみ完全モードで再実行すると、OIRIデータベース内の既存のデータをすべて切り捨てて、新しいデータがロードされます。Identity Role Intelligenceユーザー・インタフェースでは、ユーザー、アプリケーションおよび権限の数が、候補ロールと発行済候補ロールに正しく表示されます。ただし、ユーザー、アプリケーションおよび権限データがそれぞれのデータベース表から削除されているため、実際のデータは表示されません。

EXT_IDの保持によるデータ・インポート

フラット・ファイルからのデータ・インポートの実行、ロール・マイニング・タスクの作成、ロールのマイニングおよび候補ロールの発行を行います。次に、フラット・ファイルに同じEXT_IDを保持してユーザー、アプリケーションおよび権限データを変更し、完全モードでデータ・インポートを再度実行します。ここで、ユーザー、アプリケーションおよび権限のマスター・データは変更されていますが、EXT_IDは変更されていません。したがって、ユーザー、アプリケーションおよび権限の数は、候補ロールと発行済候補ロールに正しく表示されますが、変更されたユーザー、アプリケーションおよび権限の名前は、既存の候補ロールと発行済候補ロールのIdentity Role Intelligenceユーザー・インタフェースに表示されます。