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%'