Run this query select SYS1.ResourceID,SYS1.ResourceType,SYS1.Name,SYS1.SMSUniqueIdentifier,SYS1.ResourceDomainORWorkgroup,SYS1.Client from SMS _R_System as sys 1 inner join SMS _R_System as sys 2 on sys 2. NetbiosName = sys 1. NetbiosName where ( sys 1. ResourceId < sys 2. ResourceId ) to find system with null entries Run this query Select R.ResourceID,R.ResourceType,R.Name,R.SMSUniqueIdentifier,R.ResourceDomainORWorkgroup,R.Client from SMS_R_System as r full join SMS_R_System as s1 on s1.ResourceId = r.ResourceId full join SMS_R_System as s2 on s2.Name = s1.Name where s1.Name = s2.Name and s1.ResourceId != s2.ResourceId and R.Client = null to find system with Null Entries in the console having properties with values "blocked=Null,Client Type=Null,Obsolete=Null,Active=Null" moreover their Hardware id Null System UUID is null and SMS unique identifier is null. Resolution: These are not obsolete clients, they are what we call “timing issue records” t...