Open SQL Mgmt Studio and navigate to your ConfigMgr DB, open a query window and execute the following query:

PIC

SELECT dbo.v_RA_System_MACAddresses.MAC_Addresses0, Count(dbo.v_R_System.Name0) AS SystemCount 
FROM dbo.v_R_System RIGHT OUTER JOIN dbo.v_RA_System_MACAddresses 
ON dbo.v_R_System.ResourceID = dbo.v_RA_System_MACAddresses.ResourceID 
GROUP BY dbo.v_RA_System_MACAddresses.MAC_Addresses0 ORDER BY SystemCount DESC


PIC

Here is a shot of a my environment:

PIC

Last edited May 22, 2013 at 5:56 AM by s4biturbo, version 1

Comments

No comments yet.