select
sys.ResourceID,
sys.Name0,
sys.Active0,
sys.Obsolete0,
bios.SerialNumber0
from v_R_System sys
left join v_GS_PC_BIOS bios on bios.ResourceID = sys.ResourceID
where bios.SerialNumber0 in (select SerialNumber0 from v_GS_PC_BIOS group by SerialNumber0 having COUNT(*) > 1)
and sys.Obsolete0 = 0
order by SerialNumber0
Welcome to my blog...it is just a bunch of random notes to myself, for myself, and if it happens to help someone else...cool. I am currently working for a large consulting company which supports a national nonprofit organization with 23000 workstations and 250 configuration servers.
Thursday, August 7, 2014
Find Duplicate Serial Numbers SCCM 2007
We are using SCCM to feed information into an asset management system (CMDB). We keep trying to stress how SCCM is not a very good asset management tool, especially SCCM 2007. I have heard the CM12 makes some improvements.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment