I think this is what you are looking for? http://social.technet.microsoft.com/Forums/en-US/0ed57ab6-07cd-4ab2-a704-e9e8f28b0818/sccm-2012-wql-query-is-not-prompting?forum=configmanagergeneral
select SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceType, SMS_R_System.ResourceId, SMS_R_System.ClientType from SMS_R_System where SMS_R_System.ResourceId = (select distinct SMS_G_System_CABG_USERINFORMATION.ResourceID from SMS_G_System_CABG_USERINFORMATION where SMS_G_System_CABG_USERINFORMATION.AdditionalUserInformation = ##PRM:SMS_G_System_CABG_USERINFORMATION.AdditionalUserInformation##) On Tue, Oct 8, 2013 at 9:17 AM, Lassiter, Brandon < [email protected]> wrote: > Thank you for the response, however I think I did what you were asking > with no luck. I was picking the SMS_R_System attributes specifically, but I > changed it to this and I still lose my functionality. **** > > ** ** > > select * from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on > SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where > SMS_R_System.SystemOUName like "Some/OU/Name"**** > > ** ** > > Is this what you were asking me to try?**** > > ** ** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Ryan > *Sent:* Tuesday, October 8, 2013 11:48 AM > *To:* [email protected] > *Subject:* [EXTERNAL EMAIL] :Re: [mssms] Query Building Issue**** > > ** ** > > Do you join in SMS_R_System? If you do, select * from SMS_R_System, don't > pick specific properties. If you don't, try joining in all properties in > SMS_R_System.**** > > ** ** > > On Tue, Oct 8, 2013 at 10:34 AM, Lassiter, Brandon < > [email protected]> wrote:**** > > Folks**** > > **** > > I am building a query for my helpdesk to use that displays > certain items for them as a quick reference like OS, Make, Manufacturer, > memory etc. As soon as I add something that is not part of the System > Resource class it disables the ability to use resource explorer, remote > tools, etc. Would anyone be able to explain what I am doing wrong here?*** > * > > **** > > **** > > **** > > **** > > ** ** > ------------------------------ > > Please visit ATI's all-new website: www.atimetals.com**** > > ** ** > > ** ** > > ** ** > >
<<image002.png>>
<<image001.jpg>>
