Use Jason's script: http://blog.configmgrftw.com/sql-server-inventory-using-configmgr/ As a ConfigItem (a vbscript) targeted to your population you care about, and extend hardware inventory.
for me with the view I ended up with, something like this: select s1.netbios_name0, si.* from v_gs_sqlinstance si join v_r_system s1 on s1.resourceid=si.resourceid where si.InstanceType0 = 'RS' (Because RS means "reporting services", at least I assume so. On Wed, Sep 28, 2016 at 3:24 PM, Brian McDonald <[email protected]> wrote: > 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 > > -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org
