Post reply

Find all instances of SSRS in a domain

  • May 13, 2010 at 7:04 am

    #218894

    There is probably a uber-simple answer to this question, but how would someone go about finding out all instances of SSRS in a particular domain?

    There are 50+ physical servers and probably 150+ instances of SQL Server itself, so I'd like to avoid a manual search. I would also like to get the default address for each because the couple of SSRS instances that I know of have different naming conventions (I.e. one may be http://myserver/Reports or http://myserver/SQLreports or http://myserver/prod/reports)

    Any help is appreciated!

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • May 13, 2010 at 7:23 am

    #1166857

    wow that's a good question; i hadn't thought about auditing Reporting service instances....

    do you think it would it be enough to use something like SQLRecon to find all SQL instances, then trying to connect to each and look for any database that is like '%ReportServer%'? that would infer that Report Services is installed, right?

    I had used SQLRecon to gather a list of servers previously, so this seems like a possibility.

    I'll test it on my LAN and see if the idea is worthy and report back.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

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