Microsoft Dynamics 365：Dynamics365安全與合規(guī)管理技術(shù)教程.Tex.header

MicrosoftDynamics365：Dynamics365安全與合規(guī)管理技術(shù)教程1理解Dynamics365安全與合規(guī)管理1.1安全與合規(guī)管理的重要性在當今數(shù)字化時代，企業(yè)數(shù)據(jù)的安全性和合規(guī)性成為了至關(guān)重要的議題。MicrosoftDynamics365作為一款全面的業(yè)務(wù)應(yīng)用平臺，其安全與合規(guī)管理功能確保了數(shù)據(jù)的保護和業(yè)務(wù)操作的合法性。這不僅關(guān)乎企業(yè)的聲譽，也直接影響到客戶信任和業(yè)務(wù)連續(xù)性。有效的安全與合規(guī)管理能夠幫助企業(yè)：防止數(shù)據(jù)泄露：通過嚴格的訪問控制和數(shù)據(jù)加密，保護敏感信息不被未授權(quán)訪問。確保法規(guī)遵從：遵守全球范圍內(nèi)的數(shù)據(jù)保護法規(guī)，如GDPR、HIPAA等，避免法律風險。提升客戶信任：透明的數(shù)據(jù)處理流程和強大的安全措施，增強客戶對企業(yè)的信任。優(yōu)化業(yè)務(wù)流程：通過自動化合規(guī)檢查和報告，減少手動操作，提高效率。1.2Dynamics365安全與合規(guī)管理概述MicrosoftDynamics365提供了多層次的安全與合規(guī)管理功能，涵蓋了用戶權(quán)限管理、數(shù)據(jù)保護、審計跟蹤、合規(guī)報告等方面。以下是一些關(guān)鍵的安全與合規(guī)管理特性：1.2.1用戶權(quán)限管理Dynamics365通過角色和權(quán)限的設(shè)置，確保用戶只能訪問其工作職責所需的數(shù)據(jù)和功能。例如，銷售經(jīng)理可以訪問銷售報告，但不能修改財務(wù)數(shù)據(jù)。示例：創(chuàng)建角色和分配權(quán)限#PowerShell示例：創(chuàng)建一個新角色并分配權(quán)限

$roleName="銷售經(jīng)理"

$permissions=@("ReadSalesData","WriteSalesData")

#創(chuàng)建角色

New-Role-Name$roleName-Permissions$permissions

#分配角色給用戶

$userId="12345678-9abc-def0-1234-56789abcdeff"

Set-User-Id$userId-Role$roleName1.2.2數(shù)據(jù)保護Dynamics365提供了數(shù)據(jù)加密、備份和恢復(fù)機制，以及數(shù)據(jù)泄露防護策略，確保數(shù)據(jù)在存儲和傳輸過程中的安全性。示例：啟用數(shù)據(jù)加密#PowerShell示例：啟用數(shù)據(jù)加密

Set-DataEncryption-Enable$true1.2.3審計跟蹤系統(tǒng)記錄所有關(guān)鍵操作的審計日志，幫助企業(yè)追蹤數(shù)據(jù)的訪問和修改歷史，這對于合規(guī)性和安全事件的調(diào)查至關(guān)重要。示例：查詢審計日志--SQL查詢示例：查詢特定用戶對數(shù)據(jù)的訪問記錄

SELECT*FROMAuditLog

WHEREUserId='12345678-9abc-def0-1234-56789abcdeff'

ANDAction='DataAccess'

ANDDateBETWEEN'2023-01-01'AND'2023-01-31'1.2.4合規(guī)報告Dynamics365支持生成合規(guī)報告，幫助企業(yè)證明其遵守了特定的法規(guī)要求，如GDPR、SOX等。示例：生成GDPR合規(guī)報告#PowerShell示例：生成GDPR合規(guī)報告

$reportName="GDPRComplianceReport"

$startDate="2023-01-01"

$endDate="2023-01-31"

#生成報告

New-ComplianceReport-Name$reportName-Type"GDPR"-StartDate$startDate-EndDate$endDate1.2.5自動化合規(guī)檢查系統(tǒng)可以自動執(zhí)行合規(guī)檢查，如數(shù)據(jù)分類、敏感信息掃描等，減少人工錯誤，提高合規(guī)性。示例：設(shè)置自動化合規(guī)檢查//JSON配置示例：設(shè)置自動化合規(guī)檢查

{

"checkType":"DataClassification",

"schedule":"Monthly",

"scope":"AllCustomerData",

"actions":[

{

"type":"Notify",

"recipients":["compliance@"]

},

{

"type":"Encrypt",

"dataTypes":["CreditCard","PersonalInformation"]

}

]

}通過以上特性，MicrosoftDynamics365為企業(yè)提供了全面的安全與合規(guī)管理解決方案，幫助企業(yè)構(gòu)建安全、合規(guī)的業(yè)務(wù)環(huán)境。2設(shè)置Dynamics365安全策略2.1創(chuàng)建角色和權(quán)限在MicrosoftDynamics365中，角色和權(quán)限是管理用戶訪問和操作的關(guān)鍵組件。通過創(chuàng)建角色和分配權(quán)限，可以確保用戶只能訪問他們工作所需的數(shù)據(jù)和功能，從而增強系統(tǒng)的安全性。2.1.1角色角色是權(quán)限的集合，定義了用戶在系統(tǒng)中可以執(zhí)行的操作。例如，銷售經(jīng)理角色可能包括訪問銷售報告、管理銷售團隊和創(chuàng)建銷售機會的權(quán)限。創(chuàng)建角色登錄到Dynamics365，進入系統(tǒng)設(shè)置。選擇“安全”>“角色”。點擊“新建”，輸入角色名稱和描述。選擇“業(yè)務(wù)單元”或“組織”作為角色的范圍。在權(quán)限選項卡中，勾選所需的功能權(quán)限。2.1.2權(quán)限權(quán)限決定了用戶在特定實體或功能上的操作能力，如讀取、創(chuàng)建、編輯或刪除記錄。分配權(quán)限在角色編輯界面，選擇“權(quán)限”選項卡。從實體列表中選擇一個實體，如“聯(lián)系人”。在權(quán)限設(shè)置中，勾選“讀取”、“創(chuàng)建”、“編輯”或“刪除”等權(quán)限。保存角色設(shè)置。2.2配置安全組和團隊安全組和團隊是Dynamics365中用于管理用戶和角色的另一種方式。安全組可以包含多個用戶，而團隊則可以包含用戶和安全組，提供更靈活的權(quán)限管理。2.2.1安全組安全組用于將具有相似權(quán)限需求的用戶分組。例如，所有銷售團隊成員可以被放入一個安全組，以簡化權(quán)限分配。創(chuàng)建安全組登錄到Dynamics365，進入系統(tǒng)設(shè)置。選擇“安全”>“安全組”。點擊“新建”，輸入安全組名稱和描述。選擇“業(yè)務(wù)單元”或“組織”作為安全組的范圍。在“成員”選項卡中，添加用戶到安全組。保存安全組設(shè)置。2.2.2團隊團隊可以包含用戶和安全組，提供更復(fù)雜的權(quán)限管理結(jié)構(gòu)。例如，一個銷售團隊可能包含銷售經(jīng)理和銷售代表，以及一個銷售安全組。創(chuàng)建團隊登錄到Dynamics365，進入系統(tǒng)設(shè)置。選擇“團隊”。點擊“新建”，輸入團隊名稱和描述。在“成員”選項卡中，添加用戶或安全組到團隊。保存團隊設(shè)置。2.2.3分配角色到安全組和團隊在安全組或團隊的編輯界面，選擇“角色”選項卡。從角色列表中選擇一個或多個角色。點擊“添加”以分配角色到安全組或團隊。保存設(shè)置。通過以上步驟，可以有效地設(shè)置Dynamics365的安全策略，確保數(shù)據(jù)的安全性和合規(guī)性。在實際操作中，可能需要根據(jù)組織的具體需求和結(jié)構(gòu)，調(diào)整角色、權(quán)限、安全組和團隊的設(shè)置，以達到最佳的安全管理效果。請注意，上述步驟和描述是基于Dynamics365的通用操作流程，具體界面和選項可能因版本和部署類型的不同而有所變化。在進行實際操作時，建議參考最新的官方文檔或指南。3數(shù)據(jù)保護與隱私3.1數(shù)據(jù)加密技術(shù)數(shù)據(jù)加密是保護數(shù)據(jù)安全的關(guān)鍵技術(shù)之一，它通過算法將原始數(shù)據(jù)（明文）轉(zhuǎn)換為不可讀的格式（密文），確保即使數(shù)據(jù)被未授權(quán)訪問，也無法被理解。在MicrosoftDynamics365中，數(shù)據(jù)加密技術(shù)被廣泛應(yīng)用于各種場景，以增強數(shù)據(jù)的安全性和隱私保護。3.1.1對稱加密對稱加密使用相同的密鑰進行加密和解密。這種加密方式速度快，適用于大量數(shù)據(jù)的加密。例如，使用AES（AdvancedEncryptionStandard）算法：fromCrypto.CipherimportAES

fromCrypto.Randomimportget_random_bytes

#生成一個16字節(jié)的密鑰

key=get_random_bytes(16)

#創(chuàng)建AES加密器

cipher=AES.new(key,AES.MODE_EAX)

#需要加密的數(shù)據(jù)

data="ThisisasecretmessageforDynamics365"

#加密數(shù)據(jù)

ciphertext,tag=cipher.encrypt_and_digest(data.encode('utf-8'))

#打印加密后的數(shù)據(jù)

print(ciphertext)

#解密數(shù)據(jù)

cipher=AES.new(key,AES.MODE_EAX,nonce=cipher.nonce)

plaintext=cipher.decrypt(ciphertext)

#打印解密后的數(shù)據(jù)

print(plaintext.decode('utf-8'))3.1.2非對稱加密非對稱加密使用一對密鑰，公鑰用于加密，私鑰用于解密。這種加密方式安全性更高，適用于密鑰交換和數(shù)字簽名。例如，使用RSA算法：fromCrypto.PublicKeyimportRSA

fromCrypto.CipherimportPKCS1_OAEP

#生成RSA密鑰對

key=RSA.generate(2048)

private_key=key.export_key()

public_key=key.publickey().export_key()

#創(chuàng)建RSA加密器

cipher_rsa=PKCS1_OAEP.new(RSA.import_key(public_key))

#需要加密的數(shù)據(jù)

data="ThisisasecretmessageforDynamics365"

#加密數(shù)據(jù)

encrypted_data=cipher_rsa.encrypt(data.encode('utf-8'))

#打印加密后的數(shù)據(jù)

print(encrypted_data)

#創(chuàng)建RSA解密器

cipher_rsa=PKCS1_OAEP.new(RSA.import_key(private_key))

#解密數(shù)據(jù)

decrypted_data=cipher_rsa.decrypt(encrypted_data)

#打印解密后的數(shù)據(jù)

print(decrypted_data.decode('utf-8'))3.2隱私設(shè)置與GDPR合規(guī)3.2.1隱私設(shè)置MicrosoftDynamics365提供了豐富的隱私設(shè)置，以幫助組織遵守GDPR（GeneralDataProtectionRegulation）和其他數(shù)據(jù)保護法規(guī)。這些設(shè)置包括但不限于：數(shù)據(jù)主體權(quán)利請求管理：允許數(shù)據(jù)主體請求訪問、更正、刪除或限制其個人數(shù)據(jù)的處理。數(shù)據(jù)保留和刪除策略：根據(jù)數(shù)據(jù)類型和業(yè)務(wù)需求，設(shè)置自動保留和刪除數(shù)據(jù)的規(guī)則。數(shù)據(jù)最小化：確保只收集和處理完成業(yè)務(wù)目的所必需的個人數(shù)據(jù)。數(shù)據(jù)訪問和審計：記錄和監(jiān)控對個人數(shù)據(jù)的訪問，確保只有授權(quán)人員可以訪問。3.2.2GDPR合規(guī)GDPR是歐盟制定的一項數(shù)據(jù)保護法規(guī)，旨在保護個人數(shù)據(jù)和隱私。MicrosoftDynamics365通過以下方式支持GDPR合規(guī)：數(shù)據(jù)映射和分類：識別和分類個人數(shù)據(jù)，以便更好地管理和保護。數(shù)據(jù)主體權(quán)利請求工具：提供工具以響應(yīng)數(shù)據(jù)主體的權(quán)利請求，如訪問、更正和刪除數(shù)據(jù)。數(shù)據(jù)保護影響評估（DPIA）：幫助組織評估數(shù)據(jù)處理活動的風險，并采取適當?shù)陌踩胧?。?shù)據(jù)泄露通知：在發(fā)生數(shù)據(jù)泄露時，及時通知受影響的個人和監(jiān)管機構(gòu)。3.2.3示例：數(shù)據(jù)主體權(quán)利請求處理在MicrosoftDynamics365中，處理數(shù)據(jù)主體權(quán)利請求通常涉及以下步驟：接收請求：通過電子郵件或在線表單接收數(shù)據(jù)主體的權(quán)利請求。驗證請求：確認請求來自數(shù)據(jù)主體本人或其授權(quán)代表。處理請求：根據(jù)請求類型（訪問、更正、刪除等），執(zhí)行相應(yīng)的操作。記錄請求：在系統(tǒng)中記錄請求的處理情況，以備審計。通知請求者：完成請求處理后，通知數(shù)據(jù)主體。#示例代碼：處理數(shù)據(jù)主體的訪問請求

defhandle_access_request(request_id):

#從數(shù)據(jù)庫中獲取請求者的所有個人數(shù)據(jù)

data=get_data_from_database(request_id)

#準備數(shù)據(jù)報告

report=prepare_data_report(data)

#發(fā)送報告給請求者

send_report_to_requester(report)

#示例代碼：處理數(shù)據(jù)主體的刪除請求

defhandle_deletion_request(request_id):

#從數(shù)據(jù)庫中刪除請求者的所有個人數(shù)據(jù)

delete_data_from_database(request_id)

#記錄刪除操作

log_deletion(request_id)

#通知請求者數(shù)據(jù)已被刪除

notify_requester_of_deletion(request_id)以上代碼示例展示了如何處理數(shù)據(jù)主體的訪問和刪除請求，但實際操作中需要根據(jù)MicrosoftDynamics365的具體API和功能進行調(diào)整。4MicrosoftDynamics365:審計與監(jiān)控4.1審計日志的使用在MicrosoftDynamics365中，審計日志是跟蹤和記錄系統(tǒng)中所有關(guān)鍵操作的重要工具。這包括但不限于數(shù)據(jù)更改、用戶登錄、系統(tǒng)配置更改等。審計日志對于確保數(shù)據(jù)安全、合規(guī)性和進行故障排除至關(guān)重要。4.1.1啟用審計日志要啟用審計日志，您需要訪問Dynamics365的系統(tǒng)設(shè)置。在“設(shè)置”>“系統(tǒng)設(shè)置”>“審計”中，您可以選擇要審計的實體和操作類型。例如，如果您想審計所有關(guān)于客戶賬戶的更改，您可以在實體列表中選擇“賬戶”，并勾選“創(chuàng)建”、“更新”和“刪除”操作。4.1.2查看審計日志一旦審計日志被啟用，您可以通過“高級查找”或使用PowerQuery來查看和分析這些日志。例如，使用PowerQuery，您可以從Dynamics365中提取審計日志數(shù)據(jù)，并在Excel中進行進一步分析。-**步驟1**:打開Excel并創(chuàng)建一個新的PowerQuery。

-**步驟2**:從Dynamics365中獲取數(shù)據(jù)，選擇“審計日志”作為數(shù)據(jù)源。

-**步驟3**:使用PowerQuery的“轉(zhuǎn)換”和“加載”功能來清洗和格式化數(shù)據(jù)。

-**步驟4**:將數(shù)據(jù)加載到Excel中，進行分析或創(chuàng)建報告。4.1.3示例：使用PowerQuery提取審計日志let

Source=OData.Feed("/api/data/v9.1/AuditDetail",[Headers=[#"Authorization"="Beareryourtoken"]]),

#"ConvertedtoTable"=Table.FromList(Source,Splitter.SplitByNothing(),null,null,ExtraValues.Error),

#"ExpandedValue"=Table.ExpandRecordColumn(#"ConvertedtoTable","value",{"AuditDetailId","AuditDetailName","AuditDetailRecordId","AuditDetailRecordName","AuditDetailRecordType","AuditDetailRecordTypeCode","AuditDetailRecordTypeDisplayName","AuditDetailRecordTypeFriendlyName","AuditDetailRecordTypeLogicalName","AuditDetailRecordTypeSchemaName","AuditDetailRecordTypeUniqueName","AuditDetailRecordTypeVersion","AuditDetailRecordTypeVersionId","AuditDetailRecordTypeVersionName","AuditDetailRecordTypeVersionNumber","AuditDetailRecordTypeVersionPublisher","AuditDetailRecordTypeVersionSolutionId","AuditDetailRecordTypeVersionSolutionName","AuditDetailRecordTypeVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher"},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName","AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher"}),

#"ChangedTypeNames"=Table.TransformColumnTypes(#"ExpandedValue",{{"AuditDetailId",typetext},{"AuditDetailName",typetext},{"AuditDetailRecordId",typetext},{"AuditDetailRecordName",typetext},{"AuditDetailRecordType",typetext},{"AuditDetailRecordTypeCode",typenumber},{"AuditDetailRecordTypeDisplayName",typetext},{"AuditDetailRecordTypeFriendlyName",typetext},{"AuditDetailRecordTypeLogicalName",typetext},{"AuditDetailRecordTypeSchemaName",typetext},{"AuditDetailRecordTypeUniqueName",typetext},{"AuditDetailRecordTypeVersion",typetext},{"AuditDetailRecordTypeVersionId",typetext},{"AuditDetailRecordTypeVersionName",typetext},{"AuditDetailRecordTypeVersionNumber",typenumber},{"AuditDetailRecordTypeVersionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionId",typetext},{"AuditDetailRecordTypeVersionSolutionName",typetext},{"AuditDetailRecordTypeVersionSolutionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersion",typetext},{"AuditDetailRecordTypeVersionSolutionVersionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersion",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersion",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersion",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionPublisher",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionId",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolutionName",typetext},{"AuditDetailRecordTypeVersionSolutionVersionSolutionVersionSolutionVersionSolutionVersionSolu