I can’t say for sure, but if I only use SMS_R_System.OperatingSystemNameandVersion, I get fewer results.
From: [email protected] [mailto:[email protected]] On Behalf Of Sherry Kissinger Sent: Friday, January 20, 2017 11:00 AM To: [email protected] Subject: Re: [mssms] RE: Collection query weirdness 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] <mailto:[email protected]> > wrote: Full join if you want absolutely everything from both tables. Daniel Ratliff From: [email protected] <mailto:[email protected]> [mailto:[email protected] <mailto:[email protected]> ] On Behalf Of Murray, Mike Sent: Friday, January 20, 2017 12:32 PM To: [email protected] <mailto:[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 <tel:(901)%20227-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. Best Regards, Mike Murray Desktop Engineer/IT Consultant - IT Support Services California State University, Chico 530.898.4357 <tel:(530)%20898-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. -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org
smime.p7s
Description: S/MIME cryptographic signature
