Export monitored server list

• 
  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

  chriskelly August 01, 2013 07:55

  - 0 +
• 
  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 August 02, 2013 07:15

  - 0 +
• 
  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 August 15, 2013 06:54

  - 0 +
• 
  Hi Lee,
  
  You can use this view instead data.Cluster_SqlServer_Properties_StableSamples_View.
  
  Thanks,
  Priya

  priyasinha August 30, 2013 11:52

  - 0 +

Add comment

Please sign in to leave a comment.