Share This Post Find all webcam – SQL By Garth Jones on April 2, 2013 No Comments 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%' Share This Post Leave a Reply Cancel ReplyYou must be logged in to post a comment. Connect with: