How to Update Application Compatibility Toolkit 5.6 Database to Process Windows 7 or Windows Server 2008 R2 SP1 Logs

To resolve this problem, an entry describing Windows 7 Service Pack 1 or Windows Server 2008 R2 Service Pack 1 must be added to the ACT database's Dbo.OS table. To do so, run the following SQL statement against the database that the ACT log processing service is using:

To enable the parsing of Windows 7 Service Pack 1 logs:

INSERT INTO.[dbo].[OS]
           ([osID]
           ,[osName]
           ,[majorVersion]
           ,[minorVersion]
           ,[buildNumber]
           ,[servicePackName]
           ,[servicePackMajor]
           ,[servicePackMinor]
           ,[csdVersion]
           ,[productType]
           ,[suite]
           ,[publishedDate])
     VALUES
           (N'6.1.1'
           ,N'Windows 7 SP1'
           ,6
           ,1
           ,0
           ,N'Service Pack 1'
           ,1
           ,0
           ,N'Service Pack 1'
           ,0
           ,0
           ,'2011-02-22')
GO



To enable the parsing of Windows Server 2008 R2 Service Pack 1 logs:

INSERT INTO [dbo].[OS]
([osID]
,[osName]
,[majorVersion]
,[minorVersion]
,[buildNumber]
,[servicePackName]
,[servicePackMajor]
,[servicePackMinor]
,[csdVersion]
,[productType]
,[suite]
,[publishedDate])
VALUES
(N'6.1.1.SRV'
,N'Windows Server 2008 R2 SP1'
,6
,1
,0
,N'Service Pack 1'
,1
,0
,N'Service Pack 1'
,3
,0
,'2011-02-22')
GO

Once the statement is executed successfully, any logs that failed to process can be moved back to the Uncompressed folder and will be processed by the ACT log processing service.