Source: http://www.ssas-info.com/analysis-services-scripts/1197-powershell-script-to-list-info-about-ssas-databases slightly modified param($ServerName = “localhost”, $dbname = “db_name”) ## Add the AMO namespace $loadInfo = [Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices”) $server = New-Object Microsoft.AnalysisServices.Server $server.connect($ServerName) if ($server.name -eq $null) { Write-Output (“Server ‘{0}’ not found” -f $ServerName) break } foreach ($d in $server.Databases ) { if ($d.Name -ne $dbname) { continue;Czytaj dalej / Read more
Category: Useful Scripts
TSQL query for generating a report from SSISDB with SSIS package processed in execution
And the thanks goes to Michał Powaga for providing me that script below 😉 USE SSISDB; GO SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; DECLARE @execution_id BIGINT = 70660; — your package id WITH msgs AS ( SELECT event_message_id , execution_path , package_name , package_path_full , event_name , message_source_name , package_pathCzytaj dalej / Read more