Did a thread search and didn't locate an  answer, so i am starting this. 

I've already configured a custom report for our distribution servers, however, there are a few fields I need that aren't available. 

Currently, the Sub Module is set to Computer. (Is there a way to select from multiple Sub Modules for one report?)

I have selected my criteria for searching ad have selected my columns. The report is nice, it's scheduled for daily email. 

The issue I have run into is the Agent Version. This only shows the Agent version for the Desktop Central Client. I don't see an option to select the Distribution Server client version. We found a few servers that had older clients on them that needed to get upgraded.  So this is something I would like to include in the report. 

Also, I was trying to customize an alert, that would email me when a server goes down. Be it offline do t a restart, loss of network connectivity or power. However, the alerts in Desktop Central seemed to be geared toward monitoring installs and removals for hardware.

Maybe i didn't look in the right place, but is there a section I can set up a monitoring alert for when the server goes down or looses connection? 

Last, i'm used to the SCCM query wizard when creating custom queries. I've used it for years.  Is there such a tool for Desktop Central? If not, what are the possibilities that one could be created? Or can PowerShell be used to query the db to get the information? And if so, is there a guide to querying this manualyl other than the time.date that's listed in the help card?