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%'
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Brian McDonald
Sent: Tuesday, September 20, 2016 8:02 AM
Subject: Re: [mssms] RE: MySQL
Nice! How do I add to this to get devices with this installed?
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: email@example.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,
> 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.