Spreadsheet: 761513d1640970547-two-questions-find-similar-names-and-setting-values-inventory-extract-example-the1radfox-
Sheet: Sheet1

App-ID | IT App/Tool Name | LOB | Function | Purpose | Detailed Purpose | Technology | Application Type | Location | Source | Use Case Type | SL ID | [NAME] | [NAME] (CLOSE) | Business Owners | Business Owners (CLOSE) | IT Resource | IT Resource (CLOSE) | Access Management | Access Management (Close) | Identity Access Governance | Identity Access Governance (CLOSE) | Change Management | Change Management (CLOSE) | Disaster Recovery | Disaster Recovery (CLOSE) | Incident Management | Incident Management (CLOSE) | Classification | Reason for Classification | [NAME] | [NAME] (CLOSE) | Notes
Application ID from CMDB Sheet (Coulmn D "Application ID") |  | From Inventory LOB - For each LOB listed in Inventory reporting "Updated Name" list. | From Inventory Business sub-process for each of the LOB pulled. | From Inventory sheet from (Column S "Application Purpose *") for each LOB. | From Inventory sheet from (Column R "Nature of Application/Tool/Service (communication tool, social networking, data storage, spreadsheet, credit decision, etc.) *") for each LOB. | From D&C Classifications (Column M "Application Type") | From CMDB (Column F "Application Type") | From Inventory sheet (Column U "EUC Items Only (Saved location)") | From Inventory sheet (Column P "Source") | Investigating | From CMDB sheet (Column G "SL IT") | From CMDB sheet (Column A "Status") | From CMDB sheet (Column A "Status") Need to find application names close/similar to application name. | From CMDB sheet (Column J "Primary Business Application Owner") | From CMDB sheet (Column J "Primary Business Application Owner") Close to the Application Name. | From CMDB sheet (Column K "Primary IT Support") | From CMDB sheet (Column K "Primary IT Support") Close to the Application Name. | Value From MySentinel (Column A "S. No.") - Exact Match | Value from MySentinel (Column A "S. No.") - Close match | Value from IAG (Column D "Application Name" ) - Exact Match | Value from IAG (Column D "Application Name" ) - Close Match | Value from CM (Column A "Primary CI display name") - Exact Match | Value from CM (Column A "Primary CI display name") - Close Match | Value from DR Plans (Column B "Application Name") Exact Match | Value from DR Plans (Column B "Application Name") Close Match | Value from Incident Management (Column F "Description") - Exact Match | Value from Incident Management (Column F "Description") - Close Match | If Application Name not found in EAM, but found IAG, CM, and DR Plans found Classification equals Shadow IT   & "Reason for Classification" equals "No evidence of IT Governance for Enterprise Access Management (EAM)." ElseIf Application Name not found in CM and EMA, but found IAG, DR Plans found Classification equals Shadow IT   & "Reason for Classification" equals "No evidence of IT Governance for Change Management (CM) or  Enterprise Access Management (EAM)." ElseIf Application Name not found in CM, EAM, IAG, DR Plans not found, but found in CMDB Classification equals Shadow IT   & "Reason for Classification" equals "No evidence of IT Governance for Change Management (CM), Enterprise Access Management (EAM), Identity & Access Governance (IAG), or BCP/ IT Disaster Recovery." Else Application Name not found in CMDB, CM, EAM, IAG, DR Plans Classification equals Shadow   & "Reason for Classification" equals "The app/tool was not found in a (i.e [NAME]) No evidence of IT Governance for Change Management (CM), Enterprise Access Management (EAM), Identity & Access Governance (IAG), or BCP/ IT Disaster Recovery." | If Application Name not found in EAM, but found IAG, CM, and DR Plans found Classification equals Shadow IT   & "Reason for Classification" equals "No evidence of IT Governance for Enterprise Access Management (EAM)." ElseIf Application Name not found in CM and EMA, but found IAG, DR Plans found Classification equals Shadow IT   & "Reason for Classification" equals "No evidence of IT Governance for Change Management (CM) or  Enterprise Access Management (EAM)." ElseIf Application Name not found in CM, EAM, IAG, DR Plans not found, but found in CMDB Classification equals Shadow IT   & "Reason for Classification" equals "No evidence of IT Governance for Change Management (CM), Enterprise Access Management (EAM), Identity & Access Governance (IAG), or BCP/ IT Disaster Recovery." Else Application Name not found in CMDB, CM, EAM, IAG, DR Plans Classification equals Shadow   & "Reason for Classification" equals "The app/tool was not found in a (i.e [NAME]) No evidence of IT Governance for Change Management (CM), Enterprise Access Management (EAM), Identity & Access Governance (IAG), or BCP/ IT Disaster Recovery." | If Application Name found in CM, EAM, IAG, DR Plans, and CMDB equals Full Governance | If Application Name found in CM (Close), EAM (Close), IAG (Close), DR Plans (Close), and CMDB (Close) equals Full Governance (Maybe)