Autotask PSA: Where do I find a specific field in the Report Data Warehouse?

Follow

Question

Where do I find a specific field in the Report Data Warehouse?

Environment

  • Autotask PSA

Answer

You can use the Autotask Report Data Warehouse Schema to understand where you would find data in the Warehouse. This spreadsheet report provides the View Names, Column Names, and column Data Type for all views in the Report Data Warehouse. The Excel sheet includes column filters so you can sort by column to search alphabetically for views or columns. You can download it from this link.

For more information about how to use this spreadsheet, refer to our Autotask PSA: Using the Report Data Warehouse Schema Spreadsheet article.

NOTE: The Report Data Warehouse draws data directly from your Autotask database. The data returned uses the terminology found in the internal naming conventions used in Autotask code. The language that appears in the Autotask user interface is designed to enhance usability when completing tasks through the interface.

This terminology has changed over time, and sometimes, the language that appears in the user interface is different from that returned by the Report Data Warehouse. To learn more, please refer to our Autotask PSA: Terminology Differences Between Report Data Warehouse And The Autotask UI article.


Was this article helpful?

0 out of 0 found this helpful

You must sign in before voting on this article.

Want to talk about it? Have a feature request?

Head on over to our Datto Community Forum or the Datto Community Online.

For more Business Management resources, see the Datto RMM Online Help and the Autotask PSA Online Help .

Still have questions? Get live help.

Datto Homepage