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]] 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. [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...

