How to determine the software version with which all active Matters were created.

SYMPTOMS

During troubleshooting or planning, it may be necessary to find out what software version was used to create all active Matters.

CAUSE

Not applicable

RESOLUTION

Checking individual Performer DLL file versions can be tedious if there are a large number of Matters. The following SQL script will list the Legal Processing Matter ID, Matter Name, and software version to create the Matter for all active Matters:

SELECT [Performer].[MatterId] as 'LP MatterID'
     ,SUBSTRING([Performer].[AssemblyTypeName],CHARINDEX ( 'version=' ,[Performer].[AssemblyTypeName] ),CHARINDEX ( ', culture' ,[Performer].[AssemblyTypeName] )-CHARINDEX ( 'version=' ,[Performer].[AssemblyTypeName] )) as version
 ,[MatterVersion].[Name] as 'Matter Name'
 FROM [ZyLABeDiscovery].[dbo].[Performer],[ZyLABeDiscovery].[dbo].[MatterVersion],[ZyLABeDiscovery].[dbo].[Matter]
 where [Performer].[Name] = 'File System Collector'
 and [Performer].[MatterId]=[MatterVersion].[MatterId]
 and [Matter].[Id]=[MatterVersion].[MatterId]
 and [Matter].[State]=3

This script can be modified for individual needs by narrowing down to a particular MatterID or expanding the results by removing the [State] qualifier.

APPLIES TO

3.2; 3.3; 3.4; 3.7 Service Pack 2