RE: [mssms] RE: MySQL

2016-09-20 Thread John Aubrey
: 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.r

Re: [mssms] RE: MySQL

2016-09-20 Thread Sherry Kissinger
> > 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 t

Re: [mssms] RE: MySQL

2016-09-20 Thread Brian McDonald
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

RE: [mssms] RE: MySQL

2016-09-20 Thread Marcum, John
ailto: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, Mar

Re: [mssms] RE: MySQL

2016-09-20 Thread Brian McDonald
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

[mssms] RE: MySQL

2016-09-20 Thread Marcum, John
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: T