• State Suggested Answer
  • Locked Locked
  • Replies 9 replies
  • Answers 1 answer
  • Subscribers 12 subscribers
  • Views 10683 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Enhancement request - Ability to register multiple SQL Instances like CMS

dba_27450
over 7 years ago

Hello

 

We have noticed that there is an option to register SQL Instances in Litespeed console, but the registrations are available only to the person's profile. Other members in the team cannot view the same list and each individual has to register all of them again to view the whole list.

 

It would be nice to have something like SQL Server's (Central Management Server) where the connections can be edited by one person and the list gets updated for every other person with access to view them. Even Spotlight has a connection Manager where the list stays updated for everyone who has access regardless of who updates the list. Is this something that can be included in the future release?

 

This would make our operational tasks a lot easier.

 

Thanks!

  • 0 over 7 years ago
    Hello

    Thank you for feedback!

    Actually this feature is already in LiteSpeed. You need to use Central repository and select Central view in View toolbar tab. All uses who use the same central repository will see common Sql instances registrations tree.

    Alexander.
  • 0 over 7 years ago
    Hi Alexander, thank you for the feedback. Looks like that is possible only if activity logging & Central repository are setup. But we do not like to setup activity logging, and we have having difficulty with having all the SQL Instances in one view. We would like to see something similar to SQL CMS view without having to go thru activity logging and setting up Central Repository. Can this be considered as a future enhancement?
  • 0 over 6 years ago
    Hello,

    Just for clarification.

    You would like an enhancement that allows for a central view (rather than just a local view as is the case now) of SQL servers in the Litespeed console without having to setup a Litespeed central repository.


    Is this correct?

    thanks,
  • 0 over 6 years ago

    This may be hard to implement as having a centralized list for all Litespeed consoles to display requires having a centralized repository, in some form, for the console to pull that list from.

    Please note I have created LS-378 as an enhancement request to add this ability to Litepseed.

    Thanks,
    -Ben-

  • 0 over 6 years ago
    Thank you for putting the request in. Is it possible to register multiple SQL Instances at a time in Litespeed console (by adding that information is some file on disk)? We have about 150 SQL Instances approximately and I am trying to find out if adding the information a certain file on disk would register all SQL Instances in one shot. Please note that we don't have central repository or logging enabled.
  • 0 over 6 years ago
    Hello,

    Please review the help files under the following section (via a search).

    Register Server Instances

    It shows how you can use a csv file to import SQL server instances.


    Hope that helps,
    -Ben-
  • 0 over 6 years ago

    further you can also import from a .regsrvr file created  by SSMS

     EXAMPLE: export from SSMS

     

     Import into Litespeed

     

     

     

    Hope that helps,

    -Ben-

  • 0 over 6 years ago
    Thank you, this is very helpful.