SCCM collection/Report Duplicate computer names with different Resource ID
Posted by Eswar Koneti on October 17th, 2012
I was looking at client health percentage other day and found many systems were reported as not healthy though I fixed some of the machines with sccm client installed and able to receive policies.
Looked at Database for healthy computers and see double entries with different ResourceID ,client0 and HardwareID0 is NULL.
So what next ? I created collection with filter computers with sccm client installed and should be in computers with no sccm client.
Collection:
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System where
SMS_R_System.Name in (select name from SMS_R_System where SMS_R_System.Client is not null) and
SMS_R_System.Client is null
Report:
select name0 from v_R_System where client0 is null
and Name0 in( select Name0 from v_R_System where client0 =1)
order by name0
I see 100+ computers which are duplicate with same hostname but different value for ResourceID,client0 and hardwareID0 etc.
Special delete will remove them completely from database.
December 3rd, 2012 at 9:11 AM
Hi,
I try to create a query using query builder in sccm 2007 and I don’t see SMS_R_SYSTEM.ResourceType and SMS_R_SYSTEM.ResourceDomainORWorkgroup. Did I missing something in my sccm 2007 sp3?
Best Regards,
Simon
December 3rd, 2012 at 9:13 AM
Hey,
This is collection not Report.You should create collection to get the result.
Tip to identity if it is SCCM report query or collection : If you see SMS_R it is collection and if you see V_ it is sccm report query.