Red Gate forums :: View topic - Export monitored server list
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Export monitored server list

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Lee Mellor



Joined: 26 Oct 2009
Posts: 11

PostPosted: Wed Jul 31, 2013 11:22 am    Post subject: Export monitored server list Reply with quote

Hi,

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

Thanks,

Lee
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Thu Aug 01, 2013 12:55 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Lee Mellor



Joined: 26 Oct 2009
Posts: 11

PostPosted: Fri Aug 02, 2013 12:15 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Lee Mellor



Joined: 26 Oct 2009
Posts: 11

PostPosted: Thu Aug 15, 2013 11:54 am    Post subject: query again Reply with quote

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.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Fri Aug 30, 2013 4:52 pm    Post subject: Reply with quote

Hi Lee,

You can use this view instead data.Cluster_SqlServer_Properties_StableSamples_View.

Thanks,
Priya
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group