Re: [mssms] SSRS Instances
Easy enough. Thanks John! From: listsad...@lists.myitforum.com on behalf of Marcum, John Sent: Thursday, September 29, 2016 9:34:42 AM To: 'mssms@lists.myitforum.com' Subject: RE: [mssms] SSRS Instances >From within the client agent settings, hardware inventory tab you should be >able to browse to the namespace on a client that has run the script and add it. [cid:image001.png@01D21A34.B008BD30] From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Thursday, September 29, 2016 9:16 AM To: mssms@lists.myitforum.com Subject: Re: [mssms] SSRS Instances [External Email] 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: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> mailto:listsad...@lists.myitforum.com>> on behalf of Sherry Kissinger mailto:sherrylkissin...@gmail.com>> Sent: Wednesday, September 28, 2016 4:06:40 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> 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 mailto:mcdonald...@hotmail.com>> 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 Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
RE: [mssms] SSRS Instances
From within the client agent settings, hardware inventory tab you should be able to browse to the namespace on a client that has run the script and add it. [cid:image001.png@01D21A34.B008BD30] From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Thursday, September 29, 2016 9:16 AM To: mssms@lists.myitforum.com Subject: Re: [mssms] SSRS Instances [External Email] 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: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> mailto:listsad...@lists.myitforum.com>> on behalf of Sherry Kissinger mailto:sherrylkissin...@gmail.com>> Sent: Wednesday, September 28, 2016 4:06:40 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> 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 mailto:mcdonald...@hotmail.com>> 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 Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
Re: [mssms] SSRS Instances
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: listsad...@lists.myitforum.com on behalf of Sherry Kissinger Sent: Wednesday, September 28, 2016 4:06:40 PM To: mssms@lists.myitforum.com 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 mailto:mcdonald...@hotmail.com>> 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
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 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