There is a built-in report called "Services - Computers running a specific service" that would be a start. However, the service name is different for ones using a named instance rather than the default.
The easiest thing might be to create a Query with the following statement: select distinct SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.SystemOUName from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name like "ReportServer%" DAMIEN SOLODOW Senior Systems Engineer 317.447.6033 (office) HARRISON COLLEGE From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Wednesday, September 28, 2016 4:24 PM To: mssms@lists.myitforum.com Subject: [mssms] SSRS Instances Hey all, I was wondering if anyone can tell me how I can get an inventory of all SSRS instances for all SQL Servers? Specifically, I need to know where the SSRS service is running. Has anyone have any samples they can share? Thanks, Brian
