D365FOLBDAdmin.psm1
|
$script:ModuleRoot = $PSScriptRoot $script:ModuleVersion = (Import-PowerShellDataFile -Path "$($script:ModuleRoot)\D365FOLBDAdmin.psd1").ModuleVersion # Detect whether at some level dotsourcing was enforced $script:doDotSource = Get-PSFConfigValue -FullName D365FOLBDAdmin.Import.DoDotSource -Fallback $false if ($D365FOLBDAdmin_dotsourcemodule) { $script:doDotSource = $true } <# Note on Resolve-Path: All paths are sent through Resolve-Path/Resolve-PSFPath in order to convert them to the correct path separator. This allows ignoring path separators throughout the import sequence, which could otherwise cause trouble depending on OS. Resolve-Path can only be used for paths that already exist, Resolve-PSFPath can accept that the last leaf my not exist. This is important when testing for paths. #> # Detect whether at some level loading individual module files, rather than the compiled module was enforced $importIndividualFiles = Get-PSFConfigValue -FullName D365FOLBDAdmin.Import.IndividualFiles -Fallback $false if ($D365FOLBDAdmin_importIndividualFiles) { $importIndividualFiles = $true } if (Test-Path (Resolve-PSFPath -Path "$($script:ModuleRoot)\..\.git" -SingleItem -NewChild)) { $importIndividualFiles = $true } if ("<was compiled>" -eq '<was not compiled>') { $importIndividualFiles = $true } function Import-ModuleFile { <# .SYNOPSIS Loads files into the module on module import. .DESCRIPTION This helper function is used during module initialization. It should always be dotsourced itself, in order to proper function. This provides a central location to react to files being imported, if later desired .PARAMETER Path The path to the file to load .EXAMPLE PS C:\> . Import-ModuleFile -File $function.FullName Imports the file stored in $function according to import policy #> [CmdletBinding()] Param ( [string] $Path ) $resolvedPath = $ExecutionContext.SessionState.Path.GetResolvedPSPathFromPSPath($Path).ProviderPath if ($doDotSource) { . $resolvedPath } else { $ExecutionContext.InvokeCommand.InvokeScript($false, ([scriptblock]::Create([io.file]::ReadAllText($resolvedPath))), $null, $null) } } #region Load individual files if ($importIndividualFiles) { # Execute Preimport actions . Import-ModuleFile -Path "$ModuleRoot\internal\scripts\preimport.ps1" # Import all internal functions foreach ($function in (Get-ChildItem "$ModuleRoot\internal\functions" -Filter "*.ps1" -Recurse -ErrorAction Ignore)) { . Import-ModuleFile -Path $function.FullName } # Import all public functions foreach ($function in (Get-ChildItem "$ModuleRoot\functions" -Filter "*.ps1" -Recurse -ErrorAction Ignore)) { . Import-ModuleFile -Path $function.FullName } # Execute Postimport actions . Import-ModuleFile -Path "$ModuleRoot\internal\scripts\postimport.ps1" # End it here, do not load compiled code below return } #endregion Load individual files #region Load compiled code <# This file loads the strings documents from the respective language folders. This allows localizing messages and errors. Load psd1 language files for each language you wish to support. Partial translations are acceptable - when missing a current language message, it will fallback to English or another available language. #> Import-PSFLocalizedString -Path "$($script:ModuleRoot)\en-us\*.psd1" -Module 'D365FOLBDAdmin' -Language 'en-US' function Connect-ServiceFabricAutomatic { <# .SYNOPSIS todo not working yet .DESCRIPTION Connect-ServiceFabricAutomatic .EXAMPLE Connect-ServiceFabricAutomatic .EXAMPLE Connect-ServiceFabricAutomatic .PARAMETER Config optional custom object generated from Get-D365LBDConfig #> param ( [Parameter(Mandatory = $false)] [psobject]$Config, [string]$SFServerCertificate, [string]$SFConnectionEndpoint ) begin {} process { try { if (Get-Command Connect-ServiceFabricCluster -ErrorAction Stop) { } else { Write-PSFMessage -Level Error Message "Error: Service Fabric Powershell module not installed" } } catch { Stop-PSFFunction -Message "Error: Service Fabric Powershell module not installed" -EnableException $true -Cmdlet $PSCmdlet } if ((!$Config) -and (!$SFServerCertificate) -and (!$SFConnectionEndpoint)) { Write-PSFMessage -Message "No paramters selected will try and get config" -Level Verbose $Config = Get-D365LBDConfig $SFConnectionEndpoint = $config.SFConnectionEndpoint $SFServerCertificate = $config.SFServerCertificate } $SFServiceCert = Get-ChildItem "Cert:\localmachine\my" | Where-Object { $_.Thumbprint -eq $SFServerCertificate } if (!$SFServiceCert) { $SFServiceCert = Get-ChildItem "Cert:CurrentUser\my" | Where-Object { $_.Thumbprint -eq $SFServerCertificate } if ($SFServiceCert) { $CurrentUser = 'true' } } if (!$SFServiceCert) { Stop-PSFFunction -Message "Error: Can't Find SFServerCertificate $SFServerCertificate" -EnableException $true -Cmdlet $PSCmdlet } else { Write-PSFMessage -Level Verbose -Message "$SFServiceCert" } $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $SFConnectionEndpoint -X509Credential -FindType FindByThumbprint -FindValue $SFServerCertificate -ServerCertThumbprint $SFServerCertificate -StoreLocation LocalMachine -StoreName My if ($CurrentUser -eq 'true') { Write-PSFMessage -Message "Using Current User Certificate Store" -Level Verbose $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $SFConnectionEndpoint -X509Credential -FindType FindByThumbprint -FindValue $SFServerCertificate -ServerCertThumbprint $SFServerCertificate -StoreLocation CurrentUser -StoreName My } if (!$connection) { $connection = Connect-ServiceFabricCluster } $connection } end {} } <# Source: https://stackoverflow.com/questions/8423541/how-do-you-run-a-sql-server-query-from-powershell #> function Invoke-SQL { param( [string] $dataSource = ".\SQLEXPRESS", [string] $database = "MasterData", [string] $sqlCommand = $(throw "Please specify a query.") ) $connectionString = "Data Source=$dataSource; " + "Integrated Security=SSPI; " + "Initial Catalog=$database" $connection = new-object system.data.SqlClient.SQLConnection($connectionString) $command = new-object system.data.sqlclient.sqlcommand($sqlCommand,$connection) $connection.Open() $adapter = New-Object System.Data.sqlclient.sqlDataAdapter $command $dataset = New-Object System.Data.DataSet $adapter.Fill($dataSet) | Out-Null $connection.Close() $dataSet.Tables } ##CREDIT https://stackoverflow.com/questions/8800375/merging-hashtables-in-powershell-how Function Merge-Hashtables([ScriptBlock]$Operator) { $Output = @{} ForEach ($Hashtable in $Input) { If ($Hashtable -is [Hashtable]) { ForEach ($Key in $Hashtable.Keys) {$Output.$Key = If ($Output.ContainsKey($Key)) {@($Output.$Key) + $Hashtable.$Key} Else {$Hashtable.$Key}} } } If ($Operator) {ForEach ($Key in @($Output.Keys)) {$_ = @($Output.$Key); $Output.$Key = Invoke-Command $Operator}} $Output } function Add-D365LBDDatabaseDetailsandCert { <# .SYNOPSIS Adds the Encipherment Cert into the D365 Servers for the configuration of the local business data environment. .DESCRIPTION Adds the Encipherment Cert into the D365 Servers for the configuration of the local business data environment. This is to help with adding additional details in the config lookup for continued automation. .EXAMPLE Add-D365LBDDataEnciphermentCertConfig -Thumbprint "1243asd234213" -DatabaseServerNames 'DatabaseServerName01' Will get add the thumbprint to the environments config (AX SF servers) this would be a non database clustered environment (always-on in most cases) .EXAMPLE Add-D365LBDDataEnciphermentCertConfig -Thumbprint "1243asd234213" -Clustered -DatabaseServerNames ('DatabaseServerName01','DatabaseServerName02') Will get add the thumbprint to the environments config (AX SF servers) this would be a non database clustered environment (always-on in most cases) .EXAMPLE Add-D365LBDDataEnciphermentCertConfig -Config $config -Thumbprint "1243asd234213" -Clustered -DatabaseServerNames ('DatabaseServerName01','DatabaseServerName02') Will get add the thumbprint to the environments config (AX SF servers) this would be a non database clustered environment (always-on in most cases) .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Clustered Switch Turn this switch on if it is a clustered database environment. .PARAMETER DatabaseServerNames String Array Name of Database Server(s) .PARAMETER Thumbprint String Thumbprint of encryption certificate used to encrypt the database server connections .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [alias("Add-D365DatabaseDetailsandCert")] [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName='NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [switch]$Clustered, [Parameter(Mandatory = $True)] [string[]]$DatabaseServerNames, [Parameter(Mandatory = $True)] [string]$Thumbprint, [Parameter(ParameterSetName='Config', ValueFromPipeline = $True)] [psobject]$Config ) BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } foreach ($server in $Config.AllAppServerList) { if ($Clustered) { if (Test-path \\$server\c$\ProgramData\SF\DatabaseDetailsandCert.txt) { Write-PSFMessage -Level Warning -Message "\\$server\c$\ProgramData\SF\DatabaseDetailsandCert.txt already exists overwriting" } "Clustered" | Out-file \\$server\c$\ProgramData\SF\DatabaseDetailsandCert.txt -Force Write-PSFMessage -Level Verbose "Clustered Selected make sure you entered in all database server names in other parameter" } else { "NotClustered" | Out-file \\$server\c$\ProgramData\SF\DatabaseDetailsandCert.txt -Force } $Thumbprint | Out-file \\$server\c$\ProgramData\SF\DatabaseDetailsandCert.txt -append foreach ($DatabaseServerName in $DatabaseServerNames){ $DatabaseServerName | Out-file \\$server\c$\ProgramData\SF\DatabaseDetailsandCert.txt -append } } Write-PSFMessage -Level Verbose "c:\ProgramData\SF\DatabaseDetailsandCert.txt created/updated" } END { } } function Add-D365LBDDataEnciphermentCertConfig { <# .SYNOPSIS Adds the Encipherment Cert into the D365 Servers for the configuration of the local business data environment. .DESCRIPTION Adds the Encipherment Cert into the D365 Servers for the configuration of the local business data environment. Will be grabbed by the Get-D365LBDConfig after this command is ran. .EXAMPLE Add-D365LBDDataEnciphermentCertConfig -Thumbprint "1243asd234213" Will get config from the local machine. .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Thumbprint String The thumbprint of the DataEncipherment certificate. .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [alias("Add-D365DataEnciphermentCertConfig")] [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(Mandatory = $True)] [string]$Thumbprint, [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config ) ##Gather Information from the Dynamics 365 Orchestrator Server Config BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } foreach ($server in $Config.AllAppServerList) { $Thumbprint | Out-file \\$server\c$\ProgramData\SF\DataEnciphermentCert.txt } Write-PSFMessage -Level Verbose "c:\ProgramData\SF\DataEnciphermentCert.txt created/updated" } END { } } function Disable-D365LBDSFAppServers { <# .SYNOPSIS .DESCRIPTION .EXAMPLE Disable-D365LBDSFAppServers .EXAMPLE Disable-D365LBDSFAppServers -ComputerName "LBDServerName" -verbose .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [alias("Disable-D365SFAppServers")] [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [int]$Timeout = 600 ) ##Gather Information from the Dynamics 365 Orchestrator Server Config BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } [int]$count = 0 while (!$connection) { do { $OrchestratorServerName = $Config.OrchestratorServerNames | Select-Object -First 1 -Skip $count Write-PSFMessage -Message "Verbose: Reaching out to $OrchestratorServerName to try and connect to the service fabric" -Level Verbose $SFModuleSession = New-PSSession -ComputerName $OrchestratorServerName if (!$module) { $module = Import-Module -Name ServiceFabric -PSSession $SFModuleSession } Write-PSFMessage -Message "-ConnectionEndpoint $($config.SFConnectionEndpoint) -X509Credential -FindType FindByThumbprint -FindValue $($config.SFServerCertificate) -ServerCertThumbprint $($config.SFServerCertificate) -StoreLocation LocalMachine -StoreName My" -Level Verbose $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $config.SFConnectionEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.SFServerCertificate -ServerCertThumbprint $config.SFServerCertificate -StoreLocation LocalMachine -StoreName My if (!$connection) { $trialEndpoint = "https://$OrchestratorServerName" + ":198000" $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $trialEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.SFServerCertificate -ServerCertThumbprint $config.SFServerCertificate -StoreLocation LocalMachine -StoreName My } $count = $count + 1 if (!$connection) { Write-PSFMessage -Message "Count of servers tried $count" -Level Verbose } } until ($connection -or ($count -eq $($Config.OrchestratorServerNames).Count)) if (($count -eq $($Config.OrchestratorServerNames).Count) -and (!$connection)) { Stop-PSFFunction -Message "Error: Can't connect to Service Fabric" } } $AppNodes = get-servicefabricnode | Where-Object { ($_.NodeType -eq "AOSNodeType") -or ($_.NodeType -eq "MRType") -or ($_.NodeType -eq "ReportServerType") } $primarynodes = get-servicefabricnode | Where-Object { ($_.NodeType -eq "PrimaryNodeType") } if ($primarynodes.count -gt 0) { Stop-PSFFunction -Message "Error: Primary Node configuration not supported with enable or disable. Restart-D365LBDSFAppServers is supported." -EnableException $true -FunctionName $_ } foreach ($AppNode in $AppNodes) { Disable-ServiceFabricNode -NodeName $AppNode.NodeName -Intent RemoveData -force -timeoutsec 30 } Start-Sleep -Seconds 1 [int]$timeoutondisablecounter = 0 $nodestatus = Get-serviceFabricNode | Where-Object { $_.NodeStatus -eq 'Disabling' -and ($_.NodeType -eq "AOSNodeType") } do { $nodestatus = Get-serviceFabricNode | Where-Object { $_.NodeStatus -eq 'Disabling' -and ($_.NodeType -eq "AOSNodeType") } $timeoutondisablecounter = $timeoutondisablecounter + 5 Start-Sleep -Seconds 5 } until (!$nodestatus -or $nodestatus -eq 0 -or ($timeoutondisablecounter -gt $Timeout)) Write-PSFMessage -Message "All App Nodes Disabled" -Level VeryVerbose } END {} } function Enable-D365LBDSFAppServers { <# .SYNOPSIS .DESCRIPTION .EXAMPLE Enable-D365LBDSFAppServers .EXAMPLE Enable-D365LBDSFAppServers -ComputerName "LBDServerName" -verbose .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [alias("Enable-D365SFAppServers")] [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [int]$Timeout = 600 ) ##Gather Information from the Dynamics 365 Orchestrator Server Config BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName }[int]$count = 0 while (!$connection) { do { $OrchestratorServerName = $Config.OrchestratorServerNames | Select-Object -First 1 -Skip $count Write-PSFMessage -Message "Verbose: Reaching out to $OrchestratorServerName to try and connect to the service fabric" -Level Verbose $SFModuleSession = New-PSSession -ComputerName $OrchestratorServerName if (!$module) { $module = Import-Module -Name ServiceFabric -PSSession $SFModuleSession } Write-PSFMessage -Message "-ConnectionEndpoint $($config.SFConnectionEndpoint) -X509Credential -FindType FindByThumbprint -FindValue $($config.SFServerCertificate) -ServerCertThumbprint $($config.SFServerCertificate) -StoreLocation LocalMachine -StoreName My" -Level Verbose $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $config.SFConnectionEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.SFServerCertificate -ServerCertThumbprint $config.SFServerCertificate -StoreLocation LocalMachine -StoreName My if (!$connection) { $trialEndpoint = "https://$OrchestratorServerName" + ":198000" $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $trialEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.SFServerCertificate -ServerCertThumbprint $config.SFServerCertificate -StoreLocation LocalMachine -StoreName My } $count = $count + 1 if (!$connection) { Write-PSFMessage -Message "Count of servers tried $count" -Level Verbose } } until ($connection -or ($count -eq $($Config.OrchestratorServerNames).Count)) if (($count -eq $($Config.OrchestratorServerNames).Count) -and (!$connection)) { Stop-PSFFunction -Message "Error: Can't connect to Service Fabric" } } $AppNodes = Get-ServiceFabricNode | Where-Object { ($_.NodeType -eq "AOSNodeType") -or ($_.NodeType -eq "MRType") -or ($_.NodeType -eq "ReportServerType") } $primarynodes = Get-ServiceFabricNode | Where-Object { ($_.NodeType -eq "PrimaryNodeType") } if ($primarynodes.count -gt 0) { Stop-PSFFunction -Message "Error: Primary Node configuration not supported with enable or disable. Restart-D365LBDSFAppServers is supported." -EnableException $true -FunctionName $_ } foreach ($AppNode in $AppNodes) { Enable-ServiceFabricNode -NodeName $AppNode.NodeName } Start-Sleep -Seconds 1 [int]$timeoutondisablecounter = 0 $nodestatus = Get-ServiceFabricNode | Where-Object { $_.NodeStatus -eq 'Disabled' -and (($_.NodeType -eq "AOSNodeType") -or ($_.NodeType -eq "MRType")) } do { $nodestatus = Get-ServiceFabricNode | Where-Object { $_.NodeStatus -eq 'Disabled' -and (($_.NodeType -eq "AOSNodeType") -or ($_.NodeType -eq "MRType")) } $timeoutondisablecounter = $timeoutondisablecounter + 5 Start-Sleep -Seconds 5 } until (!$nodestatus -or $nodestatus -eq 0 -or ($timeoutondisablecounter -gt $Timeout)) Write-PSFMessage -Message "All App Nodes Enabled" -Level VeryVerbose } END {} } function Export-D365LBDAssetModuleVersion { <# .SYNOPSIS Looks inside the agent share extracts the version from the zip by using the custom module name. Puts an xml in root for easy idenitification .DESCRIPTION Exports .EXAMPLE Export-D365LBDAssetModuleVersion .EXAMPLE Export-D365LBDAssetModuleVersion .PARAMETER AgentShareLocation optional string The location of the Agent Share .PARAMETER CustomModuleName optional string The name of the custom module you will be using to capture the version number #> [alias("Export-D365FOLBDAssetModuleVersion", "Export-D365AssetModuleVersion")] param ( [Parameter(ParameterSetName = 'AgentShare')] [Alias('AgentShare')] [string]$AgentShareLocation, [string]$CustomModuleName, [Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config ) BEGIN { } PROCESS { if ($Config) { $AgentShareLocation = $Config.AgentShareLocation } if (!$AgentShareLocation) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly $AgentShareLocation = $Config.AgentShareLocation } Add-Type -AssemblyName System.IO.Compression.FileSystem $Filter = "*/Apps/AOS/AXServiceApp/AXSF/InstallationRecords/MetadataModelInstallationRecords/$CustomModuleName*.xml" $AssetFolders = Get-ChildItem "$AgentShareLocation\assets" | Where-Object { $_.Name -ne "topology.xml" -and $_.Name -ne "chk" } | Sort-Object LastWriteTime foreach ($AssetFolder in $AssetFolders ) { Write-PSFMessage -Message "Checking $AssetFolder" -Level Verbose $versionfile = $null $versionfilepath = $AssetFolder.FullName + "\$CustomModuleName*.xml" $versionfile = Get-ChildItem -Path $versionfilepath if (($null -eq $versionfile) -or !($versionfile)) { ##SpecificAssetFolder which will be output $SpecificAssetFolder = $AssetFolder.FullName ##StandAloneSetupZip path to the zip that will be looked into for the module $StandaloneSetupZip = Get-ChildItem $SpecificAssetFolder\*\*\Packages\*\StandaloneSetup.zip $zip = [System.IO.Compression.ZipFile]::OpenRead($StandaloneSetupZip) $count = $($zip.Entries | Where-Object { $_.FullName -like $Filter }).Count if ($count -eq 0) { Write-PSFMessage -Level Verbose -Message "Invalid Zip file or Module name $StandaloneSetupZip" } else { try { $zip.Entries | Where-Object { $_.FullName -like $Filter } | ForEach-Object { # extract the selected items from the ZIP archive # and copy them to the out folder $FileName = $_.Name [System.IO.Compression.ZipFileExtensions]::ExtractToFile($_, "$SpecificAssetFolder\$FileName") } -ErrorAction Continue } catch { Write-PSFMessage -Message "$_" -Level VeryVerbose } finally { $zip.Dispose() } ##Closes Zip ## $zip.Dispose() $NewfileWithoutVersionPath = $SpecificAssetFolder + "\$CustomModuleName.xml" Write-PSFMessage -Message "$SpecificAssetFolder\$FileName exported" -Level Verbose $NewfileWithoutVersion = Get-ChildItem "$NewfileWithoutVersionPath" if (!$NewfileWithoutVersion) { Write-PSFMessage -Message "Error Module not found" -ErrorAction Continue } [xml]$xml = Get-Content "$NewfileWithoutVersion" $Version = $xml.MetadataModelInstallationInfo.Version Rename-Item -Path $NewfileWithoutVersionPath -NewName "$CustomModuleName $Version.xml" -Verbose | Out-Null Write-PSFMessage -Message "$CustomModuleName $Version.xml exported" -Level Verbose Write-Output "$Version" } } } } END {} } function Export-D365LBDCertificates { <# .SYNOPSIS Need to rethink approach .DESCRIPTION Exports .EXAMPLE Export-D365LBDCertificates .EXAMPLE Export-D365LBDCertificates -exportlocation "C:/certs" -username Stefan -certthumbprint 'A5234656' .PARAMETER ExportLocation optional string The location where the certificates will export to. .PARAMETER Username optional string The username this will be protected to #> [alias("Export-D365Certificates")] param ( [Parameter(Mandatory = $true)] [string]$CertThumbprint, [Parameter(Mandatory = $true)] [string]$ExportLocation, [string]$Username ) BEGIN { } PROCESS { ##Export if (Test-Path -Path $ExportLocation -IsValid) { } else { mkdir $ExportLocation } if (!$Username) { $Username = whoami } try { Write-PSFMessage -Message "Trying to pull $CertThumbprint from LocalMachine My " -Level Verbose Get-ChildItem "Cert:\localmachine\my" | Where-Object { $_.Thumbprint -eq $CertThumbprint } | ForEach-Object -Process { Export-PfxCertificate -Cert $_ -FilePath $("$ExportLocation\" + $_.FriendlyName + ".pfx") -ProtectTo "$Username" } } catch { try { Write-PSFMessage -Message "Trying to pull $CertThumbprint from CurrentUser My " -Level Verbose Get-ChildItem "Cert:\CurrentUser\my" | Where-Object { $_.Thumbprint -eq $CertThumbprint } | ForEach-Object -Process { Export-PfxCertificate -Cert $_ -FilePath $("$ExportLocation\" + $_.FriendlyName + ".pfx") -ProtectTo "$Username" } } catch { Write-PSFMessage -Level Verbose "Can't Export Certificate" $_ } } } END { } } function Export-D365LBDConfigReport { <# .SYNOPSIS .DESCRIPTION .EXAMPLE Export-D365LBDConfigReport .EXAMPLE Export-D365LBDConfigReport -computername 'AXSFServer01' .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [alias("Export-D365ConfigReport")] [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName='Config', ValueFromPipeline = $True)] [psobject]$Config, [switch]$Detailed, [string]$ExportLocation,##mandatory [string]$CustomModuleName ) ##Gather Information from the Dynamics 365 Orchestrator Server Config BEGIN { } PROCESS { if (!$Config) { if ($CustomModuleName){ $Config = Get-D365LBDConfig -ComputerName $ComputerName -CustomModuleName $CustomModuleName } else{ $Config = Get-D365LBDConfig -ComputerName $ComputerName } } $html = "<html> <body>" $html += "<h1>$($Config.LCSEnvironmentName) </h1>" $html += "<p><b>Custom Code Version:</b></p> $($Config.CustomModuleVersion)" $html += "<p><b>AX Kernel Version:</b></p> $($Config.AOSKernelVersion) " $html += "<p><b>Environment ID:</b></p> $($config.LCSEnvironmentID)" $CountofAXServerNames = $Config.AXSFServerNames.Count $html += "<p><b>Amount of AX SF Servers:</b></p> $($CountofAXServerNames) </p>" if ($Detailed){ $html += "<b><p>AX SF Servers: </b></p> <ul>" foreach($axsfserver in $Config.AXSFServerNames) { $html += "<li>$axsfserver</li>" } $html += "</ul>" } $html += "<p><b>Number of Orchestrator Servers: </b> $($Config.OrchestratorServerNames.Count)</p>" if ($Detailed){ $html += "<p><b>Orchestrator Servers:</b></p> <ul>" foreach($AXOrchServerName in $Config.OrchestratorServerNames) { $html += "<li>$AXOrchServerName</li>" } $html += "</ul>" } $html += "<p><b>AX database is $($Config.DatabaseClusteredStatus)</p>" $html += "<p><b>Number of Database servers:</b> $($Config.DatabaseClusterServerNames.Count)</p>" $html += "<p><b>Database server(s):</b></p> <ul>" foreach($AXDBServerName in $($Config.DatabaseClusterServerNames)) { $html += "<li>$AXDBServerName</li>" } $html += "</ul>" $html += "<p><b>Local Agent Version: $($Config.OrchServiceLocalAgentVersionNumber)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.SFClientCertificateExpiresAfter)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.SFServerCertificateExpiresAfter)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.DataEncryptionCertificateExpiresAfter)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.DataSigningCertificateExpiresAfter)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.SessionAuthenticationCertificateExpiresAfter)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.SharedAccessSMBCertificateExpiresAfter)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.DataEnciphermentCertificateExpiresAfter)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.FinancialReportingCertificateExpiresAfter)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.ReportingSSRSCertificateExpiresAfter)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.DatabaseEncryptionCertificateExpiresAfter)</p>" $html += "<p><b>SF Client Cert Expires After:</b></p><p> $($Config.LocalAgentCertificateExpiresAfter)</p>" $html += "</body></html>" $html | Out-File "$ExportLocation" } END {} } function Get-D365LBDCertsFromConfig { <# .SYNOPSIS Grabs the certificatedetails from the config for easier export/analysis .DESCRIPTION Grabs the certificatedetails from the config for easier export/analysis .EXAMPLE Get-D365LBDCertsFromConfig .EXAMPLE Get-D365LBDCertsFromConfig -OnlyAdminCerts .PARAMETER Config optional psobject The configuration of D365 from the command Get-D365LBDConfig If ignored will use local host. .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [alias("Get-D365CertsFromConfig")] [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [string]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [switch]$OnlyAdminCerts ) ##Gather Information from the Dynamics 365 Orchestrator Server Config BEGIN { } PROCESS { $allCerts = $Config.PSObject.Properties | Where-Object { $_.name -like '*Cert*' -and $_.name -notlike '*ExpiresAfter*' } | Select-Object Name, value $admincerts = $allCerts | Where-Object { $_.name -eq "SFServerCertificate" -or $_.name -eq "SFClientCertificate" } if ($OnlyAdminCerts) { $admincerts } else { $allcerts } } END { } } function Get-D365LBDConfig { <# .SYNOPSIS Grabs the configuration of the local business data environment .DESCRIPTION Grabs the configuration of the local business data environment through logic using the Service Fabric Cluster XML, AXSF.Package.Current.xml and OrchestrationServicePkg.Package.Current.xml .EXAMPLE Get-D365LBDConfig Will get config from the local machine. .EXAMPLE Get-D365LBDConfig -ComputerName "LBDServerName" -verbose Will get the Dynamics 365 Config from the LBD server .PARAMETER ComputerName optional string The name of the Local Business Data Computer. If ignored will use local host. .PARAMETER ConfigImportFromFile optional string The name of the config file to import (if you are choosing to import rather than pull dynamically) .PARAMETER ConfigExportToFile optional string The name of the config file to export .PARAMETER CustomModuleName optional string The name of the custom module you will be using to caputre the version number .PARAMETER HighLevelOnly optional switch for quicker runs grab the config without verifying or grabbing additional details from the service fabric cluster #> [alias("Get-D365Config")] [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(Mandatory = $false)][string]$ConfigImportFromFile, [Parameter(Mandatory = $false)][string]$ConfigExportToFile, [Parameter(Mandatory = $false)][string]$CustomModuleName, [switch]$HighLevelOnly, [switch]$GetGuids ) ##Gather Information from the Dynamics 365 Orchestrator Server Config BEGIN { } PROCESS { Set-Location C:\ if ($ConfigImportFromFile) { Write-PSFMessage -Message "Warning: Importing config this data may not be the most up to date" -Level Warning if (-not (Test-Path $ConfigImportFromFile)) { Stop-PSFFunction -Message "Error: This config file doesn't exist. Stopping" -EnableException $true -Cmdlet $PSCmdlet } $Properties = Import-clixml -path $ConfigImportFromFile [PSCustomObject]$Properties } else { if ($ComputerName.IsLocalhost) { Write-PSFMessage -Message "Looking for the clusterconfig (Cluster Manifest) on the localmachine as no ComputerName provided" -Level Warning if ($(Test-Path "C:\ProgramData\SF\clusterManifest.xml") -eq $False) { Stop-PSFFunction -Message "Error: This is not an Local Business Data server or no config is found (import config if you have to). Stopping" -EnableException $true -Cmdlet $PSCmdlet } $ClusterManifestXMLFile = get-childitem "C:\ProgramData\SF\clusterManifest.xml" } else { Write-PSFMessage -Message "Connecting to admin share on $ComputerName for cluster config" -Level Verbose if ($(Test-Path "\\$ComputerName\C$\ProgramData\SF\clusterManifest.xml") -eq $False) { Stop-PSFFunction -Message "Error: This is not an Local Business Data server. Can't find Cluster Manifest. Stopping" -EnableException $true -Cmdlet $PSCmdlet } $ClusterManifestXMLFile = get-childitem "\\$ComputerName\C$\ProgramData\SF\clusterManifest.xml" } if (!($ClusterManifestXMLFile)) { Stop-PSFFunction -Message "Error: This is not an Local Business Data server or the application is not installed. Can't find Cluster Manifest. Stopping" -EnableException $true -Cmdlet $PSCmdlet } if ($(test-path $ClusterManifestXMLFile) -eq $false) { Stop-PSFFunction -Message "Error: This is not an Local Business Data server. Can't find Cluster Manifest. Stopping" -EnableException $true -Cmdlet $PSCmdlet } Write-PSFMessage -Message "Reading $ClusterManifestXMLFile" -Level Verbose [xml]$xml = get-content $ClusterManifestXMLFile $SFClusterCertificate = $(($($xml.ClusterManifest.FabricSettings.Section | Where-Object { $_.Name -eq "Security" })).Parameter | Where-Object { $_.Name -eq "ClusterCertThumbprints" }).value $OrchestratorServerNames = $($xml.ClusterManifest.Infrastructure.WindowsServer.NodeList.Node | Where-Object { $_.NodeTypeRef -contains 'OrchestratorType' }).NodeName $AXSFServerNames = $($xml.ClusterManifest.Infrastructure.WindowsServer.NodeList.Node | Where-Object { $_.NodeTypeRef -contains 'AOSNodeType' }).NodeName $ReportServerServerName = $($xml.ClusterManifest.Infrastructure.WindowsServer.NodeList.Node | Where-Object { $_.NodeTypeRef -contains 'ReportServerType' }).NodeName $ReportServerServerip = $($xml.ClusterManifest.Infrastructure.WindowsServer.NodeList.Node | Where-Object { $_.NodeTypeRef -contains 'ReportServerType' }).IPAddressOrFQDN if (($null -eq $OrchestratorServerNames) -or (!$OrchestratorServerNames)) { $OrchestratorServerNames = $($xml.ClusterManifest.Infrastructure.WindowsServer.NodeList.Node | Where-Object { $_.NodeTypeRef -contains 'PrimaryNodeType' }).NodeName $AXSFServerNames = $($xml.ClusterManifest.Infrastructure.WindowsServer.NodeList.Node | Where-Object { $_.NodeTypeRef -contains 'PrimaryNodeType' }).NodeName $ReportServerServerName = $($xml.ClusterManifest.Infrastructure.WindowsServer.NodeList.Node | Where-Object { $_.NodeTypeRef -contains 'ReportServerType' }).NodeName $ReportServerServerip = $($xml.ClusterManifest.Infrastructure.WindowsServer.NodeList.Node | Where-Object { $_.NodeTypeRef -contains 'ReportServerType' }).IPAddressOrFQDN } foreach ($OrchestratorServerName in $OrchestratorServerNames) { if (!$OrchServiceLocalAgentConfigXML) { Write-PSFMessage -Message "Verbose: Connecting to $OrchestratorServerName for Orchestrator config" -Level Verbose $OrchServiceLocalAgentConfigXML = get-childitem "\\$OrchestratorServerName\C$\ProgramData\SF\*\Fabric\work\Applications\LocalAgentType_App*\OrchestrationServicePkg.Package.Current.xml" } if (!$OrchServiceLocalAgentVersionNumber) { Write-PSFMessage -Message "Verbose: Connecting to $OrchestratorServerName for Orchestrator Local Agent version" -Level Verbose $OrchServiceLocalAgentVersionNumber = $(get-childitem "\\$OrchestratorServerName\C$\ProgramData\SF\*\Fabric\work\Applications\LocalAgentType_App*\OrchestrationServicePkg.Code.*\OrchestrationService.exe").VersionInfo.Fileversion } If (!$SFVersionNumber) { try { $SFVersionNumber = Invoke-Command -ScriptBlock { Get-ItemPropertyValue 'HKLM:\SOFTWARE\Microsoft\Service Fabric\' -Name FabricVersion } -ComputerName $OrchestratorServerName } Catch { Write-PSFMessage -Message "Warning: Can't get Service Fabric Version" -Level Warning } } } if (!$OrchServiceLocalAgentConfigXML) { Stop-PSFFunction -Message "Error: Can't find any Local Agent file on the Orchestrator Node" -EnableException $true -Cmdlet $PSCmdlet } Write-PSFMessage -Message "Reading $OrchServiceLocalAgentConfigXML" -Level Verbose [xml]$xml = get-content $OrchServiceLocalAgentConfigXML $RetrievedXMLData = $xml.ServicePackage.DigestedConfigPackage.ConfigOverride.Settings.Section | Where-Object { $_.Name -eq 'AAD' } $LocalAgentCertificate = ($RetrievedXMLData.Parameter | Where-Object { $_.Name -eq "ServicePrincipalThumbprint" }).value $RetrievedXMLData = $xml.ServicePackage.DigestedConfigPackage.ConfigOverride.Settings.Section | Where-Object { $_.Name -eq 'Data' } $OrchDBConnectionString = $RetrievedXMLData.Parameter $RetrievedXMLData = $xml.ServicePackage.DigestedConfigPackage.ConfigOverride.Settings.Section | Where-Object { $_.Name -eq 'Download' } $downloadfolderLocation = $RetrievedXMLData.Parameter $RetrievedXMLData = $xml.ServicePackage.DigestedConfigPackage.ConfigOverride.Settings.Section | Where-Object { $_.Name -eq 'ServiceFabric' } $ServiceFabricConnectionDetails = $RetrievedXMLData.Parameter $ClientCert = $($ServiceFabricConnectionDetails | Where-Object { $_.Name -eq "ClientCertificate" }).value $ClusterID = $($ServiceFabricConnectionDetails | Where-Object { $_.Name -eq "ClusterID" }).value $ConnectionEndpoint = $($ServiceFabricConnectionDetails | Where-Object { $_.Name -eq "ConnectionEndpoint" }).value $ServerCertificate = $($ServiceFabricConnectionDetails | Where-Object { $_.Name -eq "ServerCertificate" }).value ## With Orch Server config get more details for automation [int]$count = 1 $AXSFConfigServerName = $AXSFServerNames | Select-Object -First $count Write-PSFMessage -Message "Verbose: Reaching out to $AXSFConfigServerName for AX config" -Level Verbose $SFConfig = get-childitem "\\$AXSFConfigServerName\C$\ProgramData\SF\*\Fabric\work\Applications\AXSFType_App*\AXSF.Package.Current.xml" if (!$SFConfig) { $SFConfig = get-childitem "\\$AXSFConfigServerName\C$\ProgramData\SF\*\Fabric\work\Applications\AXSFType_App*\AXSF.Package.1.0.xml" } if (!$SFConfig) { do { $AXSFConfigServerName = $AXSFServerNames | Select-Object -First 1 -Skip $count Write-PSFMessage -Message "Verbose: Reaching out to $AXSFConfigServerName for AX config total servers $($AXSFServerNames.Count))" -Level Verbose $SFConfig = get-childitem "\\$AXSFConfigServerName\C$\ProgramData\SF\*\Fabric\work\Applications\AXSFType_App*\AXSF.Package.Current.xml" if (!$SFConfig) { $SFConfig = get-childitem "\\$AXSFConfigServerName\C$\ProgramData\SF\*\Fabric\work\Applications\AXSFType_App*\AXSF.Package.1.0.xml" } $count = $count + 1 Write-PSFMessage -Message "Count of servers tried $count" -Verbose } until ($SFConfig -or ($count -eq $AXSFServerNames.Count)) } if (!$SFConfig) { Write-PSFMessage -Message "Verbose: Can't find AX SF. App may not be installed. All values won't be grabbed" -Level Warning } else { [xml]$xml = get-content $SFConfig $DataAccess = $xml.ServicePackage.DigestedConfigPackage.ConfigOverride.Settings.Section | Where-Object { $_.Name -EQ 'DataAccess' } $AXDatabaseName = $($DataAccess.Parameter | Where-Object { $_.Name -eq 'Database' }).value $AXDatabaseServer = $($DataAccess.Parameter | Where-Object { $_.Name -eq 'DbServer' }).value $DataEncryptionCertificate = $($DataAccess.Parameter | Where-Object { $_.Name -eq 'DataEncryptionCertificateThumbprint' }).value $DataSigningCertificate = $($DataAccess.Parameter | Where-Object { $_.Name -eq 'DataSigningCertificateThumbprint' }).value $AAD = $xml.ServicePackage.DigestedConfigPackage.ConfigOverride.Settings.Section | Where-Object { $_.Name -EQ 'Aad' } $ClientURL = $($AAD.Parameter | Where-Object { $_.Name -eq 'AADValidAudience' }).value + "namespaces/AXSF/" $Infrastructure = $xml.ServicePackage.DigestedConfigPackage.ConfigOverride.Settings.Section | Where-Object { $_.Name -EQ 'Infrastructure' } $SessionAuthenticationCertificate = $($Infrastructure.Parameter | Where-Object { $_.Name -eq 'SessionAuthenticationCertificateThumbprint' }).value $SMBStorage = $xml.ServicePackage.DigestedConfigPackage.ConfigOverride.Settings.Section | Where-Object { $_.Name -EQ 'SmbStorage' } $SharedAccessSMBCertificate = $($SMBStorage.Parameter | Where-Object { $_.Name -eq 'SharedAccessThumbprint' }).value $sb = New-Object System.Data.Common.DbConnectionStringBuilder $sb.set_ConnectionString($($OrchDBConnectionString.Value)) $OrchDatabase = $sb.'initial catalog' $OrchdatabaseServer = $sb.'data source' } $AgentShareLocation = $downloadfolderLocation.Value $AgentShareWPConfigJson = Get-ChildItem "$AgentShareLocation\wp\*\StandaloneSetup-*\config.json" | Sort-Object { $_.CreationTime } | Select-Object -First 1 if ($AgentShareWPConfigJson) { Write-PSFMessage -Message "Verbose: Using AgentShare config at $AgentShareWPConfigJson to get Environment ID, EnvironmentName and TenantID." -Level Verbose $jsonconfig = get-content $AgentShareWPConfigJson $LCSEnvironmentId = $($jsonconfig | ConvertFrom-Json).environmentid $TenantID = $($jsonconfig | ConvertFrom-Json).tenantid $LCSEnvironmentName = $($jsonconfig | ConvertFrom-Json).environmentName } else { Write-PSFMessage -Message "Warning: Can't Find Config in WP folder can't get Environment ID or TenantID. All values won't be grabbed" -Level Warning $LCSEnvironmentId = "" $TenantID = "" $LCSEnvironmentName = "" } try { $reportconfig = Get-ChildItem "\\$ReportServerServerName\C$\ProgramData\SF\*\Fabric\work\Applications\ReportingService_*\ReportingBootstrapperPkg.Package.current.xml" [xml]$xml = Get-Content $reportconfig.FullName $Reportingconfigdetails = $xml.ServicePackage.DigestedConfigPackage.ConfigOverride.Settings.Section | Where-Object { $_.Name -EQ 'ReportingServices' } $ReportingSSRSCertificate = ($Reportingconfigdetails.parameter | Where-Object { $_.Name -eq "ReportingClientCertificateThumbprint" }).value } catch { try { $reportconfig = Get-ChildItem "\\$ReportServerServerName\C$\ProgramData\SF\*\Fabric\work\Applications\ReportingService_*\ReportingBootstrapperPkg.Package.1.0.xml" [xml]$xml = Get-Content $reportconfig.FullName $Reportingconfigdetails = $xml.ServicePackage.DigestedConfigPackage.ConfigOverride.Settings.Section | Where-Object { $_.Name -EQ 'ReportingServices' } $ReportingSSRSCertificate = ($Reportingconfigdetails.parameter | Where-Object { $_.Name -eq "ReportingClientCertificateThumbprint" }).value } catch { Write-PSFMessage -Level Warning -Message "Warning: Can't gather information from the Reporting Server $ReportServerServerName" } } $CustomModuleVersion = '' if (($CustomModuleName)) { try { $CustomModuleDll = get-childitem "\\$AXSFConfigServerName\C$\ProgramData\SF\*\Fabric\work\Applications\AXSFType_App*\AXSF.Code*\Packages\$CustomModuleName\bin\Dynamics.AX.$CustomModuleName.dll" if (-not (Test-Path $CustomModuleDll)) { Write-PSFMessage -Message "Warning: Custom Module not found; version unable to be found" -Level Warning } else { $CustomModuleVersion = $CustomModuleDll.VersionInfo.FileVersion } } catch {} } $AXServiceConfigXMLFile = get-childitem "\\$AXSFConfigServerName\C$\ProgramData\SF\*\Fabric\work\Applications\AXSFType_App*\AXSF.Code*\AXService.exe.config" | Sort-Object { $_.CreationTime } | Select-Object -First 1 Write-PSFMessage -Message "Reading $AXServiceConfigXMLFile" -Level Verbose if (!$AXServiceConfigXMLFile) { Write-PSFMessage -Message "Warning: AXSF doesnt seem installed; config cannot be found" -Level Warning } else { [xml]$AXServiceConfigXML = get-content $AXServiceConfigXMLFile } $AOSKerneldll = get-childitem "\\$AXSFConfigServerName\C$\ProgramData\SF\*\Fabric\work\Applications\AXSFType_App*\AXSF.Code*\bin\AOSKernel.dll" $AOSKernelVersion = $AOSKerneldll.VersionInfo.ProductVersion $jsonClusterConfig = get-content "\\$AXSFConfigServerName\C$\ProgramData\SF\clusterconfig.json" #$SFClusterCertificate = ($jsonClusterConfig | ConvertFrom-Json).properties.security.certificateinformation.clustercertificate.Thumbprint ## invalid if new deployment after $FinancialReportingCertificate = $($AXServiceConfigXML.configuration.claimIssuerRestrictions.issuerrestrictions.add | Where-Object { $_.alloweduserids -eq "FRServiceUser" }).name if (test-path $AgentShareLocation\scripts\D365FOLBDAdmin\AdditionalEnvironmentDetails.xml) { Write-PSFMessage -Level Verbose -Message "Found AdditionalEnvironmentDetails config" $EnvironmentAdditionalConfig = get-childitem "$AgentShareLocation\scripts\D365FOLBDAdmin\AdditionalEnvironmentDetails.xml" } else { Write-PSFMessage -Message "Warning: Can't find additional Environment Config. Not needed but recommend making one" -level warning } if ($EnvironmentAdditionalConfig) { Write-PSFMessage -Message "Reading $EnvironmentAdditionalConfig " -Level Verbose [xml]$EnvironmentAdditionalConfigXML = get-content $EnvironmentAdditionalConfig $EnvironmentType = $EnvironmentAdditionalConfigXML.D365LBDEnvironment.EnvironmentType.'#text'.Trim() $DatabaseClusterServerNames = $EnvironmentAdditionalConfigXML.D365LBDEnvironment.EnvironmentAdditionalConfig.SQLDetails.SQLServer | ForEach-Object -Process { New-Object -TypeName psobject -Property ` @{'DatabaseClusterServerNames' = $_.ServerName } } $DatabaseEncryptionThumbprints = $EnvironmentAdditionalConfigXML.D365LBDEnvironment.EnvironmentAdditionalConfig.SQLDetails.SQLServer | ForEach-Object -Process { New-Object -TypeName psobject -Property ` @{'DatabaseEncryptionCertificates' = $_.DatabaseEncryptionThumbprint } } $DatabaseEncryptionThumbprints = $DatabaseEncryptionThumbprints.DatabaseEncryptionThumprints $DatabaseClusterServerNames = $DatabaseClusterServerNames.DatabaseClusterServerNames } if ((test-path \\$ComputerName\c$\ProgramData\SF\DataEnciphermentCert.txt) -and !$EnvironmentAdditionalConfig) { Write-PSFMessage -Level Verbose -Message "Found DataEncipherment config" $DataEnciphermentCertificate = Get-Content \\$ComputerName\c$\ProgramData\SF\DataEnciphermentCert.txt } else { Write-PSFMessage -Level Warning -Message "Warning: No Encipherment Cert found run the function use Add-D365LBDDataEnciphermentCertConfig to add" } if ((test-path \\$ComputerName\c$\ProgramData\SF\DatabaseDetailsandCert.txt) -and !$EnvironmentAdditionalConfig) { $DatabaseDetailsandCertConfig = Get-Content \\$ComputerName\c$\ProgramData\SF\DatabaseDetailsandCert.txt Write-PSFMessage -Level Verbose -Message "Found DatabaseDetailsandCert config additional details added to config data" $DatabaseEncryptionCertificate = $DatabaseDetailsandCertConfig[1] $DatabaseClusteredStatus = $DatabaseDetailsandCertConfig[0] $DatabaseClusterServerNames = $DatabaseDetailsandCertConfig[2] } else { Write-PSFMessage -Level Warning -Message "Warning: No additional Database config Details found use Add-D365LBDDatabaseDetailsandCert to add" } ##checking for after deployment added servers try { $currentclustermanifestxmlfile = get-childitem "\\$AXSFConfigServerName\C$\ProgramData\SF\*\Fabric\clustermanifest.current.xml" | Sort-Object { $_.CreationTime } | Select-Object -First 1 [xml]$currentclustermanifestxml = Get-Content $currentclustermanifestxmlfile $AXSFServerListToCompare = $currentclustermanifestxml.clusterManifest.Infrastructure.NodeList.Node | Where-Object { $_.NodeTypeRef -eq 'AOSNodeType' -or $_.NodeTypeRef -eq 'PrimaryNodeType' } $SFClusterCertificate = $(($($currentclustermanifestxml.ClusterManifest.FabricSettings.Section | Where-Object { $_.Name -eq "Security" })).Parameter | Where-Object { $_.Name -eq "ClusterCertThumbprints" }).value foreach ($Node in $AXSFServerListToCompare) { if (($AXSFServerNames -contains $Node) -eq $false) { $AXSFServerNames += $Node } } } catch { Write-PSFMessage -Level Warning -Message "Warning: $_" } if ($HighLevelOnly) { Write-PSFMessage -Level Verbose -Message "High Level Only will not connect to service fabric" } else { try { Write-PSFMessage -Message "Trying to connect to $ConnectionEndpoint using $ServerCertificate" -Level Verbose $SFModuleSession = New-PSSession -ComputerName $OrchestratorServerName $module = Import-Module -Name ServiceFabric -PSSession $SFModuleSession $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $ConnectionEndpoint -X509Credential -FindType FindByThumbprint -FindValue $ServerCertificate -ServerCertThumbprint $ServerCertificate -StoreLocation LocalMachine -StoreName My if (!$connection) { try { $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $ConnectionEndpoint } catch { } } $NumberOfAppsinServicefabric = $($(get-servicefabricclusterhealth | select ApplicationHealthState).ApplicationHealthState.Count) - 1 $AggregatedSFState = get-servicefabricclusterhealth | select AggregatedHealthState $nodes = get-servicefabricnode | Where-Object { ($_.NodeType -eq "AOSNodeType") -or ($_.NodeType -eq "PrimaryNodeType") } Write-PSFMessage -message "Service Fabric connected. Grabbing nodes to validate status" -Level Verbose $appservers = $nodes.NodeName | Sort-Object $invalidsfnodes = get-servicefabricnode | Where-Object { ($_.NodeStatus -eq "Invalid") } $disabledsfnodes = get-servicefabricnode | Where-Object { ($_.NodeStatus -eq "Disabled") } $invalidnodes = $invalidsfnodes.NodeName | Sort-Object $disablednodes = $disabledsfnodes.NodeName | Sort-Object $invalidnodescount = $invalidnodes.count if (!$invalidnodes -and $invalidnodescount -ne 0 ) { Write-PSFMessage -Level Warning -Message "Warning: Invalid Node found. Suggest running Update-ServiceFabricD365ClusterConfig to help fix. $invalidnodes" } If ($GetGuids) { $ServiceFabricPartitionIdForAXSF = $(get-servicefabricpartition -servicename 'fabric:/AXSF/AXService').PartitionId foreach ($node in $nodes) { $nodename = $node.Nodename $replicainstanceIdofnode = $(get-servicefabricreplica -partition $ServiceFabricPartitionIdForAXSF | Where-Object { $_.NodeName -eq "$NodeName" }).InstanceId $ReplicaDetails = Get-Servicefabricreplicadetail -nodename $nodename -partitionid $ServiceFabricPartitionIdForAXSF -ReplicaOrInstanceId $replicainstanceIdofnode -replicatordetail $endpoints = $ReplicaDetails.deployedservicereplicainstance.address | ConvertFrom-Json $deployedinstancespecificguid = $($endpoints.Endpoints | Get-Member | Where-Object { $_.MemberType -eq "NoteProperty" }).Name $httpsurl = $endpoints.Endpoints.$deployedinstancespecificguid Write-PSFMessage -Level VeryVerbose -Message "$NodeName is accessible via $httpsurl with a guid $deployedinstancespecificguid " } } } catch { Write-PSFMessage -message "Can't connect to Service Fabric $_" -Level Verbose } $AXSFServersViaServiceFabricNodes = @() foreach ($NodeName in $appservers) { $AXSFServersViaServiceFabricNodes += $NodeName } $NewlyAddedAXSFServers = @() foreach ($Node in $AXSFServersViaServiceFabricNodes) { if (($AXSFServerNames -contains $Node) -eq $false) { Write-PSFMessage -Level Verbose -Message "Adding $Node to AXSFServerList " $AXSFServerNames += $Node $NewlyAddedAXSFServers += $Node } } [System.Collections.ArrayList]$AXSFActiveNodeList = $AXSFServerNames [System.Collections.ArrayList]$AXOrchActiveNodeList = $OrchestratorServerNames foreach ($Node in $invalidnodes) { if (($AXSFServerNames -contains $Node) -eq $true) { foreach ($AXSFNode in $AXSFServerNames) { Write-PSFMessage -Level Verbose -Message "Found the Invalid SF Node $Node in AXSFServerList. Removing from list. Use Update-ServiceFabricD365ClusterConfig to get a headstart on fixing. " $AXSFActiveNodeList.Remove($node) } } if (($OrchestratorServerNames -contains $Node) -eq $true) { foreach ($AXSFNode in $OrchestratorServerNames) { Write-PSFMessage -Level Verbose -Message "Found the Invalid Orchestrator Node $Node in OrchestratorServerNames. Removing from OrchestratorServerNames list" $AXOrchActiveNodeList.Remove($node) } } } $AXSFServerNames = $AXSFActiveNodeList $OrchestratorServerNames = $AXOrchActiveNodeList } $AllAppServerList = @() foreach ($ComputerName in $AXSFServerNames) { if (($AllAppServerList -contains $ComputerName) -eq $false) { $AllAppServerList += $ComputerName } } foreach ($ComputerName in $ReportServerServerName) { if (($AllAppServerList -contains $ComputerName) -eq $false) { $AllAppServerList += $ComputerName } } foreach ($ComputerName in $OrchestratorServerNames) { if (($AllAppServerList -contains $ComputerName) -eq $false) { $AllAppServerList += $ComputerName } } ## <# Source: https://stackoverflow.com/questions/8423541/how-do-you-run-a-sql-server-query-from-powershell #> function Invoke-SQL { param( [string] $dataSource = ".\SQLEXPRESS", [string] $database = "MasterData", [string] $sqlCommand = $(throw "Please specify a query.") ) $connectionString = "Data Source=$dataSource; " + "Integrated Security=SSPI; " + "Initial Catalog=$database" $connection = new-object system.data.SqlClient.SQLConnection($connectionString) $command = new-object system.data.sqlclient.sqlcommand($sqlCommand, $connection) $connection.Open() $adapter = New-Object System.Data.sqlclient.sqlDataAdapter $command $dataset = New-Object System.Data.DataSet $adapter.Fill($dataSet) | Out-Null $connection.Close() $dataSet.Tables } try { if ($CustomModuleName) { $path = Get-ChildItem "$agentsharelocation\wp\*\StandaloneSetup-*\Apps\AOS\AXServiceApp\AXSF\InstallationRecords\MetadataModelInstallationRecords" | Select-Object -first 1 -ExpandProperty FullName $pathtoxml = "$path\$CustomModuleName.xml" if ($path) { [xml]$xml = Get-Content $pathtoxml $CustomModuleVersioninAgentShare = $xml.MetadataModelInstallationInfo.Version } else { Write-PSFMessage -Level Warning -Message "Can't find $path\$CustomModuleName.xml to get Version in Agent Share " } } } catch {} if (!$AXDatabaseName) { $AXDatabaseName = "AXDB" } $SQLQueryToGetRefreshinfo = " Select top 1 [rh].[destination_database_name], [sd].[create_date], [bs].[backup_start_date], [rh].[restore_date], [bmf].[physical_device_name] as 'backup_file_used_for_restore' from msdb..restorehistory rh inner join msdb..backupset bs on [rh].[backup_set_id] = [bs].[backup_set_id] inner join msdb..backupmediafamily bmf on [bs].[media_set_id] = [bmf].[media_set_id] inner join sys.databases sd on [sd].[name] = [rh].[destination_database_name] where [rh].[destination_database_name] = '$AXDatabaseName' ORDER BY [rh].[restore_date] DESC" try { $SqlresultsToGetRefreshinfo = invoke-sql -datasource $AXDatabaseServer -database $AXDatabaseName -sqlcommand $SQLQueryToGetRefreshinfo } catch {} if ($SqlresultsToGetRefreshinfo.Count -eq 0) { $whoami = whoami Write-PSFMessage -Level VeryVerbose -Message "Can't find SQL results with query. Check if database is up and permissions are set for $whoami. Server: $AXDatabaseServer - DatabaseName: $AXDatabaseName." } else { $AXDatabaseRestoreDateSQL = $SqlresultsToGetRefreshinfo | Select-Object restore_date [string]$AXDatabaseRestoreDate = $AXDatabaseRestoreDateSQL $AXDatabaseRestoreDate = $AXDatabaseRestoreDate.Trim("@{restore_date=") $AXDatabaseRestoreDate = $AXDatabaseRestoreDate.Substring(0, $AXDatabaseRestoreDate.Length - 1) $AXDatabaseCreationDateSQL = $SqlresultsToGetRefreshinfo | Select-Object create_date [string]$AXDatabaseCreationDate = $AXDatabaseCreationDateSQL $AXDatabaseCreationDate = $AXDatabaseCreationDate.Trim("@{create_date=") $AXDatabaseCreationDate = $AXDatabaseCreationDate.Substring(0, $AXDatabaseCreationDate.Length - 1) $AXDatabaseBackupStartDateSQL = $SqlresultsToGetRefreshinfo | Select-Object backup_start_date [string]$AXDatabaseBackupStartDate = $AXDatabaseBackupStartDateSQL $AXDatabaseBackupStartDate = $AXDatabaseBackupStartDate.Trim("@{backup_start_date=") $AXDatabaseBackupStartDate = $AXDatabaseBackupStartDate.Substring(0, $AXDatabaseBackupStartDate.Length - 1) $AXDatabaseBackupFileUsedForRestoreSQL = $SqlresultsToGetRefreshinfo | Select-Object backup_file_used_for_restore [string]$AXDatabaseBackupFileUsedForRestore = $AXDatabaseBackupFileUsedForRestoreSQL $AXDatabaseBackupFileUsedForRestore = $AXDatabaseBackupFileUsedForRestore.Trim("@{backup_file_used_for_restore=") $AXDatabaseBackupFileUsedForRestore = $AXDatabaseBackupFileUsedForRestore.Substring(0, $AXDatabaseBackupFileUsedForRestore.Length - 1) $SQLQueryToGetConfigMode = "select * from SQLSYSTEMVARIABLES Where PARM = 'CONFIGURATIONMODE'" try { $SqlresultsToGetConfigMode = invoke-sql -datasource $AXDatabaseServer -database $AXDatabaseName -sqlcommand $SQLQueryToGetConfigMode } catch {} $ConfigurationModeSQL = $SqlresultsToGetConfigMode | Select-Object value [string]$ConfigurationModeString = $ConfigurationModeSQL $ConfigurationModeString = $ConfigurationModeString.Trim("@{value=") $ConfigurationModeString = $ConfigurationModeString.Trim("VALUE=") $ConfigurationModeString = $ConfigurationModeString.Substring(0, $ConfigurationModeString.Length - 1) [int]$configurationmode = $ConfigurationModeString if ($configurationmode -eq 1) { Write-PSFMessage -Level VeryVerbose -Message "Warning: Found that Maintenance Mode is On" $ConfigurationModeEnabledDisabled = 'Enabled' } if ($configurationmode -eq 0) { $ConfigurationModeEnabledDisabled = 'Disabled' } } $SQLQueryToGetOrchestratorDataOrchestratorJob = "select top 1 State, QueuedDateTime, LastProcessedDateTime, EndDateTime,JobId, DeploymentInstanceId from OrchestratorJob order by ScheduledDateTime desc" $SQLQueryToGetOrchestratorDataRunBook = "select top 1 RunBookTaskId, Name, Description, State, StartDateTime, EndDateTime, OutputMessage from RunBookTask" try { $SqlresultsToGetOrchestratorDataOrchestratorJob = invoke-sql -datasource $OrchdatabaseServer -database $OrchDatabase -sqlcommand $SQLQueryToGetOrchestratorDataOrchestratorJob } catch {} try { $SqlresultsToGetOrchestratorDataRunBook = invoke-sql -datasource $OrchdatabaseServer -database $OrchDatabase -sqlcommand $SQLQueryToGetOrchestratorDataRunBook } catch {} if ($SqlresultsToGetOrchestratorDataRunBook.Count -eq 0) { $whoami = whoami Write-PSFMessage -Level VeryVerbose -Message "Can't find SQL results with query. Check if database is up and permissions are set for $whoami. Server: $OrchdatabaseServer - DatabaseName: $OrchDatabase." } else { $OrchestratorJobSQL = $SqlresultsToGetOrchestratorDataOrchestratorJob | Select-Object State [string]$OrchestratorDataOrchestratorJobStateString = $OrchestratorJobSQL $OrchestratorDataOrchestratorJobStateString = $OrchestratorDataOrchestratorJobStateString.Trim("@{State=") $OrchestratorDataOrchestratorJobStateString = $OrchestratorDataOrchestratorJobStateString.Trim("State=") $OrchestratorDataOrchestratorJobStateString = $OrchestratorDataOrchestratorJobStateString.Substring(0, $OrchestratorDataOrchestratorJobStateString.Length - 1) [int]$OrchestratorDataOrchestratorJobStateInt = $OrchestratorDataOrchestratorJobStateString $RunBookSQL = $SqlresultsToGetOrchestratorDataRunBook | Select-Object State [string]$OrchestratorDataRunBookStateString = $RunBookSQL $OrchestratorDataRunBookStateString = $OrchestratorDataRunBookStateString.Trim("@{State=") $OrchestratorDataRunBookStateString = $OrchestratorDataRunBookStateString.Trim("State=") $OrchestratorDataRunBookStateString = $OrchestratorDataRunBookStateString.Substring(0, $OrchestratorDataRunBookStateString.Length - 1) [int]$OrchestratorDataRunBookStateInt = $OrchestratorDataRunBookStateString switch ( $OrchestratorDataRunBookStateInt) { 0 { $OrchestratorJobRunBookState = 'Not Started' } 1 { $OrchestratorJobRunBookState = 'In Progress' } 2 { $OrchestratorJobRunBookState = 'Successful' } 3 { $OrchestratorJobRunBookState = 'Failed' } 4 { $OrchestratorJobRunBookState = 'Cancelled' } 5 { $OrchestratorJobRunBookState = 'Unknown Status' } } switch ($OrchestratorDataOrchestratorJobStateInt ) { 0 { $OrchestratorJobRunBookState = 'Not Started' } 1 { $OrchestratorJobRunBookState = 'In Progress' } 2 { $OrchestratorJobRunBookState = 'Successful' } 3 { $OrchestratorJobRunBookState = 'Failed' } 4 { $OrchestratorJobRunBookState = 'Cancelled' } 5 { $OrchestratorJobState = 'Unknown Status' } } } if ($CustomModuleName) { $assets = Get-ChildItem -Path "$AgentShareLocation\assets" | Where-object { ($_.Name -ne "chk") -and ($_.Name -ne "topology.xml") } | Sort-Object { $_.CreationTime } -Descending $versions = @() foreach ($asset in $assets) { $versionfile = (Get-ChildItem $asset.FullName -File | Where-Object { $_.Name -like "$CustomModuleName*" }).Name $version = ($versionfile -replace $CustomModuleName) -replace ".xml" $versions += $version } $CustomModuleVersionFullPreppedinAgentShare = $versions | Sort-Object { $_.CreationTime } -Descending | Select-Object -First 1 $CustomModuleVersionFullPreppedinAgentShare = $CustomModuleVersionFullPreppedinAgentShare.trim() } ##Getting DB Sync Status using winevent Start Foreach ($AXSFServerName in $AXSFServerNames) { try { $LatestEventinLog = $(Get-WinEvent -LogName Microsoft-Dynamics-AX-DatabaseSynchronize/Operational -maxevents 1 -computername $AXSFServerName -ErrorAction Stop).TimeCreated } catch { Write-PSFMessage -Level VeryVerbose -Message "$AXSFServerName $_" if ($_.Exception.Message -eq "No events were found that match the specified selection criteria") { $LatestEventinLog = $null } if ($_.Exception.Message -eq "The RPC Server is unavailable") { { Write-PSFMessage -Level Verbose -Message "The RPC Server is Unavailable trying WinRM" $LatestEventinLog = Invoke-Command -ComputerName $AXSFServerName -ScriptBlock { $(Get-EventLog -LogName Microsoft-Dynamics-AX-DatabaseSynchronize/Operational -maxevents 1 -computername $AXSFServerName).TimeCreated } } } } if (($LatestEventinLog -gt $LatestEventinAllLogs) -or (!$LatestEventinAllLogs)) { $LatestEventinAllLogs = $LatestEventinLog $ServerWithLatestLog = $AXSFServerName Write-PSFMessage -Level Verbose -Message "Server with latest database synchronization log updated to $ServerWithLatestLog with a date time of $LatestEventinLog" } } if (!$HighLevelOnly) { ##Found which server is getting the latest database sync using winevent end Write-PSFMessage -Level VeryVerbose -Message "Gathering Database Logs from $ServerWithLatestLog" $events = Get-WinEvent -LogName Microsoft-Dynamics-AX-DatabaseSynchronize/Operational -computername $ServerWithLatestLog -maxevents 100 | ForEach-Object -Process { ` New-Object -TypeName PSObject -Property ` @{'MachineName' = $ServerWithLatestLog ; 'EventMessage' = $_.Properties[0].value; 'EventDetails' = $_.Properties[1].value; 'Message' = $_.Message; 'LevelDisplayName' = $_.LevelDisplayName; 'TimeCreated' = $_.TimeCreated; 'TaskDisplayName' = $_.TaskDisplayName 'UserId' = $_.UserId; 'LogName' = $_.LogName; 'ProcessId' = $_.ProcessId; 'ThreadId' = $_.ThreadId; 'Id' = $_.Id; } } $SyncStatusFound = $false foreach ($event in $events) { if ((($event.message -contains "Table synchronization failed.") -or ($event.message -contains "Database Synchronize Succeeded.") -or ($event.message -contains "Database Synchronize Failed.")) -and $SyncStatusFound -eq $false) { if (($event.message -contains "Table synchronization failed.") -or ($event.message -contains "Database Synchronize Failed.")) { Write-PSFMessage -Message "Found a DB Sync failure $event" -Level Verbose $DBSyncStatus = "Failed" $DBSyncTimeStamp = $event.TimeCreated } if ($event.message -contains "Database Synchronize Succeeded.") { Write-PSFMessage -Message "Found a DB Sync Success $event" -Level Verbose $DBSyncStatus = "Succeeded" $DBSyncTimeStamp = $event.TimeCreated } $SyncStatusFound = $true } } } $WPAssetIDTXT = Get-ChildItem $AgentShareLocation\wp\*\AssetID.txt | Sort-Object LastWriteTime | Select-Object -First 1 if ($WPAssetIDTXT) { $WPAssetIDTXTContent = Get-Content $WPAssetIDTXT.FullName $DeploymentAssetIDinWPFolder = $WPAssetIDTXTContent[0] -replace "AssetID: ", "" } try { $RunningAXCodeFolder = Invoke-Command -ComputerName $AXSFConfigServerName -ScriptBlock { $(Split-Path $(Get-Process | Where-Object { $_.Name -eq "AXService" } | select *).Path -Parent) } } catch { } $SSRSClusterServerNames = $ReportServerServerName # Collect information into a hashtable Add any new field to Get-D365TestConfigData # Make sure to add Certification to Cert list below properties if adding cert $Properties = @{ "AllAppServerList" = $AllAppServerList "OrchestratorServerNames" = $OrchestratorServerNames "AXSFServerNames" = $AXSFServerNames "ReportServerServerName" = $ReportServerServerName "ReportServerServerip" = $ReportServerServerip "OrchDatabaseName" = $OrchDatabase "OrchDatabaseServer" = $OrchdatabaseServer "AgentShareLocation" = $AgentShareLocation "SFClientCertificate" = $ClientCert "SFClusterID" = $ClusterID "SFConnectionEndpoint" = $ConnectionEndpoint "SFServerCertificate" = $ServerCertificate "SFClusterCertificate" = $SFClusterCertificate "ClientURL" = $ClientURL "AXDatabaseServer" = $AXDatabaseServer "AXDatabaseName" = $AXDatabaseName "LCSEnvironmentID" = $LCSEnvironmentId "LCSEnvironmentName" = $LCSEnvironmentName "TenantID" = $TenantID "SourceComputerName" = $ComputerName "CustomModuleVersion" = $CustomModuleVersion "DataEncryptionCertificate" = $DataEncryptionCertificate "DataSigningCertificate" = $DataSigningCertificate "SessionAuthenticationCertificate" = $SessionAuthenticationCertificate "SharedAccessSMBCertificate" = $SharedAccessSMBCertificate "LocalAgentCertificate" = $LocalAgentCertificate "DataEnciphermentCertificate" = "$DataEnciphermentCertificate" "FinancialReportingCertificate" = $FinancialReportingCertificate "ReportingSSRSCertificate" = "$ReportingSSRSCertificate" "OrchServiceLocalAgentVersionNumber" = $OrchServiceLocalAgentVersionNumber "NewlyAddedAXSFServers" = $NewlyAddedAXSFServers 'SFVersionNumber' = $SFVersionNumber 'InvalidSFServers' = $invalidnodes 'DisabledSFServers' = $disablednodes 'AOSKernelVersion' = $AOSKernelVersion 'DatabaseEncryptionCertificate' = $DatabaseEncryptionCertificate 'DatabaseClusteredStatus' = $DatabaseClusteredStatus 'DatabaseClusterServerNames' = $DatabaseClusterServerNames 'SourceAXSFServer' = $AXSFConfigServerName 'CustomModuleVersioninAgentShare' = $CustomModuleVersioninAgentShare 'AXDatabaseRestoreDate' = $AXDatabaseRestoreDate 'AXDatabaseCreationDate' = $AXDatabaseCreationDate 'AXDatabaseBackupStartDate' = $AXDatabaseBackupStartDate 'AXDatabaseBackupFileUsedForRestore' = $AXDatabaseBackupFileUsedForRestore 'CustomModuleVersionFullPreppedinAgentShare' = $CustomModuleVersionFullPreppedinAgentShare 'DBSyncStatus' = $DBSyncStatus 'DBSyncTimeStamp' = $DBSyncTimeStamp 'DBSyncServerWithLatestLog' = $ServerWithLatestLog 'ConfigurationModeEnabledDisabled' = $ConfigurationModeEnabledDisabled 'DeploymentAssetIDinWPFolder' = $DeploymentAssetIDinWPFolder 'OrchestratorJobRunBookState' = $OrchestratorJobRunBookState 'OrchestratorJobState' = $OrchestratorJobState 'D365FOLBDAdminEnvironmentType' = $EnvironmentType 'DatabaseEncryptionThumbprints' = $DatabaseEncryptionThumbprints 'ManagementReporterServers' = $ManagementReporterServers 'SSRSClusterServerNames' = $SSRSClusterServerNames 'RunningAXCodeFolder' = $RunningAXCodeFolder 'AggregatedSFState' = $AggregatedSFState 'NumberOfAppsinServicefabric' = $NumberOfAppsinServicefabric } $certlist = ('SFClientCertificate', 'SFServerCertificate', 'DataEncryptionCertificate', 'DataSigningCertificate', 'SessionAuthenticationCertificate', 'SharedAccessSMBCertificate', 'LocalAgentCertificate', 'DataEnciphermentCertificate', 'FinancialReportingCertificate', 'ReportingSSRSCertificate', 'DatabaseEncryptionCertificate') $CertificateExpirationHash = @{} if ($HighLevelOnly) { if ($messagecount -eq 0) { Write-PSFMessage -Level Verbose -Message "High Level Only will not connect to service fabric" $messagecount = $messagecount + 1 } } else { foreach ($cert in $certlist) { $certthumbprint = $null $certthumbprint = $Properties.$cert $certexpiration = $null if ($certthumbprint) { $value = $certthumbprint try { if ($cert -eq 'LocalAgentCertificate' -and !$certexpiration) { $certexpiration = invoke-command -scriptblock { param($value) $(Get-ChildItem Cert:\LocalMachine\my | Where-Object { $_.Thumbprint -eq "$value" }).NotAfter } -ComputerName $OrchestratorServerName -ArgumentList $value if (!$certexpiration) { $certexpiration = invoke-command -scriptblock { param($value) $(Get-ChildItem Cert:\CurrentUser\my | Where-Object { $_.Thumbprint -eq "$value" }).NotAfter } -ComputerName $OrchestratorServerName -ArgumentList $value } } if (!$certexpiration) { $certexpiration = invoke-command -scriptblock { param($value) $(Get-ChildItem Cert:\LocalMachine\my | Where-Object { $_.Thumbprint -eq "$value" }).NotAfter } -ComputerName $AXSFConfigServerName -ArgumentList $value } if (!$certexpiration) { $certexpiration = invoke-command -scriptblock { param($value) $(Get-ChildItem Cert:\CurrentUser\my | Where-Object { $_.Thumbprint -eq "$value" }).NotAfter } -ComputerName $AXSFConfigServerName -ArgumentList $value } if (!$certexpiration) { $certexpiration = invoke-command -scriptblock { param($value) $(Get-ChildItem Cert:\LocalMachine\Trust | Where-Object { $_.Thumbprint -eq "$value" }).NotAfter } -ComputerName $AXSFConfigServerName -ArgumentList $value } if ($cert -eq 'DatabaseEncryptionCertificate' -and !$certexpiration) { $DatabaseClusterServerName = $DatabaseClusterServerNames | Select-Object -First 1 try { $certexpiration = invoke-command -scriptblock { param($value) $(Get-ChildItem Cert:\LocalMachine\my | Where-Object { $_.Thumbprint -eq "$value" }).NotAfter } -ComputerName $DatabaseClusterServerName -ArgumentList $value -ErrorAction Stop if (!$certexpiration) { $certexpiration = invoke-command -scriptblock { param($value) $(Get-ChildItem Cert:\CurrentUser\my | Where-Object { $_.Thumbprint -eq "$value" }).NotAfter } -ComputerName $DatabaseClusterServerName -ArgumentList $value -ErrorAction Stop } } catch { Write-PSFMessage -Level Warning "Warning: Issue grabbing DatabaseEncryptionCertificate information. $_" } } if ($certexpiration) { Write-PSFMessage -Level Verbose -Message "$value expires at $certexpiration" } else { Write-PSFMessage -Level Verbose -Message "Could not find Certificate $cert $value" } } catch { Write-PSFMessage -Level Warning -Message "$value $_ cant be found" } } $name = $cert + "ExpiresAfter" $currdate = get-date if ($currdate -gt $certexpiration -and $certexpiration) { Write-PSFMessage -Level Warning -Message "WARNING: Expired Certificate $name with an expiration of $certexpiration" } $hash = $CertificateExpirationHash.Add($name, $certexpiration) } } Function Merge-Hashtables([ScriptBlock]$Operator) { ##probably will put in internal to test $Output = @{} ForEach ($Hashtable in $Input) { If ($Hashtable -is [Hashtable]) { ForEach ($Key in $Hashtable.Keys) { $Output.$Key = If ($Output.ContainsKey($Key)) { @($Output.$Key) + $Hashtable.$Key } Else { $Hashtable.$Key } } } } If ($Operator) { ForEach ($Key in @($Output.Keys)) { $_ = @($Output.$Key); $Output.$Key = Invoke-Command $Operator } } $Output } $FinalOutput = $CertificateExpirationHash, $Properties | Merge-Hashtables ##Sends Custom Object to Pipeline [PSCustomObject] $FinalOutput } } END { if ($ConfigExportToFile) { $FinalOutput | Export-Clixml -Path $ConfigExportToFile } } } function Get-D365LBDConfigTemplate { <# .SYNOPSIS #> [CmdletBinding()] [alias("Get-D365ConfigTemplate")] param ([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [Parameter(ParameterSetName = 'InfrastructurePath', ValueFromPipeline = $True)] [string]$infrastructurescriptspath, [switch]$CreateCopy ) BEGIN { } PROCESS { if (!$Config -and !$infrastructurescriptspath) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } $path = Join-Path $infrastructurescriptspath -ChildPath "Configtemplate.xml" [xml]$Configtemplatexml = get-content $path $Certs = $Configtemplatexml.Config.Certificates.Certificate foreach ($Cert in $Certs) { $parent = $Cert.ParentNode $CertNameinConfig = $parent.Certificate | Where-Object { $_.Thumbprint -eq $Cert.Thumbprint } $CertName = $CertNameinConfig.Name Write-PSFMessage -Level VeryVerbose -Message "Looking for $CertName with a thumbprint of $Cert" $CertinStore = Get-ChildItem "Cert:\Currentuser\My" | Where-Object { $_.Thumbprint -eq $Cert.Thumbprint } if (!$CertinStore) { Write-PSFMessage -Level VeryVerbose "Can't find Cert $Cert in CurrentUser Checking local machine" $CertinStore = Get-ChildItem "Cert:\LocalMachine\My" | Where-Object { $_.Thumbprint -eq $Cert.Thumbprint } } if ($CertinStore) { if ($CertinStore.NotAfter -lt $(get-date)) { Write-PSFMessage -Level Warning -Message "$CertName with Thumbprint $($Cert.Thumbprint) is expired! $($Cert.PSPath)" } $CertinStore | Select-Object FriendlyName, Thumbprint, NotAfter } else { $parent = $Cert.ParentNode $parent.Cert Write-PSFMessage -Level VeryVerbose "Warning: Can't find the Thumbprint $Cert on specific machine for $CertName" } } IF ($Createcopy) { ##Create Archive folder inside of config template If (!(Test-path $infrastructurescriptspath/Archive)) { New-Item -ItemType Directory -Force -Path $infrastructurescriptspath/Archive } $name = "Config$((Get-Date).ToString('yyyy-MM-dd')).xml" Copy-Item $path -Destination "$infrastructurescriptspath/Archive/$name" } } END { } } function Get-D365LBDDBEvents { <# .SYNOPSIS Checks the event viewer of the primary and secondary orchestrator nodes. .DESCRIPTION Checks the event viewer of the primary and secondary orchestrator nodes. .EXAMPLE Get-D365LBDDBEvents .EXAMPLE Get-D365LBDDBEvents -ComputerName "LBDServerName" -verbose .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER NumberofEvents Integer Number of Events to be pulled defaulted to 20 .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [CmdletBinding()] [alias("Get-D365DBEvents")] param ([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [int]$NumberofEvents = 20, [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config ) BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } Foreach ($AXSFServerName in $config.AXSFServerNames) { try { Write-PSFMessage -Level Verbose -Message "Reaching out to $AXSFServerName to look for DB logs" $LatestEventinLog = $(Get-WinEvent -LogName Microsoft-Dynamics-AX-DatabaseSynchronize/Operational -maxevents 1 -computername $AXSFServerName -ErrorAction Stop).TimeCreated } catch { Write-PSFMessage -Level VeryVerbose -Message "$AXSFServerName $_" if ($_.Exception.Message -eq "No events were found that match the specified selection criteria") { $LatestEventinLog = $null } if ($_.Exception.Message -eq "The RPC Server is unavailable") { { Write-PSFMessage -Level Verbose -Message "The RPC Server is Unavailable trying WinRM" $LatestEventinLog = Invoke-Command -ComputerName $AXSFServerName -ScriptBlock { $(Get-EventLog -LogName Microsoft-Dynamics-AX-DatabaseSynchronize/Operational -maxevents 1 -computername $AXSFServerName).TimeCreated } } } } if (($LatestEventinLog -gt $LatestEventinAllLogs) -or (!$LatestEventinAllLogs)) { $LatestEventinAllLogs = $LatestEventinLog $ServerWithLatestLog = $AXSFServerName Write-PSFMessage -Level Verbose -Message "Server with latest log updated to $ServerWithLatestLog with a date time of $LatestEventinLog" } } Write-PSFMessage -Level VeryVerbose -Message "Gathering from $ServerWithLatestLog" $events = Get-WinEvent -LogName Microsoft-Dynamics-AX-DatabaseSynchronize/Operational -maxevents $NumberofEvents -computername $ServerWithLatestLog | ForEach-Object -Process { ` New-Object -TypeName PSObject -Property ` @{'MachineName' = $ServerWithLatestLog ; 'EventMessage' = $_.Properties[0].value; 'EventDetails' = $_.Properties[1].value; 'Message' = $_.Message; 'LevelDisplayName' = $_.LevelDisplayName; 'TimeCreated' = $_.TimeCreated; 'TaskDisplayName' = $_.TaskDisplayName 'UserId' = $_.UserId; 'LogName' = $_.LogName; 'ProcessId' = $_.ProcessId; 'ThreadId' = $_.ThreadId; 'Id' = $_.Id; } $SyncStatusFound = $false foreach ($event in $events) { if ((($event.message -contains "Table synchronization failed.") -or ($event.message -contains "Database Synchronize Succeeded.")) -and $SyncStatusFound -eq $false) { if ($event.message -contains "Table synchronization failed.") { Write-PSFMessage -Message "Found a DB Sync Failure $event" -Level Verbose } if ($event.message -contains "Database Synchronize Succeeded.") { Write-PSFMessage -Message "Found a DB Sync Success $event" -Level Verbose } $SyncStatusFound = $true } } } $events } END { } } function Get-D365LBDDependencyHealth { <# .SYNOPSIS .DESCRIPTION .EXAMPLE Export-D365LBDConfigReport .EXAMPLE Export-D365LBDConfigReport -computername 'AXSFServer01' .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [alias("Get-D365DependencyHealth")] [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [string]$CustomModuleName, [switch]$WebsiteChecksOnly, [switch]$SendAlertIfIssue, [string]$SMTPServer ) ##Gather Information from the Dynamics 365 Orchestrator Server Config BEGIN { } PROCESS { if (!$Config) { if ($CustomModuleName) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -CustomModuleName $CustomModuleName -highlevelonly } else { $Config = Get-D365LBDConfig -ComputerName $ComputerName -highlevelonly } } $AgentShareLocation = $config.AgentShareLocation $EnvironmentAdditionalConfig = get-childitem "$AgentShareLocation\scripts\D365FOLBDAdmin\AdditionalEnvironmentDetails.xml" [xml]$EnvironmentAdditionalConfigXML = get-content $EnvironmentAdditionalConfig.FullName $OutputList = @() ##checking WebURLS $EnvironmentAdditionalConfigXML.D365LBDEnvironment.Dependencies.CustomWebURLDependencies.CustomWebURL | ForEach-Object -Process { $Note = $_.Note if ($_.Type.'#text'.Trim() -eq 'Basic') { ##Basic WebURL Start $results = Invoke-WebRequest -Uri $_.uri -UseBasicParsing if ($results.statusCode -eq 200 -or $results.statusCode -eq 203 -or $results.statusCode -eq 204 ) { $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Web Service/Page"; 'Name' = $_.uri ; 'State' = "Operational"; 'ExtraInfo' = $results.Statuscode } $OutputList += $Output } else { $Output += New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Web Service/Page"; 'Name' = $_.uri ; 'State' = "Down"; 'ExtraInfo' = $results.Statuscode } } } else { ##Advanced Weburl start $childnodes = $($_.AdvancedCustomSuccessResponse | Select-Object childnodes).childnodes $properties = $childnodes | Get-Member -MemberType Property $propertiestocheck = $properties.Name [int]$countofproperties = $propertiestocheck.count $results = Invoke-RestMethod -Uri $_.uri -UseBasicParsing if ($countofproperties -eq 0 -or $countofproperties -eq 1 ) { ##only one or 0 child items start $diff = Compare-Object $results -DifferenceObject $($childnodes.'#text'.Trim()) if ($diff) { Write-PSFMessage -message "Found differences $diff" -Level VeryVerbose $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Web Service/Page"; 'Name' = $_.uri ; 'State' = "Down"; 'ExtraInfo' = $Note } $OutputList += $Output } else { ##no differences found so success $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Web Service/Page"; 'Name' = $_.uri ; 'State' = "Operational"; 'ExtraInfo' = $Note } $OutputList += $Output } ##only one or 0 child items end }##multiple items to check start else { foreach ($property in $propertiestocheck) { $diff = compare-object $results.data.$property -DifferenceObject $childnodes.$property.trim() if ($diff) { Write-PSFMessage -message "Found differences $diff" -Level VeryVerbose $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Web Service/Page"; 'Name' = $_.uri ; 'State' = "Down"; 'ExtraInfo' = $results.Statuscode } $OutputList += $Output } else { $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Web Service/Page"; 'Name' = $_.uri ; 'State' = "Operational"; 'ExtraInfo' = $results.Statuscode; } $OutputList += $Output } } } } ## Advanced Weburl End }##End of All Custom WebURL if ($WebsiteChecksOnly) { Write-PSFMessage -Level VeryVerbose -Message "Only Checking Websites" } else { Write-PSFMessage -Level VeryVerbose -Message "Checking for server dependencies" $servicestovalidate = $EnvironmentAdditionalConfigXML.D365LBDEnvironment.Dependencies.ServerDependencies.Dependency | Where-Object { $_.Type.'#text'.Trim() -eq "service" } foreach ($servicetovalidate in $servicestovalidate) { ##Services Start if ($servicestovalidate.locationType.'#text'.Trim() -eq 'AXSF') { foreach ($AXSfServerName in $Config.AXSFServerNames) { $servicetovalidateName = $servicetovalidate.Name $results = Invoke-Command -ComputerName $AXSfServerName -ScriptBlock { Get-service $Using:servicetovalidateName } | ForEach-Object -Process { ` if ($results.Status -eq "Running") { $results | ForEach-Object -Process { ` $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Service"; 'Name' = "$servicetovalidateName"; 'State' = "Operational"; 'ExtraInfo' = $_.StartType; } $OutputList += $Output } } ##Operational start else { $results | ForEach-Object -Process { ` $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Service"; 'Name' = "$servicetovalidateName"; 'State' = "Down"; 'ExtraInfo' = $_.StartType; } $OutputList += $Output } }##Failure end } } } if ($servicestovalidate.locationType.'#text'.Trim() -eq 'SSRS') { foreach ($SSRSClusterServerName in $Config.SSRSClusterServerNames) { $results = Invoke-Command -ComputerName $SSRSClusterServerName -ScriptBlock { Get-service $Using:servicetovalidateName } | ForEach-Object -Process { ` if ($results.Status -eq "Running") { $results | ForEach-Object -Process { ` $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Service"; 'Name' = "$servicetovalidateName"; 'State' = "Operational"; 'ExtraInfo' = $_.StartType; } $OutputList += $Output } } ##Operational start else { $results | ForEach-Object -Process { ` $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Service"; 'Name' = "$servicetovalidateName"; 'State' = "Down"; 'ExtraInfo' = $_.StartType; } $OutputList += $Output } }##Failure end } } } if ($servicestovalidate.locationType.'#text'.Trim() -eq 'SQLDB') { foreach ($DatabaseClusterServerName in $config.DatabaseClusterServerNames) { $results = Invoke-Command -ComputerName $DatabaseClusterServerName -ScriptBlock { Get-service $Using:servicetovalidateName} | ForEach-Object -Process { ` if ($results.Status -eq "Running") { $results | ForEach-Object -Process { ` $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Service"; 'Name' = "$servicetovalidateName"; 'State' = "Operational"; 'ExtraInfo' = $_.StartType; } $OutputList += $Output } } ##Operational start else { $results | ForEach-Object -Process { ` $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Service"; 'Name' = "$servicetovalidateName"; 'State' = "Down"; 'ExtraInfo' = $_.StartType; } $OutputList += $Output } }##Failure end } } } if ($servicestovalidate.locationType.'#text'.Trim() -eq 'ManagementReporter') { foreach ($ManagementReporterServer in $ManagementReporterServers) { $results = Invoke-Command -ComputerName $ManagementReporterServer -ScriptBlock { Get-service $Using:servicetovalidateName } | ForEach-Object -Process { ` if ($results.Status -eq "Running") { $results | ForEach-Object -Process { ` $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Service"; 'Name' = "$servicetovalidateName"; 'State' = "Operational"; 'ExtraInfo' = $_.StartType; } $OutputList += $Output } } ##Operational start else { $results | ForEach-Object -Process { ` $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Service"; 'Name' = "$servicetovalidateName"; 'State' = "Down"; 'ExtraInfo' = $_.StartType; } $OutputList += $Output } }##Failure end } } } if ($servicestovalidate.locationType.'#text'.Trim() -eq 'All') { foreach ($AppServer in $Config.AllAppServerList) { $results = Invoke-Command -ComputerName $AppServer -ScriptBlock { Get-service $Using:servicetovalidateName } if ($results.Status -eq "Running") { $results | ForEach-Object -Process { ` $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Service"; 'Name' = "$servicetovalidateName"; 'State' = "Operational"; 'ExtraInfo' = $_.StartType; } $OutputList += $Output } } ##Operational start else { $results | ForEach-Object -Process { ` $Output = New-Object -TypeName PSObject -Property ` @{'Source' = $env:COMPUTERNAME ; 'DependencyType' = "Service"; 'Name' = "$servicetovalidateName"; 'State' = "Down"; 'ExtraInfo' = $_.StartType; } $OutputList += $Output } }##Failure end } } }##Services End $processestovalidate = $EnvironmentAdditionalConfigXML.D365LBDEnvironment.Dependencies.ServerDependencies.Dependency | Where-Object { $_.Type.'#text'.Trim() -eq "process" } ##Process foreach ($processtovalidate in $processestovalidate) { $ProcessName = $processtovalidate.name if ($processtovalidate.locationType.'#text'.Trim() -eq 'AXSF') { foreach ($AXSfServerName in $Config.AXSFServerNames) { Invoke-Command -ComputerName $AXSfServerName -ScriptBlock { Get-process | where-object {$_.Name -eq $Using:ProcessName} | Select-Object -First 1 } | ForEach-Object -Process { ` } } } if ($processtovalidate.locationType.'#text'.Trim() -eq 'SSRS') { foreach ($SSRSClusterServerName in $Config.SSRSClusterServerNames) { Invoke-Command -ComputerName $SSRSClusterServerName -ScriptBlock { Get-process | where-object {$_.Name -eq $Using:ProcessName} | Select-Object -First 1 } | ForEach-Object -Process { ` } } } if ($processtovalidate.locationType.'#text'.Trim() -eq 'SQLDB') { foreach ($DatabaseClusterServerName in $config.DatabaseClusterServerNames) { Invoke-Command -ComputerName $DatabaseClusterServerName -ScriptBlock { Get-process | where-object {$_.Name -eq $Using:ProcessName} | Select-Object -First 1 } | ForEach-Object -Process { ` } } } if ($processtovalidate.locationType.'#text'.Trim() -eq 'ManagementReporter') { foreach ($ManagementReporterServer in $ManagementReporterServers) { Invoke-Command -ComputerName $ManagementReporterServer -ScriptBlock { Get-process | where-object {$_.Name -eq $Using:ProcessName} | Select-Object -First 1 } | ForEach-Object -Process { ` } } } if ($processtovalidate.locationType.'#text'.Trim() -eq 'All') { foreach ($AppServer in $Config.AllAppServerList) { Invoke-Command -ComputerName $AppServer -ScriptBlock { Get-process | where-object {$_.Name -eq $Using:ProcessName} | Select-Object -First 1 } | ForEach-Object -Process { ` } } } } ##Database } $FoundIssue = $false foreach ($scanneditem in $Output) { if ($scanneditem.State -eq "Down") { Write-PSFMessage -Message "Found an item down: $Scanneditem" -Level VeryVerbose $FoundIssue = $True if ($SendAlertIfIssue) { $EnvironmentOwnerEmail = $EnvironmentAdditionalConfigXML.D365LBDEnvironment.EnvironmentAdditionalConfig.EnvironmentOwnerEmail Send-MailMessage -to "$EnvironmentOwnerEmail" -Body "$output" -Verbose -SmtpServer "$SMTPServer" } } } [PSCustomObject] $OutputList } END {} } function Get-D365LBDEnvironmentHealth { <# .SYNOPSIS Looks inside the agent share extracts the version from the zip by using the custom module name. Puts an xml in root for easy idenitification .DESCRIPTION Exports .EXAMPLE Get-D365LBDEnvironmentHealth .EXAMPLE Get-D365LBDEnvironmentHealth .PARAMETER AgentShare optional string The location of the Agent Share .PARAMETER CustomModuleName optional string The name of the custom module you will be using to capture the version number ##Switch fix minor issues #> [alias("Get-D365EnvironmentHealth")] param ( [Parameter(Mandatory = $true)] [int]$Timeout, [psobject]$Config, [string]$CustomModuleName ) BEGIN { } PROCESS { if (!$Config) { if ($CustomModuleName) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -CustomModuleName $CustomModuleName } else { $Config = Get-D365LBDConfig -ComputerName $ComputerName } } $SourceAXSFServer = $Config.SourceAXSFServer $SFModuleSession = New-PSSession -ComputerName $SourceAXSFServer Invoke-Command -SessionName $SFModuleSession -ScriptBlock { $AssemblyList = "Microsoft.SqlServer.Management.Common", "Microsoft.SqlServer.Smo", "Microsoft.SqlServer.Management.Smo" foreach ($Assembly in $AssemblyList) { $AssemblyLoad = [Reflection.Assembly]::LoadWithPartialName($Assembly) } } $AssemblyList = "Microsoft.SqlServer.Management.Common", "Microsoft.SqlServer.Smo", "Microsoft.SqlServer.Management.Smo" foreach ($Assembly in $AssemblyList) { $AssemblyLoad = [Reflection.Assembly]::LoadWithPartialName($Assembly) } $SQLSSRSServer = New-Object ("Microsoft.SqlServer.Management.Smo.Server") $ReportServerServerName $SystemDatabasesWithIssues = 0 $SystemDatabasesAccessible = 0 foreach ($database in $SQLSSRSServer.Databases) { switch ($database) { { @("[model]", "[master]", "[msdb]", "[tempdb]") -contains $_ } { if ($database.IsAccessible) { $SystemDatabasesAccessible = $SystemDatabasesAccessible + 1 } else { $SystemDatabasesWithIssues = $SystemDatabasesWithIssues + 1 } } "[DynamicsAxReportServer]" { switch ($database.IsAccessible) { "True" { $dbstatus = "Online" } "False" { $dbstatus = "Offline" } } $Properties = @{'Object' = "SSRSDatabase" 'Details' = $database.name 'Status' = "$dbstatus" 'Source' = $ReportServerServerName } New-Object -TypeName psobject -Property $Properties } "[DynamicsAxReportServerTempDB]" { switch ($database.IsAccessible) { "True" { $dbstatus = "Online" } "False" { $dbstatus = "Offline" } } $Properties = @{'Object' = "SSRSTempDBDatabase" 'Details' = $database.name 'Status' = "$dbstatus" 'Source' = $ReportServerServerName } New-Object -TypeName psobject -Property $Properties } Default {} } } if ($SystemDatabasesWithIssues -eq 0) { $Properties = @{'Object' = "SSRSSystemDatabasesDatabase" 'Details' = "$SystemDatabasesAccessible databases are accessible" 'Status' = "Online" 'Source' = $ReportServerServerName } New-Object -TypeName psobject -Property $Properties } else { $Properties = @{'Object' = "SSRSSystemDatabasesDatabase" 'Details' = "$SystemDatabasesAccessible databases are accessible. $SystemDatabasesWithIssues are not accessible" 'Status' = "Offline" 'Source' = $ReportServerServerName } New-Object -TypeName psobject -Property $Properties } } END { } } function Get-D365LBDOrchestrationLogs { <# .SYNOPSIS .DESCRIPTION .EXAMPLE Get-D365LBDOrchestrationLogs .EXAMPLE Get-D365LBDOrchestrationLogs -ComputerName "LBDServerName" -verbose .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [alias("Get-D365OrchestrationLogs")] param ([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [string]$ComputerName, [int]$NumberofEvents = 5, [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config ) BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } [int]$count = 0 while (!$connection) { do { $OrchestratorServerName = $Config.OrchestratorServerNames | Select-Object -First 1 -Skip $count Write-PSFMessage -Message "Verbose: Reaching out to $OrchestratorServerName to try and connect to the service fabric" -Level Verbose $SFModuleSession = New-PSSession -ComputerName $OrchestratorServerName if (!$module) { $module = Import-Module -Name ServiceFabric -PSSession $SFModuleSession } $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $config.SFConnectionEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.SFServerCertificate -ServerCertThumbprint $config.SFServerCertificate -StoreLocation LocalMachine -StoreName My $count = $count + 1 if (!$connection) { Write-PSFMessage -Message "Count of servers tried $count" -Level Verbose } } until ($connection -or ($count -eq $($Config.OrchestratorServerName).Count)) if (($count -eq $($Config.OrchestratorServerName).Count) -and (!$connection)) { Stop-PSFFunction -Message "Error: Can't connect to Service Fabric" } } $orchnodes = Get-D365LBDOrchestrationNodes -config $Config Write-PSFMessage -Level Verbose -Message "$orchnodes" $LatestEventInLog = $(Get-WinEvent -LogName Microsoft-Dynamics-AX-LocalAgent/Operational -MaxEvents 1 -ComputerName $orchnodes.PrimaryNodeName).TimeCreated if ($NumberofEvents -eq 1) { $primary = Get-WinEvent -LogName Microsoft-Dynamics-AX-LocalAgent/Operational -MaxEvents 2 -ComputerName $orchnodes.PrimaryNodeName | ForEach-Object -Process { ` New-Object -TypeName PSObject -Property ` @{'MachineName' = $_.Properties[0].value; 'EventMessage' = $_.Properties[1].value; 'EventDetails' = $_.Properties[2].value; 'Message' = $_.Message; 'LevelDisplayName' = $_.LevelDisplayName; 'TimeCreated' = $_.TimeCreated; 'UserId' = $_.UserId; 'LogName' = $_.LogName; 'ProcessId' = $_.ProcessId; 'ThreadId' = $_.ThreadId; 'Id' = $_.Id; 'ReplicaType' = 'Primary'; 'LatestEventInLog' = $LatestEventInLog; } } } else { $primary = Get-WinEvent -LogName Microsoft-Dynamics-AX-LocalAgent/Operational -MaxEvents $NumberofEvents -ComputerName $orchnodes.PrimaryNodeName | ForEach-Object -Process { ` New-Object -TypeName PSObject -Property ` @{'MachineName' = $_.Properties[0].value; 'EventMessage' = $_.Properties[1].value; 'EventDetails' = $_.Properties[2].value; 'Message' = $_.Message; 'LevelDisplayName' = $_.LevelDisplayName; 'TimeCreated' = $_.TimeCreated; 'UserId' = $_.UserId; 'LogName' = $_.LogName; 'ProcessId' = $_.ProcessId; 'ThreadId' = $_.ThreadId; 'Id' = $_.Id; 'ReplicaType' = 'Primary'; 'LatestEventInLog' = $LatestEventInLog; } } } $LatestEventInLog = $(Get-WinEvent -LogName Microsoft-Dynamics-AX-LocalAgent/Operational -MaxEvents 1 -ComputerName $orchnodes.SecondaryNodeName).TimeCreated if ($NumberofEvents -eq 1) { $secondary = Get-WinEvent -LogName Microsoft-Dynamics-AX-LocalAgent/Operational -MaxEvents 2 -ComputerName $orchnodes.SecondaryNodeName | ForEach-Object -Process { ` New-Object -TypeName PSObject -Property ` @{'MachineName' = $_.Properties[0].value; 'EventMessage' = $_.Properties[1].value; 'EventDetails' = $_.Properties[2].value; 'Message' = $_.Message; 'LevelDisplayName' = $_.LevelDisplayName; 'TimeCreated' = $_.TimeCreated; 'UserId' = $_.UserId; 'LogName' = $_.LogName; 'ProcessId' = $_.ProcessId; 'ThreadId' = $_.ThreadId; 'Id' = $_.Id; 'ReplicaType' = 'ActiveSecondary'; 'LatestEventInLog' = $LatestEventInLog; } } } else { $secondary = Get-WinEvent -LogName Microsoft-Dynamics-AX-LocalAgent/Operational -MaxEvents $NumberofEvents -ComputerName $orchnodes.SecondaryNodeName | ForEach-Object -Process { ` New-Object -TypeName PSObject -Property ` @{'MachineName' = $_.Properties[0].value; 'EventMessage' = $_.Properties[1].value; 'EventDetails' = $_.Properties[2].value; 'Message' = $_.Message; 'LevelDisplayName' = $_.LevelDisplayName; 'TimeCreated' = $_.TimeCreated; 'UserId' = $_.UserId; 'LogName' = $_.LogName; 'ProcessId' = $_.ProcessId; 'ThreadId' = $_.ThreadId; 'Id' = $_.Id; 'ReplicaType' = 'ActiveSecondary'; 'LatestEventInLog' = $LatestEventInLog; } } } foreach ($primarylog in $primary) { if ($primarylog.EventMessage -like "status of job *, Success") { Write-PSFMessage -Message "Found RunBook Success Message" -Level Verbose } if ($primarylog.EventMessage -like "status of job *, Error") { Write-PSFMessage -Message "Found RunBook Error Message" -Level Verbose } } if (!$secondary) { $all = $Primary | Sort-Object { $_.TimeCreated } -Descending | Select-Object -First $NumberofEvents } else { $all = $Primary + $secondary | Sort-Object { $_.TimeCreated } -Descending | Select-Object -First $NumberofEvents } return $all } END { } } ##Get Primary and Secondary function Get-D365LBDOrchestrationNodes { <# .SYNOPSIS .DESCRIPTION .EXAMPLE Get-D365LBDOrchestrationNodes .EXAMPLE Get-D365LBDOrchestrationNodes -ComputerName "LBDServerName" -verbose .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [alias("Get-D365OrchestrationNodes")] [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [string]$Thumbprint, [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config) BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } [int]$count = 0 while (!$connection) { do { $OrchestratorServerName = $Config.OrchestratorServerNames | Select-Object -First 1 -Skip $count Write-PSFMessage -Message "Verbose: Reaching out to $OrchestratorServerName to try and connect to the service fabric" -Level Verbose $SFModuleSession = New-PSSession -ComputerName $OrchestratorServerName if (!$module) { $module = Import-Module -Name ServiceFabric -PSSession $SFModuleSession } $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $config.SFConnectionEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.SFServerCertificate -ServerCertThumbprint $config.SFServerCertificate -StoreLocation LocalMachine -StoreName My if (!$connection) { $trialEndpoint = "https://$OrchestratorServerName" + ":198000" $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $trialEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.SFServerCertificate -ServerCertThumbprint $config.SFServerCertificate -StoreLocation LocalMachine -StoreName My } $count = $count + 1 if (!$connection) { Write-PSFMessage -Message "Count of servers tried $count" -Level Verbose } } until ($connection -or ($count -eq $($Config.OrchestratorServerName).Count)) if (($count -eq $($Config.OrchestratorServerName).Count) -and (!$connection)) { Stop-PSFFunction -Message "Error: Can't connect to Service Fabric" } } $PartitionId = $(Get-ServiceFabricServiceHealth -ServiceName 'fabric:/LocalAgent/OrchestrationService').PartitionHealthStates | Select-Object PartitionId [string]$PartitionIdString = $PartitionId $PartitionIdString = $PartitionIdString.Trim("@{PartitionId=") $PartitionIdString = $PartitionIdString.Substring(0, $PartitionIdString.Length - 1) Write-PSFMessage -Message "Looking up PartitionID $PartitionIdString." -Level Verbose $nodes = Get-ServiceFabricReplica -PartitionId "$PartitionIdString" $primary = $nodes | Where-Object { $_.ReplicaRole -eq "Primary" -or $_.ReplicaType -eq "Primary" } $secondary = $nodes | Where-Object { $_.ReplicaRole -eq "ActiveSecondary" -or $_.ReplicaType -eq "ActiveSecondary" } New-Object -TypeName PSObject -Property ` @{'PrimaryNodeName' = $primary.NodeName; 'SecondaryNodeName' = $secondary.NodeName; 'PrimaryReplicaStatus' = $primary.ReplicaStatus; 'SecondaryReplicaStatus' = $secondary.ReplicaStatus; 'PrimaryLastinBuildDuration' = $primary.LastinBuildDuration; 'SecondaryLastinBuildDuration' = $secondary.LastinBuildDuration; 'PrimaryHealthState' = $primary.HealthState; 'SecondaryHealthState' = $secondary.HealthState; 'PartitionId' = $PartitionIdString; } } END { } } function Get-D365LBDOrchestratorLastRunBookDetails { <# .SYNOPSIS #> [CmdletBinding()] [alias("Get-D365OrchestratorLastRunBookDetails")] param ([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [Parameter(ParameterSetName = 'Orch')] $OrchdatabaseServer, [Parameter(ParameterSetName = 'Orch')] $OrchdatabaseName ) BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } if ($Config) { $OrchdatabaseServer = $Config.OrchdatabaseServer $OrchdatabaseName = $OrchdatabaseName.OrchDatabase } function Invoke-SQL { param( [string] $dataSource = ".\SQLEXPRESS", [string] $database = "MasterData", [string] $sqlCommand = $(throw "Please specify a query.") ) $connectionString = "Data Source=$dataSource; " + "Integrated Security=SSPI; " + "Initial Catalog=$database" $connection = new-object system.data.SqlClient.SQLConnection($connectionString) $command = new-object system.data.sqlclient.sqlcommand($sqlCommand, $connection) $connection.Open() $adapter = New-Object System.Data.sqlclient.sqlDataAdapter $command $dataset = New-Object System.Data.DataSet $adapter.Fill($dataSet) | Out-Null $connection.Close() $dataSet.Tables } $Query = "Select RBT.[Order], CASE WHEN RBT.State = 0 THEN 'Not Started' WHEN RBT.State = 1 THEN 'In Progress' WHEN RBT.State THEN 'Failed' WHEN RBT.State = 4 THEN 'Cancelled' END AS TaskStatus, RBT.Name, RBT.Description, RBT.RunbookTaskId, RBT.TaskDefinitionName, RBT.State, RBT.Retries, RBT.StartDateTime, RBT.EndDateTime, DI.ID as EnvironmentID, DI.Name as EnvironmentName, DI.ActiveJobID, DI.State as EnvironmentState, DI.Status as EnvironmentStatus, OJ.JobID, OJ.CommandID, OJ.State, OJ.Exception, OJ.QueuedDateTime, OJ.QueuedDateTime, OJ.ScheduledDateTime, OJ.LastProcessedDateTime FROM DeploymentInstance DI JOIN OrchestratorJob OJ ON OJ.DeplomentInstanceID = DI.ID JOIN RunBookTask RBT ON RBT.JobID = OJ.JobID WHERE OJ.JobID = (select Top 1 JobID from RunBookTask ORDER BY StartDateTime DESC " try { $Sqlresults = invoke-sql -datasource $OrchdatabaseServer -database $OrchDatabase -sqlcommand $Query $Sqlresults } catch {} } END { } } function Get-D365LBDTestConfigData { <# .SYNOPSIS Made to test D365 Config functions without a test environment #> [alias("Get-D365TestConfigData")] [CmdletBinding()] param( ) ##Gather Information from the Dynamics 365 Orchestrator Server Config BEGIN { } PROCESS { # Collect information into a hashtable $Properties = @{ "AllAppServerList" = ('Server1', 'Server2', 'Server3', 'Server4', 'Server5') "OrchestratorServerNames" = ('Server1', 'Server2') "AXSFServerNames" = ('Server3', 'Server4', 'Server5') "ReportServerServerName" = 'Server5' "ReportServerServerip" = '1.1.1.1' "OrchDatabaseName" = 'Orchestrator' "OrchDatabaseServer" = 'OrchestratorDBServer' "AgentShareLocation" = '\\fileshare\share\agent' "SFClientCertificate" = 'A233E' "SFClusterID" = 'D365SFCluster' "SFConnectionEndpoint" = '1.2.3.4:19000' "SFServerCertificate" = 'B12131233E' "SFClusterCertificate" = 'C12313233E' "ClientURL" = 'https://ax.offandonit.com/namespaces/AXSF/' "AXDatabaseServer" = 'AXDBServer' "AXDatabaseName" = 'AXDB' "LCSEnvironmentID" = 'LCSEnvironmentID' "LCSEnvironmentName" = 'LCSEnvironmentID' "TenantID" = '123912084123-123d0-1232-11234123' "SourceComputerName" = 'D365ManagementServer' "CustomModuleVersion" = '2020.1.28.1' "DataEncryptionCertificate" = 'E1231233E' "DataSigningCertificate" = 'F1231233E' "SessionAuthenticationCertificate" = 'G1233123233E' "SharedAccessSMBCertificate" = 'H12331233E' "LocalAgentCertificate" = 'I2134213233E' "DataEnciphermentCertificate" = 'J12312233E' "FinancialReportingCertificate" = 'K123113233E' "ReportingSSRSCertificate" = 'LASDSA233E' "OrchServiceLocalAgentVersionNumber" = '2.3.0.0' "NewlyAddedAXSFServers" = 'Server4' 'SFVersionNumber' = '7.1.465.9590' 'InvalidSFServers' = 'Server5' 'DisabledSFServers' = 'Server4' 'AOSKernelVersion' = '7.0.6969.42069' 'DatabaseEncryptionCertificate' = 'ASES123113233E' 'DatabaseClusteredStatus' = 'Clustered' 'DatabaseClusterServerNames' = ('DatabaseServer1', 'DatabaseServer2') 'SFClientCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'SFServerCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'DataEncryptionCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'DataSigningCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'SessionAuthenticationCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'SharedAccessSMBCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'LocalAgentCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'DataEnciphermentCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'FinancialReportingCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'ReportingSSRSCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'DatabaseEncryptionCertificateExpiresAfter' = '5/15/2022 8:24:06 PM' 'CustomModuleVersioninAgentShare' = '2020.1.29.1' 'AXDatabaseRestoreDate' = '5/15/2021 8:24:06 PM' 'AXDatabaseCreationDate' = '5/15/2020 8:24:06 PM' 'AXDatabaseBackupStartDate' = '5/15/2022 8:24:06 PM' 'CustomModuleVersionFullPreppedinAgentShare' = '2020.1.29.1' 'DBSyncStatus' = "Failed" 'DBSyncTimeStamp' = '5/15/2022 8:24:06 PM' 'DBSyncServerWithLatestLog' = 'Server5' 'DeploymentAssetIDinWPFolder' = 'asd87213-123a-312c-213f-891798asd8231h5' } ##Sends Custom Object to Pipeline [PSCustomObject]$Properties } END { } } function Import-D365LBDCertificates { <# .SYNOPSIS Looks inside the agent share extracts the version from the zip by using the custom module name. Puts an xml in root for easy idenitification .DESCRIPTION Exports .EXAMPLE Import-D365Certificates .EXAMPLE Import-D365Certificates #> [alias("Import-D365Certificates")] param ( [Parameter(Mandatory = $false)] [string]$CertThumbprint, [Parameter(Mandatory = $false)] [string]$CertFolder, [switch]$Exportable ) BEGIN { } PROCESS { ##Import do to.. bythumbprint $certs = get-childitem "$CertFolder" foreach ($cert in $certs) { if ($Exportable) { Import-PfxCertificate $cert.FullName -CertStoreLocation "Cert:\localmachine\my" -Exportable } else { Import-PfxCertificate $cert.FullName -CertStoreLocation "Cert:\localmachine\my" } } END { } } } function New-D365LBDAXSFNode { <# .SYNOPSIS Can only be ran on the local machine not fully functional need to add fd and ud logic right now its just parameter #> [alias("New-D365AXSFNode")] [CmdletBinding()] param ( [Parameter(Mandatory = $true)] [string]$SFConnectionEndpoint, [Parameter(Mandatory = $true)] [string]$FaultDomain, [string]$UpdateDomain, [string]$SFClusterCertificate, [string]$SFClientCertificate, [string]$ServiceFabricInstallPath ) ##Gather Information from the Dynamics 365 Orchestrator Server Config BEGIN { } PROCESS { Write-PSFMessage -Message "Make sure pre reqs are installed including certificates" -Level Verbose $ipaddress = (Get-NetIPAddress | Where-Object { ($_.AddressFamily -eq "IPv4") -and ($_.IPAddress -ne "127.0.0.1") }).IPAddress Set-Location "$ServiceFabricInstallPath" .\AddNode.ps1 -NodeName $env:COMPUTERNAME -NodeType AOSNodeType -NodeIPAddressorFQDN $ipaddress -ExistingClientConnectionEndpoint $SFConnectionEndpoint -UpgradeDomain $UpdateDomain -FaultDomain $FaultDomain -AcceptEULA -X509Credential -ServerCertThumbprint $SFClusterCertificate -StoreLocation LocalMachine -StoreName My -FindValueThumbprint $SFClientCertificate Write-PSFMessage -Level Warning -Message "Remember to run a cluster configuration update after all nodes are added (and during a change downtime). Use Update-ServiceFabricD365ClusterConfig to help." } END { } } function Remove-D365LBDSFLogs { [alias("Remove-D365SFLogs")] param ( [Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [psobject]$Config, [int]$CleanupOlderThanDays = 1, [string]$CustomModuleName, [switch]$ControlFile ) BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } Foreach ($SFServerName in $($config.AllAppServerList | Select-Object ComputerName).ComputerName) { $LogFolder = Get-ChildItem -Path "\\$SFServerName\c$\ProgramData\SF\DiagnosticsStore\fabriclogs*\*\Fabric*" | Select-Object -First 1 -ExpandProperty FullName $StartTime = Get-Date Write-PSFMessage -Level Verbose -Message "Starting Clean on $LogFolder" $FilesThatAreBeingDeleted = Get-ChildItem -path $LogFolder | Sort-Object LastWriteTime | Where-Object { $_.Name -ne "ControlFile.txt" -and $_.LastWriteTime -lt (Get-Date).AddDays(-$CleanupOlderThanDays) } $FileCount = $FilesThatAreBeingDeleted.Count Write-PSFMessage -Level Verbose -Message "Deleting $FileCount files on $SFServerName" if ($FilesThatAreBeingDeleted -and $FileCount -gt 0 ) { $FilesThatAreBeingDeleted.FullName | Remove-Item -Force -Recurse } $EndTime = Get-Date $TimeDiff = New-TimeSpan -Start $StartTime -End $EndTime Write-PSFMessage -Level VeryVerbose -Message "$SFServerName - StartTime: $StartTime - EndTime: $EndTime - Execution Time: $($TimeDiff.Minutes) Minutes $($TimeDiff.Seconds) Seconds - Count of Files: $FileCount" if ($ControlFile -and $FileCount -gt 0) { "$SFServerName - StartTime: $StartTime - EndTime: $EndTime - Execution Time: $($TimeDiff.Minutes) $($TimeDiff.Seconds) Count of Files: $FileCount" | Out-File $LogFolder\ControlFile.txt -append } } Write-PSFMessage -Level VeryVerbose -Message "$($config.LCSEnvironmentName) Service Fabric Servers have been cleaned of older than $CleanupOlderThanDays days Service Fabric Logs." } END { } } function Remove-D365LBDSFOldAssets { [alias("Remove-D365SFOldAssets")] param ( [Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [psobject]$Config, [int]$NumberofAssetsToKeep, [switch]$ControlFile ) BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } if ($NumberofAssetsToKeep -lt 2) { Stop-PSFFunction -Message "Error: Number of Assets to keep must be 2 or larger as you should always keep the main and backup" -EnableException $True } $AssetsFolderinAgentShareLocation = join-path -Path $Config.AgentShareLocation -ChildPath "\assets" $Onedayold = (get-date).AddDays(-1) $AlreadyDeployedAssetIDInWPFolder = $Config.DeploymentAssetIDinWPFolder $StartTime = Get-Date Write-PSFMessage -Level Verbose -Message "Starting Clean on $AssetsFolderinAgentShareLocation" $FilesThatAreBeingDeleted = Get-ChildItem $AssetsFolderinAgentShareLocation | Where-Object { $_.Name -ne "chk" -and $_.Name -ne "toplogy.xml" -and $_.Name -ne "$AlreadyDeployedAssetIDInWPFolder" -and $_.LastWriteTime -lt $Onedayold -and $_.Name -ne "ControlFile.txt" } | Sort-Object LastWriteTime | Select-Object -SkipLast $NumberofAssetsToKeep $FileCount = $FilesThatAreBeingDeleted.Count if ($FileCount -or $FileCount -ne 0) { $FilesThatAreBeingDeleted.FullName | Remove-Item -Force -Recurse } $EndTime = Get-Date $TimeDiff = New-TimeSpan -Start $StartTime -End $EndTime Write-PSFMessage -Level VeryVerbose -Message "$AssetsFolderinAgentShareLocation - StartTime: $StartTime - EndTime: $EndTime - Execution Time: $($TimeDiff.Minutes) Minutes $($TimeDiff.Seconds) Seconds - Count of Files: $FileCount" if ($ControlFile -and $FileCount -gt 0) { "$AssetsFolderinAgentShareLocation - StartTime: $StartTime - EndTime: $EndTime - Execution Time: $($TimeDiff.Minutes) minutes $($TimeDiff.Seconds) seconds - Count of Files: $FileCount " | Out-File $AssetsFolderinAgentShareLocation\ControlFile.txt -append } Write-PSFMessage -Level VeryVerbose -Message "$($config.LCSEnvironmentName) AgentShare Assets have been cleaned" } END { } } function Remove-D365LBDStuckApps { ##created for deployment bug when it cant clean properly this was fixed in later local agent versions [alias("Remove-D365StuckApps")] param ( [string]$SFServerCertificate, [string]$SFConnectionEndpoint, [string]$AgentShareLocation, [PSFComputer]$ComputerName = "$env:COMPUTERNAME" ) BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName } if (-not $($config.TenantID)) { $cachedconfigfile = Join-path $($config.AgentShareLocation) -ChildPath "scripts\config.xml" $config = Get-D365LBDConfig -ConfigImportFromFile $cachedconfigfile } Connect-ServiceFabricCluster -ConnectionEndpoint $config.SFConnectionEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.SFServerCertificate -ServerCertThumbprint $config.SFServerCertificate $environmentwp = get-childitem $(Join-path $config.AgentShareLocation -ChildPath "\wp") $archivefolder = $(Join-path $config.AgentShareLocation -ChildPath "\archive") if ((Test-Path $archivefolder) -eq $false) { Write-PSFMessage -Message "Creating archive folder" -Level Verbose mkdir $archivefolder } else { Write-PSFMessage -Message "Archive folder already exists" -Level Verbose Get-ChildItem $environmentwp.FullName -Recurse | Remove-Item } Move-Item -Path $environmentwp.FullName -Destination $archivefolder -Force -Verbose Write-PSFMessage -Message "Deleting applications" -Level Verbose $applicationNamesToIgnore = @('fabric:/LocalAgent', 'fabric:/Agent-Monitoring', 'fabric:/Agent-LBDTelemetry') $applicationTypeNamesToIgnore = @('MonitoringAgentAppType-Agent', 'LocalAgentType', 'LBDTelemetryType-Agent') Get-ServiceFabricApplication | ` Where-Object { $_.ApplicationName -notin $applicationNamesToIgnore } | ` Remove-ServiceFabricApplication -Force Get-ServiceFabricApplicationType | ` Where-Object { $_.ApplicationTypeName -notin $applicationTypeNamesToIgnore } | ` Unregister-ServiceFabricApplicationType -Force Write-PSFMessage -Level Verbose -Message "Trigger deployment/retry in LCS" } END { } } function Remove-D365SFClusterExtraFiles { <# .SYNOPSIS When removing cluster. Run Clean fabric scripts on each server then run this to do final cleanup. Restart then remake cluster. Use Get-D365LBDConfig -ConfigImportFromFile to get config #> [alias("Remove-D365ClusterExtraFiles")] param ( [Parameter(ParameterSetName = 'AllAppServerList', ValueFromPipeline = $True)] [string[]]$AllAppServerList, [Parameter(Mandatory = $false)] [string]$ExportLocation, [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config ) BEGIN { } PROCESS { if ($Config) { $AllAppServerList= $config.AllAppServerList } else{ } foreach ($AppServer in $AllAppServerList) { Invoke-Command -ScriptBlock { $SFFolder = Get-ChildItem "C:\ProgramData" -Directory | Where-Object { $_.Name -eq "SF" }; if ($SFFolder.Count -eq 1 ) { $items.FullName | Remove-Item -Recurse -Force -Confirm -Verbose Write-PSFMessage -Level VeryVerbose -Message "Cleaned SF Folder on $env:ComputerName " } else { Write-PSFMessage -Level VeryVerbose -Message "SF Folder in Program Data doesnt exist on $env:ComputerName" } } -ComputerName $AppServer } } END {} } function Restart-D365LBDSFAppServers { <# .SYNOPSIS .DESCRIPTION .EXAMPLE Restart-D365LBDSFAppServers .EXAMPLE Enable-D365LBDSFAppServers -ComputerName "LBDServerName" -verbose .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [alias(" Restart-D365SFAppServers")] [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name', ParameterSetName = 'NoConfig')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [int]$Timeout = 600, [switch]$waittillhealthy, [switch]$RebootWholeOS, [switch]$RebootWholeOSIncludingOrch ) ##Gather Information from the Dynamics 365 Orchestrator Server Config BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName }[int]$count = 0 while (!$connection) { do { $OrchestratorServerName = $Config.OrchestratorServerNames | Select-Object -First 1 -Skip $count Write-PSFMessage -Message "Verbose: Reaching out to $OrchestratorServerName to try and connect to the service fabric" -Level Verbose $SFModuleSession = New-PSSession -ComputerName $OrchestratorServerName if (!$module) { $module = Import-Module -Name ServiceFabric -PSSession $SFModuleSession } Write-PSFMessage -Message "-ConnectionEndpoint $($config.SFConnectionEndpoint) -X509Credential -FindType FindByThumbprint -FindValue $($config.SFServerCertificate) -ServerCertThumbprint $($config.SFServerCertificate) -StoreLocation LocalMachine -StoreName My" -Level Verbose $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $config.SFConnectionEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.SFServerCertificate -ServerCertThumbprint $config.SFServerCertificate -StoreLocation LocalMachine -StoreName My $count = $count + 1 if (!$connection) { $trialEndpoint = "https://$OrchestratorServerName" + ":198000" $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $trialEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.SFServerCertificate -ServerCertThumbprint $config.SFServerCertificate -StoreLocation LocalMachine -StoreName My } if (!$connection) { Write-PSFMessage -Message "Count of servers tried $count" -Level Verbose } } until ($connection -or ($count -eq $($Config.OrchestratorServerNames).Count)) if (($count -eq $($Config.OrchestratorServerNames).Count) -and (!$connection)) { Stop-PSFFunction -Message "Error: Can't connect to Service Fabric" } } $AppNodes = Get-ServiceFabricNode | Where-Object { ($_.NodeType -eq "AOSNodeType") -or ($_.NodeType -eq "MRType") -or ($_.NodeType -eq "ReportServerType") -or ($_.NodeType -eq "PrimaryNodeType") } if ($RebootWholeOS -or $RebootWholeOSIncludingOrch) { if ($RebootWholeOSIncludingOrch) { if ($waittillhealthy) { Write-PSFMessage -Message "Restarting $($config.AllAppServerList) and Waiting for Powershell to be available" -Level Verbose Restart-computer -ComputerName $config.AllAppServerList -Force -Wait -for PowerShell -Delay 2 -Verbose } else { Write-PSFMessage -Message "Restarting $($config.AllAppServerList)" -Level Verbose Restart-computer -ComputerName $config.AllAppServerList -Force -Wait -for PowerShell -Delay 2 -Verbose } } else{ ## Only SF nodes if ($waittillhealthy) { Write-PSFMessage -Message "Restarting $($config.AXSFServerNames) and Waiting for Powershell to be available" -Level Verbose Restart-computer -ComputerName $config.AXSFServerNames -Force -Wait -for PowerShell -Delay 2 } else { Write-PSFMessage -Message "Restarting $($config.AXSFServerNames)" -Level Verbose Restart-computer -ComputerName $config.AXSFServerNames -Force -Verbose } } } else { foreach ($AppNode in $AppNodes) { Restart-ServiceFabricNode -NodeName $AppNode.NodeName -CommandCompletionMode Verify -Timeout 200 } } Start-Sleep -Seconds 5 [int]$timeoutondisablecounter = 0 $nodestatus = Get-ServiceFabricNode | Where-Object { $_.NodeStatus -eq 'Disabled' -and (($_.NodeType -eq "AOSNodeType") -or ($_.NodeType -eq "MRType")) } do { $nodestatus = Get-ServiceFabricNode | Where-Object { $_.NodeStatus -eq 'Disabled' -and (($_.NodeType -eq "AOSNodeType") -or ($_.NodeType -eq "MRType")) } $timeoutondisablecounter = $timeoutondisablecounter + 5 Start-Sleep -Seconds 5 } until (!$nodestatus -or $nodestatus -eq 0 -or ($timeoutondisablecounter -gt $Timeout)) Write-PSFMessage -Message "All App Nodes Enabled" -Level VeryVerbose do { try { $apps = Get-ServiceFabricApplication -ErrorAction Stop Start-Sleep -Seconds 5 } catch {} } until ($apps.count -gt 0) $counterofhealthyapps = 0 foreach ($app in $apps) { $health = Get-serviceFabricApplicationHealth -ApplicationName $app.ApplicationName if ($health.aggregatedhealthstate -eq "Ok") { $counterofhealthyapps = $counterofhealthyapps + 1 } else { Write-PSFMessage -Level Warning -Message "Warning: $($health.ApplicationName) is Unhealthy" if ($waittillhealthy) { $timer = 0 do { $health = Get-serviceFabricApplicationHealth -ApplicationName $app.ApplicationName $timer = $timer + 10 Start-Sleep -Seconds 10 Write-PSFMessage -Message "Waiting for $($app.ApplicationName) to be healthy" -Level VeryVerbose } until ($health.aggregatedhealthstate -eq "Ok" -or $timer -gt $Timeout) } if ($timer -gt $Timeout) { Write-PSFMessage -Message "Warning: Timeout occured" -Level Warning } } } } END {} } function Send-D365LBDUpdateMSTeams { <# .SYNOPSIS Uses switches to set different deployment options .DESCRIPTION .EXAMPLE Set-D365LBDOptions -RemoveMR .EXAMPLE #> [alias("Send-D365UpdateMSTeams")] param ( [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [switch]$PreDeployment, [switch]$PostDeployment, [switch]$RemoveMR, [switch]$MaintenanceModeOn, [switch]$MaintenanceModeOff, [string]$MSTeamsURI, [string]$MSTeamsExtraDetailsURI, [string]$MSTeamsExtraDetails, [string]$MSTeamsBuildName, [string]$MSTeamsCustomStatus, [string]$MessageType, [string]$CustomModuleName ) BEGIN { } PROCESS { switch ( $MessageType) { "PreDeployment" { $status = 'PreDeployment Started' } "PostDeployment" { $status = 'Deployment Completed' } "BuildStart" { $status = 'Build Started' } "BuildComplete" { $status = 'PreDeployment Started' } "BuildPrepStarted" { $status = 'Build Prep Started' } "BuildPrepped" { $status = 'Build Prepped' } "StatusReport" { $Status = "Status Report" } "PlainText" {} default { Stop-PSFFunction -Message "Message type $MessageType is not supported" } } if ($MSTeamsCustomStatus) { $status = "$MSTeamsCustomStatus" } if (!$MSTeamsURI) { if (!$CustomModuleName) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -CustomModuleName $CustomModuleName } else { $Config = Get-D365LBDConfig -ComputerName $ComputerName } $AgentShareLocation = $config.AgentShareLocation $EnvironmentAdditionalConfig = get-childitem "$AgentShareLocation\scripts\D365FOLBDAdmin\AdditionalEnvironmentDetails.xml" [xml]$EnvironmentAdditionalConfigXML = get-content $EnvironmentAdditionalConfig.FullName $MSTeamsURIS = $EnvironmentAdditionalConfigXML.D365LBDEnvironment.Communication.Webhooks.Webhook | Where-Object { $_.Type.'#text'.Trim() -eq "MSTeams" } if (!$MSTeamsURI -and !$MSTeamsURI) { Stop-PSFFunction -Message "Error: MS Teams URI not specified and cant find one in configs" -EnableException $true -Cmdlet $PSCmdlet } } if ($MessageType -eq "PreDeployment" -or $MessageType -eq "PostDeployment") { if (!$Config) { if (!$CustomModuleName) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -CustomModuleName $CustomModuleName } else { $Config = Get-D365LBDConfig -ComputerName $ComputerName } } if ($CustomModuleName) { $Prepped = Export-D365LBDAssetModuleVersion -CustomModuleName $CustomModuleName -config $Config if ($Prepped) { if ($Prepped.Count -eq 1) { Write-PSFMessage -Message "Found a prepped build: $Prepped" -Level VeryVerbose } else { foreach ($build in $Prepped) { Write-PSFMessage -Message "Found multiple prepped builds including: $build" -Level VeryVerbose } } } } ##$Config.CustomModuleVersioninAgentShare $bodyjson = @" { "@type": "MessageCard", "@context": "http://schema.org/extensions", "themeColor": "ff0000", "title": "D365 $LCSEnvironmentName $status", "summary": "D365 $LCSEnvironmentName $status", "sections": [{ "facts": [{ "name": "Environment", "value": "[$LCSEnvironmentName]($clienturl)" },{ "name": "Build Version/Name", "value": "$MSTeamsBuildName" },{ "name": "Status", "value": "$status" }], "markdown": true }] } "@ } if ($MSTeamsExtraDetails) { $bodyjson = @" { "@type": "MessageCard", "@context": "http://schema.org/extensions", "themeColor": "ff0000", "title": "D365 $LCSEnvironmentName $status", "summary": "D365 $LCSEnvironmentName $status", "sections": [{ "facts": [{ "name": "Environment", "value": "[$LCSEnvironmentName]($clienturl)" },{ "name": "Build Version", "value": "$MSTeamsBuildName" },{ "name": "Details", "value": "[$MSTeamsExtraDetails]($MSTeamsExtraDetailsURI)" },{ "name": "Status", "value": "$status" }], "markdown": true }] } "@ } Write-PSFMessage -Message "Calling $MSTeamsURI with Post of $bodyjson " -Level VeryVerbose if (!$MSTeamsURI) { foreach ($MSTeamsURI in $MSTeamsURIS) { $WebRequestResults = Invoke-WebRequest -uri $MSTeamsURI -ContentType 'application/json' -Body $bodyjson -UseBasicParsing -Method Post -Verbose Write-PSFMessage -Message "$WebRequestResults" -Level VeryVerbose } } else { $WebRequestResults = Invoke-WebRequest -uri $MSTeamsURI -ContentType 'application/json' -Body $bodyjson -UseBasicParsing -Method Post -Verbose Write-PSFMessage -Message "$WebRequestResults" -Level VeryVerbose } } END { } } function Set-D365LBDOptions { <# .SYNOPSIS Uses switches to set different deployment options .DESCRIPTION .EXAMPLE Set-D365LBDOptions -RemoveMR .EXAMPLE #> [alias("Set-D365Options")] param ( [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [switch]$PreDeployment, [switch]$PostDeployment, [switch]$RemoveMR, [switch]$MaintenanceModeOn, [switch]$MaintenanceModeOff, [string]$MSTeamsURI, [string]$MSTeamsExtraDetailsURI, [string]$MSTeamsExtraDetails, [string]$MSTeamsBuildName, [string]$MSTeamsCustomStatus, [string]$SQLQueryToRun ) BEGIN { } PROCESS { if (!$Config) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } if ($PreDeployment) { Write-PSFMessage -Level Verbose -Message "PreDeployment Selected" } if ($PostDeployment) { Write-PSFMessage -Level Verbose -Message "PostDeployment Selected" } if ($Config) { $agentsharelocation = $Config.AgentShareLocation $AXDatabaseServer = $Config.AXDatabaseServer $AXDatabaseName = $Config.AXDatabaseName $LCSEnvironmentName = $Config.LCSEnvironmentName $clienturl = $Config.clienturl } if ($RemoveMR) { Write-PSFMessage -Level Verbose -Message "Attempting to Remove MR" if ($PreDeployment -eq $True) { $JsonLocation = Get-ChildItem $AgentShareLocation\wp\*\StandaloneSetup-*\SetupModules.json | Sort-Object { $_.CreationTime } | Select-Object -First 1 $JsonLocationRoot = Get-ChildItem $AgentShareLocation\wp\*\StandaloneSetup-*\ copy-item $JsonLocation.fullName -Destination $AgentShareLocation\OriginalSetupModules.json $json = Get-Content $JsonLocation.FullName -Raw | ConvertFrom-Json $json.components = $json.components | Where-Object { $_.name -ne 'financialreporting' } $json | ConvertTo-Json -Depth 100 | Out-File $JsonLocationRoot\Setupmodules.json -Force -Verbose } else { Write-PSFMessage -Message "Error: Can't remove MR during anything other than PreDeployment" -Level VeryVerbose } } function Invoke-SQL { param( [string] $dataSource = ".\SQLEXPRESS", [string] $database = "MasterData", [string] $sqlCommand = $(throw "Please specify a query.") ) $connectionString = "Data Source=$dataSource; " + "Integrated Security=SSPI; " + "Initial Catalog=$database" $connection = new-object system.data.SqlClient.SQLConnection($connectionString) $command = new-object system.data.sqlclient.sqlcommand($sqlCommand, $connection) $connection.Open() $adapter = New-Object System.Data.sqlclient.sqlDataAdapter $command $dataset = New-Object System.Data.DataSet $adapter.Fill($dataSet) | Out-Null $connection.Close() $dataSet.Tables } if ($MaintenanceModeOn) { Write-PSFMessage -Message "Turning On Maintenance Mode" -Level Verbose $SQLQuery = "update SQLSYSTEMVARIABLES SET VALUE = 1 Where PARM = 'CONFIGURATIONMODE'" $Sqlresults = invoke-sql -datasource $AXDatabaseServer -database $AXDatabaseName -sqlcommand $SQLQuery if (!$PostDeployment -or !$PreDeployment) { foreach ($AXSFServer in $config.AXSFServerNames) { Restart-Computer -ComputerName $AXSFServer -Force } } Write-PSFMessage -Message "$SQLresults" -Level VeryVerbose } if ($MaintenanceModeOff) { Write-PSFMessage -Message "Turning Off Maintenance Mode" -Level Verbose $SQLQuery = "update SQLSYSTEMVARIABLES SET VALUE = 0 Where PARM = 'CONFIGURATIONMODE'" $Sqlresults = invoke-sql -datasource $AXDatabaseServer -database $AXDatabaseName -sqlcommand $SQLQuery if ($PostDeployment -eq $false -or $PreDeployment -eq $false) { foreach ($AXSFServer in $config.AXSFServerNames) { Restart-Computer -ComputerName $AXSFServer -Force } } Write-PSFMessage -Message "$SQLresults" -Level VeryVerbose } if ($EnableUserid) { ##Trim 8 characters $EnableUserid = $EnableUserid.SubString(0,8) Write-PSFMessage -Message "Enabling $EnableUserid. Note: User must already exist in system" -Level Verbose $SQLQuery = "update userinfo SET Enable = 1 Where id = '$EnableUserid'" $Sqlresults = invoke-sql -datasource $AXDatabaseServer -database $AXDatabaseName -sqlcommand $SQLQuery Write-PSFMessage -Message "$SQLresults" -Level VeryVerbose } if ($DisableUserid) { $DisableUserid = $DisableUserid.SubString(0,8) Write-PSFMessage -Message "Disabling $DisableUserid. Note: User must already exist in system" -Level Verbose $SQLQuery = "update userinfo SET Enable = 1 Where id = '$DisableUserid'" $Sqlresults = invoke-sql -datasource $AXDatabaseServer -database $AXDatabaseName -sqlcommand $SQLQuery Write-PSFMessage -Message "$SQLresults" -Level VeryVerbose } if ($SQLQueryToRun) { $Sqlresults = invoke-sql -datasource $AXDatabaseServer -database $AXDatabaseName -sqlcommand $SQLQuery Write-PSFMessage -Message "$SQLresults" -Level VeryVerbose } if ($MSTeamsURI) { if ($PreDeployment) { $status = 'PreDeployment Started' } if ($PostDeployment) { $status = 'Deployment Finished. PostDeployment Started' } if ($MSTeamsCustomStatus) { $status = "$MSTeamsCustomStatus" } $bodyjson = @" { "@type": "MessageCard", "@context": "http://schema.org/extensions", "themeColor": "ff0000", "title": "D365 $LCSEnvironmentName $status", "summary": "D365 $LCSEnvironmentName $status", "sections": [{ "facts": [{ "name": "Environment", "value": "[$LCSEnvironmentName]($clienturl)" },{ "name": "Build Version/Name", "value": "$MSTeamsBuildName" },{ "name": "Status", "value": "$status" }], "markdown": true }] } "@ if ($MSTeamsExtraDetails) { $bodyjson = @" { "@type": "MessageCard", "@context": "http://schema.org/extensions", "themeColor": "ff0000", "title": "D365 $LCSEnvironmentName $status", "summary": "D365 $LCSEnvironmentName $status", "sections": [{ "facts": [{ "name": "Environment", "value": "[$LCSEnvironmentName]($clienturl)" },{ "name": "Build Version", "value": "$MSTeamsBuildName" },{ "name": "Details", "value": "[$MSTeamsExtraDetails]($MSTeamsExtraDetailsURI)" },{ "name": "Status", "value": "$status" }], "markdown": true }] } "@ } Write-PSFMessage -Message "Calling $MSTeamsURI with Post of $bodyjson " -Level VeryVerbose $WebRequestResults = Invoke-WebRequest -uri $MSTeamsURI -ContentType 'application/json' -Body $bodyjson -UseBasicParsing -Method Post -Verbose Write-PSFMessage -Message "$WebRequestResults" -Level VeryVerbose } } END { } } function Start-D365LBDDBSync { <# .SYNOPSIS Starts a Database Synchronization on a Dynamics 365 Finance and Operations Server .DESCRIPTION Starts a Database Synchronization on a Dynamics 365 Finance and Operations Server using the "Microsoft.Dynamics.AX.Deployment.Setup.exe" executable .EXAMPLE Start-D365FOLBDDBSync .EXAMPLE Start-D365FOLBDDBSync .PARAMETER AXSFServer Parameter string The name of the Local Business Data Computer that is runnign the AXSF role. If ignored will use local host. .PARAMETER AXDatabaseServer Parameter string The name of the Local Business Data SQL Database Computer .PARAMETER AXDatabaseName Parameter string The name of the Local Business Data SQL Database name. .PARAMETER SQLUser Parameter string The name of the user to login with SQL authentication .PARAMETER SQLUserPassword Parameter string The password of the user to login with SQL authentication .PARAMETER Timeout Parameter int The timeout period of the database synchronization #> [alias("Start-D365DBSync", "Start-D365FOLBDDBSync")] [CmdletBinding()] param ( [Parameter(Mandatory = $False, ParameterSetName = 'NoConfig')] [string]$AXSFServer, ## Remote execution needs to be tested and worked on use localhost until then [Parameter(Mandatory = $true, ParameterSetName = 'NoConfig')] [string]$AXDatabaseServer, [Parameter(Mandatory = $true, ParameterSetName = 'NoConfig')] [string]$AXDatabaseName, [Parameter(Mandatory = $true)] [string]$SQLUser, [Parameter(Mandatory = $true)] [string]$SQLUserPassword, [int]$Timeout = 60, [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME" ) begin { } process { $starttime = Get-date if ($ComputerName -and !$Config -and !$AXSFServer) { $Config = Get-D365LBDConfig -ComputerName $ComputerName -HighLevelOnly } if ($Config) { $AXDatabaseServer = $Config.AXDatabaseServer $AXDatabaseName = $Config.AXDatabaseName $AXSFServer = $Config.AXSFServer } $LatestEventinLog = $(Get-WinEvent -LogName Microsoft-Dynamics-AX-DatabaseSynchronize/Operational -maxevents 1 -computername $AXSFServerName -ErrorAction Stop).TimeCreated if (($AXSFServer.IsLocalhost) -or ($AXSFServer -eq $env:COMPUTERNAME) -or ($AXSFServer -eq "$env:COMPUTERNAME.$env:UserDNSDOMAINNAME")) { Write-PSFMessage -Message "AXSF is local Server" -Level Verbose Write-PSFMessage -Message "Looking for the AX Process to find deployment exe and the packages folder to start the Database Synchronize" -Level Warning $AXSFCodeFolder = Split-Path $(Get-Process | Where-Object { $_.name -eq "AXService" }).Path -Parent $AXSFCodePackagesFolder = Join-Path $AXSFCodeFolder "\Packages" $AXSFCodeBinFolder = Join-Path $AXSFCodeFolder "\bin" $D365DeploymentExe = Get-ChildItem $AXSFCodeBinFolder | Where-Object { $_.Name -eq "Microsoft.Dynamics.AX.Deployment.Setup.exe" } $CommandLineArgs = '-metadatadir {0} --bindir {1} --sqlserver {2} --sqldatabase {3} --sqluser {4} --sqlpwd {5} --setupmode sync --syncmode fullall --isazuresql false --verbose true' -f $AXSFCodePackagesFolder, $AXSFCodePackagesFolder, $AXDatabaseServer, $AXDatabaseName, $SQLUser, $SQLUserPassword Write-PSFMessage -Level Verbose -Message "$($D365DeploymentExe.FullName)" Write-PSFMessage -Level Verbose -Message '-metadatadir {0} --bindir {1} --sqlserver {2} --sqldatabase {3} --sqluser {4} --sqlpwd removed --setupmode sync --syncmode fullall --isazuresql false --verbose true' -f $AXSFCodePackagesFolder, $AXSFCodePackagesFolder, $AXDatabaseServer, $AXDatabaseName, $SQLUser $DbSyncProcess = Start-Process -filepath $D365DeploymentExe.FullName -ArgumentList $CommandLineArgs -Verbose -PassThru -OutVariable out if ($DbSyncProcess.WaitForExit(60000 * $Timeout) -eq $false) { $DbSyncProcess.Kill() Stop-PSFFunction -Message "Error: Database Sync failed did not complete within $timeout minutes" -EnableException $true -Cmdlet $PSCmdlet } else { return $true; } } else { Write-PSFMessage -Message "Connecting to admin share on $AXSFServer for cluster config" -Level Verbose if ($(Test-Path "\\$AXSFServer\C$\ProgramData\SF\clusterManifest.xml") -eq $false) { Stop-PSFFunction -Message "Error: This is not an Local Business Data server. Can't find Cluster Manifest. Stopping" -EnableException $true -Cmdlet $PSCmdlet } Write-PSFMessage -Message "Not running DB Sync locally due to not AXSF server will trigger via WinRM" -Level Verbose $process = Invoke-PSFCommand -ComputerName $AXSFServer -ScriptBlock { Write-PSFMessage -Message "Looking for the AX Process to find deployment exe and the packages folder to start the Database Synchronize" -Level Warning $AXSFCodeFolder = Split-Path $(Get-Process | Where-Object { $_.name -eq "AXService" }).Path -Parent $AXSFCodePackagesFolder = Join-Path $AXSFCodeFolder "\Packages" $AXSFCodeBinFolder = Join-Path $AXSFCodeFolder "\bin" $D365DeploymentExe = Get-ChildItem $AXSFCodeBinFolder | Where-Object { $_.Name -eq "Microsoft.Dynamics.AX.Deployment.Setup.exe" } ##Props to Microsoft for below technique in next few lines copied/learned from the 2012 deployment scripts https://gallery.technet.microsoft.com/scriptcenter/Build-and-deploy-for-b166c6e4 $CommandLineArgs = '-metadatadir {0} --bindir {1} --sqlserver {2} --sqldatabase {3} --sqluser {4} --sqlpwd {5} --setupmode sync --syncmode fullall --isazuresql false --verbose true' -f $AXSFCodePackagesFolder, $AXSFCodePackagesFolder, $AXDatabaseServer, $AXDatabaseName, $SQLUser, $SQLUserPassword Write-PSFMessage -Level Verbose -Message "$($D365DeploymentExe.FullName)" Write-PSFMessage -Level Verbose -Message '-metadatadir {0} --bindir {1} --sqlserver {2} --sqldatabase {3} --sqluser {4} --sqlpwd removed --setupmode sync --syncmode fullall --isazuresql false --verbose true' -f $AXSFCodePackagesFolder, $AXSFCodePackagesFolder, $AXDatabaseServer, $AXDatabaseName, $SQLUser $DbSyncProcess = Start-Process -filepath $D365DeploymentExe.FullName -ArgumentList $CommandLineArgs if ($DbSyncProcess.WaitForExit(60000 * $Timeout) -eq $false) { $DbSyncProcess.Kill() return $false; Stop-PSFFunction -Message "Error: Database Sync failed did not complete within $timeout minutes" -EnableException $true -Cmdlet $PSCmdlet } else { return $true; } } -Verbose } $currtime = Get-date $timediff = New-TimeSpan -Start $starttime -End $currtime $LatestEventinLogNew = $(Get-WinEvent -LogName Microsoft-Dynamics-AX-DatabaseSynchronize/Operational -maxevents 1 -computername $AXSFServerName -ErrorAction Stop).TimeCreated if ($LatestEventinLogNew -eq $LatestEventinLog ) { Write-PSFMessage -Level Verbose -Message "No deployment happened, check username/password or SQL cert expiration" } else { Write-PSFMessage -Level Verbose -Message "Database Sync took $timediff" } } end { } } function Start-D365LBDMonitorDeployment { <# .SYNOPSIS Looks inside the agent share extracts the version from the zip by using the custom module name. Puts an xml in root for easy idenitification .DESCRIPTION Exports .EXAMPLE Start-D365LBDMonitorDeployment .EXAMPLE Export-D365FOLBDAssetModuleVersion .PARAMETER AgentShare optional string The location of the Agent Share .PARAMETER CustomModuleName optional string The name of the custom module you will be using to capture the version number #> [alias("Start-D365MonitorDeployment")] param ( [Parameter(Mandatory = $true)] [int]$Timeout ) BEGIN { } PROCESS { $propsToCompare = $Primary[0].psobject.properties.name $allnow = $Primary + $secondary | Sort-Object { $_.TimeCreated } -Descending | Select-Object -First $NumberofEventsToCheck if (Compare-Object -ReferenceObject $all -DifferenceObject $allnow -Property $propsToCompare) { $allnow } else { Write-Host "Nothing New" } } END { } } function Update-ServiceFabricD365ClusterConfig { <# .SYNOPSIS .DESCRIPTION .EXAMPLE Update-ServiceFabricD365ClusterConfig .EXAMPLE Update-ServiceFabricD365ClusterConfig -ComputerName "LBDServerName" -verbose .PARAMETER ComputerName String The name of the D365 LBD Server to grab the environment details; needed if a config is not specified and will default to local machine. .PARAMETER Config Custom PSObject Config Object created by either the Get-D365LBDConfig or Get-D365TestConfigData function inside this module #> [CmdletBinding()] param([Parameter(ValueFromPipeline = $True, ValueFromPipelineByPropertyName = $True, Mandatory = $false, HelpMessage = 'D365FO Local Business Data Server Name')] [PSFComputer]$ComputerName = "$env:COMPUTERNAME", [Parameter(ParameterSetName = 'Config', ValueFromPipeline = $True)] [psobject]$Config, [string]$Workingfolder = "C:\temp" ) BEGIN { if ((!$Config)) { Write-PSFMessage -Message "No paramters selected will try and get config" -Level Verbose $Config = Get-D365LBDConfig -ComputerName $ComputerName } } PROCESS { $SFNumber = $Config.SFVersionNumber [int]$count = 1 $OrchestratorServerName = $config.OrchestratorServerNames | Select-Object -First $count Write-PSFMessage -Message "Verbose: Reaching out to $OrchestratorServerName for service Fabric cab file version $SFNumber" -Level Verbose $SFFolder = get-childitem "\\$OrchestratorServerName\C$\ProgramData\SF\*\Fabric\work\Applications\__FabricSystem_App*\work\Store\*\$SFNumber" if (!$SFFolder) { do { $OrchestratorServerName = $config.OrchestratorServerNames | Select-Object -First $count Write-PSFMessage -Message "Verbose: Reaching out to $OrchestratorServerName for service Fabric cab file" -Level Verbose $SFFolder = get-childitem "\\$OrchestratorServerName\C$\ProgramData\SF\*\Fabric\work\Applications\__FabricSystem_App*\work\Store\*\$SFNumber" $count = $count ++ Write-PSFMessage -Message "Count of servers tried $count" -Verbose } until ($SFFolder -or ($count -eq $OrchestratorServerNames.Count)) } $SFCab = Get-ChildItem $SFFolder.FullName Copy-Item -Path $SFCab.FullName -Destination $Workingfolder\MicrosoftAzureServiceFabric.cab -Verbose try { Write-PSFMessage -Message "Trying to connect to $($config.SFConnectionEndpoint) using $($config.SFServerCertificate)" -Level Verbose $SFModuleSession = New-PSSession -ComputerName $OrchestratorServerName $module = Import-Module -Name ServiceFabric -PSSession $SFModuleSession $connection = Connect-ServiceFabricCluster -ConnectionEndpoint $config.SFConnectionEndpoint -X509Credential -FindType FindByThumbprint -FindValue $config.sfServerCertificate -ServerCertThumbprint $config.SFServerCertificate -StoreLocation LocalMachine -StoreName My Get-ServiceFabricClusterConfiguration -UseApiVersion -ApiVersion 10-2017 >$Workingfolder\ClusterConfig.json Write-PSFMessage -Level Verbose -Message "$Workingfolder\ClusterConfig.json Created Need to modify this JSON then run Start-ServiceFabricClusterConfigrationUpgrade" if ($config.InvalidSFServers) { Write-PSFMessage -Message "Warning: Suggest removing invalid Node(s) $($config.InvalidSFServers)" -Level Warning Write-PSFMessage -Message "Warning: Make sure to remove the ""WindowsIdentities"" $$id 3 area under security (if exists) " -Level Warning } $JSON = get-content $Workingfolder\ClusterConfig.json -raw | ConvertFrom-Json $versiontostring = $JSON.ClusterConfigurationVersion $version = [version]$versiontostring $versionincremented = [string][version]::new( $version.Major, $version.Minor, $version.Build + 1 ) Write-PSFMessage -Level Verbose -Message "Version updated from $versiontostring to $Versionincremented" foreach ($invalidnode in $config.InvalidSFServers) { $RemoveNodeJSON = @" { "name":"NodesToBeRemoved", "value":"$invalidnode" } "@ $JSON.ClusterConfigurationVersion = $versionincremented $parameters = $JSON.Properties.FabricSettings.Parameters $parametersnew = $parameters + (ConvertFrom-Json $RemoveNodeJSON) $JSON.Properties.FabricSettings | Add-Member -type NoteProperty -name "Parameters" -Value $parametersnew -Force Write-PSFMessage -Level Verbose -Message "NodesToBeRemoved $invalidnode added to JSON" } $JSON | ConvertTo-Json -Depth 32 | Set-Content $Workingfolder\ClusterConfig.json Write-PSFMessage -Level VeryVerbose -Message "$Workingfolder\ClusterConfig.json updated and ready to be used." } catch { Write-PSFMessage -message "Can't Connect to Service Fabric $_" -Level Verbose } } end { } } <# This is an example configuration file By default, it is enough to have a single one of them, however if you have enough configuration settings to justify having multiple copies of it, feel totally free to split them into multiple files. #> <# # Example Configuration Set-PSFConfig -Module 'D365FOLBDAdmin' -Name 'Example.Setting' -Value 10 -Initialize -Validation 'integer' -Handler { } -Description "Example configuration setting. Your module can then use the setting using 'Get-PSFConfigValue'" #> Set-PSFConfig -Module 'D365FOLBDAdmin' -Name 'Import.DoDotSource' -Value $false -Initialize -Validation 'bool' -Description "Whether the module files should be dotsourced on import. By default, the files of this module are read as string value and invoked, which is faster but worse on debugging." Set-PSFConfig -Module 'D365FOLBDAdmin' -Name 'Import.IndividualFiles' -Value $false -Initialize -Validation 'bool' -Description "Whether the module files should be imported individually. During the module build, all module code is compiled into few files, which are imported instead by default. Loading the compiled versions is faster, using the individual files is easier for debugging and testing out adjustments." <# Stored scriptblocks are available in [PsfValidateScript()] attributes. This makes it easier to centrally provide the same scriptblock multiple times, without having to maintain it in separate locations. It also prevents lengthy validation scriptblocks from making your parameter block hard to read. Set-PSFScriptblock -Name 'D365FOLBDAdmin.ScriptBlockName' -Scriptblock { } #> <# # Example: Register-PSFTeppScriptblock -Name "D365FOLBDAdmin.alcohol" -ScriptBlock { 'Beer','Mead','Whiskey','Wine','Vodka','Rum (3y)', 'Rum (5y)', 'Rum (7y)' } #> <# # Example: Register-PSFTeppArgumentCompleter -Command Get-Alcohol -Parameter Type -Name D365FOLBDAdmin.alcohol #> New-PSFLicense -Product 'D365FOLBDAdmin' -Manufacturer 'Stefan' -ProductVersion $script:ModuleVersion -ProductType Module -Name MIT -Version "1.0.0.0" -Date (Get-Date "2019-11-12") -Text @" Copyright (c) 2019 Stefan Land Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. "@ #endregion Load compiled code |