No hay datos.
| SessionId | Host | Aplicacion | Usuario | InicioTransaccion | SegundosAbierta | TipoTransaccion | UltimaConsulta |
|---|
| 53 | DWSGDAAPP1 | MicroSQL | ophelia | 6/9/2026 9:35:34 AM | 1547 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 72 | DWSGDAAPP1 | MicroSQL | ophelia | 6/9/2026 9:35:35 AM | 1546 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 109 | DWSGDAAPP3 | MicroSQL | ophelia | 6/9/2026 9:35:41 AM | 1540 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 392 | DWSGDAAPP1 | MicroSQL | ophelia | 6/9/2026 9:35:41 AM | 1540 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 557 | DWSGDAAPP2 | MicroSQL | ophelia | 6/9/2026 9:39:49 AM | 1292 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 258 | DWSGDAAPP3 | MicroSQL | ophelia | 6/9/2026 9:39:49 AM | 1292 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 355 | DWSGDAAPP1 | MicroSQL | ophelia | 6/9/2026 9:41:09 AM | 1212 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 378 | DWSGDAAPP1 | MicroSQL | ophelia | 6/9/2026 9:46:04 AM | 917 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 252 | DWSGDAAPP3 | MicroSQL | ophelia | 6/9/2026 9:52:53 AM | 508 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 530 | DWSGDAAPP1 | MicroSQL | ophelia | 6/9/2026 9:52:53 AM | 508 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 522 | DWSGDAAPP1 | MicroSQL | ophelia | 6/9/2026 9:52:53 AM | 508 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 516 | DWSGDAAPP2 | MicroSQL | ophelia | 6/9/2026 9:52:53 AM | 508 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 253 | DWSGDAAPP3 | MicroSQL | ophelia | 6/9/2026 9:52:53 AM | 508 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 181 | DWSGDAAPP1 | MicroSQL | ophelia | 6/9/2026 9:54:42 AM | 399 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 243 | DWSGDAAPP2 | MicroSQL | ophelia | 6/9/2026 9:54:42 AM | 399 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 362 | DWSGDAAPP2 | MicroSQL | ophelia | 6/9/2026 9:55:07 AM | 374 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 702 | DWSGDAAPP3 | MicroSQL | ophelia | 6/9/2026 9:57:45 AM | 216 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 248 | DWSGDAAPP2 | MicroSQL | ophelia | 6/9/2026 9:59:02 AM | 139 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 390 | DWSGDAAPP2 | | ophelia | 6/9/2026 10:01:16 AM | 5 | Read/Write | (@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL,
PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH
FROM WF_PSWET
WHERE PAR_TYPE='HEADER'
AND EMP_CODI= @
AND FLU_CONT= @_1
AND ETA_CONT= @_2 |
| Executions | CPUTimeMs | AvgCPUMs | ElapsedMs | LogicalReads | QueryText |
|---|
| 1 | 572989 | 572989 | 364924 | 48395344 | INSERT INTO ##TemReferences SELECT DISTINCT
DR.Id
, DR.Code
, DR.CreationDate
, DR.CloseDate
, ISNULL(DR.NameReferencies, '')
, C.Name
, D.Name
, S.Name
, ISNULL(SS.Name, '')
, ST.Id
, ISNULL(ST.Name, '')
, ST.Code
, ISNULL(AB.Name, '')
, ISNULL(RS.TotalFolios, DR.Folios)
, S.ManagementArchiveStay
, S.CoreArchiveStay
, S.DispositionTypeId
, SS.ManagementArchiveStay
, SS.CoreArchiveStay
, SS.DispositionTypeId
, ISNULL(DR.CompanyId, D.CompaniesId)
, D.Id
, S.Id
, SS.Id
, RF.FileNumber
, RF.OriginId
, RF.SenderName
, DR.Description
, DR.Tomo
, DR.Version
, DR.VolumeCount
, DR.DateVersion
, DR.Location
, D.Code
, SS.Code
, S.Code
, DR.NoteScope
, DR.PrimaryValue
, Dr.SecundaryValue
, SP.Id
, SP.Name
, DR.InitialDate
, DR.EndDate
, DR.size
, box.Id
, ISNULL(box.NumberBox,'')
, AB.Id
, DR.ParentId
, CONCAT(DR.Code , ' - ', DR.NameReferencies)
, DI.Id
, CAST(MR.Value AS VARCHAR(MAX)) AS metadataValue
, DR.VersionCCD
, DR.VersionTRD
, CONCAT(U.Name, ' ' , U.Surnames) AS creationUserName
, U.UserName AS creationUser
FROM DMS_References DR WITH(NOLOCK)
LEFT JOIN ReferencesRequestFile RRF WITH(NOLOCK) ON (RRF.ReferencesId = DR.Id AND RRF.TypeDocumentId = ISNULL(@iDocTypeId, RRF.TypeDocumentId))
LEFT JOIN RequestFiles RF WITH(NOLOCK) ON (RF.Id = RRF.RequestFileId AND RF.ProcedureId = ISNULL(@iProcedureId, RF.ProcedureId) )
LEFT JOIN DMS_Indexes DI WITH(NOLOCK) ON DI.ReferenceRFId = RRF.Id
INNER JOIN Dependencies D WITH(NOLOCK) ON D.Id = DR.DependencyId
INNER JOIN Companies C WITH(NOLOCK) ON C.Id = DR.CompanyId
INNER JOIN Series S WITH(NOLOCK) ON S.Id = DR.SeriesId
LEFT JOIN Subseries SS WITH(NOLOCK) ON (SS.Id = DR.SubseriesId AND SS.Id = ISNULL(@iSubseriesId, SS.Id))
LEFT JOIN TypeDetail ST WITH(NOLOCK) ON ST.Id = DR.StateId
LEFT JOIN TypeDetail AB WITH(NOLOCK) ON AB.Id = DR.AvailabilityId
LEFT JOIN TypeDetail SP WITH(NOLOCK) ON CAST(SP.Id AS varchar(50)) = DR.Support
LEFT JOIN Box box WITH(NOLOCK) ON box.Id = DR.BoxId
LEFT JOIN MetadataReference MR WITH(NOLOCK) ON MR.ReferenceId = DR.Id
LEFT JOIN Users U WITH(NOLOCK) ON DR.CreationUser = U.Id
LEFT JOIN (
SELECT ReferenceId, MAX(Tomo) AS TotalTomo, SUM(CONVERT(INT,Folios)) AS TotalFolios
FROM DMS_ReferencesSummary WITH (NOLOCK)
GROUP BY ReferenceId
) RS ON RS.ReferenceId = DR.Id
WHERE 1 = 1
AND DR.CompanyId = @iCompanyId |
| 15 | 387111 | 25807 | 110922 | 12088011 | SELECT [w].[EMP_CODI], [w].[CAS_CONT], [w].[SEG_CONT], [w].[AUD_ESTA], [w].[AUD_UFAC], [w].[AUD_USUA], [w].[ETA_CONT], [w].[FLU_CONT], [w].[SEG_ABRE], [w].[SEG_AENV], [w].[SEG_ALER], [w].[SEG_COME], [w].[SEG_CONA], [w].[SEG_DATA], [w].[SEG_DIAD], [w].[SEG_DIAE], [w].[SEG_DIAR], [w].[SEG_EANT], [w].[SEG_ERRO], [w].[SEG_ESTC], [w].[SEG_ESTE], [w].[SEG_FATI], [w].[SEG_FCUL], [w].[SEG_FENC], [w].[SEG_FIEJ], [w].[SEG_FLIM], [w].[SEG_FREC], [w].[SEG_HCUL], [w].[SEG_HLIM], [w].[SEG_HREC], [w].[SEG_IDCH], [w].[SEG_INTE], [w].[SEG_IPAD], [w].[SEG_PRIO], [w].[SEG_RECO], [w].[SEG_RESU], [w].[SEG_SUBJ], [w].[SEG_UALA], [w].[SEG_UENC], [w].[SEG_UORI]
FROM [WF_SEGUI] AS [w]
WHERE [w].[EMP_CODI] = @companyCode AND [w].[SEG_IPAD] = @localIp AND [w].[SEG_ESTE] = N'Q' AND [w].[SEG_FENC] < @queuingDate AND [w].[SEG_FREC] >= @creationDate |
| 70 | 342350 | 4890 | 93197 | 3437908 | SELECT DISTINCT
RF.IdRadicado,
RF.Radicado,
RF.Fecha,
CN.[Name] AS 'Canal',
RF.[Tipo de persona],
TD.Name AS 'Tipo de identificación',
CL.NumberIdentification AS 'Número de identificación',
RF.Entidad,
RF.Destinatario AS 'Nombres y apellidos remitente',
CL.Id AS 'Id Cliente',
CT.Id AS 'Id Contacto',
RF.País,
RF.Departamento,
RF.Ciudad,
RF.Dirección,
RF.[Correo electrónico],
RF.Asunto,
RF.Folios,
RFD.Attachments AS 'Número de anexos',
RF.[Descripción de anexos],
RF.Compañía,
RF.Dependencia,
CONCAT(DP.NameSolicitud, ' / ', LTRIM(RTRIM(DP.NameDetalle)), IIF(ISNULL(DP.NameEspecificacion, '0') = '0', NULL, ' / '), DP.NameEspecificacion) AS 'Trámite',
RFD.UserName AS 'Usuario Radicador',
RF.FuncionarioResponsable 'Responsable',
'https://tinyurl.com/5e6yz5u9' AS QR
FROM GETDATABYRADICATE_VW RF
INNER JOIN REQUESTFILE_VW RFD ON RFD.Id = RF.IdRadicado
INNER JOIN CANAL_VW CN ON CN.Id = RFD.ChannelId
INNER JOIN CLIENTS_VW CL ON CL.Id = RFD.ClientId
INNER JOIN CONTACTS_VW CT ON CT.Id = RFD.ContactId
INNER JOIN TypeDetail TD ON TD.Id = CL.DocumentTypeId
INNER JOIN DMSProcedureNew_VW DP ON RFD.ProcedureId = DP.IdProcedure
WHERE RF.Radicado = @Radicado |
| 19 | 81150 | 4271 | 19113 | 69903 | SELECT
FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fecha radicado'
, RF.FileNumber AS 'Radicado'
, RF.[Subject] AS 'Asunto'
FROM [dbo].[REQUESTFILE_VW] RF
INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = RF.ClientId
WHERE C.NumberIdentification = @NIdentification
ORDER BY Radicado DESC |
| 12 | 74357 | 6196 | 23674 | 52523 | SELECT
FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fecha radicado'
, RF.FileNumber AS 'Radicado'
, RF.[Subject] AS 'Asunto'
FROM [dbo].[REQUESTFILE_VW] RF
INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = RF.ClientId
WHERE C.NumberIdentification = @NIdentification
ORDER BY Radicado DESC |
| 960 | 69841 | 72 | 79986 | 8712960 | SELECT TOP(@__p_2) [r].[Id], [r].[CaseCode], [r].[CompanyCode], [r].[CompletedAt], [r].[CreatedAt], [r].[DependencyCode], [r].[ErrorMessage], [r].[FileNumber], [r].[JobId], [r].[LastErrorAt], [r].[MaxRetries], [r].[NextRetryAt], [r].[ProcessCode], [r].[ProcessName], [r].[ProcessingServer], [r].[Reason], [r].[ReassignBPM], [r].[ReassignDMS], [r].[RetryCount], [r].[StartedAt], [r].[Status], [r].[StatusId], [r].[TrackingCode], [r].[UserExecutor], [r].[UserToReassign]
FROM [ReassignmentTask] AS [r]
WHERE [r].[ProcessingServer] = @__serverIp_0 AND ([r].[Status] = N'Pending' OR ([r].[Status] = N'Failed' AND [r].[RetryCount] < [r].[MaxRetries] AND [r].[NextRetryAt] IS NOT NULL AND [r].[NextRetryAt] <= @__now_1))
ORDER BY [r].[CreatedAt] |
| 22 | 62180 | 2826 | 16007 | 1009284 | SELECT DISTINCT
RF.Radicado,
RF.Fecha,
RF.[Tipo de persona],
RF.Entidad,
RF.Destinatario,
RF.País,
RF.Departamento,
RF.Ciudad,
RF.Dirección,
RF.[Correo electrónico],
RF.Asunto,
RF.[Cuerpo del mensaje],
RF.Folios,
RF.[Descripción de anexos],
RF.[Canal de envío],
RF.Elaboró,
RF.Revisó,
RF.Aprobó,
RF.Compañía,
RF.Dependencia,
RF.Funcionario,
RF.Cargo,
RF.TFirma,
RF.[Firma Firmante],
RF.[Cargo destinatario],
ISNULL (RF.CollaborativeWorkName, '1') AS 'CollaborativeWorkName',
RF.CollaborativeWorkBody
FROM GETDATABYRADICATE_VW RF
WHERE RF.Radicado = @Radicado |
| 1 | 61022 | 61022 | 36670 | 436032 | select distinct RF . FileNumber as 'Radicado' , RF . FiledDate as 'Fecha radicación' , ( U . Name + ' ' + U . Surnames ) as 'Usuario Radicador' , D . Name as 'Dependencia Radicacion' from RequestFiles RF with ( NOLOCK ) inner join Users U with ( NOLOCK ) on U . UserName = RF . UserName inner join ( select RH . RequestFileId , RH . CreationDate , RH . DependencyId , ROW_NUMBER ( ) over ( PARTITION by RH . RequestFileId order by RH . CreationDate asc ) as RowNum from RequestFileHistories RH with ( NOLOCK ) ) RH on RH . RequestFileId = RF . Id and RH . RowNum = @0 left join Dependencies D with ( NOLOCK ) on D . Id = RH . DependencyId where RF . FiledDate > @1 and RF . FileNumber ! = @2 group by RF . FileNumber , RF . FiledDate , ( U . Name + ' ' + U . Surnames ) , D . Name having COUNT ( * ) > 1 |
| 2 | 60790 | 30395 | 25132 | 6539166 | SELECT TOP 1 COUNT(DISTINCT RH.CaseId) AS CaseCount, CS.SEG_ESTE AS 'Estado' FROM RequestFileHistories RH WITH (NOLOCK) INNER JOIN RequestFiles RF WITH (NOLOCK) ON RF.Id = RH.RequestFileId INNER JOIN OpheliaSuite.dbo.WF_SEGUI CS WITH (NOLOCK) ON CS.CAS_CONT = RH.CaseId WHERE RF.FileNumber = @additionalProp1 AND RH.ProcessCode = '615' AND ETA_CONT='3' GROUP BY CS.SEG_ESTE ORDER BY MAX(AUD_UFAC) desc |
| 1 | 56493 | 56493 | 81911 | 1460592 | select WF . CAS_CONT , WF . SEG_SUBJ , WF . FLU_CONT , U . UserName from WF_SEGUI WF inner join DMS . DBO . Users U on U . UserName = WF . SEG_UENC where WF . SEG_ESTE = @0 and U . RolAgora = @1 and FLU_CONT not in ( @2 , @3 , @4 , @5 , @6 , @7 ) |
| 16 | 48157 | 3009 | 11902 | 57087 | SELECT
FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fecha radicado'
, RF.FileNumber AS 'Radicado'
, RF.[Subject] AS 'Asunto'
FROM [dbo].[REQUESTFILE_VW] RF
INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = RF.ClientId
WHERE C.NumberIdentification = @NIdentification
ORDER BY Radicado DESC |
| 73 | 26031 | 356 | 34669 | 1351458 | SELECT
D.NAME AS 'Dependencia'
, RF.FileNumber AS 'Radicado'
, RF.FiledDate AS 'Fecha'
, CONCAT(isnull(RF.Pages,0), 'F/', isnull(RF.Attachments,0), 'ADJ/', RF.ReceiverName, '/', RF.UserName) AS 'Concatenado'
FROM RequestFiles RF WITH(NOLOCK)
LEFT JOIN Dependencies D WITH(NOLOCK) ON D.ID=RF.DependencyId
WHERE RF.FileNumber=@fileNumber |
| 960 | 24486 | 25 | 29124 | 1040640 | SELECT COUNT(*)
FROM [ReassignmentTask] AS [r]
WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0 |
| 1 | 23700 | 23700 | 24888 | 7497018 | INSERT INTO ##TemReferences2 SELECT
Id, Code, CreationDate, CloseDate, NameReferencies, company, dependency, series, subSeries, state, availability, Folios, Tomo, versionCCD, versionTRD, creationUserName, creationUser
FROM ##TemReferences |
| 11 | 22778 | 2070 | 6586 | 35643 | SELECT
RF.FiledDate AS 'Fecha radicado'
, RF.FileNumber AS 'Radicado'
, RF.Subject AS 'Asunto'
FROM [dbo].[REQUESTFILE_VW] RF
INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = rf.ClientId
WHERE c.NumberIdentification = convert (varchar, @NoIdent)
ORDER BY Radicado DESC |
| 9 | 21345 | 2371 | 18321 | 1361535 | UPDATE [w]
SET [w].[SEG_FATI] = @p,
[w].[SEG_FLIM] = @p4
FROM [WF_SEGUI] AS [w]
WHERE [w].[EMP_CODI] = @request_CompanyCode AND [w].[CAS_CONT] = @caseId AND [w].[FLU_CONT] = @request_ProcessCode AND [w].[SEG_ESTE] = N'P' |
| 1 | 19369 | 19369 | 42613 | 4333057 | select distinct RequestFiles . FileNumber Radicado , RequestFiles . Subject as [Asunto] , Dependencies . Name [Dependencia Actual] , CONCAT ( Users1 . Name , ' ' , Users1 . Surnames ) [Usuario Actual] , RequestFiles1 . Usuario [Usuario Rechaza] , ESTADO . Name [Proceso] , CANAL . Name [Medio Recepción] , ORIGEN . Name as [Tipo Comunicacion] , convert ( VARCHAR , RequestFiles . FiledDate , 23 ) [Fecha Radicación] , convert ( VARCHAR , RequestFileHistories . CreationDate , 23 ) [Fecha Creación] , RequestFiles . ExperationDate [Fecha Expiración] , coalesce ( case when MAX ( RequestFilesRespuestaDefinitiva . FileNumber ) over ( PARTITION by RequestFiles . FileNumber ) is not null then 'En Tiempo' end , case when MAX ( ESTADO . Name ) over ( PARTITION by RequestFiles . FileNumber ) in ( 'Finalizado' , 'Envío electrónico' , 'Comunicación pendiente por clasificar' , 'Comunicación Clasificada' , 'Pendiente en la dependencia' , 'Finalizado por Solicitud del Usuario' ) or RequestFiles . Subject like '%RESPUESTA RADICADO%' then 'En Tiempo' end , case when convert ( DATE , GETDATE ( ) ) < MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) and DATEDIFF ( DAY , convert ( DATE , GETDATE ( ) ) , MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) ) between 6 and 100000 then 'En Tiempo' end , case when DATEDIFF ( DAY , convert ( DATE , GETDATE ( ) ) , MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) ) between 0 and 5 then 'Proximo a Vencer' end , 'Vencido' ) [Estado Radicado] , ISNULL ( Rechazos . TotalRechazos , 0 ) as [Total Rechazos] from RequestFiles inner join ( select distinct RequestFiles . FileNumber , CONCAT ( Users1 . Name , ' ' , Users1 . Surnames ) Usuario from RequestFiles left join RequestFileHistories on RequestFileHistories . RequestFileId = RequestFiles . Id left join TypeDetail ESTADOGeneral on convert ( VARCHAR ( 50 ) , ESTADOGeneral . Id ) = RequestFileHistories . Status left join Users Users1 on Users1 . UserName = RequestFileHistories . UserName where ESTADOGeneral . Name = @0 and RequestFileHistories . CreationDate = ( select MAX ( AA . CreationDate ) from RequestFileHistories AA left join TypeDetail BB on convert ( VARCHAR ( 50 ) , BB . Id ) = AA . Status where AA . RequestFileId = RequestFileHistories . RequestFileId and BB . Name = @1 and AA . Status not in ( @2 , @3 , @4 ) ) ) RequestFiles1 on RequestFiles . FileNumber = RequestFiles1 . FileNumber left join ( select RF . FileNumber , COUNT ( * ) as TotalRechazos from RequestFiles RF inner join RequestFileHistories RFH on RFH . RequestFileId = RF . Id inner join TypeDetail TD on convert ( VARCHAR ( 50 ) , TD . Id ) = RFH . Status where TD . Name = @5 and RFH . Status not in ( @6 , @7 , @8 ) group by RF . FileNumber ) Rechazos on Rechazos . FileNumber = RequestFiles . FileNumber left join RequestFileHistories on RequestFileHistories . RequestFileId = RequestFiles . Id and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @9 , @10 , @11 ) ) left join TypeDetail ESTADO on convert ( VARCHAR ( 50 ) , ESTADO . Id ) = RequestFileHistories . Status left join DMS . DBO . TYPEORIGIN_VW ORIGEN on RequestFiles . OriginId = ORIGEN . Id left join Users Users1 on Users1 . UserName = RequestFileHistories . UserName left join dms . dbo . RelatedRequestFiles on RelatedRequestFiles . ParentId = RequestFiles . Id left join dms . dbo . RequestFiles RequestFilesRespuestaDefinitiva on RelatedRequestFiles . requestfileId = convert ( VARCHAR ( 40 ) , RequestFilesRespuestaDefinitiva . Id ) and RequestFilesRespuestaDefinitiva . FiledDate in ( select MAX ( AA . FiledDate ) from dms . dbo . RequestFiles AA inner join dms . dbo . RelatedRequestFiles BB on BB . RequestFileId = AA . Id inner join dms . dbo . RequestFiles CC on BB . ParentId = CC . Id where CC . FileNumber = RequestFiles . FileNumber and AA . RequestTypeId = @12 and AA . ResposnseText = @13 ) left join ( select Dependencies . Id , UserId , MIN ( Dependencies . Name ) over ( PARTITION by UserId ) Name , MIN ( case when ( Dependencies . Name ) = Dependencies . Name then Dependencies . Code end ) over ( PARTITION by UserId ) Code , TopSection , UsersCompany . State from DMS . DBO . Users inner join DMS . DBO . UsersCompany on Users . Id = UsersCompany . UserId inner join DMS . DBO . Dependencies on Dependencies . Id = UsersCompany . DependenceId inner join DMS . DBO . TypeDetail on UsersCompany . State = TypeDetail . Id and TypeDetail . Code = ( select MIN ( TypeDetail . Code ) from DMS . DBO . UsersCompany A inner join DMS . DBO . TypeDetail on A . State = TypeDetail . Id where UsersCompany . UserId = A . UserId group by A . UserId ) ) Dependencies on Users1 . Id = Dependencies . UserId left join dms . dbo . TypeDetail CANAL on CANAL . Id = RequestFiles . ChannelId where CANAL . Name in ( @14 , @15 , @16 ) and ESTADO . Name = @17 and CANAL . ID not in ( @18 ) and RequestFiles . FileNumber not in ( select A . FileNumber from RequestFiles A left join DMS_Procedures on A . ProcedureId = DMS_Procedures . Id left join dms . dbo . RequestFileHistories on RequestFileHistories . RequestFileId = A . Id left join dms . dbo . Users on Users . UserName = RequestFileHistories . UserName left join RelatedRequestFiles on RelatedRequestFiles . ParentId = A . Id left join RequestFiles RequestFiles2 on RequestFiles2 . Id = RelatedRequestFiles . RequestFileId left join dms . dbo . TypeDetail ESTADO on convert ( VARCHAR ( 40 ) , ESTADO . Id ) = RequestFileHistories . Status where A . FileNumber = RequestFiles . FileNumber and RequestFiles2 . FileNumber is not null and RequestFiles2 . ResposnseText = @19 ) and YEAR ( RequestFiles . FiledDate ) in ( @20 , @21 , @22 , @23 ) and MONTH ( RequestFiles . FiledDate ) in ( @24 , @25 , @26 , @27 , @28 , @29 , @30 , @31 , @32 , @33 , @34 , @35 ) |
| 1 | 18210 | 18210 | 313185 | 1940936 | select distinct RequestFiles . FileNumber Radicado , RequestFiles . Subject as [Asunto] , Dependencies . Name [Dependencia Actual] , CONCAT ( Users1 . Name , ' ' , Users1 . Surnames ) [Usuario Actual] , RequestFiles1 . Usuario [Usuario Rechaza] , ESTADO . Name [Proceso] , CANAL . Name [Medio Recepción] , ORIGEN . Name as [Tipo Comunicacion] , convert ( VARCHAR , RequestFiles . FiledDate , 23 ) [Fecha Radicación] , convert ( VARCHAR , RequestFileHistories . CreationDate , 23 ) [Fecha Creación] , RequestFiles . ExperationDate [Fecha Expiración] , coalesce ( case when MAX ( RequestFilesRespuestaDefinitiva . FileNumber ) over ( PARTITION by RequestFiles . FileNumber ) is not null then 'En Tiempo' end , case when MAX ( ESTADO . Name ) over ( PARTITION by RequestFiles . FileNumber ) in ( 'Finalizado' , 'Envío electrónico' , 'Comunicación pendiente por clasificar' , 'Comunicación Clasificada' , 'Pendiente en la dependencia' , 'Finalizado por Solicitud del Usuario' ) or RequestFiles . Subject like '%RESPUESTA RADICADO%' then 'En Tiempo' end , case when convert ( DATE , GETDATE ( ) ) < MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) and DATEDIFF ( DAY , convert ( DATE , GETDATE ( ) ) , MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) ) between 6 and 100000 then 'En Tiempo' end , case when DATEDIFF ( DAY , convert ( DATE , GETDATE ( ) ) , MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) ) between 0 and 5 then 'Proximo a Vencer' end , 'Vencido' ) [Estado Radicado] , ISNULL ( Rechazos . TotalRechazos , 0 ) as [Total Rechazos] from RequestFiles inner join ( select distinct RequestFiles . FileNumber , CONCAT ( Users1 . Name , ' ' , Users1 . Surnames ) Usuario from RequestFiles left join RequestFileHistories on RequestFileHistories . RequestFileId = RequestFiles . Id left join TypeDetail ESTADOGeneral on convert ( VARCHAR ( 50 ) , ESTADOGeneral . Id ) = RequestFileHistories . Status left join Users Users1 on Users1 . UserName = RequestFileHistories . UserName where ESTADOGeneral . Name = @0 and RequestFileHistories . CreationDate = ( select MAX ( AA . CreationDate ) from RequestFileHistories AA left join TypeDetail BB on convert ( VARCHAR ( 50 ) , BB . Id ) = AA . Status where AA . RequestFileId = RequestFileHistories . RequestFileId and BB . Name = @1 and AA . Status not in ( @2 , @3 , @4 ) ) ) RequestFiles1 on RequestFiles . FileNumber = RequestFiles1 . FileNumber left join ( select RF . FileNumber , COUNT ( * ) as TotalRechazos from RequestFiles RF inner join RequestFileHistories RFH on RFH . RequestFileId = RF . Id inner join TypeDetail TD on convert ( VARCHAR ( 50 ) , TD . Id ) = RFH . Status where TD . Name = @5 and RFH . Status not in ( @6 , @7 , @8 ) group by RF . FileNumber ) Rechazos on Rechazos . FileNumber = RequestFiles . FileNumber left join RequestFileHistories on RequestFileHistories . RequestFileId = RequestFiles . Id and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @9 , @10 , @11 ) ) left join TypeDetail ESTADO on convert ( VARCHAR ( 50 ) , ESTADO . Id ) = RequestFileHistories . Status left join DMS . DBO . TYPEORIGIN_VW ORIGEN on RequestFiles . OriginId = ORIGEN . Id left join Users Users1 on Users1 . UserName = RequestFileHistories . UserName left join dms . dbo . RelatedRequestFiles on RelatedRequestFiles . ParentId = RequestFiles . Id left join dms . dbo . RequestFiles RequestFilesRespuestaDefinitiva on RelatedRequestFiles . requestfileId = convert ( VARCHAR ( 40 ) , RequestFilesRespuestaDefinitiva . Id ) and RequestFilesRespuestaDefinitiva . FiledDate in ( select MAX ( AA . FiledDate ) from dms . dbo . RequestFiles AA inner join dms . dbo . RelatedRequestFiles BB on BB . RequestFileId = AA . Id inner join dms . dbo . RequestFiles CC on BB . ParentId = CC . Id where CC . FileNumber = RequestFiles . FileNumber and AA . RequestTypeId = @12 and AA . ResposnseText = @13 ) left join ( select Dependencies . Id , UserId , MIN ( Dependencies . Name ) over ( PARTITION by UserId ) Name , MIN ( case when ( Dependencies . Name ) = Dependencies . Name then Dependencies . Code end ) over ( PARTITION by UserId ) Code , TopSection , UsersCompany . State from DMS . DBO . Users inner join DMS . DBO . UsersCompany on Users . Id = UsersCompany . UserId inner join DMS . DBO . Dependencies on Dependencies . Id = UsersCompany . DependenceId inner join DMS . DBO . TypeDetail on UsersCompany . State = TypeDetail . Id and TypeDetail . Code = ( select MIN ( TypeDetail . Code ) from DMS . DBO . UsersCompany A inner join DMS . DBO . TypeDetail on A . State = TypeDetail . Id where UsersCompany . UserId = A . UserId group by A . UserId ) ) Dependencies on Users1 . Id = Dependencies . UserId left join dms . dbo . TypeDetail CANAL on CANAL . Id = RequestFiles . ChannelId where CANAL . Name in ( @14 , @15 , @16 ) and ESTADO . Name = @17 and CANAL . ID not in ( @18 ) and RequestFiles . FileNumber not in ( select A . FileNumber from RequestFiles A left join DMS_Procedures on A . ProcedureId = DMS_Procedures . Id left join dms . dbo . RequestFileHistories on RequestFileHistories . RequestFileId = A . Id left join dms . dbo . Users on Users . UserName = RequestFileHistories . UserName left join RelatedRequestFiles on RelatedRequestFiles . ParentId = A . Id left join RequestFiles RequestFiles2 on RequestFiles2 . Id = RelatedRequestFiles . RequestFileId left join dms . dbo . TypeDetail ESTADO on convert ( VARCHAR ( 40 ) , ESTADO . Id ) = RequestFileHistories . Status where A . FileNumber = RequestFiles . FileNumber and RequestFiles2 . FileNumber is not null and RequestFiles2 . ResposnseText = @19 ) and YEAR ( RequestFiles . FiledDate ) in ( @20 ) and MONTH ( RequestFiles . FiledDate ) in ( @21 , @22 , @23 , @24 , @25 , @26 ) |
| 37 | 14800 | 400 | 133565 | 1380337 | SELECT [d].[Id], [d].[AvailabilityId], [d].[BoxId], [d].[CloseDate], [d].[CloseUser], [d].[Code], [d].[CompanyId], [d].[ConsultFrequencyId], [d].[CreationDate], [d].[CreationUser], [d].[CrossReference], [d].[DateVersion], [d].[DependencyId], [d].[Description], [d].[EndDate], [d].[ExternalId], [d].[Folios], [d].[IdStatusBeforeLocked], [d].[InUnificationProcess], [d].[InitialDate], [d].[InitialRetentionDate], [d].[InitialRetentionDateAC], [d].[Location], [d].[ModificateDate], [d].[NameReferencies], [d].[NoteScope], [d].[ParentId], [d].[PendingReorder], [d].[PrimaryValue], [d].[RetentionEndDate], [d].[RetentionEndDateAC], [d].[SecundaryValue], [d].[SeriesId], [d].[size], [d].[StateId], [d].[StateTransferId], [d].[SubseriesId], [d].[Support], [d].[Tomo], [d].[TopographicLocationDescription], [d].[TopographicLocationId], [d].[Version], [d].[VersionCCD], [d].[VersionTRD], [d].[VersionTVD], [d].[VolumeCount], [s].[Id], [s].[AccessClassificationId], [s].[Code], [s].[ConformationReferenceId], [s].[CoreArchiveStay], [s].[CreationDate], [s].[Description], [s].[DispositionDescription], [s].[DispositionTypeId], [s].[ElectronicSize], [s].[HasSubserie], [s].[ManagementArchiveStay], [s].[ModificateDate], [s].[ModificateUser], [s].[Name], [s].[PhysicalSize], [s].[PreservationTechTypeId], [s].[PreservationTypeId], [s].[Section], [s].[SerieStateId], [s].[TimeId], [s].[TimeMeasurenmentId], [s].[TopSectionId], [s].[Version], [s].[VersionCCD], [s].[VersionTRD], [s].[VersionTVD], [s0].[Id], [s0].[AccessClassificationId], [s0].[ClosingDate], [s0].[Code], [s0].[ConformationReferenceId], [s0].[CoreArchiveStay], [s0].[CreationDate], [s0].[Description], [s0].[DispositionDescription], [s0].[DispositionTypeId], [s0].[ElectronicSize], [s0].[ManagementArchiveStay], [s0].[ModificateDate], [s0].[ModificateUser], [s0].[Name], [s0].[PhysicalSize], [s0].[PreservationTechTypeId], [s0].[PreservationTypeId], [s0].[SerieId], [s0].[SubserieStateId], [s0].[TimeId], [s0].[TimeMeasurenmentId], [s0].[TopSection], [s0].[Version], [s0].[VersionCCD], [s0].[VersionTRD], [r].[Id], [r].[AccessClassificationId], [r].[Annexes], [r].[ArchivingUserId], [r].[Condition], [r].[DateDocument], [r].[DateIncorporation], [r].[DocumentConditionId], [r].[EndPage], [r].[ExternalFileNumber], [r].[FirstUseDate], [r].[Folios], [r].[Homepage], [r].[LastAccessDate], [r].[Name], [r].[Observation], [r].[Orden], [r].[ReferencesId], [r].[RequestFileId], [r].[size], [r].[SupportId], [r].[TypeDocumentId], [r].[UpdateDate], [r].[UrlLocation]
FROM [DMS_References] AS [d]
LEFT JOIN [Series] AS [s] ON [d].[SeriesId] = [s].[Id]
LEFT JOIN [Subseries] AS [s0] ON [d].[SubseriesId] = [s0].[Id]
LEFT JOIN [ReferencesRequestFile] AS [r] ON [d].[Id] = [r].[ReferencesId]
WHERE [d].[Code] = @__get_Item_Code_0
ORDER BY [d].[Id], [s].[Id], [s0].[Id], [r].[Id] |
| 924 | 14210 | 15 | 16690 | 473094 | SELECT COUNT(*)
FROM [WF_PROCESS_QUEUE] AS [w]
WHERE [w].[STATUS] = N'PROCESSING' AND ([w].[LAST_HEARTBEAT] IS NULL OR DATEDIFF(minute, [w].[LAST_HEARTBEAT], @__now_1) <= @___heartbeatTimeoutMinutes_2) |
Un autogrowth significa que SQL Server tuvo que crecer automáticamente un archivo MDF, NDF o LDF porque se quedó sin espacio interno asignado. No siempre es un error, pero en producción puede causar pausas, esperas de I/O y bloqueos temporales.
| Executions | TotalLogicalReads | AvgLogicalReads | CPUTimeMs | ElapsedMs | DatabaseName | QueryText |
|---|
| 1 | 48395344 | 48395344 | 572989 | 364924 | | INSERT INTO ##TemReferences SELECT DISTINCT
DR.Id
, DR.Code
, DR.CreationDate
, DR.CloseDate
, ISNULL(DR.NameReferencies, '')
, C.Name
, D.Name
, S.Name
, ISNULL(SS.Name, '')
, ST.Id
, ISNULL(ST.Name, '')
, ST.Code
, ISNULL(AB.Name, '')
, ISNULL(RS.TotalFolios, DR.Folios)
, S.ManagementArchiveStay
, S.CoreArchiveStay
, S.DispositionTypeId
, SS.ManagementArchiveStay
, SS.CoreArchiveStay
, SS.DispositionTypeId
, ISNULL(DR.CompanyId, D.CompaniesId)
, D.Id
, S.Id
, SS.Id
, RF.FileNumber
, RF.OriginId
, RF.SenderName
, DR.Description
, DR.Tomo
, DR.Version
, DR.VolumeCount
, DR.DateVersion
, DR.Location
, D.Code
, SS.Code
, S.Code
, DR.NoteScope
, DR.PrimaryValue
, Dr.SecundaryValue
, SP.Id
, SP.Name
, DR.InitialDate
, DR.EndDate
, DR.size
, box.Id
, ISNULL(box.NumberBox,'')
, AB.Id
, DR.ParentId
, CONCAT(DR.Code , ' - ', DR.NameReferencies)
, DI.Id
, CAST(MR.Value AS VARCHAR(MAX)) AS metadataValue
, DR.VersionCCD
, DR.VersionTRD
, CONCAT(U.Name, ' ' , U.Surnames) AS creationUserName
, U.UserName AS creationUser
FROM DMS_References DR WITH(NOLOCK)
LEFT JOIN ReferencesRequestFile RRF WITH(NOLOCK) ON (RRF.ReferencesId = DR.Id AND RRF.TypeDocumentId = ISNULL(@iDocTypeId, RRF.TypeDocumentId))
LEFT JOIN RequestFiles RF WITH(NOLOCK) ON (RF.Id = RRF.RequestFileId AND RF.ProcedureId = ISNULL(@iProcedureId, RF.ProcedureId) )
LEFT JOIN DMS_Indexes DI WITH(NOLOCK) ON DI.ReferenceRFId = RRF.Id
INNER JOIN Dependencies D WITH(NOLOCK) ON D.Id = DR.DependencyId
INNER JOIN Companies C WITH(NOLOCK) ON C.Id = DR.CompanyId
INNER JOIN Series S WITH(NOLOCK) ON S.Id = DR.SeriesId
LEFT JOIN Subseries SS WITH(NOLOCK) ON (SS.Id = DR.SubseriesId AND SS.Id = ISNULL(@iSubseriesId, SS.Id))
LEFT JOIN TypeDetail ST WITH(NOLOCK) ON ST.Id = DR.StateId
LEFT JOIN TypeDetail AB WITH(NOLOCK) ON AB.Id = DR.AvailabilityId
LEFT JOIN TypeDetail SP WITH(NOLOCK) ON CAST(SP.Id AS varchar(50)) = DR.Support
LEFT JOIN Box box WITH(NOLOCK) ON box.Id = DR.BoxId
LEFT JOIN MetadataReference MR WITH(NOLOCK) ON MR.ReferenceId = DR.Id
LEFT JOIN Users U WITH(NOLOCK) ON DR.CreationUser = U.Id
LEFT JOIN (
SELECT ReferenceId, MAX(Tomo) AS TotalTomo, SUM(CONVERT(INT,Folios)) AS TotalFolios
FROM DMS_ReferencesSummary WITH (NOLOCK)
GROUP BY ReferenceId
) RS ON RS.ReferenceId = DR.Id
WHERE 1 = 1
AND DR.CompanyId = @iCompanyId |
| 15 | 12088011 | 805867 | 387111 | 110922 | | SELECT [w].[EMP_CODI], [w].[CAS_CONT], [w].[SEG_CONT], [w].[AUD_ESTA], [w].[AUD_UFAC], [w].[AUD_USUA], [w].[ETA_CONT], [w].[FLU_CONT], [w].[SEG_ABRE], [w].[SEG_AENV], [w].[SEG_ALER], [w].[SEG_COME], [w].[SEG_CONA], [w].[SEG_DATA], [w].[SEG_DIAD], [w].[SEG_DIAE], [w].[SEG_DIAR], [w].[SEG_EANT], [w].[SEG_ERRO], [w].[SEG_ESTC], [w].[SEG_ESTE], [w].[SEG_FATI], [w].[SEG_FCUL], [w].[SEG_FENC], [w].[SEG_FIEJ], [w].[SEG_FLIM], [w].[SEG_FREC], [w].[SEG_HCUL], [w].[SEG_HLIM], [w].[SEG_HREC], [w].[SEG_IDCH], [w].[SEG_INTE], [w].[SEG_IPAD], [w].[SEG_PRIO], [w].[SEG_RECO], [w].[SEG_RESU], [w].[SEG_SUBJ], [w].[SEG_UALA], [w].[SEG_UENC], [w].[SEG_UORI]
FROM [WF_SEGUI] AS [w]
WHERE [w].[EMP_CODI] = @companyCode AND [w].[SEG_IPAD] = @localIp AND [w].[SEG_ESTE] = N'Q' AND [w].[SEG_FENC] < @queuingDate AND [w].[SEG_FREC] >= @creationDate |
| 1059 | 9611484 | 9076 | 76574 | 87967 | | SELECT TOP(@__p_2) [r].[Id], [r].[CaseCode], [r].[CompanyCode], [r].[CompletedAt], [r].[CreatedAt], [r].[DependencyCode], [r].[ErrorMessage], [r].[FileNumber], [r].[JobId], [r].[LastErrorAt], [r].[MaxRetries], [r].[NextRetryAt], [r].[ProcessCode], [r].[ProcessName], [r].[ProcessingServer], [r].[Reason], [r].[ReassignBPM], [r].[ReassignDMS], [r].[RetryCount], [r].[StartedAt], [r].[Status], [r].[StatusId], [r].[TrackingCode], [r].[UserExecutor], [r].[UserToReassign]
FROM [ReassignmentTask] AS [r]
WHERE [r].[ProcessingServer] = @__serverIp_0 AND ([r].[Status] = N'Pending' OR ([r].[Status] = N'Failed' AND [r].[RetryCount] < [r].[MaxRetries] AND [r].[NextRetryAt] IS NOT NULL AND [r].[NextRetryAt] <= @__now_1))
ORDER BY [r].[CreatedAt] |
| 2 | 8666237 | 4333118 | 42559 | 88897 | | select distinct RequestFiles . FileNumber Radicado , RequestFiles . Subject as [Asunto] , Dependencies . Name [Dependencia Actual] , CONCAT ( Users1 . Name , ' ' , Users1 . Surnames ) [Usuario Actual] , RequestFiles1 . Usuario [Usuario Rechaza] , ESTADO . Name [Proceso] , CANAL . Name [Medio Recepción] , ORIGEN . Name as [Tipo Comunicacion] , convert ( VARCHAR , RequestFiles . FiledDate , 23 ) [Fecha Radicación] , convert ( VARCHAR , RequestFileHistories . CreationDate , 23 ) [Fecha Creación] , RequestFiles . ExperationDate [Fecha Expiración] , coalesce ( case when MAX ( RequestFilesRespuestaDefinitiva . FileNumber ) over ( PARTITION by RequestFiles . FileNumber ) is not null then 'En Tiempo' end , case when MAX ( ESTADO . Name ) over ( PARTITION by RequestFiles . FileNumber ) in ( 'Finalizado' , 'Envío electrónico' , 'Comunicación pendiente por clasificar' , 'Comunicación Clasificada' , 'Pendiente en la dependencia' , 'Finalizado por Solicitud del Usuario' ) or RequestFiles . Subject like '%RESPUESTA RADICADO%' then 'En Tiempo' end , case when convert ( DATE , GETDATE ( ) ) < MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) and DATEDIFF ( DAY , convert ( DATE , GETDATE ( ) ) , MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) ) between 6 and 100000 then 'En Tiempo' end , case when DATEDIFF ( DAY , convert ( DATE , GETDATE ( ) ) , MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) ) between 0 and 5 then 'Proximo a Vencer' end , 'Vencido' ) [Estado Radicado] , ISNULL ( Rechazos . TotalRechazos , 0 ) as [Total Rechazos] from RequestFiles inner join ( select distinct RequestFiles . FileNumber , CONCAT ( Users1 . Name , ' ' , Users1 . Surnames ) Usuario from RequestFiles left join RequestFileHistories on RequestFileHistories . RequestFileId = RequestFiles . Id left join TypeDetail ESTADOGeneral on convert ( VARCHAR ( 50 ) , ESTADOGeneral . Id ) = RequestFileHistories . Status left join Users Users1 on Users1 . UserName = RequestFileHistories . UserName where ESTADOGeneral . Name = @0 and RequestFileHistories . CreationDate = ( select MAX ( AA . CreationDate ) from RequestFileHistories AA left join TypeDetail BB on convert ( VARCHAR ( 50 ) , BB . Id ) = AA . Status where AA . RequestFileId = RequestFileHistories . RequestFileId and BB . Name = @1 and AA . Status not in ( @2 , @3 , @4 ) ) ) RequestFiles1 on RequestFiles . FileNumber = RequestFiles1 . FileNumber left join ( select RF . FileNumber , COUNT ( * ) as TotalRechazos from RequestFiles RF inner join RequestFileHistories RFH on RFH . RequestFileId = RF . Id inner join TypeDetail TD on convert ( VARCHAR ( 50 ) , TD . Id ) = RFH . Status where TD . Name = @5 and RFH . Status not in ( @6 , @7 , @8 ) group by RF . FileNumber ) Rechazos on Rechazos . FileNumber = RequestFiles . FileNumber left join RequestFileHistories on RequestFileHistories . RequestFileId = RequestFiles . Id and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @9 , @10 , @11 ) ) left join TypeDetail ESTADO on convert ( VARCHAR ( 50 ) , ESTADO . Id ) = RequestFileHistories . Status left join DMS . DBO . TYPEORIGIN_VW ORIGEN on RequestFiles . OriginId = ORIGEN . Id left join Users Users1 on Users1 . UserName = RequestFileHistories . UserName left join dms . dbo . RelatedRequestFiles on RelatedRequestFiles . ParentId = RequestFiles . Id left join dms . dbo . RequestFiles RequestFilesRespuestaDefinitiva on RelatedRequestFiles . requestfileId = convert ( VARCHAR ( 40 ) , RequestFilesRespuestaDefinitiva . Id ) and RequestFilesRespuestaDefinitiva . FiledDate in ( select MAX ( AA . FiledDate ) from dms . dbo . RequestFiles AA inner join dms . dbo . RelatedRequestFiles BB on BB . RequestFileId = AA . Id inner join dms . dbo . RequestFiles CC on BB . ParentId = CC . Id where CC . FileNumber = RequestFiles . FileNumber and AA . RequestTypeId = @12 and AA . ResposnseText = @13 ) left join ( select Dependencies . Id , UserId , MIN ( Dependencies . Name ) over ( PARTITION by UserId ) Name , MIN ( case when ( Dependencies . Name ) = Dependencies . Name then Dependencies . Code end ) over ( PARTITION by UserId ) Code , TopSection , UsersCompany . State from DMS . DBO . Users inner join DMS . DBO . UsersCompany on Users . Id = UsersCompany . UserId inner join DMS . DBO . Dependencies on Dependencies . Id = UsersCompany . DependenceId inner join DMS . DBO . TypeDetail on UsersCompany . State = TypeDetail . Id and TypeDetail . Code = ( select MIN ( TypeDetail . Code ) from DMS . DBO . UsersCompany A inner join DMS . DBO . TypeDetail on A . State = TypeDetail . Id where UsersCompany . UserId = A . UserId group by A . UserId ) ) Dependencies on Users1 . Id = Dependencies . UserId left join dms . dbo . TypeDetail CANAL on CANAL . Id = RequestFiles . ChannelId where CANAL . Name in ( @14 , @15 , @16 ) and ESTADO . Name = @17 and CANAL . ID not in ( @18 ) and RequestFiles . FileNumber not in ( select A . FileNumber from RequestFiles A left join DMS_Procedures on A . ProcedureId = DMS_Procedures . Id left join dms . dbo . RequestFileHistories on RequestFileHistories . RequestFileId = A . Id left join dms . dbo . Users on Users . UserName = RequestFileHistories . UserName left join RelatedRequestFiles on RelatedRequestFiles . ParentId = A . Id left join RequestFiles RequestFiles2 on RequestFiles2 . Id = RelatedRequestFiles . RequestFileId left join dms . dbo . TypeDetail ESTADO on convert ( VARCHAR ( 40 ) , ESTADO . Id ) = RequestFileHistories . Status where A . FileNumber = RequestFiles . FileNumber and RequestFiles2 . FileNumber is not null and RequestFiles2 . ResposnseText = @19 ) and YEAR ( RequestFiles . FiledDate ) in ( @20 , @21 , @22 , @23 ) and MONTH ( RequestFiles . FiledDate ) in ( @24 , @25 , @26 , @27 , @28 , @29 , @30 , @31 , @32 , @33 , @34 , @35 ) |
| 1 | 7497018 | 7497018 | 23700 | 24888 | DMS | INSERT INTO ##TemReferences2 SELECT
Id, Code, CreationDate, CloseDate, NameReferencies, company, dependency, series, subSeries, state, availability, Folios, Tomo, versionCCD, versionTRD, creationUserName, creationUser
FROM ##TemReferences |
| 2 | 6539166 | 3269583 | 60790 | 25132 | | SELECT TOP 1 COUNT(DISTINCT RH.CaseId) AS CaseCount, CS.SEG_ESTE AS 'Estado' FROM RequestFileHistories RH WITH (NOLOCK) INNER JOIN RequestFiles RF WITH (NOLOCK) ON RF.Id = RH.RequestFileId INNER JOIN OpheliaSuite.dbo.WF_SEGUI CS WITH (NOLOCK) ON CS.CAS_CONT = RH.CaseId WHERE RF.FileNumber = @additionalProp1 AND RH.ProcessCode = '615' AND ETA_CONT='3' GROUP BY CS.SEG_ESTE ORDER BY MAX(AUD_UFAC) desc |
| 97 | 4760435 | 49076 | 460228 | 122469 | | SELECT DISTINCT
RF.IdRadicado,
RF.Radicado,
RF.Fecha,
CN.[Name] AS 'Canal',
RF.[Tipo de persona],
TD.Name AS 'Tipo de identificación',
CL.NumberIdentification AS 'Número de identificación',
RF.Entidad,
RF.Destinatario AS 'Nombres y apellidos remitente',
CL.Id AS 'Id Cliente',
CT.Id AS 'Id Contacto',
RF.País,
RF.Departamento,
RF.Ciudad,
RF.Dirección,
RF.[Correo electrónico],
RF.Asunto,
RF.Folios,
RFD.Attachments AS 'Número de anexos',
RF.[Descripción de anexos],
RF.Compañía,
RF.Dependencia,
CONCAT(DP.NameSolicitud, ' / ', LTRIM(RTRIM(DP.NameDetalle)), IIF(ISNULL(DP.NameEspecificacion, '0') = '0', NULL, ' / '), DP.NameEspecificacion) AS 'Trámite',
RFD.UserName AS 'Usuario Radicador',
RF.FuncionarioResponsable 'Responsable',
'https://tinyurl.com/5e6yz5u9' AS QR
FROM GETDATABYRADICATE_VW RF
INNER JOIN REQUESTFILE_VW RFD ON RFD.Id = RF.IdRadicado
INNER JOIN CANAL_VW CN ON CN.Id = RFD.ChannelId
INNER JOIN CLIENTS_VW CL ON CL.Id = RFD.ClientId
INNER JOIN CONTACTS_VW CT ON CT.Id = RFD.ContactId
INNER JOIN TypeDetail TD ON TD.Id = CL.DocumentTypeId
INNER JOIN DMSProcedureNew_VW DP ON RFD.ProcedureId = DP.IdProcedure
WHERE RF.Radicado = @Radicado |
| 1 | 4430415 | 4430415 | 11870 | 10777 | DMS | MERGE RelatedRequestFiles AS TGT
USING #RADICADOSTEMP_ AS SRC
ON TGT.ParentId=SRC.RequestFileIdParent AND TGT.RequestFileId=SRC.RequestFileId
WHEN MATCHED THEN
UPDATE SET TGT.RequestFileId=SRC.RequestFileId
WHEN NOT MATCHED THEN
INSERT (ID,ParentId,RequestFileId) VALUES (NEWID(),SRC.RequestFileIdParent,SRC.RequestFileId); |
| 17 | 2582109 | 151888 | 35233 | 22710 | | UPDATE [w]
SET [w].[SEG_FATI] = @p,
[w].[SEG_FLIM] = @p4
FROM [WF_SEGUI] AS [w]
WHERE [w].[EMP_CODI] = @request_CompanyCode AND [w].[CAS_CONT] = @caseId AND [w].[FLU_CONT] = @request_ProcessCode AND [w].[SEG_ESTE] = N'P' |
| 6 | 2357934 | 392989 | 9534 | 2574 | | SELECT Radicado, [Fecha y Hora Radicacion], PROCESO AS 'Estado', [Tipo Comunicacion] FROM RadicacionVentUnica
WHERE PROCESO='Radicado de entrada'
AND RADICADO NOT IN (
'20260320552732',
'20260320635702'
)
AND [Tipo Comunicacion] = 'Entrada'
ORDER BY [Fecha y Hora Radicacion] ASC |
| 1 | 2321983 | 2321983 | 72537 | 57523 | DMS | SELECT DISTINCT RequestFiles.Id RequestFileId
,RequestFileIdParent
,CASE WHEN Status='914f4fcc-627c-49b0-8c67-75a21f826d31' THEN '1' --Finalizado
--WHEN Status='7AD94AE5-6D29-4EC0-B846-2664C88A7D45' THEN '2' --Getión y Tramite
--ELSE NULL END ResponseText
ELSE '2' END ResponseText --18/10/2024 Se realiza ajuste de acuerdo a los diferentes posibles status que puede tener un radicado, se valida con Julio
INTO #RADICADOSTEMP_
FROM RequestFiles
INNER JOIN
(
SELECT
RequestFileId RequestFileIdParent
--,REPLACE(RIGHT(RequestFileHistories.Reason, CHARINDEX(' ', REVERSE(RequestFileHistories.Reason)) - 1),'radicado','') AS reason
,CASE
WHEN CHARINDEX(' ', RequestFileHistories.Reason) > 0
THEN
REPLACE(
REVERSE(
SUBSTRING(
REVERSE(RequestFileHistories.Reason),
1,
CHARINDEX(' ', REVERSE(RequestFileHistories.Reason)) - 1
)
),
'radicado',
''
)
ELSE
REPLACE(RequestFileHistories.Reason, 'radicado', '')
END AS reason
,Status
FROM RequestFileHistories
INNER JOIN RequestFiles ON RequestFiles.ID=RequestFileHistories.RequestFileId AND OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7'
--AND CONVERT(DATE,RequestFileHistories.CreationDate) =CONVERT(DATE,GETDATE())
WHERE RequestFileHistories.Reason LIKE '%Se envía respuesta%' OR RequestFileHistories.Reason LIKE '%Se envió respuesta%' --and RequestFileId='D1D39553-523A-4B4F-87F0-BD80A20B6A6A'
--AND
--where
--RequestFiles.FileNumber='20231012303362'
--)RADICADOS ON RADICADOS.Reason=RequestFiles.FileNumber
--WHERE RequestFileId='B90E3FB9-304F-41C4-B124-251A6BC8B62F'
)RADICADOS ON RADICADOS.reason=RequestFiles.FileNumber |
| 52 | 2297172 | 44176 | 5000 | 78692 | DMS | SELECT
CAST(EX.Code AS VARCHAR(50)) AS 'Numero',
CAST(EX.NameReferencies AS VARCHAR(255)) AS 'Nombre',
CONVERT(VARCHAR(50), PrimerTomo.InitialDate, 120) AS 'FechaInicial',
CONVERT(VARCHAR(50), UltimoTomo.EndDate, 120) AS 'FechaFinal',
CAST(UltimoTomo.Tomo AS VARCHAR(10)) AS 'CantidadTomos'
FROM
DMS_References EX WITH (NOLOCK)
INNER JOIN Series S WITH (NOLOCK) ON S.Id = EX.SeriesId
LEFT JOIN Subseries SS WITH (NOLOCK) ON SS.Id = EX.SubseriesId
INNER JOIN Dependencies D WITH (NOLOCK) ON D.Id = EX.DependencyId
OUTER APPLY (
SELECT TOP 1
SU.InitialDate
FROM DMS_ReferencesSummary SU WITH (NOLOCK)
WHERE SU.ReferenceId = EX.Id
ORDER BY SU.Tomo ASC
) AS PrimerTomo
OUTER APPLY (
SELECT TOP 1
SU.EndDate,
SU.Tomo
FROM DMS_ReferencesSummary SU WITH (NOLOCK)
WHERE SU.ReferenceId = EX.Id
ORDER BY SU.Tomo DESC
) AS UltimoTomo
WHERE
EX.StateId = 'B2873D51-8C51-412C-8634-6ECC0FA12675'
AND (
(@TipoBusqueda = 1
AND D.Id = @Id_Dependencia_GUID
AND S.Id = @Serie_GUID
AND (
(@IsSubserieIdNull = 1 AND SS.Id IS NULL)
OR
(@IsSubserieIdNull = 0 AND SS.Id = @Subserie_GUID)
)
)
OR
(@TipoBusqueda = 2
AND CAST(D.Code AS VARCHAR(50)) = @CodigoDependencia
AND CAST(S.Code AS VARCHAR(50)) = @CodigoSerie_Normalized
-- NUEVAS CONDICIONES PARA @VersionTRD y @VersionCCD
--AND EX.VersionTRD = @VersionTRD -ESPERAR PARA HABILITAR DE ACUERDO AL REPORTE QUE SE PRESENTE
AND EX.VersionCCD = @VersionCCD
AND (
(@IsCodigoSubserieNull = 1 AND (SS.Code IS NULL OR CAST(SS.Code AS VARCHAR(50)) = ''))
OR
(@IsCodigoSubserieNull = 0 AND CAST(SS.Code AS VARCHAR(50)) = @CodigoSubserie_Normalized)
)
)
)
ORDER BY
EX.CreationDate DESC |
| 6 | 2238467 | 373077 | 12859 | 17385 | | SELECT
Radicado,
[Fecha y Hora Radicacion],
PROCESO AS 'Estado',
[Tipo Comunicacion],
[Medio de Recepcion]
FROM RadicacionVentUnica WITH (NOLOCK)
WHERE PROCESO = 'Radicado de entrada'
AND [Tipo Comunicacion] = 'PQRSD'
AND [Fecha y Hora Radicacion] <= DATEADD(HOUR, -2, GETDATE()) -- 2 o más horas atrás
AND [Medio de Recepcion] !='Ventanilla'
ORDER BY [Fecha y Hora Radicacion] ASC |
| 109 | 2160864 | 19824 | 2661 | 18241 | DMS | SELECT DISTINCT
D.Code,
D.Name,
D.VersionCCD
FROM
Dependencies D WITH (NOLOCK)
INNER JOIN
UsersCompany UC WITH (NOLOCK) ON UC.DependenceId = D.Id
INNER JOIN
Users U WITH (NOLOCK) ON U.Id = UC.UserId
INNER JOIN
Companies C WITH (NOLOCK) ON C.Id = D.CompaniesId
WHERE
(@UsuarioProductor IS NULL OR U.UserName = @UsuarioProductor)
AND UC.[State] IN ('57DC632C-79D5-458A-845B-76F4859F3E75', '91D59421-43A8-4D93-8C56-BA34F6B07673')
AND D.VersionCCD = @VersionCCD
AND D.VersionTRD = @VersionTRD
AND (@Company IS NULL OR C.Code = @Company)
ORDER BY
D.Name ASC |
| 1 | 1940936 | 1940936 | 18210 | 313185 | | select distinct RequestFiles . FileNumber Radicado , RequestFiles . Subject as [Asunto] , Dependencies . Name [Dependencia Actual] , CONCAT ( Users1 . Name , ' ' , Users1 . Surnames ) [Usuario Actual] , RequestFiles1 . Usuario [Usuario Rechaza] , ESTADO . Name [Proceso] , CANAL . Name [Medio Recepción] , ORIGEN . Name as [Tipo Comunicacion] , convert ( VARCHAR , RequestFiles . FiledDate , 23 ) [Fecha Radicación] , convert ( VARCHAR , RequestFileHistories . CreationDate , 23 ) [Fecha Creación] , RequestFiles . ExperationDate [Fecha Expiración] , coalesce ( case when MAX ( RequestFilesRespuestaDefinitiva . FileNumber ) over ( PARTITION by RequestFiles . FileNumber ) is not null then 'En Tiempo' end , case when MAX ( ESTADO . Name ) over ( PARTITION by RequestFiles . FileNumber ) in ( 'Finalizado' , 'Envío electrónico' , 'Comunicación pendiente por clasificar' , 'Comunicación Clasificada' , 'Pendiente en la dependencia' , 'Finalizado por Solicitud del Usuario' ) or RequestFiles . Subject like '%RESPUESTA RADICADO%' then 'En Tiempo' end , case when convert ( DATE , GETDATE ( ) ) < MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) and DATEDIFF ( DAY , convert ( DATE , GETDATE ( ) ) , MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) ) between 6 and 100000 then 'En Tiempo' end , case when DATEDIFF ( DAY , convert ( DATE , GETDATE ( ) ) , MAX ( convert ( DATE , RequestFiles . ExperationDate ) ) over ( PARTITION by RequestFiles . FileNumber ) ) between 0 and 5 then 'Proximo a Vencer' end , 'Vencido' ) [Estado Radicado] , ISNULL ( Rechazos . TotalRechazos , 0 ) as [Total Rechazos] from RequestFiles inner join ( select distinct RequestFiles . FileNumber , CONCAT ( Users1 . Name , ' ' , Users1 . Surnames ) Usuario from RequestFiles left join RequestFileHistories on RequestFileHistories . RequestFileId = RequestFiles . Id left join TypeDetail ESTADOGeneral on convert ( VARCHAR ( 50 ) , ESTADOGeneral . Id ) = RequestFileHistories . Status left join Users Users1 on Users1 . UserName = RequestFileHistories . UserName where ESTADOGeneral . Name = @0 and RequestFileHistories . CreationDate = ( select MAX ( AA . CreationDate ) from RequestFileHistories AA left join TypeDetail BB on convert ( VARCHAR ( 50 ) , BB . Id ) = AA . Status where AA . RequestFileId = RequestFileHistories . RequestFileId and BB . Name = @1 and AA . Status not in ( @2 , @3 , @4 ) ) ) RequestFiles1 on RequestFiles . FileNumber = RequestFiles1 . FileNumber left join ( select RF . FileNumber , COUNT ( * ) as TotalRechazos from RequestFiles RF inner join RequestFileHistories RFH on RFH . RequestFileId = RF . Id inner join TypeDetail TD on convert ( VARCHAR ( 50 ) , TD . Id ) = RFH . Status where TD . Name = @5 and RFH . Status not in ( @6 , @7 , @8 ) group by RF . FileNumber ) Rechazos on Rechazos . FileNumber = RequestFiles . FileNumber left join RequestFileHistories on RequestFileHistories . RequestFileId = RequestFiles . Id and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @9 , @10 , @11 ) ) left join TypeDetail ESTADO on convert ( VARCHAR ( 50 ) , ESTADO . Id ) = RequestFileHistories . Status left join DMS . DBO . TYPEORIGIN_VW ORIGEN on RequestFiles . OriginId = ORIGEN . Id left join Users Users1 on Users1 . UserName = RequestFileHistories . UserName left join dms . dbo . RelatedRequestFiles on RelatedRequestFiles . ParentId = RequestFiles . Id left join dms . dbo . RequestFiles RequestFilesRespuestaDefinitiva on RelatedRequestFiles . requestfileId = convert ( VARCHAR ( 40 ) , RequestFilesRespuestaDefinitiva . Id ) and RequestFilesRespuestaDefinitiva . FiledDate in ( select MAX ( AA . FiledDate ) from dms . dbo . RequestFiles AA inner join dms . dbo . RelatedRequestFiles BB on BB . RequestFileId = AA . Id inner join dms . dbo . RequestFiles CC on BB . ParentId = CC . Id where CC . FileNumber = RequestFiles . FileNumber and AA . RequestTypeId = @12 and AA . ResposnseText = @13 ) left join ( select Dependencies . Id , UserId , MIN ( Dependencies . Name ) over ( PARTITION by UserId ) Name , MIN ( case when ( Dependencies . Name ) = Dependencies . Name then Dependencies . Code end ) over ( PARTITION by UserId ) Code , TopSection , UsersCompany . State from DMS . DBO . Users inner join DMS . DBO . UsersCompany on Users . Id = UsersCompany . UserId inner join DMS . DBO . Dependencies on Dependencies . Id = UsersCompany . DependenceId inner join DMS . DBO . TypeDetail on UsersCompany . State = TypeDetail . Id and TypeDetail . Code = ( select MIN ( TypeDetail . Code ) from DMS . DBO . UsersCompany A inner join DMS . DBO . TypeDetail on A . State = TypeDetail . Id where UsersCompany . UserId = A . UserId group by A . UserId ) ) Dependencies on Users1 . Id = Dependencies . UserId left join dms . dbo . TypeDetail CANAL on CANAL . Id = RequestFiles . ChannelId where CANAL . Name in ( @14 , @15 , @16 ) and ESTADO . Name = @17 and CANAL . ID not in ( @18 ) and RequestFiles . FileNumber not in ( select A . FileNumber from RequestFiles A left join DMS_Procedures on A . ProcedureId = DMS_Procedures . Id left join dms . dbo . RequestFileHistories on RequestFileHistories . RequestFileId = A . Id left join dms . dbo . Users on Users . UserName = RequestFileHistories . UserName left join RelatedRequestFiles on RelatedRequestFiles . ParentId = A . Id left join RequestFiles RequestFiles2 on RequestFiles2 . Id = RelatedRequestFiles . RequestFileId left join dms . dbo . TypeDetail ESTADO on convert ( VARCHAR ( 40 ) , ESTADO . Id ) = RequestFileHistories . Status where A . FileNumber = RequestFiles . FileNumber and RequestFiles2 . FileNumber is not null and RequestFiles2 . ResposnseText = @19 ) and YEAR ( RequestFiles . FiledDate ) in ( @20 ) and MONTH ( RequestFiles . FiledDate ) in ( @21 , @22 , @23 , @24 , @25 , @26 ) |
| 99 | 1832822 | 18513 | 34725 | 44401 | | SELECT
D.NAME AS 'Dependencia'
, RF.FileNumber AS 'Radicado'
, RF.FiledDate AS 'Fecha'
, CONCAT(isnull(RF.Pages,0), 'F/', isnull(RF.Attachments,0), 'ADJ/', RF.ReceiverName, '/', RF.UserName) AS 'Concatenado'
FROM RequestFiles RF WITH(NOLOCK)
LEFT JOIN Dependencies D WITH(NOLOCK) ON D.ID=RF.DependencyId
WHERE RF.FileNumber=@fileNumber |
| 53 | 1777988 | 33546 | 16485 | 138032 | | SELECT [d].[Id], [d].[AvailabilityId], [d].[BoxId], [d].[CloseDate], [d].[CloseUser], [d].[Code], [d].[CompanyId], [d].[ConsultFrequencyId], [d].[CreationDate], [d].[CreationUser], [d].[CrossReference], [d].[DateVersion], [d].[DependencyId], [d].[Description], [d].[EndDate], [d].[ExternalId], [d].[Folios], [d].[IdStatusBeforeLocked], [d].[InUnificationProcess], [d].[InitialDate], [d].[InitialRetentionDate], [d].[InitialRetentionDateAC], [d].[Location], [d].[ModificateDate], [d].[NameReferencies], [d].[NoteScope], [d].[ParentId], [d].[PendingReorder], [d].[PrimaryValue], [d].[RetentionEndDate], [d].[RetentionEndDateAC], [d].[SecundaryValue], [d].[SeriesId], [d].[size], [d].[StateId], [d].[StateTransferId], [d].[SubseriesId], [d].[Support], [d].[Tomo], [d].[TopographicLocationDescription], [d].[TopographicLocationId], [d].[Version], [d].[VersionCCD], [d].[VersionTRD], [d].[VersionTVD], [d].[VolumeCount], [s].[Id], [s].[AccessClassificationId], [s].[Code], [s].[ConformationReferenceId], [s].[CoreArchiveStay], [s].[CreationDate], [s].[Description], [s].[DispositionDescription], [s].[DispositionTypeId], [s].[ElectronicSize], [s].[HasSubserie], [s].[ManagementArchiveStay], [s].[ModificateDate], [s].[ModificateUser], [s].[Name], [s].[PhysicalSize], [s].[PreservationTechTypeId], [s].[PreservationTypeId], [s].[Section], [s].[SerieStateId], [s].[TimeId], [s].[TimeMeasurenmentId], [s].[TopSectionId], [s].[Version], [s].[VersionCCD], [s].[VersionTRD], [s].[VersionTVD], [s0].[Id], [s0].[AccessClassificationId], [s0].[ClosingDate], [s0].[Code], [s0].[ConformationReferenceId], [s0].[CoreArchiveStay], [s0].[CreationDate], [s0].[Description], [s0].[DispositionDescription], [s0].[DispositionTypeId], [s0].[ElectronicSize], [s0].[ManagementArchiveStay], [s0].[ModificateDate], [s0].[ModificateUser], [s0].[Name], [s0].[PhysicalSize], [s0].[PreservationTechTypeId], [s0].[PreservationTypeId], [s0].[SerieId], [s0].[SubserieStateId], [s0].[TimeId], [s0].[TimeMeasurenmentId], [s0].[TopSection], [s0].[Version], [s0].[VersionCCD], [s0].[VersionTRD], [r].[Id], [r].[AccessClassificationId], [r].[Annexes], [r].[ArchivingUserId], [r].[Condition], [r].[DateDocument], [r].[DateIncorporation], [r].[DocumentConditionId], [r].[EndPage], [r].[ExternalFileNumber], [r].[FirstUseDate], [r].[Folios], [r].[Homepage], [r].[LastAccessDate], [r].[Name], [r].[Observation], [r].[Orden], [r].[ReferencesId], [r].[RequestFileId], [r].[size], [r].[SupportId], [r].[TypeDocumentId], [r].[UpdateDate], [r].[UrlLocation]
FROM [DMS_References] AS [d]
LEFT JOIN [Series] AS [s] ON [d].[SeriesId] = [s].[Id]
LEFT JOIN [Subseries] AS [s0] ON [d].[SubseriesId] = [s0].[Id]
LEFT JOIN [ReferencesRequestFile] AS [r] ON [d].[Id] = [r].[ReferencesId]
WHERE [d].[Code] = @__get_Item_Code_0
ORDER BY [d].[Id], [s].[Id], [s0].[Id], [r].[Id] |
| 31 | 1534994 | 49515 | 12473 | 76040 | | SELECT DISTINCT TOP 5 * FROM (SELECT S.CAS_CONT, C.CAS_DESC, S.SEG_FLIM, S.SEG_CONT, S.SEG_CONA, S.EMP_CODI, S.FLU_CONT, S.ETA_CONT, S.SEG_SUBJ, S.SEG_PRIO, S.SEG_FREC, S.SEG_HREC, S.SEG_DIAE, S.SEG_ESTC, S.SEG_ABRE, S.SEG_UORI, S.SEG_HLIM, S.SEG_UENC, S.SEG_COME, S.SEG_ESTE, F.FLU_VPLA, E.GAB_CONT, R.CAS_PADR, C.CAS_FECI FROM WF_SEGUI S INNER JOIN WF_CASOS C ON C.EMP_CODI=S.EMP_CODI AND C.CAS_CONT=S.CAS_CONT INNER JOIN WF_FLUJO F ON F.EMP_CODI=S.EMP_CODI AND F.FLU_CONT=S.FLU_CONT INNER JOIN WF_ETAPA E ON E.EMP_CODI=S.EMP_CODI AND E.FLU_CONT=S.FLU_CONT AND E.ETA_CONT=S.ETA_CONT LEFT JOIN WF_RCPRO R ON R.EMP_CODI=S.EMP_CODI AND R.CAS_HIJO=S.CAS_CONT WHERE S.SEG_ESTE = 'P' AND E.GAB_CONT IN (-20,-40, -2, -22 ) AND S.EMP_CODI=@pCompanyCode AND F.FLU_VPLA = @pVersion AND E.ETA_CRIA <> 'P' AND S.SEG_UENC=@pUserCode UNION ALL SELECT S.CAS_CONT, C.CAS_DESC, S.SEG_FLIM, S.SEG_CONT, S.SEG_CONA, S.EMP_CODI, S.FLU_CONT, S.ETA_CONT, S.SEG_SUBJ, S.SEG_PRIO, S.SEG_FREC, S.SEG_HREC, S.SEG_DIAE, S.SEG_ESTC, S.SEG_ABRE, S.SEG_UORI, S.SEG_HLIM, S.SEG_UENC, S.SEG_COME, S.SEG_ESTE, F.FLU_VPLA, E.GAB_CONT, R.CAS_PADR, C.CAS_FECI FROM WF_SEGUI S INNER JOIN WF_CASOS C ON C.EMP_CODI=S.EMP_CODI AND C.CAS_CONT=S.CAS_CONT INNER JOIN WF_FLUJO F ON F.EMP_CODI=S.EMP_CODI AND F.FLU_CONT=S.FLU_CONT INNER JOIN WF_ETAPA E ON E.EMP_CODI=S.EMP_CODI AND E.FLU_CONT=S.FLU_CONT AND E.ETA_CONT=S.ETA_CONT LEFT JOIN WF_RCPRO R ON R.EMP_CODI=S.EMP_CODI AND R.CAS_HIJO=S.CAS_CONT WHERE S.SEG_ESTE = 'P' AND E.GAB_CONT IN (-20,-40, -2, -22 ) AND S.EMP_CODI=@pCompanyCode AND S.SEG_UENC IN (SELECT WF_INTEG.USU_CODI FROM WF_APTOS,WF_INTEG WHERE WF_APTOS.EMP_CODI=WF_INTEG.EMP_CODI AND WF_APTOS.APT_DEST=WF_INTEG.ROL_CODI AND WF_APTOS.APT_TDES='R' AND WF_APTOS.EMP_CODI=S.EMP_CODI AND WF_APTOS.FLU_CONT=S.FLU_CONT AND WF_APTOS.ETA_CONT=S.ETA_CONT UNION ALL SELECT APT_DEST FROM WF_APTOS WHERE APT_TDES='U' AND EMP_CODI=S.EMP_CODI AND FLU_CONT=S.FLU_CONT AND ETA_CONT=S.ETA_CONT) AND E.ETA_CRIA = 'P') T ORDER BY T.CAS_FECI DESC, T.SEG_PRIO, T.EMP_CODI, T.FLU_CONT |
| 1 | 1460592 | 1460592 | 56493 | 81911 | | select WF . CAS_CONT , WF . SEG_SUBJ , WF . FLU_CONT , U . UserName from WF_SEGUI WF inner join DMS . DBO . Users U on U . UserName = WF . SEG_UENC where WF . SEG_ESTE = @0 and U . RolAgora = @1 and FLU_CONT not in ( @2 , @3 , @4 , @5 , @6 , @7 ) |
| 67 | 1303486 | 19455 | 11935 | 50630 | | SELECT DISTINCT TOP 5 * FROM (SELECT S.CAS_CONT, C.CAS_DESC, S.SEG_FLIM, S.SEG_CONT, S.SEG_CONA, S.EMP_CODI, S.FLU_CONT, S.ETA_CONT, S.SEG_SUBJ, S.SEG_PRIO, S.SEG_FREC, S.SEG_HREC, S.SEG_DIAE, S.SEG_ESTC, S.SEG_ABRE, S.SEG_UORI, S.SEG_HLIM, S.SEG_UENC, S.SEG_COME, S.SEG_ESTE, F.FLU_VPLA, E.GAB_CONT, R.CAS_PADR, C.CAS_FECI FROM WF_SEGUI S INNER JOIN WF_CASOS C ON C.EMP_CODI=S.EMP_CODI AND C.CAS_CONT=S.CAS_CONT INNER JOIN WF_FLUJO F ON F.EMP_CODI=S.EMP_CODI AND F.FLU_CONT=S.FLU_CONT INNER JOIN WF_ETAPA E ON E.EMP_CODI=S.EMP_CODI AND E.FLU_CONT=S.FLU_CONT AND E.ETA_CONT=S.ETA_CONT LEFT JOIN WF_RCPRO R ON R.EMP_CODI=S.EMP_CODI AND R.CAS_HIJO=S.CAS_CONT WHERE S.SEG_ESTE = 'P' AND E.GAB_CONT IN (-20,-40, -2, -22 ) AND S.EMP_CODI=@pCompanyCode AND F.FLU_VPLA = @pVersion AND E.ETA_CRIA <> 'P' AND S.SEG_UENC=@pUserCode UNION ALL SELECT S.CAS_CONT, C.CAS_DESC, S.SEG_FLIM, S.SEG_CONT, S.SEG_CONA, S.EMP_CODI, S.FLU_CONT, S.ETA_CONT, S.SEG_SUBJ, S.SEG_PRIO, S.SEG_FREC, S.SEG_HREC, S.SEG_DIAE, S.SEG_ESTC, S.SEG_ABRE, S.SEG_UORI, S.SEG_HLIM, S.SEG_UENC, S.SEG_COME, S.SEG_ESTE, F.FLU_VPLA, E.GAB_CONT, R.CAS_PADR, C.CAS_FECI FROM WF_SEGUI S INNER JOIN WF_CASOS C ON C.EMP_CODI=S.EMP_CODI AND C.CAS_CONT=S.CAS_CONT INNER JOIN WF_FLUJO F ON F.EMP_CODI=S.EMP_CODI AND F.FLU_CONT=S.FLU_CONT INNER JOIN WF_ETAPA E ON E.EMP_CODI=S.EMP_CODI AND E.FLU_CONT=S.FLU_CONT AND E.ETA_CONT=S.ETA_CONT LEFT JOIN WF_RCPRO R ON R.EMP_CODI=S.EMP_CODI AND R.CAS_HIJO=S.CAS_CONT WHERE S.SEG_ESTE = 'P' AND E.GAB_CONT IN (-20,-40, -2, -22 ) AND S.EMP_CODI=@pCompanyCode AND S.SEG_UENC IN (SELECT WF_INTEG.USU_CODI FROM WF_APTOS,WF_INTEG WHERE WF_APTOS.EMP_CODI=WF_INTEG.EMP_CODI AND WF_APTOS.APT_DEST=WF_INTEG.ROL_CODI AND WF_APTOS.APT_TDES='R' AND WF_APTOS.EMP_CODI=S.EMP_CODI AND WF_APTOS.FLU_CONT=S.FLU_CONT AND WF_APTOS.ETA_CONT=S.ETA_CONT UNION ALL SELECT APT_DEST FROM WF_APTOS WHERE APT_TDES='U' AND EMP_CODI=S.EMP_CODI AND FLU_CONT=S.FLU_CONT AND ETA_CONT=S.ETA_CONT) AND E.ETA_CRIA = 'P') T ORDER BY T.CAS_FECI DESC, T.SEG_PRIO, T.EMP_CODI, T.FLU_CONT |
| DatabaseName | SchemaName | TableName | StatisticName | LastUpdated | Rows | ModificationCounter | ModifiedPct |
|---|
| Stage | sys | sysrscols | _WA_Sys_00000003_00000003 | 1/15/2024 2:59:56 PM | 2079 | 2834133 | 136321.93 |
| Stage | sys | syscolpars | _WA_Sys_00000007_00000029 | 9/26/2024 10:24:36 AM | 1891 | 1482850 | 78416.18 |
| DMS_2 | sys | sysrscols | _WA_Sys_00000005_00000003 | 2/3/2023 12:45:16 PM | 2636 | 644782 | 24460.62 |
| DMS_2 | sys | sysrscols | _WA_Sys_00000002_00000003 | 2/3/2023 12:45:16 PM | 2636 | 644782 | 24460.62 |
| DMS_2 | sys | sysrscols | clst | 2/3/2023 12:45:16 PM | 2636 | 644782 | 24460.62 |
| DMS_BK_20 | sys | sysrscols | _WA_Sys_00000005_00000003 | 6/21/2023 4:03:31 PM | 3041 | 334572 | 11002.04 |
| DMS_BK_20 | sys | sysrscols | _WA_Sys_00000002_00000003 | 6/21/2023 4:03:31 PM | 3041 | 334572 | 11002.04 |
| DMS_BK_20 | sys | sysrscols | clst | 6/21/2023 4:03:31 PM | 3041 | 334572 | 11002.04 |
| Stage | sys | sysrscols | _WA_Sys_00000005_00000003 | 5/28/2025 9:59:29 AM | 2771 | 262376 | 9468.64 |
| Stage | sys | sysrscols | _WA_Sys_00000002_00000003 | 5/28/2025 9:59:29 AM | 2771 | 262375 | 9468.60 |
| Stage | sys | sysrscols | clst | 5/28/2025 9:59:29 AM | 2771 | 262375 | 9468.60 |
| DMS_2 | sys | sysidxstats | _WA_Sys_00000006_00000036 | 1/3/2023 11:26:45 AM | 1048 | 67260 | 6417.94 |
| DMS_2 | sys | sysiscols | _WA_Sys_00000007_00000037 | 10/13/2022 1:09:28 PM | 1131 | 71272 | 6301.68 |
| DMS_bk_040923 | sys | sysidxstats | _WA_Sys_00000006_00000036 | 4/25/2023 12:45:14 PM | 1156 | 63868 | 5524.91 |
| DMS_BK_20 | sys | sysidxstats | _WA_Sys_00000006_00000036 | 4/25/2023 12:45:14 PM | 1156 | 59898 | 5181.49 |
| DMS_BK_20 | sys | sysiscols | _WA_Sys_00000007_00000037 | 6/15/2023 9:27:37 AM | 1500 | 59280 | 3952.00 |
| DMS_bk_040923 | sys | sysrscols | _WA_Sys_00000005_00000003 | 8/30/2023 3:24:10 PM | 3272 | 111766 | 3415.83 |
| DMS_bk_040923 | sys | sysrscols | _WA_Sys_00000002_00000003 | 8/30/2023 3:24:10 PM | 3272 | 111766 | 3415.83 |
| DMS_bk_040923 | sys | sysrscols | clst | 8/30/2023 3:24:10 PM | 3272 | 111766 | 3415.83 |
| DMS_BK_20 | sys | sysidxstats | _WA_Sys_00000008_00000036 | 6/15/2023 9:27:36 AM | 1210 | 40352 | 3334.88 |
| DMS | sys | sysrscols | _WA_Sys_00000005_00000003 | 5/27/2025 4:24:37 PM | 4016 | 92889 | 2312.97 |
| DMS | sys | sysrscols | _WA_Sys_00000002_00000003 | 5/27/2025 4:24:37 PM | 4016 | 92888 | 2312.95 |
| DMS | sys | sysrscols | clst | 5/27/2025 4:24:37 PM | 4016 | 92888 | 2312.95 |
| DMS_bk_040923 | sys | sysiscols | _WA_Sys_00000007_00000037 | 9/1/2023 12:45:32 AM | 1668 | 23274 | 1395.32 |
| DMS_bk_040923 | sys | sysidxstats | _WA_Sys_00000008_00000036 | 9/1/2023 12:50:03 AM | 1262 | 11988 | 949.92 |
| Stage | sys | sysschobjs | _WA_Sys_0000000B_00000022 | 6/24/2025 9:13:37 AM | 2669 | 20299 | 760.55 |
| Stage | sys | sysschobjs | _WA_Sys_0000000A_00000022 | 6/24/2025 9:13:37 AM | 2669 | 10678 | 400.07 |
| Stage | sys | sysiscols | _WA_Sys_00000007_00000037 | 3/2/2026 10:04:26 AM | 1022 | 2413 | 236.11 |
| Stage | sys | sysschobjs | _WA_Sys_00000009_00000022 | 1/22/2026 9:13:35 AM | 2684 | 6058 | 225.71 |
| Stage | dbo | RequestFileHistories_Stage | _WA_Sys_00000002_2997B3A5 | 6/9/2026 12:59:00 AM | 3762002 | 7524584 | 200.02 |
| Stage | dbo | RequestFileHistories_Stage | PK__RequestF__3214EC07D95CCDCF | 6/9/2026 12:58:59 AM | 3762002 | 7524584 | 200.02 |
| Stage | dbo | RadicacionVentUnica | _WA_Sys_00000022_1A6B4A05 | 6/9/2026 12:58:59 AM | 1881001 | 3762292 | 200.02 |
| Stage | dbo | Users_Stage | _WA_Sys_00000004_7EB77741 | 6/9/2026 12:59:12 AM | 3616 | 7232 | 200.00 |
| Stage | dbo | Users_Stage | _WA_Sys_00000003_7EB77741 | 6/9/2026 12:59:12 AM | 3616 | 7232 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000006_641AF1A3 | 6/9/2026 12:59:12 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000017_641AF1A3 | 6/9/2026 12:59:12 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000013_641AF1A3 | 6/9/2026 12:59:12 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000018_641AF1A3 | 6/9/2026 12:59:12 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000031_641AF1A3 | 6/9/2026 12:59:12 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000032_641AF1A3 | 6/9/2026 12:59:12 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000008_641AF1A3 | 6/9/2026 12:59:12 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000030_641AF1A3 | 6/9/2026 12:59:11 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | PK_SmartSupervisionMom1 | 6/9/2026 12:59:11 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | VentanillaUnicaFinal | _WA_Sys_0000001C_436E2AEF | 6/9/2026 12:59:11 AM | 276593 | 553023 | 199.94 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_0000001B_394FC3D8 | 6/9/2026 12:59:10 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000037_394FC3D8 | 6/9/2026 12:59:10 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000038_394FC3D8 | 6/9/2026 12:59:09 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000036_394FC3D8 | 6/9/2026 12:59:09 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000019_394FC3D8 | 6/9/2026 12:59:09 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000011_394FC3D8 | 6/9/2026 12:59:09 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_0000001D_394FC3D8 | 6/9/2026 12:59:09 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_0000001E_394FC3D8 | 6/9/2026 12:59:09 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000003_394FC3D8 | 6/9/2026 12:59:08 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000034_394FC3D8 | 6/9/2026 12:59:08 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000035_394FC3D8 | 6/9/2026 12:59:08 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000009_394FC3D8 | 6/9/2026 12:59:08 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_0000000B_394FC3D8 | 6/9/2026 12:59:08 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000033_394FC3D8 | 6/9/2026 12:59:07 AM | 537362 | 1048962 | 195.21 |
| Stage | dbo | SmartSupervisionMom2 | PK__SmartSup__3214EC0733D5295D | 6/9/2026 12:59:07 AM | 537362 | 1048962 | 195.21 |
| DMS_bk_040923 | sys | syscolpars | _WA_Sys_00000009_00000029 | 4/22/2023 12:20:04 PM | 2769 | 4886 | 176.45 |
| DMS_bk_040923 | sys | syscolpars | _WA_Sys_00000008_00000029 | 4/22/2023 12:20:04 PM | 2769 | 4886 | 176.45 |
| DMS_BK_20 | sys | syscolpars | _WA_Sys_00000009_00000029 | 4/22/2023 12:20:04 PM | 2769 | 4135 | 149.33 |
| DMS_BK_20 | sys | syscolpars | _WA_Sys_00000008_00000029 | 4/22/2023 12:20:04 PM | 2769 | 4135 | 149.33 |
| OpheliaSuite | sys | sysrscols | clst | 3/21/2025 5:30:50 PM | 5479 | 6860 | 125.21 |
| OpheliaSuite | sys | sysrscols | _WA_Sys_00000002_00000003 | 3/21/2025 5:30:51 PM | 5479 | 6860 | 125.21 |
| OpheliaSuite | sys | sysrscols | _WA_Sys_00000005_00000003 | 3/21/2025 5:30:51 PM | 5479 | 6860 | 125.21 |
| DMS | sys | sysmultiobjrefs | _WA_Sys_00000006_0000004B | 9/23/2025 2:26:16 PM | 4044 | 4510 | 111.52 |
| DMS | sys | syscolpars | _WA_Sys_00000009_00000029 | 5/29/2025 10:16:23 AM | 4185 | 4286 | 102.41 |
| DMS | sys | syscolpars | _WA_Sys_00000008_00000029 | 5/29/2025 10:16:23 AM | 4185 | 4286 | 102.41 |
| DMS | sys | syscolpars | _WA_Sys_00000007_00000029 | 5/29/2025 10:16:22 AM | 4185 | 4286 | 102.41 |
| Stage | dbo | RequestFilesExpirationDate | _WA_Sys_00000002_2D27B809 | 6/9/2026 12:59:03 AM | 1882900 | 1881310 | 99.92 |
| DMS | dbo | RelatedRequestFiles | _WA_Sys_00000003_55DFB4D9 | 6/9/2026 3:07:52 AM | 590742 | 476465 | 80.66 |
| OpheliaSuite | sys | syscolpars | _WA_Sys_00000008_00000029 | 2/25/2020 8:54:10 AM | 4353 | 3289 | 75.56 |
| OpheliaSuite | sys | syscolpars | _WA_Sys_00000009_00000029 | 2/25/2020 8:54:10 AM | 4353 | 3289 | 75.56 |
| Stage | sys | syscolpars | _WA_Sys_0000000D_00000029 | 6/4/2026 11:48:45 AM | 2233 | 1372 | 61.44 |
| Stage | sys | syscolpars | _WA_Sys_0000000E_00000029 | 6/4/2026 11:48:44 AM | 2233 | 1372 | 61.44 |
| Stage | sys | syscolpars | _WA_Sys_0000000F_00000029 | 6/4/2026 11:48:45 AM | 2233 | 1372 | 61.44 |
| DMS_2 | sys | sysxprops | _WA_Sys_00000005_00000031 | 11/29/2022 9:05:44 PM | 1131 | 680 | 60.12 |
| AgoraSSB | sys | sysrscols | _WA_Sys_00000005_00000003 | 1/4/2024 5:06:30 PM | 1340 | 747 | 55.75 |
| AgoraSSB | sys | sysrscols | _WA_Sys_00000002_00000003 | 1/4/2024 5:06:30 PM | 1340 | 747 | 55.75 |
| AgoraSSB | sys | sysrscols | clst | 1/4/2024 5:06:30 PM | 1340 | 747 | 55.75 |
| DMS_2 | sys | sysidxstats | nc | 9/25/2023 11:29:49 PM | 1086 | 600 | 55.25 |
| DMS | sys | sysxprops | _WA_Sys_00000004_00000031 | 12/16/2022 3:34:50 PM | 1216 | 648 | 53.29 |
| DMS | sys | sysxprops | _WA_Sys_00000003_00000031 | 12/16/2022 3:34:50 PM | 1216 | 648 | 53.29 |
| DMS | sys | sysxprops | _WA_Sys_00000002_00000031 | 12/16/2022 3:34:51 PM | 1216 | 648 | 53.29 |
| DMS | sys | sysxprops | clust | 12/16/2022 3:34:50 PM | 1216 | 648 | 53.29 |
| DMS_BK_20 | sys | sysobjvalues | _WA_Sys_00000003_0000003C | 6/5/2026 3:35:34 AM | 1483 | 748 | 50.44 |
| DMS_BK_20 | sys | sysobjvalues | _WA_Sys_00000004_0000003C | 6/5/2026 3:35:34 AM | 1483 | 748 | 50.44 |
| DMS_BK_20 | sys | sysobjvalues | clst | 6/5/2026 3:35:34 AM | 1483 | 748 | 50.44 |
| DMS_BK_20 | sys | sysobjvalues | _WA_Sys_00000002_0000003C | 6/5/2026 3:35:34 AM | 1483 | 748 | 50.44 |
| OpheliaSuite | sys | syssingleobjrefs | clst | 9/26/2023 6:00:05 AM | 1642 | 811 | 49.39 |
| OpheliaSuite | sys | syssingleobjrefs | nc1 | 9/26/2023 6:00:05 AM | 1642 | 811 | 49.39 |
| OpheliaSuite | sys | syssingleobjrefs | _WA_Sys_00000001_0000004A | 9/26/2023 6:00:05 AM | 1642 | 811 | 49.39 |
| OpheliaSuite | sys | syssingleobjrefs | _WA_Sys_00000003_0000004A | 9/26/2023 6:00:05 AM | 1642 | 811 | 49.39 |
| DMS_bk_040923 | sys | sysobjvalues | _WA_Sys_00000005_0000003C | 6/5/2026 3:35:34 AM | 1539 | 759 | 49.32 |
| DMSGDEA | sys | syscolpars | _WA_Sys_0000000F_00000029 | 7/13/2023 9:11:09 AM | 1098 | 540 | 49.18 |
| DMSGDEA | sys | syscolpars | _WA_Sys_00000004_00000029 | 7/13/2023 9:18:17 AM | 1098 | 540 | 49.18 |
| DMS_2 | sys | syscolpars | _WA_Sys_00000009_00000029 | 1/18/2023 4:33:26 PM | 2686 | 1302 | 48.47 |
| DMS_2 | sys | syscolpars | _WA_Sys_00000008_00000029 | 1/18/2023 4:33:26 PM | 2686 | 1302 | 48.47 |
| DMS_2 | sys | syssingleobjrefs | _WA_Sys_00000003_0000004A | 9/17/2023 12:49:38 AM | 1585 | 712 | 44.92 |
| DatabaseName | SchemaName | TableName | UserSeeks | UserScans | AvgTotalUserCost | AvgUserImpact | EstimatedImpact | EqualityColumns | InequalityColumns | IncludedColumns |
|---|
| OpheliaSuite | dbo | WF_SEGUI | 10 | 0 | 4774.92 | 99.97 | 4773484.69 | [ETA_CONT] | | [SEG_ESTE], [AUD_UFAC] |
| Stage | dbo | RadicacionVentUnica | 7 | 0 | 242.85 | 99.67 | 169436.82 | [PROCESO], [Tipo Comunicacion] | [Radicado] | [Fecha y Hora Radicacion] |
| Stage | dbo | RadicacionVentUnica | 7 | 0 | 242.85 | 98.78 | 167923.86 | [PROCESO], [Tipo Comunicacion] | [Fecha y Hora Radicacion], [Medio de Recepcion] | [Radicado] |
| OpheliaSuite | dbo | WF_SEGUI | 1 | 0 | 1120.00 | 95.48 | 106937.14 | [SEG_UENC], [SEG_ESTE] | | [FLU_CONT], [SEG_SUBJ] |
| DMS | dbo | RequestFileHistories | 1 | 0 | 136.09 | 57.91 | 7881.02 | | [CreationDate] | [RequestFileId], [Reason], [Status] |
| Stage | dbo | pqrsdConsolidated | 1 | 0 | 58.52 | 98.89 | 5787.48 | [UsuarioFil] | [AñoFil], [MesFil] | [RADICADO], [FECHA_RADICADO], [HORA_RADICADO], [MEDIO_DE_RECEPCION], [TIPO_DE_PQR], [CAUSAL], [DETALLE_CAUSAL], [DETALLE_DESAGREGADO_CAUSAL], [NOMBRE_REMITENTE], [TIPO_DE_DOCUMENTO_REMITENTE], [DOCUMENTO_DE_REMITENTE], [DIRECCION_REMITENTE], [ASUNTO_RADICADO], [FUNCIONARIO_ACTUAL], [DEPENDENCIA_ACTUAL], [RADICADO_RESPUESTA_FINAL], [FECHA_DE_CONTESTACION], [ESTADO_ACTUAL], [TOTAL_DIAS_TRAMITE], [FECHA_DE_VENCIMIENTO], [MES/AÑO], [GESTION], [PROCESO], [FECHA_RESPUESTA_PARCIAL], [RADICADO_RESPUESTA_PARCIAL], [TIPO_DE_FRAUDE], [MODALIDAD_DE_FRAUDE], [MONTO_RECLAMADO], [MONTO_RECONOCIDO] |
| DMS | dbo | RequestFiles | 1 | 0 | 401.51 | 13.05 | 5239.77 | [UserName] | [FiledDate] | [FileNumber] |
| DMS | dbo | RequestFiles | 1 | 0 | 401.51 | 11.94 | 4794.08 | | [FileNumber], [FiledDate] | [UserName] |
| DMS | dbo | DMS_ReorderedDocuments | 1 | 0 | 19.36 | 99.77 | 1931.07 | [ReferenceRFId] | | [Tomo] |
| DMS | dbo | ReviewDocumentCertification | 28 | 0 | 1.84 | 33.33 | 1717.21 | | [State] | [IdDocumentCertification], [IdDetailManagePeaceAndSave], [TypeUserApproving] |
| DMS | dbo | DMS_Procedures | 77 | 0 | 1.57 | 13.68 | 1649.80 | [ProcessVersion], [ProcessType] | [ProceduresStateId] | [ResponseTime], [ResponsibleUserId], [DependenciesId], [ProcedureTypeId], [NameTypeId] |
| DMS | dbo | DMS_References | 1 | 0 | 54.97 | 16.16 | 888.29 | [SeriesId], [ParentId] | | [Code], [Description], [CreationDate], [DependencyId], [SubseriesId], [CompanyId], [NameReferencies], [CreationUser], [StateId], [CloseDate], [AvailabilityId], [Folios], [Tomo], [VersionCCD], [VersionTRD] |
| OpheliaSuite | dbo | WF_FETAP | 97 | 0 | 0.11 | 53.63 | 578.02 | [EMP_CODI], [PTL_CODI], [PTL_VERS] | | |
| DMS | dbo | Events | 1 | 0 | 14.41 | 39.85 | 574.07 | [Description] | | [MetadataModificate], [ReferencesId], [LoanUserId], [ReturnDate] |
| DMS | dbo | DMS_Procedures | 27 | 0 | 0.68 | 30.31 | 554.46 | [ProceduresStateId], [VisibleWeb] | | [ResponsibleUserId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId], [ProcessVersion], [IdTheme], [IdBussinnes] |
| DMS | dbo | DMS_Procedures | 27 | 0 | 0.68 | 26.85 | 491.17 | [VisibleWeb] | | [ResponsibleUserId], [ProceduresStateId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId], [ProcessVersion], [IdTheme], [IdBussinnes] |
| DMS | dbo | DMS_Procedures | 27 | 0 | 0.60 | 24.98 | 401.86 | [ProceduresStateId], [VisibleWeb] | [IdTheme] | [Name], [ResponsibleUserId], [ProcedureTypeId], [NameTypeId], [ProcessVersion], [IdBussinnes] |
| DMS | dbo | ClassificationHistories | 18 | 0 | 0.23 | 90.26 | 381.13 | [DependencyCode] | [SubserieCode] | [ClassificationHeadId], [SerieCode] |
| DMS | dbo | DMS_Procedures | 27 | 0 | 0.60 | 21.41 | 344.43 | [VisibleWeb] | [IdTheme] | [Name], [ResponsibleUserId], [ProceduresStateId], [ProcedureTypeId], [NameTypeId], [ProcessVersion], [IdBussinnes] |
| DMS | dbo | Subseries | 24 | 0 | 0.11 | 62.69 | 169.66 | [VersionTRD] | | [Code], [Name] |
| msdb | dbo | sysjobhistory | 11 | 0 | 0.81 | 15.07 | 133.90 | [step_id] | | [job_id] |
| msdb | dbo | backupset | 1 | 0 | 2.11 | 50.54 | 106.77 | | [backup_finish_date] | [media_set_id], [backup_start_date], [type], [backup_size], [is_copy_only], [compressed_backup_size], [encryptor_type] |
| tempdb | dbo | #B2DE28E7 | 20 | 0 | 0.05 | 65.41 | 68.09 | | [spid] | [hostname], [program_name], [cmd], [cpu], [physical_io], [dbid], [loginname], [last_batch_char] |
| msdb | dbo | sysjobactivity | 5 | 0 | 0.18 | 55.20 | 50.53 | [job_id] | | [next_scheduled_run_date] |
| DMS | dbo | DMS_Procedures | 2 | 0 | 0.82 | 25.43 | 41.65 | [ProceduresStateId], [ProcessVersion], [ProcessType] | | [ResponseTime], [ResponsibleUserId], [DependenciesId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId] |
| DMS | dbo | CertificationTracing | 1 | 0 | 0.21 | 64.01 | 13.25 | [IdDocumentCertification] | | [IdStateDocumentCertification], [IdCase] |
| DMS | dbo | DMS_References | 12 | 0 | 0.01 | 35.91 | 4.82 | [DependencyId], [SeriesId], [CompanyId], [NameReferencies], [StateId], [ParentId] | | |
| DMS | dbo | DocumentCertification | 1 | 0 | 0.21 | 18.64 | 3.86 | [SequentialNumber] | | |
No hay datos.
No hay datos.