Full join if you want absolutely everything from both tables. Daniel Ratliff
From: [email protected] [mailto:[email protected]] 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:[email protected]> [mailto:[email protected]] On Behalf Of Jimmy Martin Sent: Friday, January 20, 2017 5:07 AM To: [email protected]<mailto:[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:[email protected]> [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Thursday, January 19, 2017 5:46 PM To: [email protected]<mailto:[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. [cid:[email protected]] Best Regards, Mike Murray Desktop Engineer/IT Consultant - IT Support Services California State University, Chico 530.898.4357 [email protected]<mailto:[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.
