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
I like to be able to enter the string I am looking for into one spot and have it search the ARP string and the product name. Can also search the vendor all byt typing it once. Also like ot see the user and some other info Declare @StringToFind NVarChar(50) Declare @ProductCodeToFind NVarChar(7

Re: [mssms] RE: Query Help

2016-06-03 Thread Todd Hemsell
This will let you join an "Application + Deployment Type" in SCCM to software actually installed on the machine, provided it is a MSI file and you imported the product code onto the deployment type WITH XMLNAMESPACES ( DEFAULT ' http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/A

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