I am trying to generate the summary for dynamic sites, that looks like
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?