Post reply

Hi , How to check how many servers are there and information at a time in one command

  • November 23, 2011 at 7:48 am

    #252338

    Hi All ,

    How to check how many servers are there in sql server

    and

    how to see all information at a time.

    and how to check all the databases information at a time.

  • November 23, 2011 at 7:54 am

    #1412210

    I'm not sure what you mean.

    Are you trying to inventory all the servers on your network?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • November 23, 2011 at 9:18 am

    #1412302

    I mean, Suppose if I have around 100 servers and each server has number of databases. Is there any way to find out info about all these databases of all the 100 servers at a time?

  • November 23, 2011 at 9:36 am

    #1412316

    think what you are looking for is a central management server, will require all the "100" servers being registered under the CMS but you can execute a query against the CMS and it will run on all of the servers who are managed by that one CMS.

  • November 23, 2011 at 2:42 pm

    #1412495

    You might want to have a look at Quests Discovery Wizard[/url].


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • November 24, 2011 at 6:05 am

    #1412668

    You can use "SQLCMD -Lc" from CMD to produce the list of the SQL server instances on your network.

    Albeit , keep in mind that the output of this command can vary from time to time. Also the browser service must be started for this to work.

    Sujeet Singh

  • December 1, 2011 at 12:20 am

    #1415050

    Hi,

    I think, Single command is not possible. Please use windows powershell script for inventory purpose.

    If you have the server name inventory then the following link is very useful.

    http://www.mssqltips.com/sqlservertip/1759/retrieve-a-list-of-sql-server-databases-and-their-properties-using-powershell/

    Or

    Please try this one:

    http://www.mssqltips.com/sqlservertip/2013/find-sql-server-instances-across-your-network-using-windows-powershell/

    Thanks

    Sam

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply