Data warehouse query used for sql export?

InsightVM SQL Queries
,
1

I found this query used to extract some data from the warehouse, but I am wondering if this can be used as a sql export ?

select count (vrd.vulnerability_id)
from fact_asset_vulnerability_remediation_date vrd
join fact_asset_vulnerability_finding_date vfd
using (vulnerability_id)
where vrd.day between ‘2020-08-21’ and ‘2020-08-29’ AND
vfd.critical_vulnerabilities = ‘1’ or
vfd.severe_vulnerabilities = ‘1’

2

This query will not work as the console schema does not have fact_asset_remediation tables.