Getting list of different web browsers installed on machines

InsightVM SQL Queries
1

Wondering if there is a SQL query that can be done to comply a list of different web browsers found on machines, without listing them in the sql query?

2

Here is a query to pull out ALL the software for an Agent Group that you select. Take results and sort in a Pivot Table in Excel:

SELECT
da.mac_address AS “MAC ID”,
da.ip_address AS “IP Address”,
da.host_name AS “Host Name”,
ds.“name” AS “Software Name”,
ds.vendor,
ds.family,
ds.“version” AS “Version”
FROM
fact_asset AS fa
JOIN dim_asset AS da ON fa.asset_id = da.asset_id
AND da.mac_address IS NOT NULL
JOIN dim_asset_software AS das ON fa.asset_id = das.asset_id
JOIN dim_software AS ds ON das.software_id = ds.software_id
GROUP BY
da.ip_address,
da.host_name,
da.mac_address,
ds.“name”,
ds.vendor,
ds.family,
ds.“version”
ORDER BY
da.mac_address,
da.ip_address ASC,
da.host_name ASC,
ds.“name” ASC,
ds.vendor ASC,
ds.family ASC,
ds.“version” ASC