In DCS 6.x it is recommended more 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 from for your purposes.
NOTE: This script is not Optimized for pulling DCS Events and as is should be left to only pulling other data such as but not limited to Assets, Statistics, Guest Virtual Machines etc...
After downloaded you must edit the script to populate the following:
Required to run but change if needed:
Note: If UMC is setup with IP you must specify the IP Address instead of the FQDN.