Export monitored server list
Lee Mellor
Posts: 14
Hi,
Is it possible to either export the names of the monitored servers or query the monitor database to extract that information?
Thanks,
Lee
Is it possible to either export the names of the monitored servers or query the monitor database to extract that information?
Thanks,
Lee
Comments
settings.Clusters
settings.Machines
settings.SqlServers
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.
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.
You can use this view instead data.Cluster_SqlServer_Properties_StableSamples_View.
Thanks,
Priya
Project Manager
Red Gate Software