SQL query to find the location of files on servers? (Path)

InsightVM SQL Queries
1

Hi,

I have created a SQL query to find all Log4j software. It works fine, but I would like also display the path to where the Log4j files are on the servers. Anybody know in which table this is stored? We do not use a data warehouse.

Here is my query:

select da.host_name,
       da.ip_address,
       da.mac_address,
       ds.vendor,
       ds.name,
       ds.version
 from dim_asset_software das,
      dim_software ds,
      dim_asset da
where das.software_id = ds.software_id
  and das.asset_id = da.asset_id
  and ds.vendor = 'Apache'
  and ds.name like '%Log4j%'
order by da.host_name, ds.name asc

Regards Peter