RE: [mssms] RE: Help with computer models report

2016-09-22 Thread Murray, Mike 
This is perfect, thanks Daniel!

 

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Thursday, September 22, 2016 6:00 AM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: Help with computer models report

 

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]

FROMv_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: listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com>  
[mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John
Sent: Thursday, September 22, 2016 8:41 AM
To: mailto:mssms@lists.myitforum.com> > 
mailto:mssms@lists.myitforum.com> >
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: listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com>  
[mailto:listsad...@lists.myitforum.com] On Behalf Of Miller, Todd
Sent: Thursday, September 22, 2016 7:32 AM
To: mailto:mssms@lists.myitforum.com> > 
mailto:mssms@lists.myitforum.com> >
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 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

 

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 X, 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

 

 

 

 

 

  _  

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.

 






smime.p7s
Description: S/MIME cryptographic signature

RE: [mssms] RE: Help with computer models report

2016-09-22 Thread Daniel Ratliff 
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]
FROMv_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: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Marcum, John
Sent: Thursday, September 22, 2016 8:41 AM
To:  
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: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Miller, Todd
Sent: Thursday, September 22, 2016 7:32 AM
To: mailto:mssms@lists.myitforum.com>> 
mailto:mssms@lists.myitforum.com>>
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 
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

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 X, 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
mmur...@csuchico.edu<mailto: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






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.

RE: [mssms] RE: Help with computer models report

2016-09-22 Thread Marcum, John 
When you are doing a count don’t you have to add anything from the select in to 
the group by?

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Miller, Todd
Sent: Thursday, September 22, 2016 7:32 AM
To:  
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 
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

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 X, 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
mmur...@csuchico.edu<mailto: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






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.

Re: [mssms] RE: Help with computer models report

2016-09-22 Thread Miller, Todd 
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 
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] On Behalf Of Murray, Mike
Sent: September 21, 2016 7:26 PM
To: mssms@lists.myitforum.com
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 X, 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
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







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.