No hay datos.
| Executions | CPUTimeMs | AvgCPUMs | ElapsedMs | LogicalReads | QueryText |
|---|
| 159 | 3616980 | 22748 | 1069654 | 128288043 | 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 |
| 2661 | 2359152 | 886 | 2651789 | 3108 | SELECT target_data
FROM sys.dm_xe_session_targets xet WITH(nolock)
JOIN sys.dm_xe_sessions xes WITH(nolock)
ON xes.address = xet.event_session_address
WHERE xes.name = 'telemetry_xevents'
AND xet.target_name = 'ring_buffer' |
| 11770 | 1387267 | 117 | 1670923 | 106789210 | 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] |
| 2676 | 1035039 | 386 | 1309158 | 1167630 | SELECT
CONVERT(uniqueidentifier, HASHBYTES('MD2', rankTable.[sql_handle])) as [qhash],
rankTable.[sql_handle] as [qhandle],
st.[text],
rankTable.[plan_count],
rankTable.[execution_count],
DATEADD(second, DATEDIFF(second, GETDATE(), GETUTCDATE()), rankTable.[last_execution_time]) AS [last_execution_time],
rankTable.[avg_worker_time],
rankTable.[last_worker_time],
rankTable.[avg_physical_reads],
rankTable.[avg_logical_reads],
rankTable.[avg_logical_writes],
rankTable.[avg_elapsed_time],
rankTable.[last_elapsed_time],
s.[session_id],
s.[login_name],
s.[host_name],
s.[host_process_id],
rankTable.[dbid],
rankTable.[dbname]
FROM (
SELECT
innerTable.*,
[plan].[dbid],
[plan].[dbname],
ROW_NUMBER() OVER (PARTITION BY [plan].[dbid] ORDER BY [avg_worker_time] DESC) AS [_rank_db_worker_time],
ROW_NUMBER() OVER (PARTITION BY [plan].[dbid] ORDER BY [avg_logical_reads] DESC) AS [_rank_db_logical_reads],
ROW_NUMBER() OVER (PARTITION BY [plan].[dbid] ORDER BY [avg_logical_writes] DESC) AS [_rank_db_logical_writes],
ROW_NUMBER() OVER (ORDER BY [avg_physical_reads] DESC) AS [_rank_physical_reads],
ROW_NUMBER() OVER (ORDER BY [avg_elapsed_time] DESC) AS [_rank_elapsed_time]
FROM (
SELECT
qs.[sql_handle],
SUM(qs_plan.[plan_count]) as [plan_count],
SUM(qs.[execution_count]) as [execution_count],
MAX(qs.[last_execution_time]) as [last_execution_time],
SUM(qs.[total_worker_time]) / SUM(qs.execution_count) / 1000 as [avg_worker_time],
AVG(qs.[last_worker_time]) / 1000 as [last_worker_time],
SUM(qs.[total_physical_reads]) / SUM(qs.execution_count) as [avg_physical_reads],
SUM(qs.[total_logical_reads]) / SUM(qs.execution_count) as [avg_logical_reads],
SUM(qs.[total_logical_writes]) / SUM(qs.execution_count) as [avg_logical_writes],
SUM(qs.[total_elapsed_time]) / SUM(qs.execution_count) / 1000 as [avg_elapsed_time],
AVG(qs.[last_elapsed_time]) / 1000 as [last_elapsed_time],
MAX ([plan_handle]) as [plan_handle]
FROM sys.dm_exec_query_stats AS qs
LEFT JOIN (
SELECT
COUNT(DISTINCT [plan_handle]) as [plan_count],
[query_hash],
[query_plan_hash]
FROM sys.dm_exec_query_stats
GROUP BY [query_hash], [query_plan_hash]
) as [qs_plan]
ON qs_plan.[query_hash] = qs.[query_hash]
AND qs_plan.[query_plan_hash] = qs.[query_plan_hash]
WHERE [total_worker_time] > 0
AND [last_execution_time] > DATEADD(SECOND,-5 * 300,GETDATE())
GROUP BY qs.[sql_handle]
) AS [innerTable]
OUTER APPLY (
SELECT
value AS [dbid],
DB_NAME(CONVERT(int, value)) as [dbname]
FROM sys.dm_exec_plan_attributes(innerTable.plan_handle)
WHERE [attribute] = 'dbid'
) AS [plan]
) AS [rankTable]
CROSS APPLY sys.dm_exec_sql_text(rankTable.[sql_handle]) st
LEFT JOIN sys.dm_exec_requests r
ON rankTable.[sql_handle] = r.[sql_handle]
LEFT JOIN sys.dm_exec_sessions s
ON s.[session_id] = r.[session_id]
WHERE
rankTable.[dbname] NOT IN ('')
AND (
[_rank_db_worker_time] <= 10
OR [_rank_db_logical_reads] <= 10
OR [_rank_db_logical_writes] <= 10
OR [_rank_physical_reads] <= 10
OR [_rank_elapsed_time] <= 10
) |
| 580 | 729866 | 1258 | 1045587 | 26040729 | WITH FilteredTables AS (
SELECT
object_id
FROM sys.tables
WHERE object_id > 0
)
INSERT INTO #IndexStats
SELECT
stats.database_id,
stats.object_id,
stats.index_id,
stats.partition_number,
AVG(stats.avg_fragmentation_in_percent) AS avg_fragmentation_in_percent,
SUM(stats.page_count) * 8 AS IndexSizeKb
FROM FilteredTables AS t
INNER JOIN sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'LIMITED') AS stats ON stats.object_id = t.object_id
GROUP BY stats.database_id, stats.object_id, stats.index_id, stats.partition_number
HAVING SUM(stats.page_count) * 8 >= 1024 |
| 1 | 531708 | 531708 | 319826 | 37380886 | INSERT INTO dbo.SmartSupervisionMom2
SELECT
RequestFiles.Id AS RequestFilesId
,RequestFiles.FileNumber AS [RADICADO FIDUGESTOR] -- Número de radicado
,CAST(CAST(RequestFiles.FiledDate AS DATE) AS VARCHAR) AS [FECHA DE RADICACION] -- Fecha de radicación
,FORMAT(RequestFiles.FiledDate, 'h:mm tt') AS [HORA_RADICACION] -- Hora de radicación en formato AM/PM
,CONCAT(DATENAME(MONTH, RequestFiles.FiledDate),' - ',YEAR(RequestFiles.FiledDate)) AS [MES/AÑO] -- Mes y año en español
--Tipo de PQR extraído del motivo de reclasificación o tomado por defecto
,COALESCE(
SUBSTRING(
RequestFileHistoriesReclas.Reason,
CHARINDEX('Se reclasificó el tipo de PQRSD así: de', RequestFileHistoriesReclas.Reason) + LEN('Se reclasificó el tipo de PQRSD así: de'),
CHARINDEX(' a ', RequestFileHistoriesReclas.Reason) - CHARINDEX('Se reclasificó el tipo de PQRSD así: de', RequestFileHistoriesReclas.Reason) - LEN('Se reclasificó el tipo de PQRSD así: de')
),
PqrsType.Name
) AS [TIPO_DE_PQR]
--Clasificaciones, canal, motivos, tipo y detalle de solicitud
,producto.Name AS [CLASIFICACION SFC PRODUCTO]
,canalpqr.Name AS [CANAL]
,Motivo.Name AS [MACROMOTIVO]
,NameType.Name AS [TIPO DE SOLICITUD]
,ProcedureType.Name AS [DETALLE DE LA SOLICITUD]
,SpecificationType.Name AS [ESPECIFICACIÓN DE LA SOLICITUD]
-- Información relacionada con la transmisión a la SFC
,CONCAT(512,RequestFiles.FileNumber) AS [RADICADO SFC FIDUGESTOR]
,CAST(CAST(RequestFiles.FiledDate AS DATE) AS VARCHAR) AS [FECHA DEL ENVIO A SFC]
,'Recibida' AS [ESTADO SFC MOMENTO 2]
,CASE
WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN 'Enviada'
ELSE 'No Enviada'
END AS [ESTADO DE LA TRASMISION]
,CASE
WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN CAST(CAST(smartprocesslog.RegistrationDate AS DATE) AS VARCHAR)
END AS [FECHA DE TRASMISION]
,CASE
WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN 'N/A'
ELSE CAST(smartprocesslog.Observations AS NVARCHAR(MAX))
END AS [TIPO DE ERROR]
-- Información de funcionarios y dependencias que gestionan y responden
,CONCAT(Users1.Name,' ', Users1.Surnames ) [FUNCIONARIO QUE GESTIONA]
,Dependencies1.Name [DEPENDENCIA QUE GESTIONA]
,CAST(CAST(RequestFileHistories1.CreationDate AS DATE) AS VARCHAR) AS [FECHA DE LA GESTION]
,CASE
WHEN CONCAT(UsersFinalizador.Name,' ', UsersFinalizador.Surnames ) <>'' THEN CONCAT(UsersFinalizador.Name,' ', UsersFinalizador.Surnames )
ELSE CONCAT(Users.Name,' ', Users.Surnames )
END AS [FUNCIONARIO QUE RESPONDE]
,Dependencies.Name AS [DEPENDENCIA QUE RESPONDE]
-- Información sobre respuestas parciales o definitivas
,CASE
WHEN MAX(RequestFilesRespuestaParcial.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL AND
MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER(PARTITION BY RequestFiles.FileNumber) IS NULL THEN 'Respuesta Parcial'
WHEN MAX(RequestFilesRespuestaDefinitiva.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL THEN 'Respuesta Definitiva'
END AS [TIPO DE RESPUESTA]
,MAX(ISNULL(RequestFilesRespuestaDefinitiva.FileNumber,RequestFilesRespuestaParcial.FileNumber)) OVER(PARTITION BY RequestFiles.FileNumber) AS [RADICADO DE RESPUESTA (MOMENTO 3)]
,MAX(CONVERT(VARCHAR,CONVERT(DATE,ISNULL(RequestFilesRespuestaDefinitiva.FiledDate, RequestFilesRespuestaParcial.FiledDate)))) OVER(PARTITION BY RequestFiles.FileNumber) AS [FECHA DE RESPUESTA]
,MAX(RIGHT(CONVERT(DATETIME, ISNULL(RequestFilesRespuestaDefinitiva.FiledDate,RequestFilesRespuestaParcial.FiledDate), 108),8)) OVER(PARTITION BY RequestFiles.FileNumber) AS [HORA DE RESPUESTA]
-- Estado de envío al momento 3
,CASE
WHEN MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Enviada'
ELSE 'No Enviada'
END AS [SE ENVIO MOMENTO 3]
,CASE
WHEN MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'N/A'
WHEN smartprocesslogMom3.RegistrationDate IS NULL THEN 'No ha sido Enviada'
ELSE CAST(smartprocesslogMom3.Observations AS VARCHAR(8000))
END AS [TIPO DE ERROR MOMENTO 3]
,CAST(CAST(smartprocesslogMom3.RegistrationDate AS DATE) AS VARCHAR) AS [FECHA DE TRASMISION MOMENTO 3]
-- Estado final de la solicitud
,CASE
WHEN MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL AND
MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Cerrado'
WHEN smartprocesslog.Id IS NOT NULL AND
MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Recibida'
ELSE 'Abierto'
END AS [ESTADO ACTUAL MOMENTO 3]
-- Información adicional de reclasificación y seguimiento
,CASE WHEN RequestFileHistoriesReclas.Id IS NOT NULL THEN 'Si' ELSE 'No' END AS [EL RADICADO TUVO RECLASIFICACION]
,RequestFileHistoriesReclas.Reason AS [TIPO DE PQRS ANTES DE RECLASIFICAR]
,PqrsType.Name AS [TIPO DE PQRS DESPUES DE RECLASIFICAR]
,Admision.Name AS [ADMISION]
,SmartAddicionalRequestFiles.ComingFromProcedure AS [PROCEDENTE]
,Favorabilidad.Name AS [FAVORABILIDAD]
,SmartAddicionalRequestFiles.FavorConsumerProcedure AS [A FAVOR DE]
,CASE WHEN SmartAddicionalRequestFiles.RefusedEntityProcedure='1' THEN 'Si' ELSE 'No' END AS [INADMITIDA O RECHAZADA POR LA ENTIDAD]
,SmartAddicionalRequestFiles.SuperFRemittedProcedure AS [TRASLADO A LA SUPERINTENDENCIA]
,AFavorDe.Name AS [ACEPTACION]
,Rectificacion.Name AS [RECTIFICACION]
,Desistimiento.Name AS [DESISTIMIENTO]
,clients.NumberIdentification AS [REMITENTE]
,CASE WHEN Clients.AffiliatedFomag='1' THEN 'Si' ELSE 'No' END AS [AFILIADO AL FOMAG]
,AffiliateType.Code AS [TIPO DE AFILIADO]
,RequestFiles.Subject AS [ASUNTO]
,CASE
WHEN Clients.OriginRegistry='SmartSupervision' AND RequestFiles.ReportedSmart='1' THEN 'Si'
WHEN Clients.OriginRegistry NOT IN ('SmartSupervision') THEN 'No'
END AS [ACTUALIZO MOMENTO 4]
,CASE WHEN RequestFiles.ReportedSmart='1' THEN CONVERT(VARCHAR,CONVERT(DATE,Clients.ModificationDate)) END AS [FECHA ACTUALIZACION]
-- Campos auxiliares para filtrado por año y mes
,CAST(YEAR(RequestFiles.FiledDate) AS int) AS AñoFil
,MONTH(RequestFiles.FiledDate) AS MesFil
,ISNULL(Dependencies.code,0) AS DependeciaFil
-- Add campos Circular 19
,Circular19.[TIPO DE FRAUDE] AS [TIPO DE FRAUDE]
,Circular19.[MODALIDAD DE FRAUDE] AS [MODALIDAD DE FRAUDE]
,Circular19.[MONTO RECLAMADO] AS [MONTO RECLAMADO]
,Circular19.[MONTO RECONOCIDO] AS [MONTO RECONOCIDO]
-- Tabla principal de radicados
FROM DMS.DBO.RequestFiles
-- Unión para identificar el último usuario que gestionó el radicado
LEFT JOIN (
SELECT
RequestFileHistories.UserName,
RequestFileHistories.RequestFileId,
RequestFileHistories.Status,
RequestFileHistories.processcode,
ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS rn
FROM DMS.DBO.RequestFileHistories
WHERE Status NOT IN (--Se agregan los siguientes estados por caso SAC 960781
'4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425'
,'8d6acd5a-d128-45b0-b1a5-f9c0fef90708','EF7B7E43-9151-422A-9A2C-6E3B6C53BC85')
AND ProcessCode !='615'
) RequestFileHistories
ON RequestFileHistories.RequestFileId = RequestFiles.Id
AND RequestFileHistories.rn = 1
-- Unión con la información del cliente
LEFT JOIN DMS.DBO.clients
ON clients.Id = RequestFiles.clientid
-- Unión para obtener el último registro del Momento 2 con subproceso REPORTE_QUEJA
LEFT JOIN (
SELECT
smartprocesslog.Id,
smartprocesslog.Status,
smartprocesslog.FileNumber,
smartprocesslog.RegistrationDate,
smartprocesslog.Observations,
smartprocesslog.ClientDocumentNumber,
ROW_NUMBER() OVER (PARTITION BY FileNumber, ClientDocumentNumber ORDER BY RegistrationDate DESC) AS rn
FROM DMS.DBO.smartprocesslog
WHERE Process = 'MOMENTO_2' AND SubProcess = 'REPORTE_QUEJA'
--AND smartprocesslog.FileNumber = '20241011326782'
) smartprocesslog
ON smartprocesslog.FileNumber = RequestFiles.FileNumber
AND smartprocesslog.ClientDocumentNumber = Clients.NumberIdentification
AND smartprocesslog.rn = 1
-- Unión para obtener el último registro del Momento 3 con subproceso REPORTE_QUEJA
LEFT JOIN (
SELECT
smartprocesslog.Id,
smartprocesslog.FileNumber,
smartprocesslog.ClientDocumentNumber,
smartprocesslog.RegistrationDate,
smartprocesslog.Status,
smartprocesslog.Observations,
ROW_NUMBER() OVER (
PARTITION BY FileNumber
ORDER BY
-- Prioriza los EXITOSO más recientes, luego cualquier otro estado
CASE WHEN Status = 'EXITOSO' THEN 1 ELSE 2 END,
RegistrationDate DESC
) AS rn
FROM DMS.DBO.smartprocesslog
WHERE Process = 'MOMENTO_3'
AND SubProcess = 'REPORTE_QUEJA'
AND Status IN ('EXITOSO', 'FINALIZADO', 'FALLIDO')
) smartprocesslogMom3
ON smartprocesslogMom3.FileNumber = RequestFiles.FileNumber
--AND smartprocesslogMom3.Id = (
-- SELECT TOP 1 AA.Id
-- FROM DMS.DBO.smartprocesslog AA
-- WHERE AA.FileNumber = smartprocesslogMom3.FileNumber
-- AND AA.Process = 'MOMENTO_3'
-- AND AA.SubProcess = 'REPORTE_QUEJA'
-- ORDER BY AA.RegistrationDate DESC
--)
AND smartprocesslogMom3.rn = 1
-- Historial más antiguo con dependencia asignada
LEFT JOIN (
SELECT
RequestFileHistories.RequestFileId,
RequestFileHistories.CreationDate,
RequestFileHistories.UserName,
RequestFileHistories.ProcessCode,
ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate ASC) AS rn
FROM DMS.DBO.RequestFileHistories
WHERE DependencyId IS NOT NULL
AND ProcessCode !='615'
--AND RequestFileId ='FCF1BB64-614E-4D69-9E4A-D8BED126A1DC'
) RequestFileHistories1
ON RequestFileHistories1.RequestFileId = RequestFiles.Id
AND RequestFileHistories1.rn = 1
-- Último historial con estado 'Finalizado'
LEFT JOIN (
SELECT
AAA.RequestFileId,
AAA.CreationDate,
AAA.UserName,
ROW_NUMBER() OVER (PARTITION BY AAA.RequestFileId ORDER BY AAA.CreationDate DESC) AS rn
FROM DMS.DBO.RequestFileHistories AAA
INNER JOIN DMS.DBO.TYPESTATEREQUEST_VW BBB
ON CONVERT(VARCHAR(40), AAA.Status) = CONVERT(VARCHAR(40), BBB.Id)
WHERE BBB.Name = 'Finalizado'
) RequestFileHistoriesUsuarioFinalizador
ON RequestFileHistoriesUsuarioFinalizador.RequestFileId = RequestFiles.Id
AND RequestFileHistoriesUsuarioFinalizador.rn = 1
-- Usuario que finalizó el radicado
LEFT JOIN DMS.DBO.Users UsersFinalizador
ON UsersFinalizador.UserName = RequestFileHistoriesUsuarioFinalizador.UserName
-- Historial de reclasificación
LEFT JOIN (SELECT
RequestFileHistories.Id,
RequestFileHistories.RequestFileId,
RequestFileHistories.Reason,
ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS rn
FROM DMS.DBO.RequestFileHistories
WHERE RequestFileHistories.Status = '31b6159d-de9d-4cba-9508-4d9d4ee2faf7'
) AS RequestFileHistoriesReclas
ON RequestFileHistoriesReclas.RequestFileId = RequestFiles.Id
AND RequestFileHistoriesReclas.rn = 1
-- Usuario que respondió
LEFT JOIN DMS.DBO.Users Users
ON Users.UserName = RequestFileHistories.UserName
-- Usuario asociado al historial más antiguo con dependencia
LEFT JOIN DMS.DBO.Users Users1
ON Users1.UserName = RequestFileHistories1.UserName
-- Información adicional del radicado (producto, canal, motivo, etc.)
LEFT JOIN DMS.DBO.SmartAddicionalRequestFiles
ON SmartAddicionalRequestFiles.RequestFilesId = RequestFiles.Id
LEFT JOIN DMS.DBO.TypeDetail producto
ON producto.Id = SmartAddicionalRequestFiles.ProductCode
LEFT JOIN DMS.DBO.TypeDetail canalpqr
ON canalpqr.Id = SmartAddicionalRequestFiles.Channel
LEFT JOIN DMS.DBO.TypeDetail Motivo
ON Motivo.Id = SmartAddicionalRequestFiles.MacroReasonCode
LEFT JOIN DMS.DBO.TypeDetail Admision
ON Admision.Id = SmartAddicionalRequestFiles.Admission
LEFT JOIN DMS.DBO.TypeDetail Favorabilidad
ON Favorabilidad.Id = SmartAddicionalRequestFiles.Favorability
LEFT JOIN DMS.DBO.TypeDetail AFavorDe
ON AFavorDe.Id = SmartAddicionalRequestFiles.Acceptance
LEFT JOIN DMS.DBO.TypeDetail Rectificacion
ON Rectificacion.Id = SmartAddicionalRequestFiles.Rectification
LEFT JOIN DMS.DBO.TypeDetail Desistimiento
ON Desistimiento.Id = SmartAddicionalRequestFiles.ComplaintWithdrawal
-- Tipo de afiliado del cliente
LEFT JOIN DMS.DBO.TYPEAFFILIATE_VW AffiliateType
ON Clients.AffiliateTypeId = CONVERT(VARCHAR(40), AffiliateType.Id)
-- Procedimiento asociado al radicado
LEFT JOIN DMS.DBO.DMS_Procedures
ON DMS_Procedures.Id = RequestFiles.ProcedureId
LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType
ON NameType.Id = DMS_Procedures.NameTypeId
LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType
ON ProcedureType.Id = DMS_Procedures.ProcedureTypeId
LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType
ON SpecificationType.Id = DMS_Procedures.SpecificationTypeId
-- Tipo PQRSD del radicado
LEFT JOIN DMS.dbo.PQRSDType PqrsType
ON PqrsType.Id = RequestFiles.PqrsTypeId
-- Verifica si tiene respuesta parcial
LEFT JOIN (
SELECT
CC.Id,
AA.FiledDate,
AA.FileNumber,
AA.ChannelId,
ROW_NUMBER() OVER (PARTITION BY BB.ParentId ORDER BY AA.FiledDate DESC) AS RN
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
AA.RequestTypeId = '956FE4FE-E0C0-4F50-B742-DB431F9F536B'
AND AA.ResposnseText = 2
) RequestFilesRespuestaParcial
ON RequestFiles.Id = RequestFilesRespuestaParcial.Id
AND RequestFilesRespuestaParcial.RN = '1'
-- Verifica si tiene respuesta definitiva
LEFT JOIN (
SELECT
CC.Id,
AA.FiledDate,
AA.FileNumber,
AA.ChannelId,
ROW_NUMBER() OVER (PARTITION BY BB.ParentId ORDER BY AA.FiledDate DESC) AS RN
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
AA.RequestTypeId = '956FE4FE-E0C0-4F50-B742-DB431F9F536B'
AND AA.ResposnseText = 1
) RequestFilesRespuestaDefinitiva
ON RequestFiles.Id = RequestFilesRespuestaDefinitiva.Id
AND RequestFilesRespuestaDefinitiva.RN = '1'
--Dependencia del usuario finalizador o de quien respondió
LEFT JOIN (
SELECT *
FROM (
SELECT
UsersCompany.UserId,
Dependencies.Id AS DependencyId,
Dependencies.Name,
Dependencies.Code,
Dependencies.TopSection,
UsersCompany.State,
ROW_NUMBER() OVER (PARTITION BY UsersCompany.UserId ORDER BY TypeDetail.Code ASC) AS rn
FROM DMS.DBO.UsersCompany
INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id = UsersCompany.DependenceId
INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State = TypeDetail.Id
) RankedDependencies
WHERE rn = 1
) Dependencies
ON ISNULL(UsersFinalizador.id, Users.id) = Dependencies.UserId
--Consulta adiciona los campos de la actualización circular 19
LEFT JOIN (
SELECT
RequestFilesId,
FraudTypeName.Name AS [Tipo de Fraude],
FraudModalityName.Name AS [Modalidad de Fraude],
FORMAT(ISNULL(ClaimedAmount, 0), 'N0', 'es-CO') AS [Monto Reclamado],
FORMAT(ISNULL(RecognizedAmount, 0), 'N0', 'es-CO') AS [Monto Reconocido]
FROM DMS.dbo.SmartAddicionalRequestFiles
LEFT JOIN DMS.dbo.TypeDetail AS FraudTypeName
ON SmartAddicionalRequestFiles.FraudType = FraudTypeName.Id
AND FraudTypeName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB754'
LEFT JOIN DMS.dbo.TypeDetail AS FraudModalityName
ON SmartAddicionalRequestFiles.FraudModality = FraudModalityName.Id
AND FraudModalityName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB758') AS Circular19 ON RequestFiles.Id = Circular19.RequestFilesId
-- Dependencia asociada al primer usuario con historial
LEFT JOIN (
SELECT *
FROM (
SELECT
UsersCompany.UserId,
Dependencies.Id AS DependencyId,
Dependencies.Name,
Dependencies.Code,
Dependencies.TopSection,
UsersCompany.State,
ROW_NUMBER() OVER (PARTITION BY UsersCompany.UserId ORDER BY TypeDetail.Code ASC) AS rn
FROM DMS.DBO.UsersCompany
INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id = UsersCompany.DependenceId
INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State = TypeDetail.Id
) RankedDependencies
WHERE rn = 1
) Dependencies1
ON Users1.Id = Dependencies1.UserId
-- Filtros principales
WHERE
RequestFiles.OriginId = '2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' -- Origen de radicados
AND RequestFiles.StatusId <> 'E6D67E4A-F545-4D62-B882-5A38A0FC35E2' -- Excluir anulados
AND RequestFileHistories.Status NOT IN ('4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425')
AND RequestFiles.PqrsTypeId NOT IN (
'B48BF430-F3F7-4431-A375-3B9DBC1441E4', -- QuejEx
'496B613B-8905-4496-A201-5AF1235DA91C' -- QejSFC
)
AND RequestFileHistories.ProcessCode !='615' |
| 11770 | 503947 | 42 | 605247 | 12758680 | SELECT COUNT(*)
FROM [ReassignmentTask] AS [r]
WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0 |
| 13401 | 327416 | 24 | 503671 | 36211 | SELECT RTRIM(object_name) AS object_name,
RTRIM(counter_name) AS counter_name,
RTRIM(instance_name) AS instance_name,
RTRIM(cntr_value) AS cntr_value
FROM sys.dm_os_performance_counters
UNION SELECT @SQLNAME AS object_name,
'Version' AS counter_name,
@@version AS instance_name,
CAST(0 as bigint) AS cntr_value
UNION SELECT @SQLNAME AS object_name,
'Uptime' AS counter_name,
'' AS instance_name,
CAST(DATEDIFF(second, sqlserver_start_time, GETDATE()) as bigint) AS cntr_value
FROM sys.dm_os_sys_info
UNION SELECT @SQLNAME + ':Databases' AS object_name,
'State' AS counter_name,
name AS instance_name,
state AS cntr_value
FROM sys.databases
UNION SELECT a.object_name,
'BufferCacheHitRatio' AS counter_name,
'' AS instance_name,
cast(a.cntr_value * ISNULL((100.0 / NULLIF(b.cntr_value,0)),0) AS dec(3, 0)) AS cntr_value
FROM sys.dm_os_performance_counters a
JOIN (
SELECT cntr_value,
OBJECT_NAME
FROM sys.dm_os_performance_counters
WHERE counter_name = 'Buffer cache hit ratio base'
AND OBJECT_NAME = @SQLNAME + ':Buffer Manager'
) b
ON a.OBJECT_NAME = b.OBJECT_NAME
WHERE a.counter_name = 'Buffer cache hit ratio'
AND a.OBJECT_NAME = @SQLNAME + ':Buffer Manager'
UNION SELECT a.object_name,
'WorktablesFromCacheRatio' AS counter_name,
'' AS instance_name,
cast(a.cntr_value * ISNULL((100.0 / NULLIF(b.cntr_value,0)),0) AS dec(3, 0)) AS cntr_value
FROM sys.dm_os_performance_counters a
JOIN (
SELECT cntr_value,
OBJECT_NAME
FROM sys.dm_os_performance_counters
WHERE counter_name = 'Worktables From Cache Base'
AND OBJECT_NAME = @SQLNAME + ':Access Methods'
) b
ON a.OBJECT_NAME = b.OBJECT_NAME
WHERE a.counter_name = 'Worktables From Cache Ratio'
AND a.OBJECT_NAME = @SQLNAME + ':Access Methods'
UNION SELECT a.object_name,
'CacheHitRatio' AS counter_name,
'_Total' AS instance_name,
cast(a.cntr_value * ISNULL((100.0 / NULLIF(b.cntr_value,0)),0) AS dec(3, 0)) AS cntr_value
FROM sys.dm_os_performance_counters a
JOIN (
SELECT cntr_value,
OBJECT_NAME
FROM sys.dm_os_performance_counters
WHERE counter_name = 'Cache Hit Ratio base'
AND OBJECT_NAME = @SQLNAME + ':Plan Cache'
AND instance_name = '_Total'
) b
ON a.OBJECT_NAME = b.OBJECT_NAME
WHERE a.counter_name = 'Cache Hit Ratio'
AND a.OBJECT_NAME = @SQLNAME + ':Plan Cache'
AND instance_name = '_Total' |
| 12851 | 312931 | 24 | 332301 | 6566885 | 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) |
| 2671 | 307981 | 115 | 317167 | 3544187 | SELECT
data_space_id,
[file_id],
[type],
name,
physical_name,
[state],
CONVERT(bigint, size) * 8 as size_kbytes,
CASE [type] WHEN 2 THEN NULL ELSE CONVERT(bigint, FILEPROPERTY(name,'SpaceUsed')) * 8 END as space_used_kbytes,
CASE max_size WHEN -1 THEN NULL ELSE CONVERT(bigint, max_size) * 8 END as max_size_kbytes,
CASE is_percent_growth WHEN 1 THEN growth ELSE growth * 8 END as growth,
is_percent_growth,
((SELECT SUM(CONVERT(bigint, size)) FROM sys.database_files WHERE [type] % 2 = 0) - (SELECT SUM(CONVERT(bigint,total_pages)) FROM sys.partitions AS p INNER JOIN sys.allocation_units AS a ON p.[partition_id] = a.container_id))*8 AS ShrinkSpace_kbytes
FROM sys.database_files |
| 3221429 | 305869 | 0 | 322549 | 6438854 | SELECT COUNT(*) FROM GN_DIASN
WHERE CCA_CONT= @
AND DIA_NOTR > @_1 AND DIA_NOTR <= @_2 |
| 12849 | 289631 | 22 | 306774 | 6647841 | SELECT TOP(@__p_0) [w].[QUEUE_ID]
FROM [WF_PROCESS_QUEUE] AS [w]
WHERE [w].[STATUS] = N'PENDING' AND [w].[RETRY_COUNT] < [w].[MAX_RETRIES]
ORDER BY [w].[PRIORITY] DESC, [w].[CREATED_DATE] |
| 1 | 253897 | 253897 | 1396931 | 527070 | INSERT INTO #IndexStats (IndexName, SchemaName, TableName, Fragmentation)SELECT IDX.name AS Index_Name, SCHEMA_NAME(OBJ.schema_id) AS Schema_Name, OBJECT_NAME(IDX.OBJECT_ID) AS Table_Name, CAST (IDXPS.avg_fragmentation_in_percent as int) AS Fragmentation FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) AS IDXPS INNER JOIN sys.indexes AS IDX ON IDX.object_id = IDXPS.object_id AND IDX.index_id = IDXPS.index_id AND IDX.name IS NOT NULL INNER JOIN sys.objects AS OBJ ON OBJ.object_id = IDX.object_id WHERE IDX.type_desc IN ('CLUSTERED', 'NONCLUSTERED') AND OBJECTPROPERTY(IDX.object_id, 'IsUserTable') = 1 AND IDXPS.avg_fragmentation_in_percent > 49 ORDER BY Fragmentation DESC |
| 1 | 215477 | 215477 | 220009 | 11053139 | SELECT * FROM dbo.V_RPTG_Radicados WHERE Radicado <> '0' |
| 2676 | 214526 | 80 | 281662 | 8201 | WITH Sessions(IsActive, IsUser) AS
(
SELECT
CASE
WHEN COALESCE (w.wait_type, r.Command, r.wait_type, r.last_wait_type) IS NOT NULL THEN 1
ELSE 0
END AS IsActive,
s.is_user_process AS IsUser
FROM sys.dm_exec_sessions s
LEFT OUTER JOIN sys.dm_exec_requests r ON s.session_id = r.session_id
LEFT OUTER JOIN sys.dm_os_waiting_tasks w ON s.session_id = w.session_id
)
SELECT TOP 1
SERVERPROPERTY('ResourceVersion') as ProductVersion,
SERVERPROPERTY('ProductLevel') as ProductLevel,
SERVERPROPERTY('Edition') as Edition,
SERVERPROPERTY('IsClustered') as IsClustered,
(SELECT Count(*) FROM Sessions WHERE IsUser = 0) AS SystemSessions,
(SELECT Count(*) FROM Sessions WHERE IsUser = 1) AS UserSessions,
(SELECT Count(*) FROM Sessions WHERE IsActive = 1) AS ActiveSessions,
(SELECT Count(*) FROM Sessions WHERE IsActive = 0) AS InactiveSessions,
(SELECT SUM(CONVERT(BIGINT,usecounts)) FROM sys.dm_exec_cached_plans) AS CacheUseCount,
GETUTCDATE() AS TimeStamp
FROM Sessions |
| 32395 | 184825 | 5 | 222302 | 4331 | SELECT ag.name AS group_name,
drs.database_state as database_state,
drs.is_suspended as is_suspended,
drs.synchronization_health as synchronization_health,
arcs.replica_server_name AS replica_name,
db_name(drs.database_id) AS dbname,
drs.is_local
FROM sys.dm_hadr_database_replica_states drs
JOIN sys.dm_hadr_availability_replica_cluster_states arcs
ON arcs.replica_id = drs.replica_id
JOIN sys.availability_groups ag
ON ag.group_id = arcs.group_id
JOIN sys.dm_hadr_availability_replica_states ars
ON ars.replica_id = arcs.replica_id
WHERE drs.is_local = 1 |
| 2676 | 181829 | 67 | 220672 | 49054 | SELECT * FROM (SELECT
c.session_id,
c.client_net_address,
s.login_name,
DATEADD(second, DATEDIFF(second, GETDATE(), GETUTCDATE()), s.login_time) AS login_time,
s.program_name,
s.cpu_time,
(CONVERT(bigint,c.num_reads) + c.num_writes) * c.net_packet_size AS tranferred_bytes,
CASE
WHEN s.last_request_start_time > s.last_request_end_time THEN DATEDIFF(SECOND, s.last_request_start_time, GETDATE())
WHEN s.last_request_end_time > '1900-01-01T00:00:00' THEN DATEDIFF(SECOND, s.last_request_end_time, GETDATE())
ELSE 0
END AS idle_time_in_secs,
CASE
WHEN DATEDIFF(YEAR, s.login_time, GETDATE()) > 67 THEN 2147483647
ELSE DATEDIFF(SECOND, s.login_time, GETDATE())
END AS connection_duration_in_secs,
s.database_id,
ROW_NUMBER() OVER (PARTITION BY s.database_id ORDER BY cpu_time DESC) as row_rank
FROM sys.dm_exec_connections c
INNER JOIN sys.dm_exec_sessions s ON c.session_id = s.session_id) AS x
WHERE x.row_rank <= 10ORDER BY x.cpu_time DESC |
| 9 | 155516 | 17279 | 28994 | 34907927 | select RequestFiles . FileNumber , convert ( VARCHAR , RequestFiles . FiledDate ) Z from RequestFiles left join RequestFileHistories on RequestFiles . Id = RequestFileHistories . RequestFileId and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from dms . dbo . RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @0 ) ) left join TypeDetail on TypeDetail . Id = RequestFileHistories . Status where RequestFileHistories . UserName = @1 and TypeDetail . Name < > @2 |
| 2 | 150559 | 75279 | 202576 | 2370428 | MERGE RequestFiles AS TGT
USING #RADICADOSTEMP2 AS SRC
ON TGT.id=SRC.RequestFileId
WHEN MATCHED THEN
UPDATE SET TGT.ResposnseText=SRC.ResponseText; |
| 871 | 147814 | 169 | 171763 | 53456784 | SELECT bs.database_name as dbname,
[type],
DATEDIFF(SECOND, bs.backup_finish_date, getdate()) as time_since_last_backup,
(DATEDIFF(SECOND, bs.backup_start_date, bs.backup_finish_date)) as duration,
db.recovery_model as db_recovery_model
FROM msdb.dbo.backupset as bs
LEFT JOIN sys.databases as db ON bs.database_name = db.name
WHERE bs.database_name not in (
SELECT AGDatabases.database_name AS Databasename
FROM sys.dm_hadr_availability_group_states States
INNER JOIN master.sys.availability_groups Groups
ON States.group_id = Groups.group_id
INNER JOIN sys.availability_databases_cluster AGDatabases
ON Groups.group_id = AGDatabases.group_id
WHERE primary_replica != @@Servername OR primary_replica is NULL
) and db.name is not NULL
GROUP BY bs.database_name,
backup_finish_date,
[type],
backup_start_date,
db.recovery_model
HAVING backup_finish_date = (
SELECT MAX(backup_finish_date)
FROM msdb.dbo.backupset
WHERE database_name = bs.database_name
AND bs.type = [type]
)
ORDER BY bs.database_name |
| EventName | DatabaseName | FileName | StartTime | DurationMs | GrowthMB | HostName | ApplicationName | LoginName |
|---|
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 10:02:50 AM | 117.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 10:02:34 AM | 97.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | msdb | MSDBLog | 6/7/2026 9:00:03 AM | 7.00 | 0.24 | SRVCLSGDEA | SQLAgent - Job Manager | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | msdb | MSDBLog | 6/7/2026 7:15:00 AM | 7.00 | 0.24 | SRVCLSGDEA | SQLAgent - Job Manager | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 6:02:51 AM | 116.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 6:02:48 AM | 133.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:37:23 AM | 246.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:37:12 AM | 357.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:37:02 AM | 240.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:36:47 AM | 254.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:36:32 AM | 386.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:36:19 AM | 160.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:35:59 AM | 330.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:35:48 AM | 310.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:35:34 AM | 220.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:35:21 AM | 207.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:35:12 AM | 354.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/7/2026 4:32:11 AM | 557.00 | 64.00 | | | sa |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 2:25:56 AM | 237.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 2:24:23 AM | 180.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 2:22:29 AM | 130.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 2:07:53 AM | 563.00 | 64.00 | DWSGDAAPP4 | MicroSQL | ophelia |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 2:03:33 AM | 990.00 | 64.00 | DWSGDAAPP4 | MicroSQL | ophelia |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 1:16:45 AM | 383.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 12:56:08 AM | 1050.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 12:55:57 AM | 903.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 12:55:41 AM | 1087.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | DMS | DMS_log | 6/7/2026 12:55:21 AM | 1233.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | msdb | MSDBLog | 6/7/2026 12:30:02 AM | 33.00 | 0.24 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | msdb | MSDBLog | 6/7/2026 12:30:02 AM | 10.00 | 0.24 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | msdb | MSDBLog | 6/7/2026 12:30:01 AM | 26.00 | 0.24 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1) | DIGITALWARE\SCVSGDA-AGENT |
| Data File Auto Grow | OpheliaSuite | OpheliaSuiteDMS | 6/6/2026 11:54:26 PM | 220.00 | 64.00 | DWSGDAAPP2 | | ophelia |
| Log File Auto Grow | OpheliaSuite | OpheliaSuiteDMS_log | 6/6/2026 11:30:30 PM | 130.00 | 64.00 | DWSGDAAPP3 | | ophelia |
| Data File Auto Grow | OpheliaSuite | OpheliaSuiteDMS | 6/6/2026 11:15:19 PM | 120.00 | 64.00 | DWSGDAAPP2 | | ophelia |
| Log File Auto Grow | OpheliaSuite | OpheliaSuiteDMS_log | 6/6/2026 10:56:51 PM | 177.00 | 64.00 | DWSGDAAPP2 | | ophelia |
| Log File Auto Grow | Stage | Stage_log | 6/6/2026 10:35:03 PM | 153.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/6/2026 10:34:52 PM | 143.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/6/2026 10:34:41 PM | 390.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/6/2026 10:34:31 PM | 120.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/6/2026 10:34:20 PM | 230.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/6/2026 10:34:04 PM | 180.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/6/2026 10:33:49 PM | 206.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/6/2026 10:33:35 PM | 204.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Log File Auto Grow | Stage | Stage_log | 6/6/2026 10:33:21 PM | 206.00 | 64.00 | SRVCLSGDEA | SQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2) | DIGITALWARE\SCVSGDA-AGENT |
| Data File Auto Grow | OpheliaSuite | OpheliaSuiteDMS | 6/6/2026 10:17:13 PM | 143.00 | 64.00 | DWSGDAAPP2 | | ophelia |
| Log File Auto Grow | OpheliaSuite | OpheliaSuiteDMS_log | 6/6/2026 10:10:56 PM | 144.00 | 64.00 | DWSGDAAPP1 | | ophelia |
| Log File Auto Grow | OpheliaSuite | OpheliaSuiteDMS_log | 6/6/2026 8:11:55 PM | 97.00 | 64.00 | | | sa |
| Log File Auto Grow | msdb | MSDBLog | 6/6/2026 8:11:52 PM | 6.00 | 0.38 | | | sa |
| Log File Auto Grow | msdb | MSDBLog | 6/6/2026 8:11:52 PM | 6.00 | 0.38 | | | sa |
| Data File Auto Grow | OpheliaSuite | OpheliaSuiteDMS | 6/6/2026 8:02:29 PM | 87.00 | 64.00 | DWSGDAAPP1 | | ophelia |
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 |
|---|
| 159 | 128288043 | 806843 | 3616980 | 1069654 | | 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 |
| 11850 | 107515050 | 9073 | 1392285 | 1676281 | | 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] |
| 871 | 53456784 | 61374 | 147814 | 171763 | | SELECT bs.database_name as dbname,
[type],
DATEDIFF(SECOND, bs.backup_finish_date, getdate()) as time_since_last_backup,
(DATEDIFF(SECOND, bs.backup_start_date, bs.backup_finish_date)) as duration,
db.recovery_model as db_recovery_model
FROM msdb.dbo.backupset as bs
LEFT JOIN sys.databases as db ON bs.database_name = db.name
WHERE bs.database_name not in (
SELECT AGDatabases.database_name AS Databasename
FROM sys.dm_hadr_availability_group_states States
INNER JOIN master.sys.availability_groups Groups
ON States.group_id = Groups.group_id
INNER JOIN sys.availability_databases_cluster AGDatabases
ON Groups.group_id = AGDatabases.group_id
WHERE primary_replica != @@Servername OR primary_replica is NULL
) and db.name is not NULL
GROUP BY bs.database_name,
backup_finish_date,
[type],
backup_start_date,
db.recovery_model
HAVING backup_finish_date = (
SELECT MAX(backup_finish_date)
FROM msdb.dbo.backupset
WHERE database_name = bs.database_name
AND bs.type = [type]
)
ORDER BY bs.database_name |
| 1 | 37380886 | 37380886 | 531708 | 319826 | Stage | INSERT INTO dbo.SmartSupervisionMom2
SELECT
RequestFiles.Id AS RequestFilesId
,RequestFiles.FileNumber AS [RADICADO FIDUGESTOR] -- Número de radicado
,CAST(CAST(RequestFiles.FiledDate AS DATE) AS VARCHAR) AS [FECHA DE RADICACION] -- Fecha de radicación
,FORMAT(RequestFiles.FiledDate, 'h:mm tt') AS [HORA_RADICACION] -- Hora de radicación en formato AM/PM
,CONCAT(DATENAME(MONTH, RequestFiles.FiledDate),' - ',YEAR(RequestFiles.FiledDate)) AS [MES/AÑO] -- Mes y año en español
--Tipo de PQR extraído del motivo de reclasificación o tomado por defecto
,COALESCE(
SUBSTRING(
RequestFileHistoriesReclas.Reason,
CHARINDEX('Se reclasificó el tipo de PQRSD así: de', RequestFileHistoriesReclas.Reason) + LEN('Se reclasificó el tipo de PQRSD así: de'),
CHARINDEX(' a ', RequestFileHistoriesReclas.Reason) - CHARINDEX('Se reclasificó el tipo de PQRSD así: de', RequestFileHistoriesReclas.Reason) - LEN('Se reclasificó el tipo de PQRSD así: de')
),
PqrsType.Name
) AS [TIPO_DE_PQR]
--Clasificaciones, canal, motivos, tipo y detalle de solicitud
,producto.Name AS [CLASIFICACION SFC PRODUCTO]
,canalpqr.Name AS [CANAL]
,Motivo.Name AS [MACROMOTIVO]
,NameType.Name AS [TIPO DE SOLICITUD]
,ProcedureType.Name AS [DETALLE DE LA SOLICITUD]
,SpecificationType.Name AS [ESPECIFICACIÓN DE LA SOLICITUD]
-- Información relacionada con la transmisión a la SFC
,CONCAT(512,RequestFiles.FileNumber) AS [RADICADO SFC FIDUGESTOR]
,CAST(CAST(RequestFiles.FiledDate AS DATE) AS VARCHAR) AS [FECHA DEL ENVIO A SFC]
,'Recibida' AS [ESTADO SFC MOMENTO 2]
,CASE
WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN 'Enviada'
ELSE 'No Enviada'
END AS [ESTADO DE LA TRASMISION]
,CASE
WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN CAST(CAST(smartprocesslog.RegistrationDate AS DATE) AS VARCHAR)
END AS [FECHA DE TRASMISION]
,CASE
WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN 'N/A'
ELSE CAST(smartprocesslog.Observations AS NVARCHAR(MAX))
END AS [TIPO DE ERROR]
-- Información de funcionarios y dependencias que gestionan y responden
,CONCAT(Users1.Name,' ', Users1.Surnames ) [FUNCIONARIO QUE GESTIONA]
,Dependencies1.Name [DEPENDENCIA QUE GESTIONA]
,CAST(CAST(RequestFileHistories1.CreationDate AS DATE) AS VARCHAR) AS [FECHA DE LA GESTION]
,CASE
WHEN CONCAT(UsersFinalizador.Name,' ', UsersFinalizador.Surnames ) <>'' THEN CONCAT(UsersFinalizador.Name,' ', UsersFinalizador.Surnames )
ELSE CONCAT(Users.Name,' ', Users.Surnames )
END AS [FUNCIONARIO QUE RESPONDE]
,Dependencies.Name AS [DEPENDENCIA QUE RESPONDE]
-- Información sobre respuestas parciales o definitivas
,CASE
WHEN MAX(RequestFilesRespuestaParcial.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL AND
MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER(PARTITION BY RequestFiles.FileNumber) IS NULL THEN 'Respuesta Parcial'
WHEN MAX(RequestFilesRespuestaDefinitiva.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL THEN 'Respuesta Definitiva'
END AS [TIPO DE RESPUESTA]
,MAX(ISNULL(RequestFilesRespuestaDefinitiva.FileNumber,RequestFilesRespuestaParcial.FileNumber)) OVER(PARTITION BY RequestFiles.FileNumber) AS [RADICADO DE RESPUESTA (MOMENTO 3)]
,MAX(CONVERT(VARCHAR,CONVERT(DATE,ISNULL(RequestFilesRespuestaDefinitiva.FiledDate, RequestFilesRespuestaParcial.FiledDate)))) OVER(PARTITION BY RequestFiles.FileNumber) AS [FECHA DE RESPUESTA]
,MAX(RIGHT(CONVERT(DATETIME, ISNULL(RequestFilesRespuestaDefinitiva.FiledDate,RequestFilesRespuestaParcial.FiledDate), 108),8)) OVER(PARTITION BY RequestFiles.FileNumber) AS [HORA DE RESPUESTA]
-- Estado de envío al momento 3
,CASE
WHEN MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Enviada'
ELSE 'No Enviada'
END AS [SE ENVIO MOMENTO 3]
,CASE
WHEN MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'N/A'
WHEN smartprocesslogMom3.RegistrationDate IS NULL THEN 'No ha sido Enviada'
ELSE CAST(smartprocesslogMom3.Observations AS VARCHAR(8000))
END AS [TIPO DE ERROR MOMENTO 3]
,CAST(CAST(smartprocesslogMom3.RegistrationDate AS DATE) AS VARCHAR) AS [FECHA DE TRASMISION MOMENTO 3]
-- Estado final de la solicitud
,CASE
WHEN MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL AND
MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Cerrado'
WHEN smartprocesslog.Id IS NOT NULL AND
MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Recibida'
ELSE 'Abierto'
END AS [ESTADO ACTUAL MOMENTO 3]
-- Información adicional de reclasificación y seguimiento
,CASE WHEN RequestFileHistoriesReclas.Id IS NOT NULL THEN 'Si' ELSE 'No' END AS [EL RADICADO TUVO RECLASIFICACION]
,RequestFileHistoriesReclas.Reason AS [TIPO DE PQRS ANTES DE RECLASIFICAR]
,PqrsType.Name AS [TIPO DE PQRS DESPUES DE RECLASIFICAR]
,Admision.Name AS [ADMISION]
,SmartAddicionalRequestFiles.ComingFromProcedure AS [PROCEDENTE]
,Favorabilidad.Name AS [FAVORABILIDAD]
,SmartAddicionalRequestFiles.FavorConsumerProcedure AS [A FAVOR DE]
,CASE WHEN SmartAddicionalRequestFiles.RefusedEntityProcedure='1' THEN 'Si' ELSE 'No' END AS [INADMITIDA O RECHAZADA POR LA ENTIDAD]
,SmartAddicionalRequestFiles.SuperFRemittedProcedure AS [TRASLADO A LA SUPERINTENDENCIA]
,AFavorDe.Name AS [ACEPTACION]
,Rectificacion.Name AS [RECTIFICACION]
,Desistimiento.Name AS [DESISTIMIENTO]
,clients.NumberIdentification AS [REMITENTE]
,CASE WHEN Clients.AffiliatedFomag='1' THEN 'Si' ELSE 'No' END AS [AFILIADO AL FOMAG]
,AffiliateType.Code AS [TIPO DE AFILIADO]
,RequestFiles.Subject AS [ASUNTO]
,CASE
WHEN Clients.OriginRegistry='SmartSupervision' AND RequestFiles.ReportedSmart='1' THEN 'Si'
WHEN Clients.OriginRegistry NOT IN ('SmartSupervision') THEN 'No'
END AS [ACTUALIZO MOMENTO 4]
,CASE WHEN RequestFiles.ReportedSmart='1' THEN CONVERT(VARCHAR,CONVERT(DATE,Clients.ModificationDate)) END AS [FECHA ACTUALIZACION]
-- Campos auxiliares para filtrado por año y mes
,CAST(YEAR(RequestFiles.FiledDate) AS int) AS AñoFil
,MONTH(RequestFiles.FiledDate) AS MesFil
,ISNULL(Dependencies.code,0) AS DependeciaFil
-- Add campos Circular 19
,Circular19.[TIPO DE FRAUDE] AS [TIPO DE FRAUDE]
,Circular19.[MODALIDAD DE FRAUDE] AS [MODALIDAD DE FRAUDE]
,Circular19.[MONTO RECLAMADO] AS [MONTO RECLAMADO]
,Circular19.[MONTO RECONOCIDO] AS [MONTO RECONOCIDO]
-- Tabla principal de radicados
FROM DMS.DBO.RequestFiles
-- Unión para identificar el último usuario que gestionó el radicado
LEFT JOIN (
SELECT
RequestFileHistories.UserName,
RequestFileHistories.RequestFileId,
RequestFileHistories.Status,
RequestFileHistories.processcode,
ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS rn
FROM DMS.DBO.RequestFileHistories
WHERE Status NOT IN (--Se agregan los siguientes estados por caso SAC 960781
'4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425'
,'8d6acd5a-d128-45b0-b1a5-f9c0fef90708','EF7B7E43-9151-422A-9A2C-6E3B6C53BC85')
AND ProcessCode !='615'
) RequestFileHistories
ON RequestFileHistories.RequestFileId = RequestFiles.Id
AND RequestFileHistories.rn = 1
-- Unión con la información del cliente
LEFT JOIN DMS.DBO.clients
ON clients.Id = RequestFiles.clientid
-- Unión para obtener el último registro del Momento 2 con subproceso REPORTE_QUEJA
LEFT JOIN (
SELECT
smartprocesslog.Id,
smartprocesslog.Status,
smartprocesslog.FileNumber,
smartprocesslog.RegistrationDate,
smartprocesslog.Observations,
smartprocesslog.ClientDocumentNumber,
ROW_NUMBER() OVER (PARTITION BY FileNumber, ClientDocumentNumber ORDER BY RegistrationDate DESC) AS rn
FROM DMS.DBO.smartprocesslog
WHERE Process = 'MOMENTO_2' AND SubProcess = 'REPORTE_QUEJA'
--AND smartprocesslog.FileNumber = '20241011326782'
) smartprocesslog
ON smartprocesslog.FileNumber = RequestFiles.FileNumber
AND smartprocesslog.ClientDocumentNumber = Clients.NumberIdentification
AND smartprocesslog.rn = 1
-- Unión para obtener el último registro del Momento 3 con subproceso REPORTE_QUEJA
LEFT JOIN (
SELECT
smartprocesslog.Id,
smartprocesslog.FileNumber,
smartprocesslog.ClientDocumentNumber,
smartprocesslog.RegistrationDate,
smartprocesslog.Status,
smartprocesslog.Observations,
ROW_NUMBER() OVER (
PARTITION BY FileNumber
ORDER BY
-- Prioriza los EXITOSO más recientes, luego cualquier otro estado
CASE WHEN Status = 'EXITOSO' THEN 1 ELSE 2 END,
RegistrationDate DESC
) AS rn
FROM DMS.DBO.smartprocesslog
WHERE Process = 'MOMENTO_3'
AND SubProcess = 'REPORTE_QUEJA'
AND Status IN ('EXITOSO', 'FINALIZADO', 'FALLIDO')
) smartprocesslogMom3
ON smartprocesslogMom3.FileNumber = RequestFiles.FileNumber
--AND smartprocesslogMom3.Id = (
-- SELECT TOP 1 AA.Id
-- FROM DMS.DBO.smartprocesslog AA
-- WHERE AA.FileNumber = smartprocesslogMom3.FileNumber
-- AND AA.Process = 'MOMENTO_3'
-- AND AA.SubProcess = 'REPORTE_QUEJA'
-- ORDER BY AA.RegistrationDate DESC
--)
AND smartprocesslogMom3.rn = 1
-- Historial más antiguo con dependencia asignada
LEFT JOIN (
SELECT
RequestFileHistories.RequestFileId,
RequestFileHistories.CreationDate,
RequestFileHistories.UserName,
RequestFileHistories.ProcessCode,
ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate ASC) AS rn
FROM DMS.DBO.RequestFileHistories
WHERE DependencyId IS NOT NULL
AND ProcessCode !='615'
--AND RequestFileId ='FCF1BB64-614E-4D69-9E4A-D8BED126A1DC'
) RequestFileHistories1
ON RequestFileHistories1.RequestFileId = RequestFiles.Id
AND RequestFileHistories1.rn = 1
-- Último historial con estado 'Finalizado'
LEFT JOIN (
SELECT
AAA.RequestFileId,
AAA.CreationDate,
AAA.UserName,
ROW_NUMBER() OVER (PARTITION BY AAA.RequestFileId ORDER BY AAA.CreationDate DESC) AS rn
FROM DMS.DBO.RequestFileHistories AAA
INNER JOIN DMS.DBO.TYPESTATEREQUEST_VW BBB
ON CONVERT(VARCHAR(40), AAA.Status) = CONVERT(VARCHAR(40), BBB.Id)
WHERE BBB.Name = 'Finalizado'
) RequestFileHistoriesUsuarioFinalizador
ON RequestFileHistoriesUsuarioFinalizador.RequestFileId = RequestFiles.Id
AND RequestFileHistoriesUsuarioFinalizador.rn = 1
-- Usuario que finalizó el radicado
LEFT JOIN DMS.DBO.Users UsersFinalizador
ON UsersFinalizador.UserName = RequestFileHistoriesUsuarioFinalizador.UserName
-- Historial de reclasificación
LEFT JOIN (SELECT
RequestFileHistories.Id,
RequestFileHistories.RequestFileId,
RequestFileHistories.Reason,
ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS rn
FROM DMS.DBO.RequestFileHistories
WHERE RequestFileHistories.Status = '31b6159d-de9d-4cba-9508-4d9d4ee2faf7'
) AS RequestFileHistoriesReclas
ON RequestFileHistoriesReclas.RequestFileId = RequestFiles.Id
AND RequestFileHistoriesReclas.rn = 1
-- Usuario que respondió
LEFT JOIN DMS.DBO.Users Users
ON Users.UserName = RequestFileHistories.UserName
-- Usuario asociado al historial más antiguo con dependencia
LEFT JOIN DMS.DBO.Users Users1
ON Users1.UserName = RequestFileHistories1.UserName
-- Información adicional del radicado (producto, canal, motivo, etc.)
LEFT JOIN DMS.DBO.SmartAddicionalRequestFiles
ON SmartAddicionalRequestFiles.RequestFilesId = RequestFiles.Id
LEFT JOIN DMS.DBO.TypeDetail producto
ON producto.Id = SmartAddicionalRequestFiles.ProductCode
LEFT JOIN DMS.DBO.TypeDetail canalpqr
ON canalpqr.Id = SmartAddicionalRequestFiles.Channel
LEFT JOIN DMS.DBO.TypeDetail Motivo
ON Motivo.Id = SmartAddicionalRequestFiles.MacroReasonCode
LEFT JOIN DMS.DBO.TypeDetail Admision
ON Admision.Id = SmartAddicionalRequestFiles.Admission
LEFT JOIN DMS.DBO.TypeDetail Favorabilidad
ON Favorabilidad.Id = SmartAddicionalRequestFiles.Favorability
LEFT JOIN DMS.DBO.TypeDetail AFavorDe
ON AFavorDe.Id = SmartAddicionalRequestFiles.Acceptance
LEFT JOIN DMS.DBO.TypeDetail Rectificacion
ON Rectificacion.Id = SmartAddicionalRequestFiles.Rectification
LEFT JOIN DMS.DBO.TypeDetail Desistimiento
ON Desistimiento.Id = SmartAddicionalRequestFiles.ComplaintWithdrawal
-- Tipo de afiliado del cliente
LEFT JOIN DMS.DBO.TYPEAFFILIATE_VW AffiliateType
ON Clients.AffiliateTypeId = CONVERT(VARCHAR(40), AffiliateType.Id)
-- Procedimiento asociado al radicado
LEFT JOIN DMS.DBO.DMS_Procedures
ON DMS_Procedures.Id = RequestFiles.ProcedureId
LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType
ON NameType.Id = DMS_Procedures.NameTypeId
LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType
ON ProcedureType.Id = DMS_Procedures.ProcedureTypeId
LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType
ON SpecificationType.Id = DMS_Procedures.SpecificationTypeId
-- Tipo PQRSD del radicado
LEFT JOIN DMS.dbo.PQRSDType PqrsType
ON PqrsType.Id = RequestFiles.PqrsTypeId
-- Verifica si tiene respuesta parcial
LEFT JOIN (
SELECT
CC.Id,
AA.FiledDate,
AA.FileNumber,
AA.ChannelId,
ROW_NUMBER() OVER (PARTITION BY BB.ParentId ORDER BY AA.FiledDate DESC) AS RN
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
AA.RequestTypeId = '956FE4FE-E0C0-4F50-B742-DB431F9F536B'
AND AA.ResposnseText = 2
) RequestFilesRespuestaParcial
ON RequestFiles.Id = RequestFilesRespuestaParcial.Id
AND RequestFilesRespuestaParcial.RN = '1'
-- Verifica si tiene respuesta definitiva
LEFT JOIN (
SELECT
CC.Id,
AA.FiledDate,
AA.FileNumber,
AA.ChannelId,
ROW_NUMBER() OVER (PARTITION BY BB.ParentId ORDER BY AA.FiledDate DESC) AS RN
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
AA.RequestTypeId = '956FE4FE-E0C0-4F50-B742-DB431F9F536B'
AND AA.ResposnseText = 1
) RequestFilesRespuestaDefinitiva
ON RequestFiles.Id = RequestFilesRespuestaDefinitiva.Id
AND RequestFilesRespuestaDefinitiva.RN = '1'
--Dependencia del usuario finalizador o de quien respondió
LEFT JOIN (
SELECT *
FROM (
SELECT
UsersCompany.UserId,
Dependencies.Id AS DependencyId,
Dependencies.Name,
Dependencies.Code,
Dependencies.TopSection,
UsersCompany.State,
ROW_NUMBER() OVER (PARTITION BY UsersCompany.UserId ORDER BY TypeDetail.Code ASC) AS rn
FROM DMS.DBO.UsersCompany
INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id = UsersCompany.DependenceId
INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State = TypeDetail.Id
) RankedDependencies
WHERE rn = 1
) Dependencies
ON ISNULL(UsersFinalizador.id, Users.id) = Dependencies.UserId
--Consulta adiciona los campos de la actualización circular 19
LEFT JOIN (
SELECT
RequestFilesId,
FraudTypeName.Name AS [Tipo de Fraude],
FraudModalityName.Name AS [Modalidad de Fraude],
FORMAT(ISNULL(ClaimedAmount, 0), 'N0', 'es-CO') AS [Monto Reclamado],
FORMAT(ISNULL(RecognizedAmount, 0), 'N0', 'es-CO') AS [Monto Reconocido]
FROM DMS.dbo.SmartAddicionalRequestFiles
LEFT JOIN DMS.dbo.TypeDetail AS FraudTypeName
ON SmartAddicionalRequestFiles.FraudType = FraudTypeName.Id
AND FraudTypeName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB754'
LEFT JOIN DMS.dbo.TypeDetail AS FraudModalityName
ON SmartAddicionalRequestFiles.FraudModality = FraudModalityName.Id
AND FraudModalityName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB758') AS Circular19 ON RequestFiles.Id = Circular19.RequestFilesId
-- Dependencia asociada al primer usuario con historial
LEFT JOIN (
SELECT *
FROM (
SELECT
UsersCompany.UserId,
Dependencies.Id AS DependencyId,
Dependencies.Name,
Dependencies.Code,
Dependencies.TopSection,
UsersCompany.State,
ROW_NUMBER() OVER (PARTITION BY UsersCompany.UserId ORDER BY TypeDetail.Code ASC) AS rn
FROM DMS.DBO.UsersCompany
INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id = UsersCompany.DependenceId
INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State = TypeDetail.Id
) RankedDependencies
WHERE rn = 1
) Dependencies1
ON Users1.Id = Dependencies1.UserId
-- Filtros principales
WHERE
RequestFiles.OriginId = '2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' -- Origen de radicados
AND RequestFiles.StatusId <> 'E6D67E4A-F545-4D62-B882-5A38A0FC35E2' -- Excluir anulados
AND RequestFileHistories.Status NOT IN ('4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425')
AND RequestFiles.PqrsTypeId NOT IN (
'B48BF430-F3F7-4431-A375-3B9DBC1441E4', -- QuejEx
'496B613B-8905-4496-A201-5AF1235DA91C' -- QejSFC
)
AND RequestFileHistories.ProcessCode !='615' |
| 9 | 34907927 | 3878658 | 155516 | 28994 | | select RequestFiles . FileNumber , convert ( VARCHAR , RequestFiles . FiledDate ) Z from RequestFiles left join RequestFileHistories on RequestFiles . Id = RequestFileHistories . RequestFileId and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from dms . dbo . RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @0 ) ) left join TypeDetail on TypeDetail . Id = RequestFileHistories . Status where RequestFileHistories . UserName = @1 and TypeDetail . Name < > @2 |
| 580 | 26040729 | 44897 | 729866 | 1045587 | | WITH FilteredTables AS (
SELECT
object_id
FROM sys.tables
WHERE object_id > 0
)
INSERT INTO #IndexStats
SELECT
stats.database_id,
stats.object_id,
stats.index_id,
stats.partition_number,
AVG(stats.avg_fragmentation_in_percent) AS avg_fragmentation_in_percent,
SUM(stats.page_count) * 8 AS IndexSizeKb
FROM FilteredTables AS t
INNER JOIN sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'LIMITED') AS stats ON stats.object_id = t.object_id
GROUP BY stats.database_id, stats.object_id, stats.index_id, stats.partition_number
HAVING SUM(stats.page_count) * 8 >= 1024 |
| 11850 | 12845400 | 1084 | 505745 | 607167 | | SELECT COUNT(*)
FROM [ReassignmentTask] AS [r]
WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0 |
| 2671 | 12410422 | 4646 | 66630 | 89876 | | SELECT TOP 10
t.NAME AS TableName,
t.object_id,
mainIndex.data_space_id,
SUM(p.rows) AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
SUM(CASE i.[type]
WHEN 2 THEN 8 * a.used_pages
ELSE 0
END) AS IndexSpaceKB
FROM [sys].[tables] t
INNER HASH JOIN sys.indexes mainIndex ON (t.object_id = mainIndex.object_id AND mainIndex.[type] IN (0,1))
INNER HASH JOIN sys.indexes i ON t.OBJECT_ID = i.object_id
INNER HASH JOIN [sys].[partitions] p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER HASH JOIN [sys].[allocation_units] a ON p.partition_id = a.container_id
WHERE t.is_ms_shipped = 0 AND i.OBJECT_ID > 255 GROUP BY t.Name, t.object_id, mainIndex.data_space_id
ORDER BY TotalSpaceKB DESC |
| 1 | 11053139 | 11053139 | 215477 | 220009 | | SELECT * FROM dbo.V_RPTG_Radicados WHERE Radicado <> '0' |
| 557787 | 10053766 | 18 | 145104 | 150214 | | SELECT ETA_ASUN,GAB_CONT,ETA_INST,ETA_CRIA,ETA_PCOM,ETA_PDEL,
ETA_PSEG,ETA_PRIO,ETA_MTIE,ETA_DLIM,ETA_HLIM,ETA_CLIM,ETA_DREC,
ETA_HREC,ETA_CREC,ETA_POSX,ETA_POSY,ETA_INIC,ETA_SECS,ETA_RECO,
ETA_MACC,CCA_CONT,ETA_EMAI,ETA_TABL,ETA_CAMP,ETA_ANTE,ETA_MASU,
ETA_CRIS,ETA_ANTS,ETA_NOTI,ETA_SNOT,ETA_APAR,ETA_VMIN,ETA_VMAX,
ETA_COST,FLU_COND,ETA_ACOR,ETA_MCOR,WEB_CONT,MWE_CONT,ETA_ARCH,
REG_CONT,PLA_CONT,DPL_CONT,ETA_EJEC,ETA_TPLA,ETA_ADJU,ETA_ATDO,
ETA_APLA,ETA_ADPR,ETA_TTAR,PLA_COND,DGR_CONU,DGR_CONA,ETA_DEST,
ETA_SSQL,DPL_COND,ETA_TLIM,ETA_TESP,ETA_TARC,ETA_SARC,ETA_OSEP,
ETA_ODAT,ETA_IENC,PME_CONT,ETA_EXTE,ETA_TFIN,ETA_TTES,DPL_CON1,
DPL_CON2,DPL_CON3,ETA_CDOC,ETA_CLEC,ETA_TCON,ETA_CCES,ETA_CSMS,
ETA_DSMS,ETA_ESMS,ETA_CEMA,ETA_DEMA,PTL_CODI,PTL_VERS,DPT_CODI,
PTL_CODA,PTL_VERA,DPT_CODA,PTL_CODD,PTL_VERD,DPT_CODD,PTL_CODE,
PTL_VERE,DPT_COD1,DPT_COD2,DPT_COD3,DPT_COD4,DPT_COD5,DPT_COD6,
WSE_CODE,ETA_ADDP,DPG_CODU,DPG_CODA,ETA_VSER,ETA_TREG,
ETA_TIES,ETA_CLES,ETA_DLES,ETA_HLES,ETA_TCAL,ETA_DALE,ETA_HALE
FROM WF_ETAPA WITH (NOLOCK)
WHERE EMP_CODI= @
AND FLU_CONT= @_1
AND ETA_CONT= @_2 |
| 2675 | 7648218 | 2859 | 51114 | 62916 | | SELECT TOP 10
t.NAME AS TableName,
t.object_id,
mainIndex.data_space_id,
SUM(p.rows) AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
SUM(CASE i.[type]
WHEN 2 THEN 8 * a.used_pages
ELSE 0
END) AS IndexSpaceKB
FROM [sys].[tables] t
INNER HASH JOIN sys.indexes mainIndex ON (t.object_id = mainIndex.object_id AND mainIndex.[type] IN (0,1))
INNER HASH JOIN sys.indexes i ON t.OBJECT_ID = i.object_id
INNER HASH JOIN [sys].[partitions] p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER HASH JOIN [sys].[allocation_units] a ON p.partition_id = a.container_id
WHERE t.is_ms_shipped = 0 AND i.OBJECT_ID > 255 GROUP BY t.Name, t.object_id, mainIndex.data_space_id
ORDER BY TotalSpaceKB DESC |
| 2675 | 7340683 | 2744 | 48063 | 66542 | | SELECT TOP 10
t.NAME AS TableName,
t.object_id,
mainIndex.data_space_id,
SUM(p.rows) AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
SUM(CASE i.[type]
WHEN 2 THEN 8 * a.used_pages
ELSE 0
END) AS IndexSpaceKB
FROM [sys].[tables] t
INNER HASH JOIN sys.indexes mainIndex ON (t.object_id = mainIndex.object_id AND mainIndex.[type] IN (0,1))
INNER HASH JOIN sys.indexes i ON t.OBJECT_ID = i.object_id
INNER HASH JOIN [sys].[partitions] p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER HASH JOIN [sys].[allocation_units] a ON p.partition_id = a.container_id
WHERE t.is_ms_shipped = 0 AND i.OBJECT_ID > 255 GROUP BY t.Name, t.object_id, mainIndex.data_space_id
ORDER BY TotalSpaceKB DESC |
| 3 | 6964777 | 2321592 | 172008 | 1075296 | 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 |
| 12945 | 6697512 | 517 | 290914 | 308089 | | SELECT TOP(@__p_0) [w].[QUEUE_ID]
FROM [WF_PROCESS_QUEUE] AS [w]
WHERE [w].[STATUS] = N'PENDING' AND [w].[RETRY_COUNT] < [w].[MAX_RETRIES]
ORDER BY [w].[PRIORITY] DESC, [w].[CREATED_DATE] |
| 2675 | 6680144 | 2497 | 40871 | 55105 | | SELECT TOP 10
t.NAME AS TableName,
t.object_id,
mainIndex.data_space_id,
SUM(p.rows) AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
SUM(CASE i.[type]
WHEN 2 THEN 8 * a.used_pages
ELSE 0
END) AS IndexSpaceKB
FROM [sys].[tables] t
INNER HASH JOIN sys.indexes mainIndex ON (t.object_id = mainIndex.object_id AND mainIndex.[type] IN (0,1))
INNER HASH JOIN sys.indexes i ON t.OBJECT_ID = i.object_id
INNER HASH JOIN [sys].[partitions] p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER HASH JOIN [sys].[allocation_units] a ON p.partition_id = a.container_id
WHERE t.is_ms_shipped = 0 AND i.OBJECT_ID > 255 GROUP BY t.Name, t.object_id, mainIndex.data_space_id
ORDER BY TotalSpaceKB DESC |
| 12947 | 6615941 | 511 | 314271 | 333707 | | 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) |
| 3226440 | 6448874 | 1 | 306044 | 322726 | | SELECT COUNT(*) FROM GN_DIASN
WHERE CCA_CONT= @
AND DIA_NOTR > @_1 AND DIA_NOTR <= @_2 |
| 2675 | 5737307 | 2144 | 12563 | 14646 | | SELECT
data_space_id,
[file_id],
[type],
name,
physical_name,
[state],
CONVERT(bigint, size) * 8 as size_kbytes,
CASE [type] WHEN 2 THEN NULL ELSE CONVERT(bigint, FILEPROPERTY(name,'SpaceUsed')) * 8 END as space_used_kbytes,
CASE max_size WHEN -1 THEN NULL ELSE CONVERT(bigint, max_size) * 8 END as max_size_kbytes,
CASE is_percent_growth WHEN 1 THEN growth ELSE growth * 8 END as growth,
is_percent_growth,
((SELECT SUM(CONVERT(bigint, size)) FROM sys.database_files WHERE [type] % 2 = 0) - (SELECT SUM(CONVERT(bigint,total_pages)) FROM sys.partitions AS p INNER JOIN sys.allocation_units AS a ON p.[partition_id] = a.container_id))*8 AS ShrinkSpace_kbytes
FROM sys.database_files |
| 2675 | 5316876 | 1987 | 11605 | 12861 | | SELECT
data_space_id,
[file_id],
[type],
name,
physical_name,
[state],
CONVERT(bigint, size) * 8 as size_kbytes,
CASE [type] WHEN 2 THEN NULL ELSE CONVERT(bigint, FILEPROPERTY(name,'SpaceUsed')) * 8 END as space_used_kbytes,
CASE max_size WHEN -1 THEN NULL ELSE CONVERT(bigint, max_size) * 8 END as max_size_kbytes,
CASE is_percent_growth WHEN 1 THEN growth ELSE growth * 8 END as growth,
is_percent_growth,
((SELECT SUM(CONVERT(bigint, size)) FROM sys.database_files WHERE [type] % 2 = 0) - (SELECT SUM(CONVERT(bigint,total_pages)) FROM sys.partitions AS p INNER JOIN sys.allocation_units AS a ON p.[partition_id] = a.container_id))*8 AS ShrinkSpace_kbytes
FROM sys.database_files |
| 1 | 4447173 | 4447173 | 7966 | 5985 | 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); |
| DatabaseName | SchemaName | TableName | StatisticName | LastUpdated | Rows | ModificationCounter | ModifiedPct |
|---|
| Stage | sys | sysrscols | _WA_Sys_00000003_00000003 | 1/15/2024 2:59:56 PM | 2079 | 2833621 | 136297.31 |
| Stage | sys | syscolpars | _WA_Sys_00000007_00000029 | 9/26/2024 10:24:36 AM | 1891 | 1482346 | 78389.53 |
| 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 | 261864 | 9450.16 |
| Stage | sys | sysrscols | _WA_Sys_00000002_00000003 | 5/28/2025 9:59:29 AM | 2771 | 261863 | 9450.13 |
| Stage | sys | sysrscols | clst | 5/28/2025 9:59:29 AM | 2771 | 261863 | 9450.13 |
| 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 | 92461 | 2302.32 |
| DMS | sys | sysrscols | _WA_Sys_00000002_00000003 | 5/27/2025 4:24:37 PM | 4016 | 92460 | 2302.29 |
| DMS | sys | sysrscols | clst | 5/27/2025 4:24:37 PM | 4016 | 92460 | 2302.29 |
| 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 | 20247 | 758.60 |
| Stage | sys | sysschobjs | _WA_Sys_0000000A_00000022 | 6/24/2025 9:13:37 AM | 2669 | 10650 | 399.03 |
| Stage | sys | sysiscols | _WA_Sys_00000007_00000037 | 3/2/2026 10:04:26 AM | 1022 | 2393 | 234.15 |
| Stage | sys | sysschobjs | _WA_Sys_00000009_00000022 | 1/22/2026 9:13:35 AM | 2684 | 6016 | 224.14 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_0000001B_394FC3D8 | 6/7/2026 2:49:53 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000037_394FC3D8 | 6/7/2026 2:49:53 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000038_394FC3D8 | 6/7/2026 2:49:53 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000036_394FC3D8 | 6/7/2026 2:49:53 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000019_394FC3D8 | 6/7/2026 2:49:53 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000011_394FC3D8 | 6/7/2026 2:49:52 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_0000001D_394FC3D8 | 6/7/2026 2:49:52 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_0000001E_394FC3D8 | 6/7/2026 2:49:52 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000003_394FC3D8 | 6/7/2026 2:49:52 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000034_394FC3D8 | 6/7/2026 2:49:51 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000035_394FC3D8 | 6/7/2026 2:49:51 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000009_394FC3D8 | 6/7/2026 2:49:51 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_0000000B_394FC3D8 | 6/7/2026 2:49:51 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | _WA_Sys_00000033_394FC3D8 | 6/7/2026 2:49:50 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom2 | PK__SmartSup__3214EC0733D5295D | 6/7/2026 2:49:50 AM | 537219 | 1074443 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000006_641AF1A3 | 6/7/2026 2:49:55 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000017_641AF1A3 | 6/7/2026 2:49:55 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000013_641AF1A3 | 6/7/2026 2:49:55 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000018_641AF1A3 | 6/7/2026 2:49:55 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000031_641AF1A3 | 6/7/2026 2:49:55 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000032_641AF1A3 | 6/7/2026 2:49:55 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000008_641AF1A3 | 6/7/2026 2:49:55 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | _WA_Sys_00000030_641AF1A3 | 6/7/2026 2:49:55 AM | 1979 | 3958 | 200.00 |
| Stage | dbo | SmartSupervisionMom1 | PK_SmartSupervisionMom1 | 6/7/2026 2:49:55 AM | 1979 | 3958 | 200.00 |
| 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 | dbo | RelatedRequestFiles | _WA_Sys_00000003_55DFB4D9 | 6/7/2026 2:47:52 AM | 590186 | 951814 | 161.27 |
| 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 | 6814 | 124.37 |
| OpheliaSuite | sys | sysrscols | _WA_Sys_00000002_00000003 | 3/21/2025 5:30:51 PM | 5479 | 6814 | 124.37 |
| OpheliaSuite | sys | sysrscols | _WA_Sys_00000005_00000003 | 3/21/2025 5:30:51 PM | 5479 | 6814 | 124.37 |
| 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 |
| 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 |
| 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 |
| 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 |
| OpheliaSuite | sys | syssingleobjrefs | clst | 9/26/2023 6:00:05 AM | 1642 | 807 | 49.15 |
| OpheliaSuite | sys | syssingleobjrefs | nc1 | 9/26/2023 6:00:05 AM | 1642 | 807 | 49.15 |
| OpheliaSuite | sys | syssingleobjrefs | _WA_Sys_00000001_0000004A | 9/26/2023 6:00:05 AM | 1642 | 807 | 49.15 |
| OpheliaSuite | sys | syssingleobjrefs | _WA_Sys_00000003_0000004A | 9/26/2023 6:00:05 AM | 1642 | 807 | 49.15 |
| 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 |
| DMS | dbo | RequestFiles | _WA_Sys_0000001F_33FF9E21 | 6/7/2026 4:30:01 AM | 1882359 | 840169 | 44.63 |
| DMS_BK_20 | sys | sysobjvalues | _WA_Sys_00000005_0000003C | 6/4/2026 3:28:28 AM | 1483 | 639 | 43.09 |
| Stage | sys | sysiscols | _WA_Sys_00000006_00000037 | 5/27/2026 10:59:41 PM | 1046 | 447 | 42.73 |
| DMS | sys | sysidxstats | nc | 3/11/2026 5:30:39 AM | 2004 | 851 | 42.47 |
| DMS | sys | sysidxstats | clst | 3/11/2026 5:30:39 AM | 2004 | 851 | 42.47 |
| DMS | sys | sysidxstats | _WA_Sys_00000004_00000036 | 3/11/2026 5:30:39 AM | 2004 | 851 | 42.47 |
| DMS | sys | syssingleobjrefs | nc1 | 5/23/2025 11:02:12 AM | 1876 | 774 | 41.26 |
| DMS | sys | syssingleobjrefs | clst | 5/23/2025 11:02:12 AM | 1876 | 774 | 41.26 |
| DMS_bk_040923 | sys | sysschobjs | _WA_Sys_0000000A_00000022 | 10/13/2022 2:11:25 PM | 3290 | 1323 | 40.21 |
| DMS_BK_20 | sys | sysschobjs | _WA_Sys_0000000A_00000022 | 10/13/2022 2:11:25 PM | 3290 | 1283 | 39.00 |
| DMS_BK_20 | sys | sysmultiobjrefs | _WA_Sys_00000001_0000004B | 6/13/2023 6:07:37 PM | 1705 | 663 | 38.89 |
| DMS_BK_20 | sys | sysmultiobjrefs | _WA_Sys_00000005_0000004B | 6/14/2023 8:37:17 AM | 1705 | 663 | 38.89 |
| DMS_BK_20 | sys | sysmultiobjrefs | _WA_Sys_00000003_0000004B | 6/14/2023 8:37:17 AM | 1705 | 663 | 38.89 |
| DMS_BK_20 | sys | sysmultiobjrefs | nc1 | 6/13/2023 6:07:37 PM | 1705 | 663 | 38.89 |
| DMS_BK_20 | sys | sysmultiobjrefs | clst | 6/13/2023 6:07:37 PM | 1705 | 663 | 38.89 |
| DatabaseName | SchemaName | TableName | UserSeeks | UserScans | AvgTotalUserCost | AvgUserImpact | EstimatedImpact | EqualityColumns | InequalityColumns | IncludedColumns |
|---|
| OpheliaSuite | dbo | WF_SEGUI | 320 | 0 | 4735.67 | 99.97 | 151496000.35 | [ETA_CONT] | | [SEG_ESTE], [AUD_UFAC] |
| OpheliaSuite | dbo | WF_SEGUI | 164 | 0 | 1537.38 | 96.50 | 24330532.30 | [SEG_UENC], [SEG_ESTE] | | [FLU_CONT], [ETA_CONT], [SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI] |
| OpheliaSuite | dbo | WF_SEGUI | 107 | 0 | 1066.69 | 91.76 | 10473130.10 | [SEG_ESTE] | | [SEG_UENC] |
| OpheliaSuite | dbo | WF_SEGUI | 61 | 0 | 1556.85 | 96.11 | 9127358.01 | [FLU_CONT], [ETA_CONT], [SEG_UENC], [SEG_ESTE] | | [SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI] |
| OpheliaSuite | dbo | WF_SEGUI | 49 | 0 | 1375.85 | 88.11 | 5940072.59 | [FLU_CONT], [ETA_CONT], [SEG_ESTE] | | [SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI], [SEG_UENC] |
| OpheliaSuite | dbo | WF_SEGUI | 44 | 0 | 1535.87 | 78.37 | 5296096.12 | [SEG_ESTE] | | [FLU_CONT], [ETA_CONT], [SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI], [SEG_UENC] |
| OpheliaSuite | dbo | WF_SEGUI | 45 | 0 | 1106.65 | 95.39 | 4750337.04 | [SEG_UENC], [SEG_ESTE] | | [FLU_CONT], [SEG_SUBJ] |
| OpheliaSuite | dbo | WF_SEGUI | 19 | 0 | 1080.58 | 99.97 | 2052492.69 | [SEG_UENC] | [SEG_ESTE] | |
| OpheliaSuite | dbo | WF_SEGUI | 12 | 0 | 952.94 | 88.08 | 1007219.47 | [EMP_CODI], [FLU_CONT], [ETA_CONT] | [SEG_FREC], [SEG_FLIM], [SEG_ESTE] | [SEG_SUBJ], [SEG_UORI], [SEG_UENC] |
| OpheliaSuite | dbo | WF_SEGUI | 8 | 0 | 1121.00 | 96.45 | 864962.39 | [SEG_UENC] | [SEG_ESTE] | [FLU_CONT] |
| OpheliaSuite | dbo | WF_SEGUI | 9 | 0 | 640.44 | 80.85 | 466017.69 | [SEG_ESTE] | [ETA_CONT] | |
| DMS | dbo | DMS_ReorderedDocuments | 119 | 0 | 26.05 | 99.79 | 309389.17 | [ReferenceId] | | [Tomo], [DateDocument], [Folios], [Size] |
| DMS | dbo | DMS_ReorderedDocuments | 119 | 0 | 25.76 | 99.92 | 306323.85 | [ReferenceId] | | [CodeReference], [Tomo], [ReferenceRFId], [DateDocument], [Orden], [Folios], [Size], [HomePage], [EndPage], [CreationUser], [RegistrationDate], [ModificationUser], [ModificationDate] |
| DMS | dbo | RequestFileHistories | 12 | 0 | 1758.61 | 13.62 | 287427.17 | | [Status], [ProcessCode] | [RequestFileId], [CreationDate] |
| DMS | dbo | RequestFileHistories | 33 | 0 | 136.03 | 57.97 | 260218.60 | | [CreationDate] | [RequestFileId], [Reason], [Status] |
| Stage | dbo | RadicacionVentUnica | 6 | 0 | 242.53 | 99.64 | 144992.33 | [PROCESO], [Tipo Comunicacion] | [Radicado] | [Fecha y Hora Radicacion] |
| Stage | dbo | RadicacionVentUnica | 6 | 0 | 242.53 | 98.67 | 143580.83 | [PROCESO], [Tipo Comunicacion] | [Fecha y Hora Radicacion], [Medio de Recepcion] | [Radicado] |
| DMS | dbo | DMS_Procedures | 5432 | 0 | 1.57 | 13.69 | 116397.13 | [ProcessVersion], [ProcessType] | [ProceduresStateId] | [ResponseTime], [ResponsibleUserId], [DependenciesId], [ProcedureTypeId], [NameTypeId] |
| DMS | dbo | RequestFiles | 5 | 0 | 392.24 | 59.03 | 115769.07 | [ChannelId] | [FiledDate], [OriginId] | [FileNumber], [Subject], [PqrsTypeId], [ExperationDate] |
| OpheliaSuite | dbo | WF_SEGUI | 1 | 0 | 1216.92 | 88.40 | 107576.06 | [FLU_CONT], [SEG_UENC] | | [SEG_ESTE] |
| DMS | dbo | RequestFiles | 3 | 0 | 277.13 | 87.05 | 72371.43 | | [FileNumber] | [ClientId], [ProcedureId], [FiledDate], [StatusId], [Subject], [DependencyId], [UserName], [ReceiverName], [SeriesId], [SubseriesId], [OriginId], [DocumentTypeId], [ExperationDate] |
| OpheliaSuite | dbo | WF_CASOS | 17 | 0 | 37.81 | 99.72 | 64093.21 | [EMP_CODI], [USU_CODI] | [CAS_FECI] | [CAS_DESC], [FLU_CONT], [CAS_FLIM], [CAS_HLIM], [CAS_HORI], [CAS_FECF], [CAS_HORF], [CAS_ESTA] |
| OpheliaSuite | dbo | WF_SEGUI | 1 | 0 | 779.81 | 77.22 | 60217.23 | [SEG_ESTE] | | [FLU_CONT], [ETA_CONT] |
| DMS | dbo | ReviewDocumentCertification | 974 | 0 | 1.84 | 33.01 | 59215.14 | | [State] | [IdDocumentCertification], [IdDetailManagePeaceAndSave], [TypeUserApproving] |
| DMS | dbo | DMS_Security | 378 | 0 | 4.70 | 30.63 | 54407.37 | [UserName], [ValidateUser] | | |
| DMS | dbo | DMS_Procedures | 2302 | 0 | 0.68 | 30.37 | 47277.30 | [ProceduresStateId], [VisibleWeb] | | [ResponsibleUserId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId], [ProcessVersion], [IdTheme], [IdBussinnes] |
| DMS | dbo | DMS_Procedures | 2302 | 0 | 0.68 | 26.90 | 41875.52 | [VisibleWeb] | | [ResponsibleUserId], [ProceduresStateId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId], [ProcessVersion], [IdTheme], [IdBussinnes] |
| DMS | dbo | RequestFiles | 1 | 0 | 414.07 | 99.99 | 41402.40 | [ApproverName] | | |
| DMS | dbo | RequestFiles | 1 | 0 | 414.19 | 99.76 | 41319.57 | | [ApproverName] | |
| DMS | dbo | RequestFiles | 1 | 0 | 416.31 | 99.05 | 41235.59 | [ApproverName] | | [ClientId], [ProcedureId], [FileNumber], [FiledDate], [StatusId], [Subject], [DependencyId], [ReceiverName], [SeriesId], [SubseriesId], [OriginId], [CaseId], [DocumentTypeId], [ExperationDate], [ContactId], [CollaboratorDependencyId], [VersionCCD], [VersionTRD] |
| Stage | dbo | pqrsdConsolidated | 7 | 0 | 248.10 | 23.34 | 40533.88 | [RADICADO_RESPUESTA_FINAL], [PROCESO] | | |
| DMS | dbo | ClassificationHistories | 1934 | 0 | 0.22 | 89.67 | 37784.21 | [DependencyCode] | [SubserieCode] | [ClassificationHeadId], [SerieCode] |
| DMS | dbo | RequestFiles | 6 | 0 | 86.87 | 72.38 | 37725.31 | [StatusId], [OriginId], [ReportedSmart] | [ComplaintOrigin] | [ClientId], [FileNumber], [PqrsTypeId] |
| DMS | dbo | DocumentType | 229 | 0 | 3.97 | 38.37 | 34901.27 | [Version] | | [Name], [Code] |
| OpheliaSuite | dbo | WF_FETAP | 5796 | 0 | 0.11 | 53.61 | 34539.28 | [EMP_CODI], [PTL_CODI], [PTL_VERS] | | |
| DMS | dbo | DMS_Procedures | 2304 | 0 | 0.59 | 25.04 | 34299.67 | [ProceduresStateId], [VisibleWeb] | [IdTheme] | [Name], [ResponsibleUserId], [ProcedureTypeId], [NameTypeId], [ProcessVersion], [IdBussinnes] |
| DMS | dbo | ReviewDocumentCertification | 353 | 0 | 1.11 | 85.08 | 33341.91 | [IdDocumentCertification] | | [IdDetailManagePeaceAndSave], [IdUserApproving], [State], [CreationDate], [ModificationDate] |
| OpheliaSuite | dbo | WF_SEGUI | 17 | 0 | 25.10 | 74.71 | 31880.77 | [EMP_CODI], [SEG_CONA], [SEG_ESTE] | [FLU_CONT], [SEG_FREC] | |
| DMS | dbo | RequestFiles | 6 | 0 | 437.76 | 11.85 | 31124.86 | [UserName] | [FiledDate] | [FileNumber] |
| DMS | dbo | DMS_Procedures | 2304 | 0 | 0.59 | 21.45 | 29382.10 | [VisibleWeb] | [IdTheme] | [Name], [ResponsibleUserId], [ProceduresStateId], [ProcedureTypeId], [NameTypeId], [ProcessVersion], [IdBussinnes] |
| DMS | dbo | RequestFiles | 5 | 0 | 61.04 | 95.37 | 29107.80 | [OriginId], [VersionCCD] | [FiledDate] | [DependencyId] |
| DMS | dbo | RequestFiles | 5 | 0 | 61.04 | 95.29 | 29083.38 | [OriginId] | [FiledDate] | [DependencyId], [VersionCCD] |
| DMS | dbo | RequestFiles | 6 | 0 | 437.76 | 10.83 | 28445.76 | | [FileNumber], [FiledDate] | [UserName] |
| DMS | dbo | RequestFiles | 3 | 0 | 181.55 | 49.75 | 27096.32 | [RequestTypeId], [MassiveConsecutive] | [StatusId] | [CaseId] |
| OpheliaSuite | dbo | WF_CASOS | 6 | 0 | 43.24 | 99.37 | 25778.03 | [EMP_CODI], [USU_CODI] | [CAS_FECI], [CAS_FECF] | [CAS_DESC], [FLU_CONT], [CAS_FLIM], [CAS_HLIM], [CAS_HORI], [CAS_HORF], [CAS_ESTA] |
| DMS | dbo | RequestFiles | 4 | 0 | 59.94 | 96.03 | 23025.20 | [StatusId], [OriginId], [ComplaintOrigin] | | [FileNumber] |
| DMS | dbo | RequestFiles | 4 | 0 | 80.61 | 70.93 | 22870.96 | [StatusId], [OriginId], [ComplaintOrigin] | | [ClientId], [FileNumber], [PqrsTypeId] |
| OpheliaSuite | dbo | WF_CASOS | 6 | 0 | 37.53 | 99.71 | 22453.59 | [EMP_CODI], [USU_CODI] | [CAS_FECF] | [CAS_DESC], [FLU_CONT], [CAS_FLIM], [CAS_HLIM], [CAS_FECI], [CAS_HORI], [CAS_HORF], [CAS_ESTA] |
| DMS | dbo | RequestFiles | 5 | 0 | 44.40 | 94.84 | 21056.37 | | [FiledDate] | [DependencyId] |
| OpheliaSuite | dbo | WF_SEGUI | 1 | 0 | 1351.20 | 14.65 | 19795.07 | [EMP_CODI], [FLU_CONT], [ETA_CONT], [SEG_ESTE] | [SEG_FREC] | [SEG_HREC] |
No hay datos.
| LogDate | ProcessInfo | Text |
|---|
| 6/3/2026 10:34:23 AM | Logon | Login failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.2.44] |
| 6/3/2026 10:34:23 AM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/2/2026 2:54:54 PM | Logon | Login failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.179] |
| 6/2/2026 2:54:54 PM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/2/2026 2:54:50 PM | Logon | Login failed for user 'opheliadms'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.179] |
| 6/2/2026 2:54:50 PM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/2/2026 2:54:47 PM | Logon | Login failed for user 'opheliadms'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.179] |
| 6/2/2026 2:54:47 PM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/2/2026 11:46:54 AM | Logon | Login failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159] |
| 6/2/2026 11:46:54 AM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/2/2026 11:46:44 AM | Logon | Login failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159] |
| 6/2/2026 11:46:44 AM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/2/2026 11:46:41 AM | Logon | Login failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159] |
| 6/2/2026 11:46:41 AM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/2/2026 11:46:21 AM | Logon | Login failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159] |
| 6/2/2026 11:46:21 AM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/2/2026 11:46:09 AM | Logon | Login failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159] |
| 6/2/2026 11:46:09 AM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/2/2026 11:46:05 AM | Logon | Login failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159] |
| 6/2/2026 11:46:05 AM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/1/2026 2:42:17 PM | Logon | Login failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.25] |
| 6/1/2026 2:42:17 PM | Logon | Error: 18456, Severity: 14, State: 8. |
| 6/1/2026 2:41:49 PM | Logon | Login failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.25] |
| 6/1/2026 2:41:49 PM | Logon | Error: 18456, Severity: 14, State: 8. |
| 5/31/2026 6:02:58 AM | spid6s | Warning: Failure to calculate super-latch promotion threshold. |
| 5/29/2026 2:58:25 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:58:25 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153] |
| 5/29/2026 2:58:19 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:58:19 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151] |
| 5/29/2026 2:58:12 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:58:12 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150] |
| 5/29/2026 2:58:02 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:58:02 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153] |
| 5/29/2026 2:57:56 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:57:56 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151] |
| 5/29/2026 2:57:53 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:57:53 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150] |
| 5/29/2026 2:57:49 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:57:49 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151] |
| 5/29/2026 2:57:47 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:57:47 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153] |
| 5/29/2026 2:57:46 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:57:46 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150] |
| 5/29/2026 2:57:43 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:57:43 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153] |
| 5/29/2026 2:57:34 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:57:34 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150] |
| 5/29/2026 2:57:19 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151] |
| 5/29/2026 2:57:19 AM | Logon | Error: 18456, Severity: 14, State: 38. |
| 5/29/2026 2:57:18 AM | Logon | Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153] |
No hay datos.
| base_datos | esquema | tabla | indice | type_desc | fragmentacion_pct | page_count | tamano_mb | accion_recomendada |
|---|
| OpheliaSuite | dbo | WF_SEGUI | PK_WF_SEGUI | CLUSTERED | 48.60 | 6413702 | 50107.0 | REBUILD |
| Drive | dbo | DRIVE_METADATA | PK__DRIVE_ME__DED88B1C6A0453BF | CLUSTERED | 90.84 | 834756 | 6521.5 | REBUILD |
| Drive | dbo | DRIVE_METADATA | IDX_NC_DRIVE_METADATA_009 | NONCLUSTERED | 96.39 | 659420 | 5151.7 | REBUILD |
| OpheliaSuite | dbo | WF_SEGUI | IDX_NC_WF_SEGUI_002 | NONCLUSTERED | 48.31 | 1187063 | 9273.9 | REBUILD |
| OpheliaSuite | dbo | WF_SEGUI | IN_WF_SEGUI_02 | NONCLUSTERED | 39.45 | 1427534 | 11152.6 | REBUILD |
| OpheliaSuite | dbo | WF_SEGUI | IDX_NC_WF_SEGUI_001 | NONCLUSTERED | 47.26 | 1180847 | 9225.4 | REBUILD |
| Drive | dbo | DRIVE_METADATA | IDX_NC_DRIVE_METADATA_006 | NONCLUSTERED | 69.89 | 760846 | 5944.1 | REBUILD |
| OpheliaSuite | dbo | WF_LOGPL | PK_WF_LOGPL | CLUSTERED | 46.58 | 1095412 | 8557.9 | REBUILD |
| OpheliaSuite | dbo | WF_IRUTA | PK_WF_IRUTA | CLUSTERED | 35.51 | 1339220 | 10462.7 | REBUILD |
| OpheliaSuite | dbo | WF_SEGUI | IDX_NC_WF_SEGUI_004 | NONCLUSTERED | 35.87 | 1239777 | 9685.8 | REBUILD |
| OpheliaSuite | dbo | WF_SEGUI | IDX_NC_WF_SEGUI_003 | NONCLUSTERED | 47.36 | 893993 | 6984.3 | REBUILD |
| OpheliaSuite | dbo | WF_IRUTA | IDX_NC_WF_IRUTA_001 | NONCLUSTERED | 20.40 | 1576273 | 12314.6 | REORGANIZE |
| OpheliaSuite | dbo | WF_SEGUI | IDX_NC_WF_SEGUI_007 | NONCLUSTERED | 37.34 | 780840 | 6100.3 | REBUILD |
| OpheliaSuite | dbo | WF_IRUTA | IDX_NC_WF_IRUTA_002 | NONCLUSTERED | 23.39 | 1125168 | 8790.4 | REORGANIZE |
| DMS | dbo | DMS_Indexes | PK__DMS_Inde__3214EC0764BB43FA | CLUSTERED | 45.82 | 557876 | 4358.4 | REBUILD |
| Drive | dbo | DRIVE_METADATA | IDX_NC_DRIVE_METADATA_010 | NONCLUSTERED | 95.03 | 226836 | 1772.2 | REBUILD |
| Drive | dbo | DRIVE_METADATA | IX_DRIVE_METADATA_FolderCode | NONCLUSTERED | 86.63 | 237808 | 1857.9 | REBUILD |
| Drive | dbo | DRIVE_METADATA | IDX_NC_DRIVE_METADATA_002 | NONCLUSTERED | 82.04 | 245185 | 1915.5 | REBUILD |
| Drive | dbo | DRIVE_METADATA | UQ__DRIVE_ME__6F0F98BEF15CEBCC | NONCLUSTERED | 71.50 | 230543 | 1801.1 | REBUILD |
| OpheliaSuite | dbo | WF_SEGUI | IDX_NC_WF_SEGUI_008 | NONCLUSTERED | 10.49 | 1554729 | 12146.3 | REORGANIZE |
| Drive | dbo | DRIVE_FOLDER | PK__DRIVE_FO__DED88B1C73D9DEFE | CLUSTERED | 93.20 | 160233 | 1251.8 | REBUILD |
| OpheliaSuite | dbo | WF_SEGUI | IN_WF_SEGUI_01 | NONCLUSTERED | 6.57 | 2187162 | 17087.2 | NO ACCION |
| Drive | dbo | DRIVE_FOLDER | IDX_NC_DRIVE_FOLDER_003 | NONCLUSTERED | 65.25 | 129677 | 1013.1 | REBUILD |
| DMS | dbo | RequestEmail | PK__tmp_ms_x__3214EC0709EC20FC | CLUSTERED | 34.90 | 220657 | 1723.9 | REBUILD |
| OpheliaSuite | dbo | WF_FPLAN | UQ_WF_FPLAN_001 | NONCLUSTERED | 33.07 | 212688 | 1661.6 | REBUILD |
| DMS | dbo | PQRSDWebProcessLog | PK__PQRSDWeb__3214EC07598FFB3B | CLUSTERED | 20.21 | 329874 | 2577.1 | REORGANIZE |
| OpheliaSuite | dbo | WF_FPLAN | IDX_NC_WF_FPLAN_001 | NONCLUSTERED | 23.02 | 256631 | 2004.9 | REORGANIZE |
| Drive | dbo | DRIVE_FOLDER | IDX_NC_DRIVE_FOLDER_004 | NONCLUSTERED | 95.04 | 59222 | 462.7 | REBUILD |
| Drive | dbo | DRIVE_FOLDER | IX_DRIVE_FOLDER_Code | NONCLUSTERED | 94.97 | 59179 | 462.3 | REBUILD |
| OpheliaSuite | dbo | WF_CASOS | IDX_NC_WF_CASOS_001 | NONCLUSTERED | 45.94 | 113903 | 889.9 | REBUILD |
| OpheliaSuite | dbo | WF_FPLAN | PK_WF_FPLAN | CLUSTERED | 11.15 | 395685 | 3091.3 | REORGANIZE |
| Drive | dbo | DRIVE_FOLDER | UQ__DRIVE_FO__A25C5AA750312A26 | NONCLUSTERED | 74.58 | 42497 | 332.0 | REBUILD |
| DMS | dbo | DMS_ReorderedDocuments | PK_DMS_ReorderedDocuments | CLUSTERED | 66.76 | 44968 | 351.3 | REBUILD |
| Drive | dbo | DRIVE_METADATA | IDX_NC_DRIVE_METADATA_005 | NONCLUSTERED | 24.18 | 113261 | 884.9 | REORGANIZE |
| OpheliaSuite | dbo | WF_FPLAN | IDX_NC_WF_FPLAN_002 | NONCLUSTERED | 8.40 | 307385 | 2401.4 | NO ACCION |
| DMS | dbo | ReferencesRequestFile | IDX_NC_ReferencesRequestFile_00 | NONCLUSTERED | 28.91 | 84617 | 661.1 | REORGANIZE |
| DMS | dbo | ReferencesRequestFile | PK_ReferencesRequestFile | CLUSTERED | 24.81 | 88149 | 688.7 | REORGANIZE |
| OpheliaSuite | dbo | WF_CASOS | IDX_NC_WF_CASOS_003 | NONCLUSTERED | 34.71 | 57528 | 449.4 | REBUILD |
| DMS | dbo | RequestFiles | PK__tmp_ms_x__3214EC077390A34D | CLUSTERED | 3.12 | 561786 | 4389.0 | NO ACCION |
| OpheliaSuite | dbo | WF_VBPER | PK_WF_VBPER | CLUSTERED | 48.29 | 34965 | 273.2 | REBUILD |
| DMS | dbo | RequestFiles | IDX_NC_RequestFiles_012 | NONCLUSTERED | 22.14 | 69474 | 542.8 | REORGANIZE |
| DMS | dbo | RadicadeHistory | PK__tmp_ms_x__3214EC078C329747 | CLUSTERED | 26.94 | 48324 | 377.5 | REORGANIZE |
| DMS | dbo | RequestFileHistories | IDX_NC_RequestFileHistories_005 | NONCLUSTERED | 7.60 | 159908 | 1249.3 | NO ACCION |
| DMS | dbo | DMS_ReorderedDocuments | IX_DMS_ReorderedDocuments_001 | NONCLUSTERED | 47.89 | 24113 | 188.4 | REBUILD |
| DMS | dbo | ManagePeaceAndSaveDetailScope | PK_ManagePeaceAndSaveDetailScope | CLUSTERED | 23.19 | 47378 | 370.1 | REORGANIZE |
| OpheliaSuite | dbo | WF_CASOS | IDX_NC_WF_CASOS_005 | NONCLUSTERED | 25.86 | 36904 | 288.3 | REORGANIZE |
| OpheliaSuite | dbo | WF_CASOS | IDX_NC_WF_CASOS_011 | NONCLUSTERED | 14.74 | 54099 | 422.6 | REORGANIZE |
| DMS | dbo | DMS_Indexes | IDX_NC_DMS_Indexes_002 | NONCLUSTERED | 17.84 | 44388 | 346.8 | REORGANIZE |
| DMS | dbo | ReferencesRequestFile | IDX_NC_ReferencesRequestFile_002 | NONCLUSTERED | 48.35 | 15469 | 120.9 | REBUILD |
| DMS | dbo | Contacts | PK__Contacts__3214EC07786292A4 | CLUSTERED | 14.05 | 52614 | 411.0 | REORGANIZE |
| DMS | dbo | RequestEmail | IDX_RequestEmailV_DateAffairSender | NONCLUSTERED | 30.70 | 23889 | 186.6 | REBUILD |
| DMS | dbo | DMS_Indexes | IDX_NC_DMS_Indexes_001 | NONCLUSTERED | 22.76 | 29835 | 233.1 | REORGANIZE |
| DMS | dbo | RequestFiles | IDX_NC_RequestFiles_006 | NONCLUSTERED | 19.10 | 35190 | 274.9 | REORGANIZE |
| OpheliaSuite | dbo | WF_CASOS | IDX_NC_WF_CASOS_002 | NONCLUSTERED | 19.06 | 35056 | 273.9 | REORGANIZE |
| DMS | dbo | DMS_References | IDX_NC_DMS_References_007 | NONCLUSTERED | 48.58 | 12223 | 95.5 | REBUILD |
| DMS | dbo | RequestFiles | IDX_NC_RequestFiles_004 | NONCLUSTERED | 12.53 | 45491 | 355.4 | REORGANIZE |
| DMS | dbo | RequestFiles | IDX_NC_RequestFiles_015 | NONCLUSTERED | 31.54 | 17824 | 139.3 | REBUILD |
| DMS | dbo | RequestFiles | IDX_NC_RequestFiles_013 | NONCLUSTERED | 28.58 | 17721 | 138.4 | REORGANIZE |
| OpheliaSuite | dbo | WF_ICOMP | PK_WF_ICOMP | CLUSTERED | 4.53 | 100499 | 785.1 | NO ACCION |
| DMS | dbo | RequestFilesStamped | IDX_NC_RequestFilesStamped_001 | NONCLUSTERED | 25.47 | 16673 | 130.3 | REORGANIZE |
| Stage | dbo | RequestFilesExpirationDate | idx_nc_RequestFilesExpirationDate_001 | NONCLUSTERED | 45.61 | 8764 | 68.5 | REBUILD |
| OpheliaSuite | dbo | WF_RCPRO | IN_WF_RCPRO_01 | NONCLUSTERED | 9.61 | 40896 | 319.5 | NO ACCION |
| DMS | dbo | RadicadeHistory | IDX_NC_RadicadeHistory_002 | NONCLUSTERED | 28.30 | 13625 | 106.4 | REORGANIZE |
| DMS | dbo | GeneralErrorsLog | PK__GeneralE__3214EC07DE39B021 | CLUSTERED | 12.45 | 30799 | 240.6 | REORGANIZE |
| Drive | dbo | DRIVE_FOLDER | IDX_NC_DRIVE_FOLDER_002 | NONCLUSTERED | 14.84 | 24759 | 193.4 | REORGANIZE |
| OpheliaSuite | dbo | WF_RCPRO | IDX_NC_WF_RCPRO_002 | NONCLUSTERED | 9.20 | 39887 | 311.6 | NO ACCION |
| DMS | dbo | RequestFiles | DX_NC_RequestFiles_002 | NONCLUSTERED | 27.49 | 13134 | 102.6 | REORGANIZE |
| DMS | dbo | RadicadeHistory | IDX_NC_RadicadeHistory_001 | NONCLUSTERED | 15.67 | 22466 | 175.5 | REORGANIZE |
| OpheliaSuite | dbo | WF_RCPRO | IDX_NC_WF_RCPRO_001 | NONCLUSTERED | 8.47 | 40730 | 318.2 | NO ACCION |
| DMS | dbo | RequestFiles | IX_RequestFiles_MassiveConsecutive | NONCLUSTERED | 34.43 | 9823 | 76.7 | REBUILD |
| Drive | dbo | DRIVE_FOLDER | IDX_NC_DRIVE_FOLDER_001 | NONCLUSTERED | 14.31 | 22606 | 176.6 | REORGANIZE |
| DMS | dbo | RadicadeHistory | IDX_NC_RadicadeHistory_003 | NONCLUSTERED | 34.64 | 9082 | 71.0 | REBUILD |
| OpheliaSuite | dbo | WF_RCPRO | PK_WF_RCPRO | CLUSTERED | 4.71 | 65286 | 510.0 | NO ACCION |
| DMS | dbo | Events | PK__Events__3214EC07909701ED | CLUSTERED | 31.96 | 9597 | 75.0 | REBUILD |
| OpheliaSuite | dbo | WF_RCPRO | IDX_NC_WF_RCPRO_003 | NONCLUSTERED | 7.49 | 39757 | 310.6 | NO ACCION |
| DMS | dbo | Representatives | PK_Representatives | CLUSTERED | 45.16 | 6550 | 51.2 | REBUILD |
| DMS | dbo | RequestFiles | IX_RequestFiles_FiledDate | NONCLUSTERED | 26.87 | 10925 | 85.4 | REORGANIZE |
| DMS | dbo | SmartReportedComplaintFiles | PK__SmartRep__3214EC07AFE49E42 | CLUSTERED | 45.24 | 5130 | 40.1 | REBUILD |
| Drive | dbo | FILE_METADATA | PK_FILE_METADATA | CLUSTERED | 99.22 | 2295 | 17.9 | REBUILD |
| DMS | dbo | DMS_References | PK__tmp_ms_x__3214EC0766F9A7BB | CLUSTERED | 14.07 | 16036 | 125.3 | REORGANIZE |
| DMS | dbo | Representatives | IDX_NC_Representatives_003 | NONCLUSTERED | 37.67 | 5840 | 45.6 | REBUILD |
| OpheliaSuite | dbo | WF_CASOS | PK_WF_CASOS | CLUSTERED | 1.19 | 174171 | 1360.7 | NO ACCION |
| DMS | dbo | RequestFileHistories | IDX_NC_RequestFileHistories_001 | NONCLUSTERED | 0.44 | 379822 | 2967.4 | NO ACCION |
| DMS | dbo | SmartProcessLog | PK__SmartPro__3214EC07387BAEFF | CLUSTERED | 46.94 | 3364 | 26.3 | REBUILD |
| DMS | dbo | DMS_References | IDX_NC_DMS_References_009 | NONCLUSTERED | 42.11 | 3726 | 29.1 | REBUILD |
| DMS | dbo | RequestFileHistories | IDX_NC_RequestFileHistories_004 | NONCLUSTERED | 0.85 | 180095 | 1407.0 | NO ACCION |
| DMS | dbo | CopiesCommunication | IDX_NC_CopiesCommunication_001 | NONCLUSTERED | 29.35 | 5213 | 40.7 | REORGANIZE |
| DMS | dbo | ManagePeaceAndSaveDetailScope | IDX_NC_ManagePeaceAndSaveDetailScope_001 | NONCLUSTERED | 5.21 | 28316 | 221.2 | NO ACCION |
| DMS | dbo | Clients | PK__Clients__3214EC075B672D4A | CLUSTERED | 5.37 | 25937 | 202.6 | NO ACCION |
| DMS | dbo | RequestFileHistories | PK__RequestF__3214EC07B438AE64 | CLUSTERED | 0.37 | 361364 | 2823.2 | NO ACCION |
| DMS | dbo | Contacts | IDX_NC_Contacts_001 | NONCLUSTERED | 15.61 | 6731 | 52.6 | REORGANIZE |
| DMS | dbo | Representatives | IDX_NC_Representatives_001 | NONCLUSTERED | 27.64 | 3672 | 28.7 | REORGANIZE |
| DMS | dbo | RequestFileHistories | IDX_NC_RequestFileHistories_002 | NONCLUSTERED | 0.46 | 204152 | 1594.9 | NO ACCION |
| DMS | dbo | RequestFiles | IDX_NC_RequestFiles_016 | NONCLUSTERED | 5.35 | 17391 | 135.9 | NO ACCION |
| DMSGDEA | dbo | DIMRADICACION | Pk_Radicacion | CLUSTERED | 48.76 | 1848 | 14.4 | REBUILD |
| DMS | dbo | RequestFileHistories | IDX_NC_RequestFileHistories_006 | NONCLUSTERED | 0.48 | 179407 | 1401.6 | NO ACCION |
| DMS | dbo | PQRSDWebProcessLog | IX_PQRSDWebProcessLog_BeginQueue | NONCLUSTERED | 17.55 | 4444 | 34.7 | REORGANIZE |
| DMS | dbo | DMS_ReferencesSummary | IX_DMS_ReferencesSummary_001 | NONCLUSTERED | 47.08 | 1576 | 12.3 | REBUILD |
| OpheliaSuite | dbo | WF_PROCESS_QUEUE | PK_WF_PROCESS_QUEUE | CLUSTERED | 0.68 | 75086 | 586.6 | NO ACCION |
| OpheliaSuite | dbo | WF_DEVOL | PK_WF_DEVOL | CLUSTERED | 33.97 | 1107 | 8.6 | REBUILD |