We ran into the same issue in my old environment. There is a post in ms forum on that, I just need to find it. On Oct 8, 2013 9:19 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>>
