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
Comments
0 comments
Article is closed for comments.