This is what I use: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like "Mac OS X%"
On Fri, Jan 20, 2017 at 11:31 AM, Murray, Mike <[email protected]> wrote: > Here’s the query. What join should I use? > > > > select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_ > SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM. > ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner > join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId > = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion > like "%OS X%" or SMS_G_System_OPERATING_SYSTEM.Name like "%OS X%" > > > > *From:* [email protected] [mailto:listsadmin@lists. > myitforum.com] *On Behalf Of *Jimmy Martin > *Sent:* Friday, January 20, 2017 5:07 AM > *To:* [email protected] > *Subject:* [mssms] RE: Collection query weirdness > > > > You need to adjust the join properties. You are tying discovery data and > data that would be provided via sccm inventory. Default join would make it > where it was the least common denominator of the data sets > > > > Jimmy Martin > (901) 227-8209 > > *From:* [email protected] [mailto:listsadmin@lists. > myitforum.com <[email protected]>] *On Behalf Of *Murray, > Mike > *Sent:* Thursday, January 19, 2017 5:46 PM > *To:* [email protected] > *Subject:* [mssms] Collection query weirdness > > > > Can someone explain this to me? The query below returns fewer results than > if I just use the first part of the query. Adding the “or” option drops the > total results. Seems wrong to me. > > > > > > > > Best Regards, > > > > Mike Murray > > Desktop Engineer/IT Consultant - IT Support Services > > California State University, Chico > > 530.898.4357 <(530)%20898-4357> > [email protected] > > > > Remember, Chico State will NEVER ask you for your password via email! > > For more information about recognizing phishing scam emails go to: > http://www.csuchico.edu/isec/basics/spam-and-phishing.shtml > > > > > > This message and any files transmitted with it may contain legally > privileged, confidential, or proprietary information. If you are not the > intended recipient of this message, you are not permitted to use, copy, or > forward it, in whole or in part without the express consent of the sender. > Please notify the sender of the error by reply email, disregard the > foregoing messages, and delete it immediately. > > > > P *Please consider the environment before printing this email...* > > > > > >
