I’m trying to find the list of assets that have specific product from query builder. But the result always gives multiple product like .net framework, SAP applications, etc.,
When I build a query, I want to be able to display ONLY the results based on the criterion entered in the query pills. Instead, I’m getting results of ALL software installed on specific assets that have the criterion installed.
Is there any way to modify the query builder to display ONLY the results of the specified software criterion?
When clicking on the software tab, it shows ALL installed software on those specific assets with the discovered criterion, however, I still have to “page down” for an eternity until I see the specific software and vendor I’m looking for.
What are you trying to do with the data? Just seeing how many instances of it are installed? If so, why not just use the filtered asset search in IVM and just look for "software name CONTAINS ‘Google Chrome’. This will output the list of assets with it installed.
What I’m trying to do with the data is break down the list of the version installed that are less than a specified version.
I have already created a remediation project but I want the proof of which version is installed and each query I’m running is only showing me the assets affected, but I want to show something on the lines of:
Asset - IP - Hostname - Product - Version
I can track in the remediation projects which has been remediated etc, but it just doesn’t sow the version.
Might be worth trying something like this? Obviously changing the input to what you want regarding google chrome and the info you need on the device.
SELECT
da.sites AS “Site_Name”,
da.ip_address AS “IP_Address”,
da.mac_address AS “MAC_Address”,
da.host_name AS “DNS_Hostname”,
ds.vendor AS “Vendor”,
ds.name AS “Software_Name”,
ds.family AS “Software_Family”,
ds.version AS “Software_Version”,
ds.software_class AS “Software_Class”
FROM
dim_asset_software das
JOIN dim_software ds USING(software_id)
JOIN dim_asset da ON da.asset_id = das.asset_id
WHERE
ds.software_class like ‘Internet Client%’
AND ds.name like ‘Firefox%’
AND ds.version < ‘67.04’
ORDER BY
ds.name ASC