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.
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.
Hi there,
You can use the Discovery feature of the Connection Manager.
Hope that helps out.
Gita
Spotlight Support Team
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?
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)
server1,sa,pwd server2,sa,pwd