• State Verified Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 7 subscribers
  • Views 3677 views
  • Users 0 members are here
Options
Related

Batch adding new SQL server for Spotlight monitoring

flan
over 3 years ago

Dear All: I plan to add 50+ SQL server/SSAS/Windows servers into Spotlight monitoring.

Is there any tool/script existing to allow me import server information to Spotlight? 

Current Spotlight version is 13.0.0.7. Thank ahead.

Parents Reply Children
  • +1 over 3 years ago in reply to Gita Sharifi

    Thank you but I notice that there is a file import option exist.

    May I have a sample import file with specify monitoring template specified? 

  • 0 over 3 years ago in reply to flan

    Hi there,

    See attached for a simple sample file. With this format, the Discover import option creates two SQL connections with their associated Windows connections. The credentials of the SQL connections are defined in the file or you can leave those fields blank if you'd like for Spotlight to use the Diagnostic Server owner account. The Windows connections will be created using the Diagnostic Server owner account.  (Note, Discover feature doesn't import SSAS type connections)

    connections.txt 
    server1,sa,pwd
server2,sa,pwd