Hi,
I am trying to generate the summary for dynamic sites, that looks like/asset/group/listing.jsp
. Specifically:
site name, # of assets, # of vulnerabilities, risk score.
The python API, get_asset_groups
returns the information exactly as what is shown in the UI.
However, the below SQL does not. The riskscore, number of assets and vulnerabilities are all smaller.
SELECT dag.name, fag.assets, fag.vulnerabilities,ROUND(fag.riskscore) as riskscore
FROM fact_asset_group fag
JOIN dim_asset_group dag USING (asset_group_id)
ORDER BY dag.name
Anyone know why?