We have scans split based on sites. Is there a way to consolidate and get one report for multiple scans?
Yes. Scanning and reporting are two independent services. You can generate a report that includes any arbitrary set of assets. It doesn't matter whether they were scanned at the same time or not.
Just make sure your reporting template uses "Host Based" rather than "Scan Based" findings.
Retrieving data ...