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]<mailto:[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? [cid:[email protected]] [cid:[email protected]] ________________________________ Please visit ATI's all-new website: www.atimetals.com<http://www.atimetals.com>
<<inline: image001.jpg>>
<<inline: image002.png>>
