Set-sqmConfig
Examples
Set-sqmConfig -LogPath "D:\Logs" -OlaJobNameFull "Prod-FULL"
Set-sqmConfig -LogPath "D:\Logs" -OlaJobNameFull "Prod-FULL"
Set-sqmConfig -TsmManagementClasses @('MC_10','MC_30','MC_100')
Set-sqmConfig -TsmManagementClasses @('MC_10','MC_30','MC_100')
Set-sqmConfig -HpuDomainGroupMap @(
Set-sqmConfig -HpuDomainGroupMap @(
[PSCustomObject]@{ DomainPattern = '*.sfinance.net'; GroupNamePattern = 'Rg_DC_AouAllowManageAuditSecLogSrvAll_Mod' },
[PSCustomObject]@{ DomainPattern = '*'; GroupNamePattern = 'Rg_DC_AouAllowManageAuditSecLogSrvAll_Mod' }
)
Set-sqmConfig -SsrsInstallerPath '\\srv-share\Software\SSRS2022\SQLServerReportingServices.exe'
Set-sqmConfig -SsrsInstallerPath '\\srv-share\Software\SSRS2022\SQLServerReportingServices.exe'
Export-sqmDatabaseDocumentation
Export-sqmDatabaseDocumentation
Export-sqmDatabaseDocumentation -SqlInstance "SQL01" -Database "SalesDB","HRApp" -OutputPath "D:\Reports"
Export-sqmDatabaseDocumentation -SqlInstance "SQL01" -Database "SalesDB","HRApp" -OutputPath "D:\Reports"
Export-sqmDatabaseDocumentation -SqlInstance "SQL01" -IncludeSystemDatabases -ContinueOnError
Export-sqmDatabaseDocumentation -SqlInstance "SQL01" -IncludeSystemDatabases -ContinueOnError
# Multiple instances via pipeline
# Multiple instances via pipeline
"SQL01","SQL02","SQL03" | Export-sqmDatabaseDocumentation -ContinueOnError