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 
<ga...@enhansoft.com<mailto:ga...@enhansoft.com>> 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: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Murray, Mike
Sent: September 21, 2016 7:26 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Help with computer models report


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?

,       Model0
,       COUNT(*) AS 'Count'

GROUP BY  Manufacturer0, Model0


Best Regards,

Mike Murray
Desktop Engineer/IT Consultant - IT Support Services
California State University, Chico

Remember, Chico State will NEVER ask you for your password via email!
For more information about recognizing phishing scam emails go to: 

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.

Reply via email to