32 vs 64 Bit Report (Count Wrong)

[pvr02]

I found this code on this site, but when I run it I get more computers than I have in my environment. From playing around, I did notice I have duplicate resourceid's in the v_gs_processor table. I believe this is what is throwing my numbers off. Any ideas?

SELECT pr.datawidth0 [Processor bits]
, pr.addresswidth0 [OS bits]
, sys.Operating_system_Name_and0 [OS Name]
,COUNT(sys.resourceid) [Computers]
FROM v_r_system sys JOIN v_gs_processor pr ON sys.resourceid=pr.resourceid
GROUP BY pr.datawidth0, pr.addresswidth0, sys.Operating_system_Name_and0
ORDER BY pr.datawidth0, pr.addresswidth0, sys.Operating_system_Name_and0

[Peter van der Woude]

Use a select distinct to only get unique resource id's.

[pvr02]

Worked like a charm.

 

Thanks

[GarthMJ]

The dups are going to be caused by Dual CPU PCs.