Metadata Collection - SQL Server Integration Services Design Patterns - page 20

AND instance_name <> '_Total'
GROUP BY instance_name;

This query will produce results similar to the following.

captureDate serverName
databaseName dataSizeInKB logSizeInKB
----------------------- ----------
-------------------------- ------------ -----------
2014-06-29 19:52:21.543
LOCALHOST _Total 1320896 274288

2014-06-29 19:52:21.543
LOCALHOST AdventureWorks2012 193536 496

2014-06-29 19:52:21.543
LOCALHOST dbaCentralLogging 1048576 262136

2014-06-29 19:52:21.543
LOCALHOST master

4096 760

2014-06-29 19:52:21.543
LOCALHOST model

2112 760

2014-06-29 19:52:21.543
LOCALHOST msdb 14080 760

2014-06-29 19:52:21.543
LOCALHOST mssqlsystemresource 40960 504

2014-06-29 19:52:21.543
LOCALHOST ReportServer$SQL2012 5184 7032

2014-06-29 19:52:21.543
LOCALHOST ReportServer$SQL2012TempDB 4160 1080

2014-06-29 19:52:21.543
LOCALHOST tempdb

8192 760

(10 row(s) affected)

Your OLE DB Source Editor should now resemble the editor in Figure 1-15 . Click
Parse Query to ensure the SQL syntax is correct, and then click Preview at the bottom
of the editor to see a sample of the results. Click OK to exit the OLE DB Source Editor.