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