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?



Date Votes
  • 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 we could add a column that would show that information. That would be really helpful!

  • 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.

Didn't find what you were looking for?

New post