Sherry,
This script looks great. I do not understand this though: "add the class to your hardware inventory in the appropriate client settings package" I know how to modify the HW inventory in the client settings, but what exactly am I modifying? Any guidance on how I might set this up or links you can reference? Thank you, Brian ________________________________ From: [email protected] <[email protected]> on behalf of Sherry Kissinger <[email protected]> Sent: Wednesday, September 28, 2016 4:06:40 PM To: [email protected] Subject: Re: [mssms] SSRS Instances 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]<mailto:[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
