SQL Report?
Is there a way to list or run a report that will show what each package in Deploy has set for Scanning (ex. Scan After Deployment) and what scan profile is being used?
0
Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.
Is there a way to list or run a report that will show what each package in Deploy has set for Scanning (ex. Scan After Deployment) and what scan profile is being used?
Comments
Hey Dan, a cleverly crafted SQL query against the deploy database should pull this information.
Looks like that information lives in the PackageDefinitions table and the ScanAfterDeployment column. I think you'll need to join that table with the Packages table on the PackageDefinitionID column.
Be very careful poking around in your database, I suggest making a backup and running the queries on a copy.
I was really hoping to see that information added as a column. That would make things a lot easier and would be very helpful.