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
<mailto:mmur...@csuchico.edu> mmur...@csuchico.edu
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>
http://www.csuchico.edu/isec/basics/spam-and-phishing.shtml
smime.p7s
Description: S/MIME cryptographic signature
