In DCS 6.x, it is more recommended to query DCS using the API whenever possible, rather than connecting to the database, and an example to start from is needed.
The attached script is a PowerShell 3 and newer compatible script provided as an "As Is" example that can be built upon for your purposes.
NOTE: This script is not optimized for pulling DCS Events and should be used only for pulling other data such as Assets, Statistics, Guest Virtual Machines, etc.
After downloading, you must edit the script to populate the following:
Required to run but change if needed:
Note: If UMC is set up with an IP, you must specify the IP Address instead of the FQDN.