RE: [mssms] RE: MySQL
There is a space between SOFTWARE and ARPDisplayName0 that needs to be removed. -Original Message- From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, September 20, 2016 10:00 AM To: mssms@lists.myitforum.com Subject: Re: [mssms] RE: MySQL I'm getting incorrect Syntax near 'Software'. Brian Sent from my iPhone > On Sep 20, 2016, at 8:37 AM, Marcum, John wrote: > > Select sys.Name0, v_GS_INSTALLED_SOFTWARE. ARPDisplayName0 From > v__R_System sys INNER JOIN sys.resourceID on sys.resourceID = > v_GS_INSTALLED_SOFTWARE.resourceID > SOFTWARE where ARPDisplayName0 like '%my%SQL%' > > > > > > -Original Message- > From: listsad...@lists.myitforum.com > [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald > Sent: Tuesday, September 20, 2016 8:02 AM > To: mssms@lists.myitforum.com > Subject: Re: [mssms] RE: MySQL > > Nice! How do I add to this to get devices with this installed? > > Brian > > Sent from my iPhone > >> On Sep 20, 2016, at 7:34 AM, Marcum, John wrote: >> >> Looks like it shows in ARP. I see it when I run this: >> >> select distinct ARPDisplayName0 from v_GS_INSTALLED_SOFTWARE where >> ARPDisplayName0 like '%my%SQL%' >> >> >> >> >> -Original Message- >> From: listsad...@lists.myitforum.com >> [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald >> Sent: Tuesday, September 20, 2016 7:19 AM >> To: mssms@lists.myitforum.com >> Subject: [mssms] MySQL >> >> [This message is from outside Bradley. Exercise caution in opening >> attachments or links.] >> >> Good morning, >> >> Does anyone have a query to find all devices with MySQL installed? >> >> Thank you, >> >> Brian >> >> Sent from my iPhone >> >> >> >> >> 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] RE: MySQL
There is a syntax you have to follow for sql queries. when you need data from two different views, you need to join those views on a common element. In this specific case, you will need to join the data from installed software (contains the add/remove programs displayname) to the data from system (which contains the computer name) using the unique-to-ConfigMgr-way to tell a uniqueness of "resourceid". so.. select distinct sys.name0 [ComputerName from v_r_system] ,arp.ARPDisplayname0 [Add/Remove Programs Name from v_gs_installed_software] from v_r_system sys join v_gs_installed_software arp on arp.resourceid=sys.resourceid --Join the two tables together using the unique attribute where arp.arpdisplayname0 like '%my%SQL%' -- you just want the results of machine that DO have something with a name sorta like that name in the ' ', because to sql a % is a wildcard On Tue, Sep 20, 2016 at 8:59 AM, Brian McDonald wrote: > I'm getting incorrect Syntax near 'Software'. > > Brian > > Sent from my iPhone > > > On Sep 20, 2016, at 8:37 AM, Marcum, John wrote: > > > > Select sys.Name0, v_GS_INSTALLED_SOFTWARE. ARPDisplayName0 > > From v__R_System sys > > INNER JOIN sys.resourceID on sys.resourceID = v_GS_INSTALLED_SOFTWARE. > resourceID > > SOFTWARE where ARPDisplayName0 like '%my%SQL%' > > > > > > > > > > > > -Original Message- > > From: listsad...@lists.myitforum.com [mailto:listsadmin@lists. > myitforum.com] On Behalf Of Brian McDonald > > Sent: Tuesday, September 20, 2016 8:02 AM > > To: mssms@lists.myitforum.com > > Subject: Re: [mssms] RE: MySQL > > > > Nice! How do I add to this to get devices with this installed? > > > > Brian > > > > Sent from my iPhone > > > >> On Sep 20, 2016, at 7:34 AM, Marcum, John wrote: > >> > >> Looks like it shows in ARP. I see it when I run this: > >> > >> select distinct ARPDisplayName0 from v_GS_INSTALLED_SOFTWARE where > ARPDisplayName0 like '%my%SQL%' > >> > >> > >> > >> > >> -Original Message- > >> From: listsad...@lists.myitforum.com [mailto:listsadmin@lists. > myitforum.com] On Behalf Of Brian McDonald > >> Sent: Tuesday, September 20, 2016 7:19 AM > >> To: mssms@lists.myitforum.com > >> Subject: [mssms] MySQL > >> > >> [This message is from outside Bradley. Exercise caution in opening > attachments or links.] > >> > >> Good morning, > >> > >> Does anyone have a query to find all devices with MySQL installed? > >> > >> Thank you, > >> > >> Brian > >> > >> Sent from my iPhone > >> > >> > >> > >> > >> 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. > > > > > > > > > > > > > > > > > > > > > -- 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] RE: MySQL
I'm getting incorrect Syntax near 'Software'. Brian Sent from my iPhone > On Sep 20, 2016, at 8:37 AM, Marcum, John wrote: > > Select sys.Name0, v_GS_INSTALLED_SOFTWARE. ARPDisplayName0 > From v__R_System sys > INNER JOIN sys.resourceID on sys.resourceID = > v_GS_INSTALLED_SOFTWARE.resourceID > SOFTWARE where ARPDisplayName0 like '%my%SQL%' > > > > > > -Original Message- > From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] > On Behalf Of Brian McDonald > Sent: Tuesday, September 20, 2016 8:02 AM > To: mssms@lists.myitforum.com > Subject: Re: [mssms] RE: MySQL > > Nice! How do I add to this to get devices with this installed? > > Brian > > Sent from my iPhone > >> On Sep 20, 2016, at 7:34 AM, Marcum, John wrote: >> >> Looks like it shows in ARP. I see it when I run this: >> >> select distinct ARPDisplayName0 from v_GS_INSTALLED_SOFTWARE where >> ARPDisplayName0 like '%my%SQL%' >> >> >> >> >> -Original Message- >> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] >> On Behalf Of Brian McDonald >> Sent: Tuesday, September 20, 2016 7:19 AM >> To: mssms@lists.myitforum.com >> Subject: [mssms] MySQL >> >> [This message is from outside Bradley. Exercise caution in opening >> attachments or links.] >> >> Good morning, >> >> Does anyone have a query to find all devices with MySQL installed? >> >> Thank you, >> >> Brian >> >> Sent from my iPhone >> >> >> >> >> 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] RE: MySQL
Select sys.Name0, v_GS_INSTALLED_SOFTWARE. ARPDisplayName0 >From v__R_System sys INNER JOIN sys.resourceID on sys.resourceID = v_GS_INSTALLED_SOFTWARE.resourceID SOFTWARE where ARPDisplayName0 like '%my%SQL%' -Original Message- From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, September 20, 2016 8:02 AM To: mssms@lists.myitforum.com Subject: Re: [mssms] RE: MySQL Nice! How do I add to this to get devices with this installed? Brian Sent from my iPhone > On Sep 20, 2016, at 7:34 AM, Marcum, John wrote: > > Looks like it shows in ARP. I see it when I run this: > > select distinct ARPDisplayName0 from v_GS_INSTALLED_SOFTWARE where > ARPDisplayName0 like '%my%SQL%' > > > > > -Original Message- > From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] > On Behalf Of Brian McDonald > Sent: Tuesday, September 20, 2016 7:19 AM > To: mssms@lists.myitforum.com > Subject: [mssms] MySQL > > [This message is from outside Bradley. Exercise caution in opening > attachments or links.] > > Good morning, > > Does anyone have a query to find all devices with MySQL installed? > > Thank you, > > Brian > > Sent from my iPhone > > > > > 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] RE: MySQL
Nice! How do I add to this to get devices with this installed? Brian Sent from my iPhone > On Sep 20, 2016, at 7:34 AM, Marcum, John wrote: > > Looks like it shows in ARP. I see it when I run this: > > select distinct ARPDisplayName0 from v_GS_INSTALLED_SOFTWARE where > ARPDisplayName0 like '%my%SQL%' > > > > > -Original Message- > From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] > On Behalf Of Brian McDonald > Sent: Tuesday, September 20, 2016 7:19 AM > To: mssms@lists.myitforum.com > Subject: [mssms] MySQL > > [This message is from outside Bradley. Exercise caution in opening > attachments or links.] > > Good morning, > > Does anyone have a query to find all devices with MySQL installed? > > Thank you, > > Brian > > Sent from my iPhone > > > > > 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. >
[mssms] RE: MySQL
Looks like it shows in ARP. I see it when I run this: select distinct ARPDisplayName0 from v_GS_INSTALLED_SOFTWARE where ARPDisplayName0 like '%my%SQL%' -Original Message- From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, September 20, 2016 7:19 AM To: mssms@lists.myitforum.com Subject: [mssms] MySQL [This message is from outside Bradley. Exercise caution in opening attachments or links.] Good morning, Does anyone have a query to find all devices with MySQL installed? Thank you, Brian Sent from my iPhone 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.