If anyone is interested, here is what I came up with. I’ll blog it if anyone thinks it’s worth anything. If there are some SQL tweaks I could apply to it I would appreciate the tips.

SELECT     'Product' AS 'Product Name', 'Version', COUNT('Product') AS 'Total'

FROM         (SELECT     'Internet Explorer' AS 'Product', FileVersion AS 'Version'

                       FROM          v_GS_SoftwareFile

                       WHERE      (FileName = 'IEXPLORE.EXE') AND (FilePath = 'C:\Program Files\Internet Explorer\')

                       UNION ALL

                       SELECT     CASE WHEN DisplayName0 LIKE 'Mozilla Firefox%' THEN 'Firefox' ELSE DisplayName0 END AS 'Product', Version0 AS 'Version'

                       FROM         v_GS_ADD_REMOVE_PROGRAMS

                       WHERE     (DisplayName0 IN ('Google Chrome', 'Safari')) OR

                                             (DisplayName0 LIKE 'Mozilla Firefox%') OR

                                             (DisplayName0 LIKE 'Opera%')) AS p

GROUP BY 'Product', 'Version'

ORDER BY 'Product Name', 'Version'

Anyone have one they can share? Need to know who has IE, FireFox, Chrome, Opera, and Safari.

Regards,

Christopher Summers

District Seven Network Administrator

Florida Department of Transportation

(813) 975-6029

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/