Issues with Logon reports failing and/or causing Temp DB to grow very large. (4310247)

When running the reports list below you notice failures and/or extreme growth of the Temp DB even if you filter to a small dataset.

Account logon events [NTLM]
All Exchange-related audit events from Windows event logs
All logons
Multiple Logon Failures
Multiple logons failure [Windows-Kerberos-NTLM]

This is due to the non-optimized joins under certain filtering conditions.

1. Download the reports attached.

2. Create a new folder within QKP for these reports

3. Upload the five reports to this folder and run them with the same filters and settings as the existing reports.

The report fixes are scheduled to be part of InTrust 10.4 when it is released.