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?
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.
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.
Please sign in to leave a comment.