Interrogate Installed instances on Network

• J-174451

  SSChasing Mays

  Points: 602

  More actions

  May 9, 2007 at 10:42 pm

  #195576

  Does anyone know how I can interrogate the network to find out how what SQL Server 2005 Reporting services instances there are installed?

  I use OSQL -L to fien the SQL Server Instances, but I need to to find Reporting Services.

   

  Any help, much appreciated.

  ---

  cheers,

  J
  

• Ben Sullins-437405

  SSCertifiable

  Points: 5397

  More actions

  May 10, 2007 at 4:48 pm

  #705679

  You should be able to use Windows Management Instrumentation to find what servers have it installed and possibly this will give the name of the instance since it would be included in the service name? SSIS also has some WMI tasks that could capture this info...

  cheers,

  Ben

  ---

  Cheers,

  Ben Sullins
  bensullins.com
  Beer is my primary key...

• J-174451

  SSChasing Mays

  Points: 602

  More actions

  May 10, 2007 at 6:03 pm

  #705687

  Thanks Ben,

  anyone out there have such a script ?

  

  ---

  cheers,

  J