PC Serial Number by OU.

For full details, please see http://www.myitforum.com/forums/Active-Directory-Discovery-additional-Attributes-and-broken-reports-and-queries-m238462.aspx

select  distinct 
    R.ResourceID,
    R.Name0,
    R.Client0,
    BIOS.SerialNumber0
from 
    dbo.v_R_System AS R
    LEFT OUTER JOIN dbo.v_RA_System_SystemOUName AS OU ON R.ResourceID = OU.ResourceID
    INNER JOIN dbo.v_GS_PC_BIOS AS BIOS ON R.ResourceID = Bios.ResourceID 
where 
    OU.System_OU_Name0 = N'GARTEK.TST/DOMAIN CONTROLLERS' 

Leave a Reply

Your email address will not be published. Required fields are marked *