When you are doing a count don’t you have to add anything from the select in to the group by?
From: [email protected] [mailto:[email protected]] On Behalf Of Miller, Todd Sent: Thursday, September 22, 2016 7:32 AM To: <[email protected]> <[email protected]> Subject: Re: [mssms] RE: Help with computer models report [This message is from outside Bradley. Exercise caution in opening attachments or links.] What if you group just by model? Is the report being thrown off by the double group by? I seem to always have trouble when double grouping. As long as you don't have two manufacturers with the same model- should be ok to group by model only. Sent from my iPhone On Sep 22, 2016, at 05:12, Garth Jones <[email protected]<mailto:[email protected]>> wrote: What is the other report? How many more does it see? This query look right, you should only see a few extra at best, due to dupe and deleted pcs. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Murray, Mike Sent: September 21, 2016 7:26 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] Help with computer models report Hello, I am using the following query to get a list of all computers models in our DB plus the count of each. But this report returns more values than should exist. Example, it says we have 450 of Dell XXXXX, but through other reports I count far less. Ideas? SELECT Manufacturer0 , Model0 , COUNT(*) AS 'Count' FROM v_GS_COMPUTER_SYSTEM GROUP BY Manufacturer0, Model0 ORDER BY Count DESC 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 ________________________________ Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521 and is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately and delete or destroy all copies of the original message and attachments thereto. Email sent to or from UI Health Care may be retained as required by law or regulation. Thank you. ________________________________ ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
