Skip to content

SQL DB Configuration Reporting

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
If you need a quicker response, please create a support ticket via the customer portal or contact our support team by email at [email protected].
  • panickc Offline
  • Posts: 1
  • Joined: Wed Aug 15, 2018 7:16 am

SQL DB Configuration Reporting

Post by panickc »

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
  • Support_Hans Offline
  • Support Specialist
  • Posts: 9
  • Joined: Mon Jul 22, 2019 11:32 am

Re: SQL DB Configuration Reporting

Post by Support_Hans »


The project_data column appears null because your projects are stored as XMLs. Your projects can be found in [Install Directory]/userdata/projects. They are not null when the Projects are made in an Agent, and Agents store their data within the database.

Restoring the userdata folder would also be necessary for your backup. When you navigate to that folder and open it, you will find all of your essentials in this folder.
Post Reply