Just curious... would there be situations where a OS X device would report into SMS_G_System_OPERATING_SYSTEM.Name , but NOT report into SMS_R_System.OperatingSystemNameandVersion ?
On Fri, Jan 20, 2017 at 12:08 PM, Daniel Ratliff <[email protected]> wrote: > Full join if you want absolutely everything from both tables. > > > > *Daniel Ratliff* > > > > *From:* [email protected] [mailto:listsadmin@lists. > myitforum.com] *On Behalf Of *Murray, Mike > *Sent:* Friday, January 20, 2017 12:32 PM > *To:* [email protected] > *Subject:* [mssms] RE: Collection query weirdness > > > > 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 <[email protected]>] *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...* > > > > > > > > The information transmitted is intended only for the person or entity to > which it is addressed > and may contain CONFIDENTIAL material. If you receive this > material/information in error, > please contact the sender and delete or destroy the material/information. > > -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org
