Get scan based on scan name

Hi,

How do I get a scan just based on scan name. We have a integration with InsightVM but some of them are failing. Only data I’ve is scan name and asset. Asset is part of multiple asset. So I need to way to get to the scan using scan name and get details of it.

Thanks in advance

the dim_scan table references the scan name if it was given a name. I did however notice that our docs were missing that column in the table so I put in a ticket internally to get that resolved.