Redgate sql server monitoring tool - extracting summary of sql servers

Sorry everyone this SQL server post is going to sneak on here.

We have the redgate sqlmonitoring tool installed (we tried grid/cloud control and it wasn't that good i'm afraid to say) and we just wanted a summary of the instances we are monitoring - to extract this i created the following SQL:


SELECT    
      [Cluster_Name]+'\'+[Cluster_SqlServer_Name],[Cluster_SqlServer_Properties_ProductVersion]  
      ,[Cluster_SqlServer_Properties_ProductLevel],[Cluster_SqlServer_Properties_Edition]
  FROM [RedGateMonitor].[data].[Cluster_SqlServer_Properties_StableSamples_View]

This won't be the start of a lot of SQL server posts......

Comments