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

Leave a Reply

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