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

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

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

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

#創(chuàng)建角色

New-Role-Name$roleName-Permissions$permissions

#分配角色給用戶(hù)

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

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

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

SELECT*FROMAuditLog

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

ANDAction='DataAccess'

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

$reportName="GDPRComplianceReport"

$startDate="2023-01-01"

$endDate="2023-01-31"

#生成報(bào)告

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

{

"checkType":"DataClassification",

"schedule":"Monthly",

"scope":"AllCustomerData",

"actions":[

{

"type":"Notify",

"recipients":["compliance@"]

},

{

"type":"Encrypt",

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

}

]

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

fromCrypto.Randomimportget_random_bytes

#生成一個(gè)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非對(duì)稱(chēng)加密非對(duì)稱(chēng)加密使用一對(duì)密鑰，公鑰用于加密，私鑰用于解密。這種加密方式安全性更高，適用于密鑰交換和數(shù)字簽名。例如，使用RSA算法：fromCrypto.PublicKeyimportRSA

fromCrypto.CipherimportPKCS1_OAEP

#生成RSA密鑰對(duì)

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

defhandle_access_request(request_id):

#從數(shù)據(jù)庫(kù)中獲取請(qǐng)求者的所有個(gè)人數(shù)據(jù)

data=get_data_from_database(request_id)

#準(zhǔn)備數(shù)據(jù)報(bào)告

report=prepare_data_report(data)

#發(fā)送報(bào)告給請(qǐng)求者

send_report_to_requester(report)

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

defhandle_deletion_request(request_id):

#從數(shù)據(jù)庫(kù)中刪除請(qǐng)求者的所有個(gè)人數(shù)據(jù)

delete_data_from_database(request_id)

#記錄刪除操作

log_deletion(request_id)

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

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

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

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

-**步驟4**:將數(shù)據(jù)加載到Excel中，進(jìn)行分析或創(chuàng)建報(bào)告。4.1.3示例：使用PowerQuery提取審計(jì)日志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