

FIND MAC ADDRESS IN SCCM DATABASE FULL
I am making use of SMS_R_System with full join. Where sys1.Name0 = sys2.Name0 and sys1.ResourceId != sys2.ResourceIdĬreate WQL Collection with following syntax: Select sys.name0,sys.ResourceID from v_r_system as sysįull join v_r_system as sys1 on sys1.ResourceId = sys.ResourceIdįull join v_r_system as sys2 on sys2.Name0 = sys1.Name0 If you want to see the list of all devices with its resource ID ,use the following query: If you want to see the device that appear maximum times in the top ,use the following query: Select name0 ,count(*) Total from v_r_system
FIND MAC ADDRESS IN SCCM DATABASE CODE
Here is the SQL code to find out the list of devices with appear in SCCM console with its count. If you have maintenance task enabled ,these obsolete or inactive stale records taken care by that but do want to wait until the default maintenance task runs ?

Why did this happens ? Old article but still valid though So i went to site hierarchy settings to see the conflict records but the settings applied correctly: With this information ,i started looking at SQL to write code and convert that to collection ,so it would be easy to cleanup records in automated way.ĭevice with different resource ID and client =Noĭevice with different resource ID and client=No

ĭevice with different resource ID and Client=Yes Take a look at the following screenshots with 3 different problems. The GUID is stored in the client's Registry and in a binary file on the client's hard disk into smscfg.ini file ( C:\Windows\SMSCFG.INI)Īs you see below snapshot ,computer record appear twice with the information that was gathered through inventory/BGB/discovery. The GUID assignment occurs during the client discovery and installation processes. This combination produces a number that is virtually always unique. A GUID is a combination of the client's media access control (MAC) address and the time when the GUID is assigned. SCCM clients are uniquely identified by a GUID. So i started looking at this issue to see how identify the records with duplicate hostnames. During this report creation ,found that ,device appear twice with different GUID ID and resource ID but with same hostname. I was working on SCCM report for client health dashboard.
