Export monitored server list

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Export monitored server list

Postby Lee Mellor » Wed Jul 31, 2013 11:22 am

Hi,

Is it possible to either export the names of the monitored servers or query the monitor database to extract that information?

Thanks,

Lee
Lee Mellor
 
Posts: 11
Joined: Mon Oct 26, 2009 2:33 pm

Postby chriskelly » Thu Aug 01, 2013 12:55 pm

There is no export function for the monitored servers list. The data that you are after can be found in the following tables in the data repository. However, we do not provide any documentation for the database schema.

settings.Clusters
settings.Machines
settings.SqlServers
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby Lee Mellor » Fri Aug 02, 2013 12:15 pm

hi Chris,

thanks for the response. the cluster table seems to hold what i need. i did look in the sqlservers and machines tables but couldnt find a plain text server name field.

regards,

lee.
Lee Mellor
 
Posts: 11
Joined: Mon Oct 26, 2009 2:33 pm

query again

Postby Lee Mellor » Thu Aug 15, 2013 11:54 am

hi Chris,

is there a way to link the info contained in data.Cluster_SqlServer_Properties_StableSamples
to the info in [settings].[Clusters] or [settings].[SqlServers]?

im asking as im using this info to collect info from each server with regards to user/login permissions. my collection method uses the system tables that are not available in sql 2000 and i have 1 sql 2000 server being monitored which causes my process to fail.

thanks,

Lee.
Lee Mellor
 
Posts: 11
Joined: Mon Oct 26, 2009 2:33 pm

Postby priyasinha » Fri Aug 30, 2013 4:52 pm

Hi Lee,

You can use this view instead data.Cluster_SqlServer_Properties_StableSamples_View.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests