SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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 Sep 30 2008, 03:36 PM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems