PSQUERY #Variables initialization $databaselist = get-content 'D:\Scripts\MBXJNL.txt' $SqlServer = "FQDN of SQL server\INSTANCE,PORT" $strDateyyyyMMdd = (Get-Date).ToString("yyyyMMddHHmm") $CurrentPath = Split-Path -Path $MyInvocation.MyCommand.Definition -Parent $OutputFile = "D:\Scripts\Logs_MBX\MBX_IngestedData-$strDateyyyyMMdd.txt" Foreach ($SqlCatalog in $databaselist) { $timeout = 600 $SqlQuery = "select ""Archived Date"" = left (convert (varchar, archiveddate,20),14), ""Hourly Rate"" = count (*), ""MB (original)"" = sum (originalsize)/1024/1024, ""MB (compressed)"" = sum (itemsize)/1024, ""Start Time (Minute)"" = min(Datepart(minute,ArchivedDate)), ""End Time (Minute)"" = max(datepart(minute,ArchivedDate)) from saveset,savesetproperty WHERE saveset.savesetidentity = savesetproperty.savesetidentity and archiveddate > dateadd(""hh"", -25, getdate ()) group by left (convert (varchar, archiveddate,20),14) ORDER BY ""Archived Date""" $SqlConnection = New-Object System.Data.SqlClient.SqlConnection $SqlConnection.ConnectionString = "Server = $SqlServer; Database = $SqlCatalog; Integrated Security = True" $SqlCmd = New-Object System.Data.SqlClient.SqlCommand $SqlCmd.CommandText = $SqlQuery $SqlCmd.CommandTimeout = $timeout $SqlCmd.Connection = $SqlConnection $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter $SqlAdapter.SelectCommand = $SqlCmd $DataSet = New-Object System.Data.DataSet $SqlAdapter.Fill($DataSet) #Output the created table $object = @() $object = $DataSet.Tables[0] $object | add-member -MemberType NoteProperty -Name "Database" -Value $SqlCatalog $object | Export-CSV -append $OutputFile $SqlConnection.Close() } BATFILE c:\WINDOWS\SysWow64\windowspowershell\v1.0\powershell .\24hrs.ps1 DBNAME EVVSJournalStore001_01 EVVSJournalStore002_02 EVVSJournalStore003_03 EVVSJournalStore004_04 EVVSJournalStore005_05 EVVSJournalStore006_06 EVVSJournalStore007_07 EVVSJournalStore008_08