SQL using Installed Software

SELECT    
    S.Name0,
    S.SystemRole0,
    S.SystemType0,
    S.Domain0,
    INSO.ARPDisplayName0
FROM        
    v_GS_INSTALLED_SOFTWARE INSO
    INNER JOIN v_GS_SYSTEM S ON INSO.ResourceID = S.ResourceID
where
    ARPDisplayName0 like ‘%SQL%’ 

Leave a Reply

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