Over time reports get slower and slower.
You may also get errors simalar to the error below.
Unexpected error while attempting to read from the database.
Query timeout expired
SELECT [NTAccount] AS S0, [Date] AS X0,SUM([SuccessfulLogons]) AS Y0 FROM (SELECT Organization, Date, NTAccount, SuccessfulLogons FROM (SELECT Organization, Date, NTAccount, SUM(CAST(SuccessCount AS BIGINT)) AS SuccessfulLogons FROM T_OWANTAccountStatsDaily INNER JOIN V_ServersAllReport ON T_OWANTAccountStatsDaily.ServerGUID = V_ServersAllReport.ServerGUID WHERE NTAccount IN (SELECT TOP 10 NTAccount FROM T_OWANTAccountStatsDaily INNER JOIN V_ServersAllReport ON T_OWANTAccountStatsDaily.ServerGUID = V_ServersAllReport.ServerGUID WHERE ((([Date] >= '2011-01-01' AND [Date] < '2011-08-31'))) GROUP BY NTAccount ORDER BY SUM(SuccessCount) DESC) AND ((([Date] >= '2011-01-01' AND [Date] < '2011-08-31'))) GROUP BY Organization, Date, NTAccount) AS InnerQuery) [_IntResult] GROUP BY [NTAccount], [Date] ORDER BY [NTAccount] ASC, [Date] ASC
(0x80040217)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center