#Variables initialization
$SqlServer = "SQL Server FQDN\INSTANCE,PORTNR"
$SqlCatalog = "VaultStoreDatabaseName"
$strDateyyyyMMdd = (Get-Date).ToString("yyyyMMddHHmm")
$CurrentPath = Split-Path -Path $MyInvocation.MyCommand.Definition -Parent
$OutputFile = "$CurrentPath\$SqlCatalog-IngestedData-$strDateyyyyMMdd.txt" 
$timeout = 600

$SqlQuery = "select ""Archived Date"" = left (convert (varchar, archiveddate,20),10), ""Daily Rate"" = count (*), ""MB (original)"" = sum (originalsize)/1024/1024, ""MB (compressed)"" = sum (itemsize)/1024  from saveset,savesetproperty WHERE saveset.savesetidentity = savesetproperty.savesetidentity and archiveddate > dateadd(""dd"", -7, getdate ()) group by left (convert (varchar, archiveddate,20),10) 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
$DataSet.Tables[0] | Export-CSV $OutputFile 
$SqlConnection.Close()