-
Title
When viewing the Storage | Servers Summary report. Historical data for old servers or after a -
Description
When viewing the Storage | Servers Summary report. Historical data for old servers or after a failover of a cluster, data is no longer showing in the report.
From the Messagestats Release notes:
Decommissioned servers were not appearing in historical reports. Historical data should have been included for deleted items in the following reports:
Storage | Servers Summary
Storage | Stores Summary
Storage | Database Copy Distribution
Inventory | Mailbox Growth.
When you select a date range in the past the servers and stores that existed during that time period, but which no longer exist, will now be included. Historical reports will now include deleted servers and their data.
-
Cause
This issue was actually not fixed in version 6.8.1 or previously, even though the release notes list this issue as resolved under Resolved Issues and Enhancements.
-
Resolution
If you are experiencing this issue please do the following.
****Please make sure you have a backup of your Messagestats database before running this solution*****
Please run the following sql query on the Messagestats database.
USE [MessageStats]
GO
/****** Object: View [dbo].[V_ExchangeServerStorageDistinctRaw] Script Date: 12/07/2010 13:24:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: View dbo.V_ExchangeServerStorageDistinctRaw Script Date: 1/30/2002 12:32:32 PM ******/
ALTER VIEW [dbo].[V_ExchangeServerStorageDistinctRaw]
AS
SELECT DISTINCT T3.[Date], T3.ServerGUID,
SSC.ServerStoreCopyGUID,
T2.StoreDbPath,
T6.Directory AS [Volume],
T3.SizeBytes,
T8.SizeBytes As VolSizeBytes,
T8.FreeBytes As VolFreeBytes,
T1.StoreType
FROM dbo.T_ServerStores T1 INNER JOIN
dbo.T_ServerStoreCopies SSC ON T1.ServerStoreGUID = SSC.ServerStoreGUID INNER JOIN
dbo.T_ServerStoreDbs T2 ON SSC.ServerStoreCopyGUID = T2.ServerStoreCopyGUID INNER JOIN
dbo.T_ServerStoreDbStats T3 ON T2.ServerStoreDBGUID = T3.ServerStoreDBGUID LEFT OUTER JOIN
dbo.T_ServerStorageGroups T4 ON T1.ServerStorageGroupGUID = T4.ServerStorageGroupGUID INNER JOIN
dbo.T_ServerStoreStats T5 ON T1.ServerStoreGUID = T5.ServerStoreGUID AND
T5.[Date] = T3.[Date] LEFT OUTER JOIN
dbo.T_ServerVolumeDirectories T6 ON T2.ServerVolumeDirectoryGUID = T6.ServerVolumeDirectoryGUID LEFT OUTER JOIN
dbo.T_ServerVolumes T7 ON T6.ServerVolumeGUID = T7.ServerVolumeGUID LEFT OUTER JOIN
dbo.T_ServerVolumeStats T8 ON T8.ServerVolumeGUID = T7.ServerVolumeGUID AND
T8.[Date] = T3.[Date]
WHERE T2.ServerVolumeDirectoryGUID IS NOT NULL
After the script completes please run the report again that was not showing the historical data. The information should now be displayed in the report. -
Defect ID
TFS0040181