I know this probably could be posted under the "SQL_Accessibility Data
Collection" but thought starting a new thread would be better. I am
trying to put together a Operations Dashboard in SSRS that has the
follow information from the query below:

SELECT name, database_id, create_date, state_desc, is_in_standby,
is_cleanly_shutdown FROM sys.databases

NAME DATABASE_ID CREATE_DATE STATE_DESC
IS_IN_STANDBY IS_CLEANLY_SHUTDOWN
master 1 2003-04-08 09:13:36.390 ONLINE
0 0

Is there a way I can do this within AppManager? I tried using the
RunSQL job but it just gives me the number of rows returned, that's it.
Any help would be greatly appreciated.

v/r
Chris


--
abel5405
------------------------------------------------------------------------
abel5405's Profile: https://forums.netiq.com/member.php?userid=5035
View this thread: https://forums.netiq.com/showthread.php?t=56985