SQL DB Configuration Reporting
Posted: Fri Aug 02, 2019 11:37 am
Hello! New user of GoAnywhere. Our configuration is using MS SQL Server for the GoAnywhere MFT configuration database. We'd like to query the dpa_* tables for Project component settings in our projects; ie file paths, file names, variables, etc., so that when things change we can identify all projects affected by a particular change.
I looked at the dpa_project table, and was expecting xml or something in the project_data field, but they're all null. Also, I couldn't find a linked table with anything that looked like xml or legible content to query.
Is there a field I can query/retrieve this information?
Thanks, -Craig
I looked at the dpa_project table, and was expecting xml or something in the project_data field, but they're all null. Also, I couldn't find a linked table with anything that looked like xml or legible content to query.
Is there a field I can query/retrieve this information?
Thanks, -Craig