That’s just looking at the hardware inventory class, which doesn’t eliminate
inactive or obsolete records.
Join it to v_r_system_valid and that should clean up your data.
Here is what we use:
SELECT csp.Vendor0 [Vendor], csp.Version0 [Model_Name], csp.Name0
[Model_Number], COUNT(*) AS [Count]
FROM v_R_System_valid sys INNER JOIN
v_GS_COMPUTER_SYSTEM_PRODUCT csp ON sys.ResourceID =
csp.ResourceID
GROUP BY csp.Vendor0, csp.Version0, csp.Name0
ORDER BY Model_Name, Model_Number
Daniel Ratliff
From: [email protected] [mailto:[email protected]] On
Behalf Of Marcum, John
Sent: Thursday, September 22, 2016 8:41 AM
To: <[email protected]> <[email protected]>
Subject: RE: [mssms] RE: Help with computer models report
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]>
[mailto:[email protected]] On Behalf Of Miller, Todd
Sent: Thursday, September 22, 2016 7:32 AM
To: <[email protected]<mailto:[email protected]>>
<[email protected]<mailto:[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.
The information transmitted is intended only for the person or entity to which
it is addressed
and may contain CONFIDENTIAL material. If you receive this
material/information in error,
please contact the sender and delete or destroy the material/information.
