> 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?
>>
>> <image001.jpg>
>>
>> <image002.png>
>>
>>
>>
>>
>>
>>
>>
>> Please visit ATI's all-new website: www.atimetals.com
>>
>
>
