SMSUG.ca

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

Garth Jones

Find all webcam - SQL

Use this query to find all webcam – SQL reports

select 
    CS.Name0, 
    SD.Name0,
    SD.DeviceID0
from 
    dbo.v_GS_COMPUTER_SYSTEM CS
    join dbo.v_GS_SYSTEM_DEVICES SD on CS.ResourceID = SD.ResourceID
Where 
    SD.Name0 like '%Webcam%'

Comments

 

Find all webcam – SQL | My CMS said:

Pingback from  Find all webcam – SQL | My CMS

June 10, 2013 5:40 PM

This Blog

Syndication

News

Training

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