This tool will perform a data consistency check on a XenDesktop 5 database. It will also export important diagnostic information about the environment.

This new version includes update notifications to ensure the latest version is being used as well as improved consistency checking. It supports both local installations of SQL express and remote SQL servers.

But wait there is more..

The program exports key troubleshooting data such as the sqlConnectionLog file that conatins the user connection history for the past 48 hours of both successful and unsuccessful attempts. This includes the Last Error column which can be helpful to troubleshoot connectivity issues. Another useful file is the sqlVDAStates which will display the configuration details on the VDA’s. The Last Contact Time, Registration State Status, and Last De-registration Reason columns contain valuable data to troubleshoot VDA issues as well.

It is available at
Download XDDBDiag

Enjoy!