Find all PCs with out any v_gs_Computer_System data

Use this query to find all PCs that don't have any data within the v_GS_* views.  Right John... :-)

select
    R.Netbios_Name0,
    R.*
from
    v_R_System r
where
    R.ResourceID not in (select
                            cs.resourceId
                        from
                            v_gs_computer_system cs)
Order by
    R.Netbios_Name0

Published Tuesday, September 30, 2008 3:36 PM by Garth
Filed under: , , ,

Comments

No Comments