[mssms] Re: Query help

2016-07-21 Thread Garth Jones
There are a couple thing that you need to look at. First subselect queries can only have one column. Secondly, you likely need an Left outer join on the Reg key within the main query. Third, you use always use ResourceID for your "not in" Fourthly, Understand that the IP address that you are

[mssms] RE: Query help

2016-07-21 Thread David McSpadden
Sent: Thursday, July 21, 2016 9:34 AM To: mssms@lists.myitforum.com Subject: [mssms] RE: Query help Would simply switching it from 'like' to 'not like' do it? Rich From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.m

[mssms] RE: Query help

2016-07-21 Thread Mawdsley R.
Would simply switching it from 'like' to 'not like' do it? Rich From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of David McSpadden Sent: 21 July 2016 14:18 To: Patch Management Mailing List (patchmanagem...@listserv.patchmanagement.org) ; mssms@lists.myit

Re: [mssms] RE: Query Help

2016-06-03 Thread Stephen Leuthold
sts.myitforum.com] On Behalf Of Stephen Leuthold Sent: Friday, June 3, 2016 1:21 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: Re: [mssms] RE: Query Help PLUS ONE for V_GS_INSTALLED_SOFTWARE ! -Stephen On Jun 3, 2016, at 11:29 AM, Todd Hemsell mailto:hems...@g

Re: [mssms] RE: Query Help

2016-06-03 Thread Todd Hemsell
GS_COMPUTER_SYSTEM.Name0 > > > > > > *From:* listsad...@lists.myitforum.com [mailto: > listsad...@lists.myitforum.com] *On Behalf Of *Brian McDonald > *Sent:* Thursday, June 2, 2016 6:47 AM > *To:* mssms@lists.myitforum.com > *Subject:* [mssms] Re: Query Help > >

Re: [mssms] RE: Query Help

2016-06-03 Thread Todd Hemsell
ice 365 Pro%' > > ORDER BY v_GS_COMPUTER_SYSTEM.Name0 > > > > > > *From:* listsad...@lists.myitforum.com [mailto: > listsad...@lists.myitforum.com] *On Behalf Of *Brian McDonald > *Sent:* Thursday, June 2, 2016 6:47 AM > *To:* mssms@lists.myitforum.com >

RE: [mssms] RE: Query Help

2016-06-03 Thread Garth Jones
//myitforum.com/myitforumwp/community/groups/enhansoft/> Subscribe to Enhansoft's Newsletter!<http://www.enhansoft.com/register> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Stephen Leuthold Sent: Friday, June 3, 2016 1:21 PM To: mssms@lists.m

[mssms] RE: Query Help

2016-06-03 Thread Murray, Mike
STEM.Name0 From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Thursday, June 2, 2016 6:47 AM To: mssms@lists.myitforum.com Subject: [mssms] Re: Query Help Yes. Problem is several of these names aren't coming up when I searc

[mssms] Re: Query Help

2016-06-02 Thread Brian McDonald
@CollID GROUP BY DisplayName0, Publisher0, Version0 ORDER BY Publisher0, Version0 From: listsad...@lists.myitforum.com on behalf of Garth Jones Sent: Wednesday, June 1, 2016 3:45:04 PM To: mssms@lists.myitforum.com Subject: [mssms] RE: Query Help Have you looked at

[mssms] RE: Query Help

2016-06-01 Thread Murray, Mike
There are reports under "Software - Companies and Products" that should handle what you need. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones Sent: Wednesday, June 1, 2016 1:45 PM To: mssms@lists.myitforum.com Subject: [mssms]

[mssms] RE: Query Help

2016-06-01 Thread Garth Jones
Have you looked at the built-in reports for this yet? Garth Jones Chief Architect www.Enhansoft.com [Description: Description: cid:image001.jpg@01CC63FB.974F4EC0] Enhancing Your Business [Description: Description: Description: Description: