Good Morning!!!

We are a customer who uses Dynamics 365 Customer Service with great potential.

So, in order to automate some monitoring process with SQL routines in DATAVERSE, we would like some SYS tables to be enabled to query via SQL.

This is a basic premise for us to be able to automate processes.

How difficult is it to enable?

We validated the following tables and only the last two (sys.partitions and sys.allocation_units) are not available:

SELECT count(*) FROM sys.tables;     -- OK

SELECT count(*) FROM sys.all_columns; -- OK

SELECT count(*) FROM sys.indexes; -- Ok

SELECT count(*) FROM sys.schemas; -- Ok

SELECT count(*) FROM sys.partitions;

SELECT count(*) FROM sys.allocation_units;