The first part appears to be getting the info from 'System Resource' While the one after the OR is getting it from 'Operating System'
So if there are some machines that have not reporting in HW Inventory and Populated the 'Operation System' with its info they would not show up Depending on how the Join is... I prefer to use the "show Query Language" so I'm only guessing... ________________________________ Magnus Tveten Server Engineer Infrastructure oN demand IAG labs From: [email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Friday, 20 January 2017 10:46 AM 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 _____________________________________________________________________ The information transmitted in this message and its attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information, by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete this e-mail and associated material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files, with the permission of the sender. This message has been scanned for viruses. _____________________________________________________________________
