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 <jmar...@bradley.com> 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 <jmar...@bradley.com> 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.
> 
> 
> 
> 
> 
> 
> 
> 








Reply via email to