alex_pixley (9/24/2014)
Shawn,Thanks for the reply. I was looking for something simple that could be run on demand. If SSRS can't do what I've described, I'd rather build an SSIS package to do this.
Thanks,
Alex
If you just want the information on demand write it in PowerShell and have it build out an HTML report file.
[void][System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO')
$sList = "myServer1","myServer2\Instance1","myserver3"
$results = foreach ($s in $sList)
{
$srv = new-object microsoft.sqlserver.management.smo.server $s
$srv.Databases["tempdb"] | Select @{Label="ServerName";Expression={$s}}, @{Label="UpSince";Expression={$_.CreateDate}}
}
$results | ConverTo-Html | Out-File C:\Temp\Test.html
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton