...
| Code Block |
|---|
<repoName>.protocolservice.database.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver <repoName>.protocolservice.database.url=jdbc:sqlserver://localhost:1433;databaseName=CONTENTSERVER; |
Required Configuration for Searching in Protocols:
Make sure you configure as last these values:
| Code Block |
|---|
FI.protocolservice.document.properties=name,contentlength,path,contentDigest
FI.protocolservice.container.properties= name,path
|
Supported values for document:starttime,endtime,requestid,path,id,respository,status,message,command,object,module,client,user,objectcommand,objectid,contentLength,contentType,contentDisposition,contentDigest,contentDigestAlgorithm,contentEncoding,creationTime,modificationTime,creationUser,modificationUser
Supported values for container:
name,path
Tables:
PROTOCOL
Contains on record per access, defines acces modul and access data
...
Value | Description |
|---|---|
read | all read access to a folder or document (only CMIS/ILM) |
create | all create folder or document entries |
update | all update requests |
delete | all delete requests for folder or documents |
info | for info requests (AricheLink or ILM) |
admin | all admin access like create put certificate or serverInfo |
| Code Block |
|---|
SELECT p.*, pv.FIELDSTRINGVALUE as 'Path'
FROM [PROTOCOL] p
inner join PROTKEY_VALUES pv on p.RECORDID = pv.RECORDID
where pv.FIELDID = 'path' and p.COMMANDCATEGORY = 'read' |
ArchiveLink based Queries
all protocols ArchiveLink entries
Protocols fpr Doicuments and components create seperate protocoll entries. A “Create” exists for creation of the document and for each component. Same applies for other commands.
COMMANDOBJECT | Description |
|---|---|
document | Protocols for the ArchiveLink Component |
container | Protocol fpr the ArchiveLink Document |
| Code Block | ||
|---|---|---|
| ||
select CLIENT,COMMANDOBJECT,COMMANDMESSAGE, COMMANDCATEGORY,COMMANDSTATUS,STARTTIME,ENDTIME,MODULENAME,REPOSITORYNAME,REQUESTID,
(select FIELDSTRINGVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'path' and prot.COMMANDOBJECT = 'document') as DOCUMENT,
(select FIELDSTRINGVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'name' and prot.COMMANDOBJECT = 'document') as COMPONENT,
(select FIELDINTVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'contentlength' and prot.COMMANDOBJECT = 'document') as SIZE,
(select FIELDSTRINGVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'contentDigest' and prot.COMMANDOBJECT = 'document') as HASHVALUE
from Protocol p
where MODULENAME = 'ContentServer4ArchiveLink' |
filter based on docID
enter docID instead of example value 85DCD9A03683496DB7B9A8BFED0EBEAD
| Code Block | ||
|---|---|---|
| ||
select*, CLIENT,COMMANDOBJECT,COMMANDMESSAGE, COMMANDCATEGORY,COMMANDSTATUS,STARTTIME,ENDTIME,MODULENAME,REPOSITORYNAME,REQUESTID, pv.FIELDSTRINGVALUE as 'PATH',
(select FIELDINTVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'contentlength' and prot.COMMANDOBJECT = 'document') as SIZE,
(select FIELDSTRINGVALUE from PROTKEY_VALUES pv inner join PROTOCOL prot on PROT.RECORDID = pv.RECORDID and prot.REQUESTID = P.REQUESTID where FIELDID = 'contentDigest' and prot.COMMANDOBJECT = 'document') as HASHVALUE
from Protocol p
inner join PROTKEY_VALUES pv on p.RECORDID = pv.RECORDID and pv.FIELDID = 'path'
where pv.FIELDID = 'path'
and MODULENAME = 'ContentServer4ArchiveLink'
and pv.FIELDSTRINGVALUE like '%85DCD9A03683496DB7B9A8BFED0EBEAD%' |