Diagnóstico SQL Server - DWSGDASQL2

Resumen Ejecutivo SQL

RAM libre host6.81 GB
Memoria SQL comprometida43.94 GB
Page Life Expectancy494 s
Conexiones SQL1767
Volúmenes SQL bajos1
Bloqueos activos0
Bases de datos20
Transacciones abiertas77
Tareas en cola (Q)31
Índices REBUILD48
Logs críticos5
Jobs fallidos11
Autogrowths 7 días50
Deadlocks0

Servidor SQL: SRVCLSGDEA\SGDEAPRY,1633

Host: DWSGDASQL2

Fecha: 06/03/2026 11:40:44

Recomendaciones

Alertas consolidadas

Información del sistema

CSNameCaptionVersionLastBootUpTimeTotalRAMGBFreeRAMGB
DWSGDASQL2Microsoft Windows Server 2019 Standard10.0.177635/24/2026 12:01:11 AM606.81

CPU

NameNumberOfCoresNumberOfLogicalProcessorsMaxClockSpeed
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900

Discos

DeviceIDVolumeNameSizeGBFreeGBFreePercent
C:179.4121.3867.66
D:TEMP299.9878.5826.19
E:DATA5222.38703.6513.47
F:LOG299.98243.8181.28
G:BACKUPS499.98321.9164.38
Q:New Volume19.9819.3696.91
S:Spool299.98287.3695.79

Contadores de rendimiento - muestra 1 minuto

CounterMinMaxAverage
\\dwsgdasql2\processor(_total)\% processor time17.8237.7227.74
\\dwsgdasql2\memory\available mbytes654470866733.75
\\dwsgdasql2\system\processor queue length010.08
\\dwsgdasql2\physicaldisk(_total)\% disk time1.510.444.67
\\dwsgdasql2\physicaldisk(_total)\current disk queue length020.42

Información SQL Server

ServerNameEditionProductLevelProductVersionCollationStartTime
SRVCLSGDEA\SGDEAPRYEnterprise Edition: Core-based Licensing (64-bit)RTM15.0.4316.3SQL_Latin1_General_CP1_CI_AS5/29/2026 2:34:52 AM

Memoria SQL

PhysicalMemoryMBCommittedMBCommittedTargetMBPageLifeExpectancySecBufferCacheHitRatio
61439449994500049411636

Bases de datos

DatabaseNameStateRecoveryModelCompatibilityLevelSizeMBCreateDate
OpheliaSuiteONLINEFULL15044750261/25/2023 11:42:38 AM
tempdbONLINESIMPLE1502243785/29/2026 2:36:28 AM
DMSONLINEFULL1501219893/9/2024 11:45:05 PM
StageONLINEFULL150350185/8/2023 11:39:48 AM
DriveONLINEFULL1503473211/9/2023 7:00:50 PM
DMS_bk_040923ONLINEFULL15050119/4/2023 11:54:28 AM
DMS_BK_20ONLINEFULL15021956/21/2023 3:24:03 PM
AgoraSSBONLINEFULL15054012/1/2023 10:18:55 PM
msdbONLINEFULL1502639/24/2019 2:21:42 PM
EstructuraImportacionONLINEFULL1501122/24/2024 11:16:01 AM
ImperiumReportCacheONLINEFULL1501122/28/2026 8:36:43 PM
AgoraSSB_OLDONLINEFULL150825/29/2024 3:42:38 PM
DMS_2ONLINEFULL150811/31/2023 8:44:52 AM
modelONLINEFULL150804/8/2003 9:13:36 AM
DBAONLINEFULL150809/29/2023 9:16:16 AM
DMSGDEAONLINEFULL150766/23/2023 10:34:45 AM
DWMaintenanceONLINEFULL150352/6/2023 4:32:54 PM
ProcessTableONLINEFULL150191/25/2023 11:41:51 AM
CalendarioONLINEFULL150111/25/2023 11:40:30 AM
masterONLINESIMPLE15064/8/2003 9:13:36 AM

Conexiones por aplicación

program_namehost_namelogin_nameconnections
MicroSQLDWSGDAAPP1opheliadms348
MicroSQLDWSGDAAPP3opheliadms344
MicroSQLDWSGDAAPP2opheliadms305
MicroSQLDWSGDAAPP1ophelia127
MicroSQLDWSGDAAPP3ophelia119
MicroSQLDWSGDAAPP2ophelia104
ODKDWSGDAAPP1ophelia90
MicroSQLDWSGDAAPP4opheliadms85
ODKDWSGDAAPP3ophelia48
ODKDWSGDAAPP2ophelia33
Core Microsoft SqlClient Data ProviderDWSGDAAPP3opheliadms29
Core Microsoft SqlClient Data ProviderDWSGDAAPP1opheliadms18
Core Microsoft SqlClient Data ProviderDWSGDAAPP2opheliadms13
DWSGDAAPP2ophelia10
DWSGDAAPP3ophelia9
DWSGDAAPP1ophelia9
.Net SqlClient Data ProviderFASECOLDAVMmonitoreosaas5
Core Microsoft SqlClient Data ProviderDWSGDAAPP2ophelia5
Microsoft SQL Server Management StudioDWSGDASQL2DIGITALWARE\JeisonCR5
Core Microsoft SqlClient Data ProviderDWSGDAAPP1ophelia5
Core Microsoft SqlClient Data ProviderDWSGDAAPP3ophelia4
Microsoft SQL Server Management Studio - ConsultaDW-P10961ophelia3
Microsoft SQL Server Management Studio - ConsultaDW-P10966ophelia3
Microsoft SQL Server Management StudioDW-P10966ophelia3
Core .Net SqlClient Data ProviderDWSGDAAPP1ophelia3
Core .Net SqlClient Data ProviderDWSGDAAPP3ophelia3
Core .Net SqlClient Data ProviderDWSGDAAPP2ophelia3
Core Microsoft SqlClient Data ProviderDWSGDAAPP4ophelia2
Core Microsoft SqlClient Data ProviderDWSGDAMON2opheliadms2
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP1ophelia2
Microsoft SQL Server Management Studio - QueryDW-P10840ophelia2
Microsoft SQL Server Management Studio - QueryDWSGDASQL2DIGITALWARE\JeisonCR2
Microsoft SQL Server Management Studio - QueryDW-P10326ophelia2
Microsoft SQL Server Management Studio - QueryDW-P10785ophelia1
Microsoft® Windows® Operating SystemDWSGDASQL2NT AUTHORITY\SYSTEM1
MicroSQLDWSGDAAPP11
Microsoft SQL Server Management Studio - QueryDW-P1722ophelia1
Microsoft SQL Server Management StudioDW-P10967ophelia1
Microsoft SQL Server Management StudioDW-P1722ophelia1
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP2ophelia1
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP3ophelia1
Microsoft SQL Server Management StudioDW-P10840ophelia1
Microsoft SQL Server Management StudioDW-P10934ophelia1
Core .Net SqlClient Data ProviderDWSGDAAPP2Opheliasuitebi1
Core .Net SqlClient Data ProviderDWSGDAAPP1Opheliasuitebi1
.Net SqlClient Data ProviderDWSGDASQL2ophelia1
MicroSQLDWSGDAAPP31
SQL Server Management StudioDW-P10815ophelia1
SQL Server Management StudioDW-P10961ophelia1
SQLAgent - Contained AGSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLAgent - Email LoggerSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLAgent - Generic RefresherSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLAgent - Job invocation engineSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLServerCEIPSRVCLSGDEANT SERVICE\SQLTELEMETRY$SGDEAPRY1
Zabbix agent 2 MSSQL pluginDWSGDASQL2zbx_monitor1

Sesiones activas

session_idlogin_namehost_nameprogram_namestatuscommandwait_typewait_timecpu_timelogical_readsDatabaseName
1271opheliaDWSGDAAPP1Core .Net SqlClient Data ProviderrunningSELECT093045109DMS
1383DWSGDAAPP1MicroSQLrunningSELECT053713238OpheliaSuite
51NT AUTHORITY\SYSTEMDWSGDASQL2Microsoft® Windows® Operating SystemrunningEXECUTESP_SERVER_DIAGNOSTICS_SLEEP21137633master
1663opheliaDWSGDASQL2.Net SqlClient Data ProviderrunningSELECT0100master
1708DWSGDAAPP3MicroSQLrunningSELECTASYNC_NETWORK_IO33574AgoraSSB
1814opheliaDWSGDAAPP1runningTM REQUEST000OpheliaSuite

Bloqueos activos

No hay datos.

Transacciones abiertas (> 5 seg)

SessionIdHostAplicacionUsuarioInicioTransaccionSegundosAbiertaTipoTransaccionUltimaConsulta
263DWSGDAAPP2MicroSQLophelia6/3/2026 8:07:34 AM12598Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
404DWSGDAAPP3MicroSQLophelia6/3/2026 8:09:06 AM12506Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
423DWSGDAAPP2MicroSQLophelia6/3/2026 8:20:10 AM11842Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
358DWSGDAAPP3MicroSQLophelia6/3/2026 8:20:18 AM11834Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
383DWSGDAAPP2MicroSQLophelia6/3/2026 8:23:32 AM11640Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
62DWSGDAAPP3MicroSQLophelia6/3/2026 8:26:14 AM11478Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
294DWSGDAAPP3MicroSQLophelia6/3/2026 8:35:00 AM10952Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
74DWSGDAAPP3MicroSQLophelia6/3/2026 8:35:17 AM10935Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
514DWSGDAAPP2MicroSQLophelia6/3/2026 8:37:02 AM10830Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
245DWSGDAAPP3MicroSQLophelia6/3/2026 8:37:02 AM10830Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
632DWSGDAAPP2MicroSQLophelia6/3/2026 8:39:18 AM10694Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
482DWSGDAAPP1MicroSQLophelia6/3/2026 8:40:36 AM10616Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
473DWSGDAAPP1MicroSQLophelia6/3/2026 8:43:00 AM10472Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
114DWSGDAAPP1MicroSQLophelia6/3/2026 8:44:57 AM10355Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
87DWSGDAAPP2MicroSQLophelia6/3/2026 8:46:31 AM10261Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
60DWSGDAAPP2MicroSQLophelia6/3/2026 8:48:06 AM10166Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
513DWSGDAAPP2MicroSQLophelia6/3/2026 8:49:09 AM10103Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
742DWSGDAAPP3MicroSQLophelia6/3/2026 8:53:16 AM9856Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
617DWSGDAAPP3MicroSQLophelia6/3/2026 8:54:24 AM9788Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
346DWSGDAAPP2MicroSQLophelia6/3/2026 8:54:24 AM9788Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
406DWSGDAAPP1MicroSQLophelia6/3/2026 8:56:10 AM9682Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
128DWSGDAAPP3MicroSQLophelia6/3/2026 8:57:09 AM9623Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
351DWSGDAAPP2MicroSQLophelia6/3/2026 8:58:37 AM9535Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
454DWSGDAAPP1MicroSQLophelia6/3/2026 8:59:19 AM9493Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
614DWSGDAAPP3MicroSQLophelia6/3/2026 9:00:39 AM9413Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
466DWSGDAAPP1MicroSQLophelia6/3/2026 9:03:59 AM9213Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
267DWSGDAAPP3MicroSQLophelia6/3/2026 9:05:36 AM9116Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
677DWSGDAAPP2MicroSQLophelia6/3/2026 9:15:37 AM8515Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
326DWSGDAAPP1MicroSQLophelia6/3/2026 9:19:16 AM8296Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
149DWSGDAAPP2MicroSQLophelia6/3/2026 9:28:13 AM7759Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
259DWSGDAAPP3MicroSQLophelia6/3/2026 9:29:16 AM7696Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
264DWSGDAAPP3MicroSQLophelia6/3/2026 9:31:32 AM7560Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
972DWSGDAAPP1MicroSQLophelia6/3/2026 9:35:10 AM7342Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
708DWSGDAAPP3MicroSQLophelia6/3/2026 9:44:46 AM6766Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
525DWSGDAAPP1MicroSQLophelia6/3/2026 9:46:29 AM6663Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
340DWSGDAAPP2MicroSQLophelia6/3/2026 9:58:38 AM5934Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
942DWSGDAAPP2MicroSQLophelia6/3/2026 9:59:23 AM5889Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
112DWSGDAAPP1MicroSQLophelia6/3/2026 10:00:06 AM5846Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1056DWSGDAAPP1MicroSQLophelia6/3/2026 10:00:36 AM5816Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
736DWSGDAAPP3MicroSQLophelia6/3/2026 10:01:10 AM5782Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
704DWSGDAAPP3MicroSQLophelia6/3/2026 10:05:20 AM5532Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
639DWSGDAAPP1MicroSQLophelia6/3/2026 10:08:22 AM5350Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
695DWSGDAAPP3MicroSQLophelia6/3/2026 10:08:47 AM5325Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1033DWSGDAAPP2MicroSQLophelia6/3/2026 10:09:21 AM5291Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1057DWSGDAAPP2MicroSQLophelia6/3/2026 10:12:40 AM5092Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
455DWSGDAAPP3MicroSQLophelia6/3/2026 10:16:45 AM4847Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
687DWSGDAAPP3MicroSQLophelia6/3/2026 10:18:48 AM4724Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1269DWSGDAAPP2MicroSQLophelia6/3/2026 10:20:59 AM4593Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
624DWSGDAAPP3MicroSQLophelia6/3/2026 10:32:11 AM3921Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
53DWSGDAAPP2MicroSQLophelia6/3/2026 10:32:36 AM3896Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
265DWSGDAAPP1MicroSQLophelia6/3/2026 10:36:48 AM3644Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
280DWSGDAAPP1MicroSQLophelia6/3/2026 10:47:03 AM3029Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1167DWSGDAAPP2MicroSQLophelia6/3/2026 10:49:42 AM2870Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1186DWSGDAAPP2MicroSQLophelia6/3/2026 10:50:11 AM2841Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
898DWSGDAAPP2MicroSQLophelia6/3/2026 10:58:17 AM2355Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
334DWSGDAAPP3MicroSQLophelia6/3/2026 11:05:29 AM1923Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
950DWSGDAAPP2MicroSQLophelia6/3/2026 11:07:15 AM1817Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1209DWSGDAAPP1MicroSQLophelia6/3/2026 11:08:30 AM1742Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
309DWSGDAAPP2MicroSQLophelia6/3/2026 11:10:14 AM1638Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
392DWSGDAAPP3MicroSQLophelia6/3/2026 11:10:16 AM1636Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
481DWSGDAAPP1MicroSQLophelia6/3/2026 11:10:38 AM1614Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1420DWSGDAAPP3MicroSQLophelia6/3/2026 11:10:47 AM1605Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
893DWSGDAAPP2MicroSQLophelia6/3/2026 11:12:09 AM1523Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
568DWSGDAAPP2MicroSQLophelia6/3/2026 11:13:06 AM1466Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1427DWSGDAAPP3MicroSQLophelia6/3/2026 11:13:06 AM1466Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
966DWSGDAAPP1MicroSQLophelia6/3/2026 11:17:25 AM1207Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
545DWSGDAAPP3MicroSQLophelia6/3/2026 11:20:15 AM1037Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
826DWSGDAAPP1MicroSQLophelia6/3/2026 11:21:06 AM986Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
363DWSGDAAPP3MicroSQLophelia6/3/2026 11:21:06 AM986Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1308DWSGDAAPP2MicroSQLophelia6/3/2026 11:25:51 AM701Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
175DWSGDAAPP3MicroSQLophelia6/3/2026 11:34:30 AM182Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1431DWSGDAAPP3MicroSQLophelia6/3/2026 11:35:06 AM146Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
250DWSGDAAPP2MicroSQLophelia6/3/2026 11:35:20 AM132Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
889DWSGDAAPP2MicroSQLophelia6/3/2026 11:36:27 AM65Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1810DWSGDAAPP2ophelia6/3/2026 11:37:11 AM21Read/Write(@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL, PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH FROM WF_PSWET WHERE PAR_TYPE='HEADER' AND EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2
1726DWSGDAAPP2ophelia6/3/2026 11:37:26 AM6Read/Write(@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL, PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH FROM WF_PSWET WHERE PAR_TYPE='HEADER' AND EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2
1797DWSGDAAPP2ophelia6/3/2026 11:37:26 AM6Read/Write(@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(4),@_3 INT)SELECT PTL_REGI FROM WF_FPLAN WHERE EMP_CODI= @ AND CAS_CONT= @_1 AND PTL_CODI= @_2 AND PTL_VERS= @_3

Wait Stats

wait_typewaiting_tasks_countwait_time_msAvgWaitMssignal_wait_time_ms
SOS_WORK_DISPATCHER6069205959515514286980.0033132815
CXPACKET10554277310127723919.0028350457
CXCONSUMER2227112548471550113.0054972374
PAGEIOLATCH_SH730814401168876771.004273401
ASYNC_NETWORK_IO75142909358881512.002454503
PREEMPTIVE_XE_DISPATCHER68579484114299140.000
BACKUPBUFFER61570308204756213.004716144
LCK_M_IS38397717328020102.003367
SOS_SCHEDULER_YIELD87488479755809160.0075393914
BACKUPIO22652904850017621.001186595
ASYNC_IO_COMPLETION3733408075991369.0069
BPSORT9297012296715083.004084711
LCK_M_IX15042039519313560.001541
LATCH_EX7041410169353322.003257926
PAGEIOLATCH_EX2992576128005394.00357948
PARALLEL_REDO_WORKER_WAIT_WORK1690398108029516.0021139
WRITELOG2052228105594955.001070682
LCK_M_X2515100486673995.006471
LCK_M_SCH_S904958445710602.001170
LCK_M_S383167293441756.001831

Guía de lectura - Wait Stats

WaitQué indicaQué revisar
CXPACKET / CXCONSUMERParalelismo. No siempre es problema; puede ser normal en consultas grandes.MAXDOP, Cost Threshold for Parallelism, planes de ejecución y consultas con alto CPU/lecturas.
PAGEIOLATCH_SH / PAGEIOLATCH_EXLectura de páginas desde disco hacia memoria.Índices faltantes, scans grandes, presión de memoria, latencia de discos.
ASYNC_NETWORK_IOSQL espera a que la aplicación cliente consuma resultados.Aplicaciones que leen lento, redes, consultas que devuelven demasiadas filas.
LCK_M_*Bloqueos entre sesiones.Transacciones largas, índices ausentes, orden de acceso, aislamiento y consultas de escritura.
WRITELOGEscritura al transaction log.Latencia del disco de logs, transacciones grandes, backups de log, crecimiento del LDF.
SOS_SCHEDULER_YIELDPresión de CPU o consultas que consumen mucho procesador.Top queries CPU, paralelismo, planes, funciones escalares, consultas no sargables.
BACKUPIO / BACKUPBUFFERActividad asociada a backups.Horario de backups, duración, destino, solapamiento con operación.
PREEMPTIVE_XE_DISPATCHER / SOS_WORK_DISPATCHEREsperas internas/Extended Events. Pueden aparecer altas por acumulado histórico.No concluir solo por total acumulado. Comparar deltas entre ejecuciones del reporte.

Uso: Wait Stats sirve para identificar el tipo de cuello de botella dominante: CPU, disco, bloqueos, red, log o paralelismo. Para monitoreo real conviene guardar histórico y comparar deltas, porque la DMV es acumulada desde el último reinicio de SQL Server.

Top Queries CPU

ExecutionsCPUTimeMsAvgCPUMsElapsedMsLogicalReadsQueryText
198396515320026903197156695970SELECT [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
1209229748992464130191119370782WITH profiled_sessions as ( SELECT DISTINCT session_id profiled_session_id from sys.dm_exec_query_profiles ) SELECT [Session ID] = s.session_id, [User Process] = CONVERT(CHAR(1), s.is_user_process), [Login] = s.login_name, [Database] = CASE WHEN s.database_id=0 THEN N'' ELSE ISNULL(db_name(s.database_id),N'') END, [Task State] = ISNULL(t.task_state, N''), [Command] = ISNULL(r.command, N''), [Application] = ISNULL(s.program_name, N''), [Wait Time (ms)] = ISNULL(w.wait_duration_ms, 0), [Wait Type] = ISNULL(w.wait_type, N''), [Wait Resource] = ISNULL(w.resource_description, N''), [Blocked By] = ISNULL(CONVERT (varchar, w.blocking_session_id), ''), [Head Blocker] = CASE -- session has an active request, is blocked, but is blocking others or session is idle but has an open tran and is blocking others WHEN r2.session_id IS NOT NULL AND (r.blocking_session_id = 0 OR r.session_id IS NULL) THEN '1' -- session is either not blocking someone, or is blocking someone but is blocked by another party ELSE '' END, [Total CPU (ms)] = s.cpu_time, [Total Physical I/O (MB)] = (s.reads + s.writes) * 8 / 1024, [Memory Use (KB)] = s.memory_usage * (8192 / 1024), [Open Transactions] = ISNULL(r.open_transaction_count,0), [Login Time] = s.login_time, [Last Request Start Time] = s.last_request_start_time, [Host Name] = ISNULL(s.host_name, N''), [Net Address] = ISNULL(c.client_net_address, N''), [Execution Context ID] = ISNULL(t.exec_context_id, 0), [Request ID] = ISNULL(r.request_id, 0), [Workload Group] = ISNULL(g.name, N''), [Profiled Session Id] = profiled_session_id FROM sys.dm_exec_sessions s LEFT OUTER JOIN sys.dm_exec_connections c ON (s.session_id = c.session_id) LEFT OUTER JOIN sys.dm_exec_requests r ON (s.session_id = r.session_id) LEFT OUTER JOIN sys.dm_os_tasks t ON (r.session_id = t.session_id AND r.request_id = t.request_id) OUTER APPLY ( -- In some cases (e.g. parallel queries, also waiting for a worker), one thread can be flagged as -- waiting for several different threads. This will cause that thread to show up in multiple rows -- in our grid, which we don't want. SELECT TOP 1 * FROM sys.dm_os_waiting_tasks wt WHERE wt.waiting_task_address = t.task_address ORDER BY wt.wait_duration_ms desc ) w LEFT OUTER JOIN sys.dm_exec_requests r2 ON (s.session_id = r2.blocking_session_id) LEFT OUTER JOIN sys.dm_resource_governor_workload_groups g ON (g.group_id = s.group_id) LEFT OUTER JOIN profiled_sessions ON profiled_session_id = s.session_id ORDER BY s.session_id
66128666424336336061632130205SELECT DISTINCT RF.IdRadicado, RF.Radicado, RF.Fecha, CN.[Name] AS 'Canal', RF.[Tipo de persona], TD.Name AS 'Tipo de identificación', CL.NumberIdentification AS 'Número de identificación', RF.Entidad, RF.Destinatario AS 'Nombres y apellidos remitente', CL.Id AS 'Id Cliente', CT.Id AS 'Id Contacto', RF.País, RF.Departamento, RF.Ciudad, RF.Dirección, RF.[Correo electrónico], RF.Asunto, RF.Folios, RFD.Attachments AS 'Número de anexos', RF.[Descripción de anexos], RF.Compañía, RF.Dependencia, CONCAT(DP.NameSolicitud, ' / ', LTRIM(RTRIM(DP.NameDetalle)), IIF(ISNULL(DP.NameEspecificacion, '0') = '0', NULL, ' / '), DP.NameEspecificacion) AS 'Trámite', RFD.UserName AS 'Usuario Radicador', RF.FuncionarioResponsable 'Responsable', 'https://tinyurl.com/5e6yz5u9' AS QR FROM GETDATABYRADICATE_VW RF INNER JOIN REQUESTFILE_VW RFD ON RFD.Id = RF.IdRadicado INNER JOIN CANAL_VW CN ON CN.Id = RFD.ChannelId INNER JOIN CLIENTS_VW CL ON CL.Id = RFD.ClientId INNER JOIN CONTACTS_VW CT ON CT.Id = RFD.ContactId INNER JOIN TypeDetail TD ON TD.Id = CL.DocumentTypeId INNER JOIN DMSProcedureNew_VW DP ON RFD.ProcedureId = DP.IdProcedure WHERE RF.Radicado = @Radicado
6671557840233545583030296171SELECT DISTINCT RF.Radicado, RF.Fecha, RF.[Tipo de persona], RF.Entidad, RF.Destinatario, RF.País, RF.Departamento, RF.Ciudad, RF.Dirección, RF.[Correo electrónico], RF.Asunto, RF.[Cuerpo del mensaje], RF.Folios, RF.[Descripción de anexos], RF.[Canal de envío], RF.Elaboró, RF.Revisó, RF.Aprobó, RF.Compañía, RF.Dependencia, RF.Funcionario, RF.Cargo, RF.TFirma, RF.[Firma Firmante], RF.[Cargo destinatario], ISNULL (RF.CollaborativeWorkName, '1') AS 'CollaborativeWorkName', RF.CollaborativeWorkBody FROM GETDATABYRADICATE_VW RF WHERE RF.Radicado = @Radicado
1536128115383414604231158SELECT 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'
11182943118294364140794274643INSERT INTO Stage.dbo.RadicacionVentUnica SELECT RequestFiles.Id as [RequestFilesId], RequestFiles.FileNumber AS [Radicado], -- Número de radicación CAST(RequestFiles.FiledDate AS DATETIME) AS [Fecha y Hora Radicacion], CAST(RequestFiles.FiledDate AS DATE) AS [Fecha Radicacion], -- Fecha de radicación CAST(RequestFiles.FiledDate AS TIME(0)) AS [Hora Radicacion], -- Hora de radicación TIPORADICADO.Name AS [Tipo Radicado], -- Tipo de radicación -- Determinar el usuario actual IIF(Users.Name + Users.Surnames IS NULL, 'La información del usuario en el sistema ' + COALESCE(WF_SEGUI_PEN.SEG_UENC, RequestFileHistories.UserName, Users1.UserName) + ' no es correcta', CONCAT(Users.Name, ' ', Users.Surnames) ) AS [Usuario Actual], dep.Vicepresidencia AS [Vicepresidencia], -- Vicepresidencia dep.Dependencia AS [Dependencia Actual], -- Dependencia actual ESTADO.Name AS [PROCESO], -- Estado del proceso ISNULL(DocumentType.Name, 'No Definido') AS [Tipo de Documento], -- Tipo de documento -- Definir el medio de recepción CASE WHEN TIPORADICADO.Name = 'Comunicación Interna' THEN 'Correo electrónico' ELSE CANAL.Name END AS [Medio de Recepcion], --Determinar el tipo de remitente ISNULL(TYPEPERSON_VW.Name, TYPEPERSON_VW1.Name) AS [Tipo Remitente], --Determinar el remitente CASE WHEN TYPEPERSON_VW.Name = 'Anónimo' OR TYPEPERSON_VW1.Name = 'Anónimo' THEN 'Anónimo' WHEN TYPEPERSON_VW.Name IN ('Persona Natural', 'Apoderado / Representante Legal') --OR TYPEPERSON_VW1.Name IN ('Persona Natural', 'Apoderado / Representante Legal') --THEN IIF(CONCAT(Contacto.Names, ' ', Contacto.Surnames) IS NULL, CONCAT(Clients.NamesClients, ' ', Clients.SurNames), CONCAT(Clients1.NamesClients, ' ', Clients1.SurNames)) --113839 Aranda 12-09-2025 donde se evidencia error en remitente por lo cual se realiza validación que priorice el dato de contacto THEN COALESCE(IIF (Contacto.Names IS NOT NULL OR Contacto.SurNames IS NOT NULL, CONCAT(Contacto.Names, ' ', Contacto.SurNames),NULL), IIF(Clients.NamesClients IS NOT NULL OR Clients.SurNames IS NOT NULL, CONCAT(Clients.NamesClients, ' ', Clients.SurNames),NULL), IIF(Clients1.NamesClients IS NOT NULL OR Clients1.SurNames IS NOT NULL, CONCAT(Clients1.NamesClients, ' ', Clients1.SurNames),NULL) ) ELSE CASE WHEN Contacto.BusinessName IS NOT NULL THEN Contacto.BusinessName WHEN Clients.BusinessName IS NOT NULL THEN Clients.BusinessName WHEN Clients1.BusinessName IS NOT NULL THEN Clients1.BusinessName ELSE IIF(CONCAT(Contacto.Names, ' ', Contacto.Surnames) IS NULL, CONCAT(Clients.NamesClients, ' ', Clients.SurNames), CONCAT(Clients1.NamesClients, ' ', Clients1.SurNames)) END END AS [Remitente], TIPODOCUMENTOREMITENTE.Name AS [Tipo Documento Remitente], -- Tipo de documento del remitente ISNULL(Contacto.NumberIdentification, Clients1.NumberIdentification) AS [Documento Remitente], -- Número de identificación del remitente ISNULL(Contacto.Address, Clients.Address) AS [Direccion Remitente], -- Dirección del remitente ISNULL(Contacto.Mobile, Clients.Mobile) AS [Celular], -- Celular del remitente ISNULL(Contacto.Telephone, Clients.Phone) AS [Telefono], -- Teléfono del remitente CITY.Description AS [Ciudad], -- Ciudad del remitente DEPARTMENT.Description AS [Departamento], -- Departamento del remitente ISNULL(Contacto.Email, Clients1.Email) AS [Email], -- Email del remitente -- Información sobre la radicación CONCAT(Users1.Name, ' ', Users1.Surnames) AS [Usuario Radicador], -- Usuario que radicó Dependencies1.Name AS [Dependencia Radicacion], -- Dependencia donde se radicó CAST(RequestFiles.ExperationDate AS DATE) AS [Fecha Vencimiento], -- Fecha de vencimiento CAST(RequestFiles.ExperationDate AS Time(0)) AS [Hora Vencimiento], -- Hora de vencimiento ORIGEN.Name AS [Tipo Comunicacion], -- Tipo de comunicación DMS_Procedures.ResponseTime AS [Dias Habiles de Respuesta], -- Días hábiles para respuesta -- Documentos adjuntos RequestFiles.Pages AS [Folios], -- Cantidad de folios RequestFiles.Attachments AS [Anexos], -- Cantidad de anexos -- Tipificación del procedimiento CONCAT(NameType.Name, ' ', ProcedureType.Name, ' ', SpecificationType.Name) AS [Tipificacion], -- Información del asunto RequestFiles.Subject AS [Asunto], -- Asunto del radicado -- Estado del radicado COALESCE( CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CONVERT(DATE,RequestFilesRespuestaDefinitiva.FiledDate) <=CONVERT(DATE,RequestFiles.ExperationDate)--22/10/2024 Se cambia campo RequestFilesExpirationDate.ExpirationDateFinal THEN 'En Tiempo'--'TRAMITADO OPORTUNAMENTE' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CONVERT(DATE,RequestFilesRespuestaDefinitiva.FiledDate)>CONVERT(DATE,RequestFiles.ExperationDate) THEN 'Vencido'--'TRAMITADO EXTEMPORALMENTE' END ,CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND CONVERT(DATE,RequestFiles.ExperationDate) < GETDATE()-1 THEN 'Vencido' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND DATEDIFF(DAY,GETDATE(),CONVERT(DATE,RequestFiles.ExperationDate)) IN (0,1,2,3) THEN 'Proximo a Vencer' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND DATEDIFF(DAY,GETDATE(),CONVERT(DATE,RequestFiles.ExperationDate)) >3 THEN 'En Tiempo' END ,CASE WHEN ESTADO.Name NOT IN ('Finalizado','Envío electrónico','Comunicación pendiente por clasificar','Comunicación Clasificada','Pendiente en la dependencia','Finalizado por Solicitud del Usuario') AND TIPORADICADO.Name='Salida' THEN 'Elaboración' END )[Estado Radicado], --COALESCE( -- -- Si existe fecha de radicación, evaluamos si fue en tiempo o vencido -- CASE -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL -- AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) <= CAST(RequestFiles.ExperationDate AS DATE) -- THEN 'En Tiempo' -- Tramitado oportunamente -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL -- AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) > CAST(RequestFiles.ExperationDate AS DATE) -- THEN 'Vencido' -- Tramitado extemporáneamente -- END, -- -- Si no existe fecha de radicación, evaluamos su estado según la fecha de expiración -- CASE -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND CAST(RequestFiles.ExperationDate AS DATE) < DATEADD(DAY, -1, GETDATE()) -- THEN 'Vencido' -- La expiración ya pasó -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND RequestFiles.ExperationDate - GETDATE() BETWEEN 0 AND 3 -- THEN 'Próximo a Vencer' -- Expira en los próximos 3 días -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND RequestFiles.ExperationDate - GETDATE() > 3 -- THEN 'En Tiempo' -- Todavía en plazo -- END, -- -- Si el estado no es final y es un radicado de salida, se considera en "Elaboración" -- CASE -- WHEN ESTADO.Name NOT IN ( -- 'Finalizado', 'Envío electrónico', 'Comunicación pendiente por clasificar', -- 'Comunicación Clasificada', 'Pendiente en la dependencia', 'Finalizado por Solicitud del Usuario' -- ) -- AND TIPORADICADO.Name = 'Salida' -- THEN 'Elaboración' -- END --) AS [Estado Radicado], -- Información adicional Users1.UserName AS UsuarioFiltro, CAST(MAX(RequestFilesRespuestaParcial.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) AS VARCHAR(30)) AS [Respuesta Parcial], CAST(MAX(RequestFilesRespuestaParcial.FiledDate) OVER(PARTITION BY RequestFiles.FiledDate) AS DATE) AS [Fecha Respuesta Parcial], -- Validaciones de respuestas finales CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND RequestFiles.RequestTypeId = '5449808C-16FF-4BDE-98C7-4C04C76B221B' THEN CAST(MAX(RequestFilesRespuestaDefinitiva.FileNumber) OVER (PARTITION BY RequestFiles.FileNumber) AS VARCHAR(30)) ELSE NULL END AS [Respuesta Final], CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND RequestFiles.RequestTypeId = '5449808C-16FF-4BDE-98C7-4C04C76B221B' THEN CAST(MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER (PARTITION BY RequestFiles.FiledDate) AS DATE) ELSE NULL END AS [Fecha Respuesta Final], -- Información sobre finalización CASE WHEN ESTADO.Name IN('Finalizado', 'Finalizado por Solicitud del Usuario') THEN CAST(RequestFileHistories.CreationDate AS DATE) ELSE NULL END AS [Fecha Finalizado], CASE WHEN ESTADO.Name IN('Finalizado','Finalizado por Solicitud del Usuario') THEN CAST(RequestFileHistories.CreationDate AS Time(0)) ELSE NULL END [Hora Finalizado], CASE WHEN ESTADO.Name IN('Finalizado', 'Finalizado por Solicitud del Usuario') THEN RequestFileHistories.Reason ELSE NULL END AS [Observación Finalizado], RequestFilesRespuestaDefinitiva.ChannelId AS Canal_Respuesta_Final, RequestFilesRespuestaParcial.ChannelId AS Canal_Respuesta_Parcial, Users.Id AS USERID -- Identificador del usuario FROM dms.dbo.RequestFiles LEFT JOIN dms.dbo.RequestFileHistories ON RequestFileHistories.RequestFileId = RequestFiles.Id AND EXISTS (SELECT 1 FROM [Stage].[dbo].[RequestFileHistories_Stage] WHERE RequestFileHistories_Stage.RequestFileHistoriesId = RequestFileHistories.Id AND RequestFileHistories_Stage.RequestPosition = 1) LEFT JOIN dms.dbo.RequestFileHistories RequestFileHistories1 ON RequestFileHistories1.RequestFileId = RequestFiles.Id AND EXISTS (SELECT 1 FROM [Stage].[dbo].[RequestFileHistories_Stage] WHERE RequestFileHistories_Stage.RequestFileHistoriesId = RequestFileHistories1.Id AND RequestFileHistories_Stage.RequestPosition = 0) LEFT JOIN [Stage].[dbo].[Users_Stage] Users1 ON Users1.UserName = RequestFileHistories1.UserName --ok LEFT JOIN OpheliaSuite.dbo.WF_SEGUI_PEN ON WF_SEGUI_PEN.CAS_CONT = RequestFileHistories.CaseId --ok AND WF_SEGUI_PEN.SEG_SUBJ NOT LIKE '%VISUALIZAR INCONSISTENCIA%' LEFT JOIN [Stage].[dbo].[Users_Stage] Users ON Users.UserName = COALESCE(WF_SEGUI_PEN.SEG_UENC,RequestFileHistories.UserName,Users1.UserName) --ok --LEFT JOIN [Stage].[dbo].[Depentencias_Vicepresidencia] Dep ON RequestFileHistories.DependencyId = Dep.id --ok LEFT JOIN (SELECT Dependencies.Id, Dependencies.Name AS Dependencia, CASE WHEN Dependencies.Name in ('DIRECCIÓN SARLAFT', 'UNIDAD DE CONTROL INTERNO DISCIPLINARIO', 'AUDITORIA CORPORATIVA','GERENCIA DE RIESGOS') THEN Dependencies.Name WHEN Dependencies.Name = 'PRESIDENCIA' THEN 'PRESIDENCIA' WHEN N1.Name = 'PRESIDENCIA' THEN Dependencies.Name WHEN N1.Name like '%VICEPRESIDENCIA %' THEN N1.Name WHEN N2.Name like '%VICEPRESIDENCIA %' THEN N2.Name WHEN N3.Name like '%VICEPRESIDENCIA %' THEN N3.Name ELSE '' END AS Vicepresidencia FROM [DMS].[dbo].[Dependencies] LEFT JOIN dms.dbo.Dependencies N1 ON Dependencies.TopSection = N1.Id LEFT JOIN dms.dbo.Dependencies N2 ON N1.TopSection = N2.Id LEFT JOIN dms.dbo.Dependencies N3 ON N2.TopSection = N3.Id where Dependencies.State = '57DC632C-79D5-458A-845B-76F4859F3E75' ) Dep ON COALESCE(RequestFileHistories.DependencyId, RequestFileHistories1.DependencyId) = Dep.id LEFT JOIN ( SELECT Users.UserName, Dependencies.Name, ROW_NUMBER() OVER (PARTITION BY Users.UserName ORDER BY Dependencies.Name ASC) AS Rn FROM [Stage].[dbo].[Users_Stage] Users INNER JOIN DMS.DBO.UsersCompany ON Users.Id=UsersCompany.UserId INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id=UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State=TypeDetail.Id AND TypeDetail.Code = (SELECT MIN(TypeDetail.Code) FROM DMS.DBO.UsersCompany A INNER JOIN DMS.DBO.TypeDetail ON A.State=TypeDetail.Id WHERE UsersCompany.UserId = A.UserId GROUP BY A.UserId)) Dependencies1 ON RequestFileHistories1.UserName = Dependencies1.UserName --ok AND Dependencies1.Rn = '1' LEFT JOIN STAGE.DBO.RequestFilesExpirationDate ON RequestFilesExpirationDate.FileNumber=RequestFiles.FileNumber --OK LEFT JOIN DMS.DBO.TYPEORIGIN_VW ORIGEN ON RequestFiles.OriginId =ORIGEN.Id LEFT JOIN DMS.DBO.TYPEORIGIN_VW TIPORADICADO ON RequestFiles.RequestTypeId =TIPORADICADO.Id LEFT JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))= COALESCE(RequestFileHistories.status, RequestFileHistories1.status) --OK LEFT JOIN DMS.DBO.DocumentType ON DocumentType.Id=RequestFiles.DocumentTypeId LEFT JOIN DMS.DBO.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId --OK LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id=DMS_Procedures.NameTypeId --OK LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id=DMS_Procedures.ProcedureTypeId --OK LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id=DMS_Procedures.SpecificationTypeId --OK LEFT JOIN DMS.DBO.CANAL_VW CANAL ON CANAL.Id=RequestFiles.ChannelId LEFT JOIN DMS.DBO.Contacts Contacto ON Contacto.Id = RequestFiles.ContactId --OK LEFT JOIN DMS.DBO.Clients ON RequestFiles.ClientId=Clients.Id --OK LEFT JOIN DMS.DBO.Clients Clients1 ON Clients1.Id=Contacto.ClientId --OK LEFT JOIN DMS.DBO.TYPEPERSON_VW ON TYPEPERSON_VW.Id=Contacto.TypeContactId --OK LEFT JOIN DMS.DBO.TYPEPERSON_VW TYPEPERSON_VW1 ON TYPEPERSON_VW1.Id=Clients1.PersonTypeId --OK LEFT JOIN DMS.DBO.TYPEIDENTI_VW TIPODOCUMENTOREMITENTE ON Clients1.DocumentTypeId=TIPODOCUMENTOREMITENTE.Id --OK LEFT JOIN DMS.DBO.GeographicsLocationMun_VW CITY ON Contacto.CityId=CITY.Id --OK LEFT JOIN DMS.DBO.GeographicsLocatioDep_VW DEPARTMENT ON Contacto.DepartamentId = DEPARTMENT.Id --OK 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' 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' WHERE RequestFileHistories1.Status != 'e6d67e4a-f545-4d62-b882-5a38a0fc35e2' AND RequestFileHistories.Status != 'e6d67e4a-f545-4d62-b882-5a38a0fc35e2' AND (RequestFileHistories.ProcessCode != 'Combinación de Correspondencia - ' AND RequestFileHistories.ProcessName != 'Respuesta Parcial')
13039902881691035121117858551SELECT 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]
189235289235217944119722552SELECT FileNumber --,MAX(F.FechaTermino)ExpirationDate ,MAX(ISNULL(F1.FechaTermino,[FechaRadicacion]))ExpirationDateInitial --,CASE WHEN ExperationDate >= [FechaRadicacion] THEN ExperationDate ELSE MAX(ISNULL(F1.FechaTermino,[FechaRadicacion]))END ExpirationDateInitial --Se realiza ajuste a campo de acuerdo a validación con Julio INTO FECHAINICIALVENCIMIENTOTEMP FROM ( SELECT DISTINCT RequestFiles.FileNumber ,MIN(RequestFiles.FiledDate) [FechaRadicacion] ,MAX(CASE WHEN RequestFiles1.ResposnseText=2 THEN RequestFiles1.FiledDate END ) [FechaRespuestaParcialMaxima] ,MAX(CASE WHEN RequestFiles1.ResposnseText=1 THEN RequestFiles1.FiledDate END ) [FechaRespuestaFinalMaxima] ,MAX(DMS_Procedures.ResponseTime) ResponseTime --,RequestFiles.ExperationDate --,MAX(F1.FechaTermino) [ExpirationDateInitial] --INTO #FECHAINICIALVENCIMIENTO FROM DMS.dbo.RequestFiles LEFT JOIN DMS.dbo.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId LEFT JOIN DMS.dbo.RequestFileHistories ON RequestFileHistories.RequestFileId=RequestFiles.Id AND RequestFileHistories.CreationDate=(SELECT MAX(CreationDate) FROM DMS.dbo.RequestFileHistories A WHERE A.RequestFileId=RequestFileHistories.RequestFileId) LEFT JOIN DMS.dbo.Dependencies ON Dependencies.Id=RequestFileHistories.DependencyId LEFT JOIN dms.dbo.RelatedRequestFiles ON RelatedRequestFiles.ParentId =RequestFiles.Id LEFT JOIN dms.dbo.RequestFiles RequestFiles1 ON RelatedRequestFiles.requestfileId =CONVERT(VARCHAR(40),RequestFiles1.Id) --WHERE RequestFiles.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' --WHERE RequestFileHistories.CreationDate >= DATEADD(MONTH, -6, GETDATE()) --AND RequestFiles.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' --AND RequestFiles.FileNumber ='20230321376732' WHERE RequestFileHistories.Status <>'E6D67E4A-F545-4D62-B882-5A38A0FC35E2' --AND RequestFileHistories.CreationDate >= DATEADD(MONTH, -6, GETDATE()) --AND RequestFiles.FileNumber IN ('20240323449482','20241073468712','20241013458352') --AND RequestFiles.FileNumber IN ('20241014144082') --AND YEAR(RequestFiles.FiledDate) = 2024 --AND MONTH(RequestFiles.FiledDate) = 10 --AND DAY(RequestFiles.FiledDate) = 30 --AND RequestFiles.FiledDate <> '2024-10-29' --AND RequestFiles.FileNumber <> 0 GROUP BY RequestFiles.FileNumber --,RequestFiles.ExperationDate ,RequestFiles.FiledDate )Vencimiento --CROSS APPLY DBO.FechaTerminoSinDiasInhabiles (CONVERT(date,[FechaRespuestaParcialMaxima]+1),15) F CROSS APPLY DBO.FechaTerminoSinDiasInhabiles (CONVERT(DATE,[FechaRadicacion]+1),ResponseTime) F1 GROUP BY FileNumber
5807298661258104558726040729WITH 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
416928071689772112621491971with 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 , @1 ) 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
1547597207386753161607706SELECT 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 )
15073965073961380444710431INSERT INTO dbo.DiasHabiles (Id, DiasHabiles) SELECT R.Id, (COUNT(D.Fecha) * CASE WHEN R.ExperationDate >= CAST(GETDATE() AS DATE) THEN 1 ELSE -1 END) - 1 AS DiasHabiles FROM dms.dbo.RequestFiles AS R LEFT JOIN ( SELECT ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS MaxReg ,RequestFileId ,CreationDate ,DependencyId ,CaseId ,UserName ,Status FROM dms.dbo.RequestFileHistories WHERE Status NOT IN ('31B6159D-DE9D-4CBA-9508-4D9D4EE2FAF7','C143C3ED-F4F1-4524-AD59-80FF0F35CB9C' ,'9337A841-5E78-4C45-B1BE-9607B0833F5C','56D07A62-76F6-4AB3-A26F-E18C949CBA60' ,'59536473-5BE9-4D7D-9CD8-D3FCB7A8D652','9BD808F4-6E9F-4710-B789-19FE1CE8C55A' ,'4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425' --estados de fraude ,'8d6acd5a-d128-45b0-b1a5-f9c0fef90708','EF7B7E43-9151-422A-9A2C-6E3B6C53BC85') ) AS RequestFileHistories ON RequestFileHistories.RequestFileId=R.Id AND RequestFileHistories.MaxReg = 1 AND RequestFileHistories.DependencyId IS NOT NULL LEFT JOIN #DiasHabiles AS D ON D.Fecha BETWEEN CASE WHEN R.ExperationDate >= CAST(GETDATE() AS DATE) THEN CAST(GETDATE() AS DATE) ELSE R.ExperationDate END AND CASE WHEN R.ExperationDate >= CAST(GETDATE() AS DATE) THEN R.ExperationDate ELSE CAST(GETDATE() AS DATE) END WHERE RequestFileHistories.Status NOT IN ('e6d67e4a-f545-4d62-b882-5a38a0fc35e2', '80878642-df5b-4a9c-b42b-3f8a3682fcb0') AND R.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' GROUP BY R.Id, R.ExperationDate
724060515639105825341938SELECT FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fecha radicado' , RF.FileNumber AS 'Radicado' , RF.[Subject] AS 'Asunto' FROM [dbo].[REQUESTFILE_VW] RF INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = RF.ClientId WHERE C.NumberIdentification = @NIdentification ORDER BY Radicado DESC
3737089351408037063420847515SET @DiferenciaDias = ( SELECT COUNT(DISTINCT D.DIA_NOTR) FROM OpheliaSuite.dbo.GN_DIASN D INNER JOIN OpheliaSuite.dbo.GN_CCALE C ON D.CCA_CONT = C.CCA_CONT AND C.CCA_NOMB = 'CALENDARIO SGDEA' WHERE CONVERT(DATE, D.DIA_NOTR) BETWEEN @FechaInicial AND @FechaFinal )
133337042253495843505223SELECT FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fecha radicado' , RF.FileNumber AS 'Radicado' , RF.[Subject] AS 'Asunto' FROM [dbo].[REQUESTFILE_VW] RF INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = RF.ClientId WHERE C.NumberIdentification = @NIdentification ORDER BY Radicado DESC
137893294712338408614866986SELECT COUNT(*) FROM [ReassignmentTask] AS [r] WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0
633122014955102711298839SELECT FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fecha radicado' , RF.FileNumber AS 'Radicado' , RF.[Subject] AS 'Asunto' FROM [dbo].[REQUESTFILE_VW] RF INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = RF.ClientId WHERE C.NumberIdentification = @NIdentification ORDER BY Radicado DESC
33042151014051146775788710WITH RowCTE AS ( -- Último registro por RequestFileId SELECT RequestFileId, RequestFileHistoriesId, 1 AS RequestPosition FROM ( SELECT RequestFileHistories.RequestFileId AS [RequestFileId], RequestFileHistories.Id AS [RequestFileHistoriesId], ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS [RowNumberDate] FROM dms.dbo.RequestFileHistories WHERE Status NOT IN ( '31B6159D-DE9D-4CBA-9508-4D9D4EE2FAF7', 'C143C3ED-F4F1-4524-AD59-80FF0F35CB9C', '9337A841-5E78-4C45-B1BE-9607B0833F5C', '56D07A62-76F6-4AB3-A26F-E18C949CBA60', '59536473-5BE9-4D7D-9CD8-D3FCB7A8D652', 'E6D67E4A-F545-4D62-B882-5A38A0FC35E2', '80878642-DF5B-4A9C-B42B-3F8A3682FCB0'--, 'D626C7EB-1090-468A-B1E7-24DD2FC0C40F' ) AND ProcessCode != '2' ) AS Ends WHERE RowNumberDate = 1 UNION ALL -- Primer registro por RequestFileId SELECT RequestFileId, RequestFileHistoriesId, 0 AS RequestPosition FROM ( SELECT RequestFileHistories.RequestFileId AS [RequestFileId], RequestFileHistories.Id AS [RequestFileHistoriesId], ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate ASC) AS [RowNumberDate] FROM dms.dbo.RequestFileHistories --WHERE Status NOT IN ( -- '31B6159D-DE9D-4CBA-9508-4D9D4EE2FAF7', 'C143C3ED-F4F1-4524-AD59-80FF0F35CB9C', -- '9337A841-5E78-4C45-B1BE-9607B0833F5C', '56D07A62-76F6-4AB3-A26F-E18C949CBA60', -- '59536473-5BE9-4D7D-9CD8-D3FCB7A8D652', 'E6D67E4A-F545-4D62-B882-5A38A0FC35E2', -- '80878642-DF5B-4A9C-B42B-3F8A3682FCB0', 'D626C7EB-1090-468A-B1E7-24DD2FC0C40F' --) --AND ProcessCode != '2' ) AS Init WHERE RowNumberDate = 1 ) -- Insertar datos en la tabla Stage INSERT INTO Stage.dbo.RequestFileHistories_Stage (RequestFileId, RequestFileHistoriesId, RequestPosition) SELECT RequestFileId, RequestFileHistoriesId, RequestPosition FROM RowCTE WHERE RequestFileId NOT IN (SELECT RequestFileId FROM dms.dbo.RequestFileHistories WHERE Status = 'e6d67e4a-f545-4d62-b882-5a38a0fc35e2')
18727275471143262529341294SELECT 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)
18727267114143093269460850SELECT 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]

Archivos SQL más pesados

DatabaseNameLogicalNamePhysicalNameFileTypeSizeMBMaxSizeMBIsPercentGrowth
OpheliaSuiteOpheliaSuiteDMSE:\SGDEA\OpheliaSuite.mdfROWS4472070-1False
DMSDMSE:\SGDEA\DMS.mdfROWS52015-1False
DMSDMS_BE:\SGDEA\DMS_B.ndfROWS43402-1False
DriveDriveE:\SGDEA\Drive.mdfROWS34484-1False
tempdbtemp6D:\TEMPDB\temp6.mdfROWS31071-1False
tempdbtemp7D:\TEMPDB\temp7.mdfROWS30755-1False
tempdbtemp5D:\TEMPDB\temp5.mdfROWS30735-1False
tempdbtemp10D:\TEMPDB\temp10.mdfROWS30709-1False
tempdbtemp8D:\TEMPDB\temp8.mdfROWS29267-1False
DMSDMS_logF:\LOG\DMS_log.ldfLOG265712097152False
StageStage_logF:\LOG\Stage_log.ldfLOG242032097152False
tempdbtemp9D:\TEMPDB\temp9.mdfROWS23991-1False
tempdbtemp4D:\TEMPDB\temp4.mdfROWS21358-1False
tempdbtemp11D:\TEMPDB\temp11.mdfROWS13169-1False
tempdbtempdevD:\TEMPDB\tempdev.mdfROWS12644-1False
StageStageE:\SGDEA\Stage.mdfROWS10814-1False
DMS_bk_040923DMSE:\SGDEA\DMS_bk_040923.mdfROWS5000-1False
OpheliaSuiteOpheliaSuiteDMS_logF:\LOG\OpheliaSuite_log.ldfLOG29552097152False
DMS_BK_20DMSE:\SGDEA\DMS_BK_20.mdfROWS2184-1False
AgoraSSBAgoraE:\SGDEA\Agora.mdfROWS436-1False

Volumenes fisicos SQL

DatabaseNameFileTypePhysicalNameVolumeMountPointLogicalVolumeNameTotalGBFreeGBFreePct
AgoraSSBROWSE:\SGDEA\Agora.mdfE:\DATA5222.38703.5913.47
AgoraSSB_OLDROWSE:\SGDEA\AgoraSSB.mdfE:\DATA5222.38703.5913.47
CalendarioROWSE:\SGDEA\Calendario.mdfE:\DATA5222.38703.5913.47
DBAROWSE:\SGDEA\DBA.mdfE:\DATA5222.38703.5913.47
DMSROWSE:\SGDEA\DMS.mdfE:\DATA5222.38703.5913.47
DMSROWSE:\SGDEA\DMS_B.ndfE:\DATA5222.38703.5913.47
DMS_2ROWSE:\SGDEA\DMS_2.mdfE:\DATA5222.38703.5913.47
DMS_bk_040923ROWSE:\SGDEA\DMS_bk_040923.mdfE:\DATA5222.38703.5913.47
DMS_BK_20ROWSE:\SGDEA\DMS_BK_20.mdfE:\DATA5222.38703.5913.47
DMSGDEAROWSE:\SGDEA\DMSGDEA.mdfE:\DATA5222.38703.5913.47
DriveROWSE:\SGDEA\Drive.mdfE:\DATA5222.38703.5913.47
DWMaintenanceLOGE:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\DWMaintenance_logE:\DATA5222.38703.5913.47
DWMaintenanceROWSE:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\DWMaintenanceE:\DATA5222.38703.5913.47
EstructuraImportacionROWSE:\SGDEA\EstructuraImportacion.mdfE:\DATA5222.38703.5913.47
ImperiumReportCacheROWSE:\SGDEA\ImperiumReportCache.mdfE:\DATA5222.38703.5913.47
OpheliaSuiteROWSE:\SGDEA\OpheliaSuite.mdfE:\DATA5222.38703.5913.47
ProcessTableROWSE:\SGDEA\ProcessTable.mdfE:\DATA5222.38703.5913.47
StageROWSE:\SGDEA\Stage.mdfE:\DATA5222.38703.5913.47
AgoraSSBLOGF:\LOG\Agora_log.ldfF:\LOG299.98243.7581.25
AgoraSSB_OLDLOGF:\LOG\AgoraSSB_log.ldfF:\LOG299.98243.7581.25
CalendarioLOGF:\LOG\Calendario_log.ldfF:\LOG299.98243.7581.25
DBALOGF:\LOG\DBA_log.ldfF:\LOG299.98243.7581.25
DMSLOGF:\LOG\DMS_log.ldfF:\LOG299.98243.7581.25
DMS_2LOGF:\LOG\DMS_2_log.ldfF:\LOG299.98243.7581.25
DMS_bk_040923LOGF:\LOG\DMS_bk_040923_log.ldfF:\LOG299.98243.7581.25
DMS_BK_20LOGF:\LOG\DMS_BK_20_log.ldfF:\LOG299.98243.7581.25
DMSGDEALOGF:\LOG\DMSGDEA_log.ldfF:\LOG299.98243.7581.25
DriveLOGF:\LOG\Drive_log.ldfF:\LOG299.98243.7581.25
EstructuraImportacionLOGF:\LOG\EstructuraImportacion_log.ldfF:\LOG299.98243.7581.25
ImperiumReportCacheLOGF:\LOG\ImperiumReportCache_log.ldfF:\LOG299.98243.7581.25
OpheliaSuiteLOGF:\LOG\OpheliaSuite_log.ldfF:\LOG299.98243.7581.25
ProcessTableLOGF:\LOG\ProcessTable_log.ldfF:\LOG299.98243.7581.25
StageLOGF:\LOG\Stage_log.ldfF:\LOG299.98243.7581.25

Uso interno de archivos por base

DatabaseNameLogicalNameFileTypePhysicalNameSizeGBUsedGBFreeInternalGBUsedPctGrowthConfigMaxSizeGB
OpheliaSuiteOpheliaSuiteDMSROWSE:\SGDEA\OpheliaSuite.mdf4367.264366.021.2499.9764.000000 MBSin limite
DMSDMS_logLOGF:\LOG\DMS_log.ldf25.9525.930.0299.9264.000000 MB2048.00 GB
OpheliaSuiteOpheliaSuiteDMS_logLOGF:\LOG\OpheliaSuite_log.ldf2.952.910.0498.5964.000000 MB2048.00 GB
AgoraSSBAgoraROWSE:\SGDEA\Agora.mdf0.430.410.0295.1264.000000 MBSin limite
DMSDMSROWSE:\SGDEA\DMS.mdf50.8048.172.6294.8364.000000 MBSin limite
DMSDMS_BROWSE:\SGDEA\DMS_B.ndf42.3840.152.2494.7264.000000 MBSin limite
StageStage_logLOGF:\LOG\Stage_log.ldf23.6421.771.8692.1264.000000 MB2048.00 GB
DriveDrive_logLOGF:\LOG\Drive_log.ldf0.240.220.0291.8164.000000 MB2048.00 GB
DriveDriveROWSE:\SGDEA\Drive.mdf33.6829.514.1787.6364.000000 MBSin limite
DMS_BK_20DMSROWSE:\SGDEA\DMS_BK_20.mdf2.131.850.2986.5964.000000 MBSin limite
DWMaintenanceDWMaintenanceROWSE:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\DWMaintenance0.020.020.0084.8264.000000 MBSin limite
DMS_bk_040923DMSROWSE:\SGDEA\DMS_bk_040923.mdf4.884.130.7584.6364.000000 MBSin limite
AgoraSSB_OLDAgoraSSBROWSE:\SGDEA\AgoraSSB.mdf0.010.010.0082.9364.000000 MBSin limite
ProcessTableProcessTableDMSROWSE:\SGDEA\ProcessTable.mdf0.010.010.0082.8164.000000 MBSin limite
DMS_2DMSROWSE:\SGDEA\DMS_2.mdf0.070.060.0181.3364.000000 MBSin limite
DMSGDEADMSGDEAROWSE:\SGDEA\DMSGDEA.mdf0.050.040.0180.5564.000000 MBSin limite
StageStageROWSE:\SGDEA\Stage.mdf10.568.022.5475.9564.000000 MBSin limite
DWMaintenanceDWMaintenance_logLOGE:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\DWMaintenance_log0.010.010.0070.0964.000000 MB2048.00 GB
CalendarioCalendarioROWSE:\SGDEA\Calendario.mdf0.010.000.0062.5064.000000 MBSin limite
ProcessTableProcessTableDMS_logLOGF:\LOG\ProcessTable_log.ldf0.010.010.0056.9464.000000 MB2048.00 GB
EstructuraImportacionEstructuraImportacionROWSE:\SGDEA\EstructuraImportacion.mdf0.010.000.0049.2264.000000 MBSin limite
ImperiumReportCacheImperiumReportCacheROWSE:\SGDEA\ImperiumReportCache.mdf0.010.000.0042.9764.000000 MBSin limite
DBADBAROWSE:\SGDEA\DBA.mdf0.010.000.0036.7264.000000 MBSin limite
DMS_BK_20DMS_logLOGF:\LOG\DMS_BK_20_log.ldf0.010.000.0122.8164.000000 MB2048.00 GB
DMS_2DMS_logLOGF:\LOG\DMS_2_log.ldf0.010.000.0112.3664.000000 MB2048.00 GB
CalendarioCalendario_logLOGF:\LOG\Calendario_log.ldf0.000.000.008.8564.000000 MB2048.00 GB
EstructuraImportacionEstructuraImportacion_logLOGF:\LOG\EstructuraImportacion_log.ldf0.100.010.098.4364.000000 MB2048.00 GB
DMS_bk_040923DMS_logLOGF:\LOG\DMS_bk_040923_log.ldf0.010.000.016.2564.000000 MB2048.00 GB
DMSGDEADMSGDEA_logLOGF:\LOG\DMSGDEA_log.ldf0.020.000.026.0964.000000 MB2048.00 GB
AgoraSSBAgora_logLOGF:\LOG\Agora_log.ldf0.100.000.104.4764.000000 MB2048.00 GB
DBADBA_logLOGF:\LOG\DBA_log.ldf0.070.000.072.6664.000000 MB2048.00 GB
AgoraSSB_OLDAgoraSSB_logLOGF:\LOG\AgoraSSB_log.ldf0.070.000.071.7564.000000 MB2048.00 GB
ImperiumReportCacheImperiumReportCache_logLOGF:\LOG\ImperiumReportCache_log.ldf0.100.000.101.3664.000000 MB2048.00 GB

Uso Transaction Log

DatabaseNameLogSizeGBLogSpaceUsedPctStatus
DMS25.9599.920
msdb0.0098.730
OpheliaSuite2.9598.590
Stage23.6492.120
Drive0.2491.810
DWMaintenance0.0170.090
ProcessTable0.0156.970
master0.0032.110
model0.0732.070
DMS_BK_200.0122.830
DMS_20.0112.420
Calendario0.009.010
EstructuraImportacion0.108.430
DMS_bk_0409230.016.260
DMSGDEA0.026.110
AgoraSSB0.104.470
DBA0.072.660
AgoraSSB_OLD0.071.760
ImperiumReportCache0.101.360
tempdb0.870.420

Autogrowths recientes - 7 dias

EventNameDatabaseNameFileNameStartTimeDurationMsGrowthMBHostNameApplicationNameLoginName
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/3/2026 11:38:41 AM106.0064.00DWSGDAAPP2ophelia
Data File Auto GrowOpheliaSuiteOpheliaSuiteDMS6/3/2026 11:36:34 AM100.0064.00DWSGDAAPP3ophelia
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/3/2026 11:34:01 AM103.0064.00DWSGDAAPP2ophelia
Data File Auto GrowOpheliaSuiteOpheliaSuiteDMS6/3/2026 11:30:02 AM214.0064.00DWSGDAAPP2ophelia
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/3/2026 11:27:45 AM114.0064.00DWSGDAAPP1ophelia
Data File Auto GrowOpheliaSuiteOpheliaSuiteDMS6/3/2026 11:23:57 AM114.0064.00DWSGDAAPP1ophelia
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/3/2026 11:23:06 AM103.0064.00DWSGDAAPP3ophelia
Log File Auto GrowStageStage_log6/3/2026 11:16:48 AM133.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:47 AM343.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:46 AM96.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:45 AM347.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:43 AM104.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:42 AM120.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:42 AM313.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:41 AM346.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:40 AM120.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:40 AM366.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:39 AM330.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:38 AM100.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:37 AM94.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:36 AM130.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:34 AM90.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:34 AM97.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:33 AM343.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:32 AM107.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:31 AM334.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:30 AM310.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:28 AM313.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:27 AM306.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:26 AM310.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:25 AM337.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:23 AM547.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:21 AM797.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:09 AM790.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:08 AM547.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:07 AM567.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:05 AM313.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:04 AM350.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:02 AM100.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:01 AM387.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:16:00 AM317.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:15:59 AM307.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:15:58 AM347.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:15:57 AM110.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:15:56 AM330.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:15:55 AM103.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:15:53 AM97.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:15:52 AM370.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:15:52 AM117.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/3/2026 11:15:51 AM544.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 3)DIGITALWARE\SCVSGDA-AGENT

Guía de lectura - Autogrowths recientes

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.

DatoPara qué sirve
DatabaseNameIdentifica la base que está creciendo.
FileNameIndica si creció un archivo de datos o de log.
StartTimePermite cruzar el crecimiento con lentitud, bloqueos o caídas reportadas por usuarios.
DurationMsMide cuánto tardó el crecimiento. Si es alto, puede afectar la operación.
GrowthMBIndica cuánto creció. Crecimientos muy pequeños y frecuentes sugieren mala configuración.

Recomendación: preasignar tamaño a MDF/LDF y configurar crecimiento fijo en MB/GB. Evitar crecimiento porcentual en producción.

Backups recientes

DatabaseNameRecoveryModelLastFullBackupHoursSinceFullLastDifferentialBackupLastLogBackupMinutesSinceLog
AgoraSSBFULL5/31/2026 12:32:04 AM836/3/2026 12:31:00 AM
AgoraSSB_OLDFULL5/31/2026 12:32:12 AM836/3/2026 12:31:05 AM
CalendarioFULL5/31/2026 12:32:14 AM836/3/2026 12:31:08 AM
DBAFULL5/31/2026 12:32:17 AM836/3/2026 12:31:12 AM
DMSFULL5/31/2026 12:49:35 AM836/3/2026 12:37:59 AM
DMS_2FULL5/31/2026 12:49:42 AM836/3/2026 12:38:02 AM
DMS_bk_040923FULL5/31/2026 12:50:20 AM836/3/2026 12:38:05 AM
DMS_BK_20FULL5/31/2026 12:50:40 AM836/3/2026 12:38:07 AM
DMSGDEAFULL5/31/2026 12:50:42 AM836/3/2026 12:38:10 AM
DriveFULL5/31/2026 12:55:44 AM836/3/2026 12:40:14 AM
DWMaintenanceFULL5/31/2026 12:55:46 AM836/3/2026 12:40:19 AM
EstructuraImportacionFULL5/31/2026 12:55:48 AM836/3/2026 12:40:24 AM
ImperiumReportCacheFULL5/31/2026 12:55:50 AM836/3/2026 12:40:27 AM
OpheliaSuiteFULL5/31/2026 8:38:16 AM756/3/2026 12:54:21 AM
ProcessTableFULL5/31/2026 8:38:19 AM756/3/2026 12:54:24 AM
StageFULL5/31/2026 8:38:42 AM756/3/2026 12:55:24 AM

SQL Agent Jobs fallidos o sin historial

JobNameLastRunStatusrun_daterun_timerun_durationmessage
collection_set_1_noncached_collect_and_uploadNo history
collection_set_2_collectionNo history
collection_set_2_uploadNo history
collection_set_3_collectionNo history
collection_set_3_uploadNo history
DELETE_MANTNo history
DependenciesNo history
JOB BACKUP V2No history
JOB MANTENIMIENTO V2 DriveNo history
MongoSqlServerNo history
Smart SupervisionCanceled202606031030002022The job was stopped prior to completion by User ophelia. The Job was invoked by Schedule 22 (daily). The last step to run was step 2 (Momento 2).

TempDB - archivos

LogicalNameFileTypePhysicalNameSizeMBUsedMBFreeMBUsedPctGrowthConfig
templogLOGD:\TEMPDB\templog.ldf893.943.92890.020.4464.000000000000 MB
temp10ROWSD:\TEMPDB\temp10.mdf30709.25718.7529990.502.3464.000000000000 MB
temp11ROWSD:\TEMPDB\temp11.mdf13169.50349.6312819.882.6564.000000000000 MB
temp2ROWSD:\TEMPDB\temp2.mdf250.004.69245.311.8864.000000000000 MB
temp3ROWSD:\TEMPDB\temp3.mdf300.005.00295.001.6764.000000000000 MB
temp4ROWSD:\TEMPDB\temp4.mdf21358.13640.6320717.503.0064.000000000000 MB
temp5ROWSD:\TEMPDB\temp5.mdf30735.75670.2530065.502.1864.000000000000 MB
temp6ROWSD:\TEMPDB\temp6.mdf31071.81650.5630421.252.0964.000000000000 MB
temp7ROWSD:\TEMPDB\temp7.mdf30755.94672.8130083.132.1964.000000000000 MB
temp8ROWSD:\TEMPDB\temp8.mdf29267.19651.8128615.382.2364.000000000000 MB
temp9ROWSD:\TEMPDB\temp9.mdf23991.00643.0623347.942.6864.000000000000 MB
tempdevROWSD:\TEMPDB\tempdev.mdf12644.19331.2512312.942.6264.000000000000 MB

TempDB - consumidores principales

SessionIdLoginNameHostNameProgramNameDatabaseNamestatuscommandTempdbAllocatedMBTempdbDeallocatedMBQueryText
339DIGITALWARE\JeisonCRDWSGDASQL2Microsoft SQL Server Management Studio647.38632.19
116opheliaDW-P10326Microsoft SQL Server Management Studio - Query195.19195.19
441opheliaDW-P10961Microsoft SQL Server Management Studio - Consulta89.5089.25
1638opheliadmsDWSGDAAPP2Core Microsoft SqlClient Data Provider32.500.00
178opheliaDW-P10966Microsoft SQL Server Management Studio - Consulta6.756.19
344DIGITALWARE\JeisonCRDWSGDASQL2Microsoft SQL Server Management Studio3.383.31
85DIGITALWARE\SCVSGDA-AGENTSRVCLSGDEASQLAgent - Generic Refresher1.190.69
1786opheliaDWSGDAAPP2Core Microsoft SqlClient Data Provider0.880.88
1828monitoreosaasFASECOLDAVM.Net SqlClient Data Provider0.440.44
1229opheliaDW-P10961Microsoft SQL Server Management Studio - Consulta0.310.31
967opheliaDW-P10967Microsoft SQL Server Management Studio0.190.13
70opheliaDW-P10966Microsoft SQL Server Management Studio0.060.06
1770opheliadmsDWSGDAAPP3Core Microsoft SqlClient Data Provider0.060.06
1788opheliadmsDWSGDAAPP3Core Microsoft SqlClient Data Provider0.060.06
1811opheliaDWSGDAAPP2ODK0.060.06
931opheliaDWSGDAAPP1ODK0.060.06
1732opheliadmsDWSGDAAPP2Core Microsoft SqlClient Data Provider0.060.06
1733opheliadmsDWSGDAAPP2Core Microsoft SqlClient Data Provider0.060.06
1639opheliaDWSGDAAPP1ODK0.060.06
1230opheliaDW-P10815SQL Server Management Studio0.060.06
978opheliadmsDWSGDAAPP3Core Microsoft SqlClient Data Provider0.060.06
1405opheliadmsDWSGDAAPP3Core Microsoft SqlClient Data Provider0.060.06
1553opheliadmsDWSGDAAPP3Core Microsoft SqlClient Data ProviderDMSrunningINSERT0.060.06(@0 int,@1 int,@2 varchar(8000),@3 varchar(8000))insert into #CountSecurity ( CountSecurity ) select COUNT ( s . Id ) from DMS_Security as s where @0 = @1 and DependencyId = convert ( uniqueidentifier , @2 ) and s . Rol = @3
1649opheliadmsDWSGDAAPP1Core Microsoft SqlClient Data Provider0.060.06
1650opheliadmsDWSGDAAPP4MicroSQL0.000.00
1651opheliadmsDWSGDAAPP2MicroSQL0.000.00
1652opheliadmsDWSGDAAPP1MicroSQL0.000.00
1653opheliaDWSGDAAPP1ODK0.000.00
1654opheliadmsDWSGDAAPP4MicroSQL0.000.00
1655opheliadmsDWSGDAAPP4MicroSQL0.000.00

Top Queries Logical Reads

ExecutionsTotalLogicalReadsAvgLogicalReadsCPUTimeMsElapsedMsDatabaseNameQueryText
2011590680557913834024354918520SELECT [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
12111119563175987229783414134631WITH profiled_sessions as ( SELECT DISTINCT session_id profiled_session_id from sys.dm_exec_query_profiles ) SELECT [Session ID] = s.session_id, [User Process] = CONVERT(CHAR(1), s.is_user_process), [Login] = s.login_name, [Database] = CASE WHEN s.database_id=0 THEN N'' ELSE ISNULL(db_name(s.database_id),N'') END, [Task State] = ISNULL(t.task_state, N''), [Command] = ISNULL(r.command, N''), [Application] = ISNULL(s.program_name, N''), [Wait Time (ms)] = ISNULL(w.wait_duration_ms, 0), [Wait Type] = ISNULL(w.wait_type, N''), [Wait Resource] = ISNULL(w.resource_description, N''), [Blocked By] = ISNULL(CONVERT (varchar, w.blocking_session_id), ''), [Head Blocker] = CASE -- session has an active request, is blocked, but is blocking others or session is idle but has an open tran and is blocking others WHEN r2.session_id IS NOT NULL AND (r.blocking_session_id = 0 OR r.session_id IS NULL) THEN '1' -- session is either not blocking someone, or is blocking someone but is blocked by another party ELSE '' END, [Total CPU (ms)] = s.cpu_time, [Total Physical I/O (MB)] = (s.reads + s.writes) * 8 / 1024, [Memory Use (KB)] = s.memory_usage * (8192 / 1024), [Open Transactions] = ISNULL(r.open_transaction_count,0), [Login Time] = s.login_time, [Last Request Start Time] = s.last_request_start_time, [Host Name] = ISNULL(s.host_name, N''), [Net Address] = ISNULL(c.client_net_address, N''), [Execution Context ID] = ISNULL(t.exec_context_id, 0), [Request ID] = ISNULL(r.request_id, 0), [Workload Group] = ISNULL(g.name, N''), [Profiled Session Id] = profiled_session_id FROM sys.dm_exec_sessions s LEFT OUTER JOIN sys.dm_exec_connections c ON (s.session_id = c.session_id) LEFT OUTER JOIN sys.dm_exec_requests r ON (s.session_id = r.session_id) LEFT OUTER JOIN sys.dm_os_tasks t ON (r.session_id = t.session_id AND r.request_id = t.request_id) OUTER APPLY ( -- In some cases (e.g. parallel queries, also waiting for a worker), one thread can be flagged as -- waiting for several different threads. This will cause that thread to show up in multiple rows -- in our grid, which we don't want. SELECT TOP 1 * FROM sys.dm_os_waiting_tasks wt WHERE wt.waiting_task_address = t.task_address ORDER BY wt.wait_duration_ms desc ) w LEFT OUTER JOIN sys.dm_exec_requests r2 ON (s.session_id = r2.blocking_session_id) LEFT OUTER JOIN sys.dm_resource_governor_workload_groups g ON (g.group_id = s.group_id) LEFT OUTER JOIN profiled_sessions ON profiled_session_id = s.session_id ORDER BY s.session_id
1309911840209190399067951039989SELECT 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]
194274643942746431182943641407StageINSERT INTO Stage.dbo.RadicacionVentUnica SELECT RequestFiles.Id as [RequestFilesId], RequestFiles.FileNumber AS [Radicado], -- Número de radicación CAST(RequestFiles.FiledDate AS DATETIME) AS [Fecha y Hora Radicacion], CAST(RequestFiles.FiledDate AS DATE) AS [Fecha Radicacion], -- Fecha de radicación CAST(RequestFiles.FiledDate AS TIME(0)) AS [Hora Radicacion], -- Hora de radicación TIPORADICADO.Name AS [Tipo Radicado], -- Tipo de radicación -- Determinar el usuario actual IIF(Users.Name + Users.Surnames IS NULL, 'La información del usuario en el sistema ' + COALESCE(WF_SEGUI_PEN.SEG_UENC, RequestFileHistories.UserName, Users1.UserName) + ' no es correcta', CONCAT(Users.Name, ' ', Users.Surnames) ) AS [Usuario Actual], dep.Vicepresidencia AS [Vicepresidencia], -- Vicepresidencia dep.Dependencia AS [Dependencia Actual], -- Dependencia actual ESTADO.Name AS [PROCESO], -- Estado del proceso ISNULL(DocumentType.Name, 'No Definido') AS [Tipo de Documento], -- Tipo de documento -- Definir el medio de recepción CASE WHEN TIPORADICADO.Name = 'Comunicación Interna' THEN 'Correo electrónico' ELSE CANAL.Name END AS [Medio de Recepcion], --Determinar el tipo de remitente ISNULL(TYPEPERSON_VW.Name, TYPEPERSON_VW1.Name) AS [Tipo Remitente], --Determinar el remitente CASE WHEN TYPEPERSON_VW.Name = 'Anónimo' OR TYPEPERSON_VW1.Name = 'Anónimo' THEN 'Anónimo' WHEN TYPEPERSON_VW.Name IN ('Persona Natural', 'Apoderado / Representante Legal') --OR TYPEPERSON_VW1.Name IN ('Persona Natural', 'Apoderado / Representante Legal') --THEN IIF(CONCAT(Contacto.Names, ' ', Contacto.Surnames) IS NULL, CONCAT(Clients.NamesClients, ' ', Clients.SurNames), CONCAT(Clients1.NamesClients, ' ', Clients1.SurNames)) --113839 Aranda 12-09-2025 donde se evidencia error en remitente por lo cual se realiza validación que priorice el dato de contacto THEN COALESCE(IIF (Contacto.Names IS NOT NULL OR Contacto.SurNames IS NOT NULL, CONCAT(Contacto.Names, ' ', Contacto.SurNames),NULL), IIF(Clients.NamesClients IS NOT NULL OR Clients.SurNames IS NOT NULL, CONCAT(Clients.NamesClients, ' ', Clients.SurNames),NULL), IIF(Clients1.NamesClients IS NOT NULL OR Clients1.SurNames IS NOT NULL, CONCAT(Clients1.NamesClients, ' ', Clients1.SurNames),NULL) ) ELSE CASE WHEN Contacto.BusinessName IS NOT NULL THEN Contacto.BusinessName WHEN Clients.BusinessName IS NOT NULL THEN Clients.BusinessName WHEN Clients1.BusinessName IS NOT NULL THEN Clients1.BusinessName ELSE IIF(CONCAT(Contacto.Names, ' ', Contacto.Surnames) IS NULL, CONCAT(Clients.NamesClients, ' ', Clients.SurNames), CONCAT(Clients1.NamesClients, ' ', Clients1.SurNames)) END END AS [Remitente], TIPODOCUMENTOREMITENTE.Name AS [Tipo Documento Remitente], -- Tipo de documento del remitente ISNULL(Contacto.NumberIdentification, Clients1.NumberIdentification) AS [Documento Remitente], -- Número de identificación del remitente ISNULL(Contacto.Address, Clients.Address) AS [Direccion Remitente], -- Dirección del remitente ISNULL(Contacto.Mobile, Clients.Mobile) AS [Celular], -- Celular del remitente ISNULL(Contacto.Telephone, Clients.Phone) AS [Telefono], -- Teléfono del remitente CITY.Description AS [Ciudad], -- Ciudad del remitente DEPARTMENT.Description AS [Departamento], -- Departamento del remitente ISNULL(Contacto.Email, Clients1.Email) AS [Email], -- Email del remitente -- Información sobre la radicación CONCAT(Users1.Name, ' ', Users1.Surnames) AS [Usuario Radicador], -- Usuario que radicó Dependencies1.Name AS [Dependencia Radicacion], -- Dependencia donde se radicó CAST(RequestFiles.ExperationDate AS DATE) AS [Fecha Vencimiento], -- Fecha de vencimiento CAST(RequestFiles.ExperationDate AS Time(0)) AS [Hora Vencimiento], -- Hora de vencimiento ORIGEN.Name AS [Tipo Comunicacion], -- Tipo de comunicación DMS_Procedures.ResponseTime AS [Dias Habiles de Respuesta], -- Días hábiles para respuesta -- Documentos adjuntos RequestFiles.Pages AS [Folios], -- Cantidad de folios RequestFiles.Attachments AS [Anexos], -- Cantidad de anexos -- Tipificación del procedimiento CONCAT(NameType.Name, ' ', ProcedureType.Name, ' ', SpecificationType.Name) AS [Tipificacion], -- Información del asunto RequestFiles.Subject AS [Asunto], -- Asunto del radicado -- Estado del radicado COALESCE( CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CONVERT(DATE,RequestFilesRespuestaDefinitiva.FiledDate) <=CONVERT(DATE,RequestFiles.ExperationDate)--22/10/2024 Se cambia campo RequestFilesExpirationDate.ExpirationDateFinal THEN 'En Tiempo'--'TRAMITADO OPORTUNAMENTE' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CONVERT(DATE,RequestFilesRespuestaDefinitiva.FiledDate)>CONVERT(DATE,RequestFiles.ExperationDate) THEN 'Vencido'--'TRAMITADO EXTEMPORALMENTE' END ,CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND CONVERT(DATE,RequestFiles.ExperationDate) < GETDATE()-1 THEN 'Vencido' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND DATEDIFF(DAY,GETDATE(),CONVERT(DATE,RequestFiles.ExperationDate)) IN (0,1,2,3) THEN 'Proximo a Vencer' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND DATEDIFF(DAY,GETDATE(),CONVERT(DATE,RequestFiles.ExperationDate)) >3 THEN 'En Tiempo' END ,CASE WHEN ESTADO.Name NOT IN ('Finalizado','Envío electrónico','Comunicación pendiente por clasificar','Comunicación Clasificada','Pendiente en la dependencia','Finalizado por Solicitud del Usuario') AND TIPORADICADO.Name='Salida' THEN 'Elaboración' END )[Estado Radicado], --COALESCE( -- -- Si existe fecha de radicación, evaluamos si fue en tiempo o vencido -- CASE -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL -- AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) <= CAST(RequestFiles.ExperationDate AS DATE) -- THEN 'En Tiempo' -- Tramitado oportunamente -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL -- AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) > CAST(RequestFiles.ExperationDate AS DATE) -- THEN 'Vencido' -- Tramitado extemporáneamente -- END, -- -- Si no existe fecha de radicación, evaluamos su estado según la fecha de expiración -- CASE -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND CAST(RequestFiles.ExperationDate AS DATE) < DATEADD(DAY, -1, GETDATE()) -- THEN 'Vencido' -- La expiración ya pasó -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND RequestFiles.ExperationDate - GETDATE() BETWEEN 0 AND 3 -- THEN 'Próximo a Vencer' -- Expira en los próximos 3 días -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND RequestFiles.ExperationDate - GETDATE() > 3 -- THEN 'En Tiempo' -- Todavía en plazo -- END, -- -- Si el estado no es final y es un radicado de salida, se considera en "Elaboración" -- CASE -- WHEN ESTADO.Name NOT IN ( -- 'Finalizado', 'Envío electrónico', 'Comunicación pendiente por clasificar', -- 'Comunicación Clasificada', 'Pendiente en la dependencia', 'Finalizado por Solicitud del Usuario' -- ) -- AND TIPORADICADO.Name = 'Salida' -- THEN 'Elaboración' -- END --) AS [Estado Radicado], -- Información adicional Users1.UserName AS UsuarioFiltro, CAST(MAX(RequestFilesRespuestaParcial.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) AS VARCHAR(30)) AS [Respuesta Parcial], CAST(MAX(RequestFilesRespuestaParcial.FiledDate) OVER(PARTITION BY RequestFiles.FiledDate) AS DATE) AS [Fecha Respuesta Parcial], -- Validaciones de respuestas finales CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND RequestFiles.RequestTypeId = '5449808C-16FF-4BDE-98C7-4C04C76B221B' THEN CAST(MAX(RequestFilesRespuestaDefinitiva.FileNumber) OVER (PARTITION BY RequestFiles.FileNumber) AS VARCHAR(30)) ELSE NULL END AS [Respuesta Final], CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND RequestFiles.RequestTypeId = '5449808C-16FF-4BDE-98C7-4C04C76B221B' THEN CAST(MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER (PARTITION BY RequestFiles.FiledDate) AS DATE) ELSE NULL END AS [Fecha Respuesta Final], -- Información sobre finalización CASE WHEN ESTADO.Name IN('Finalizado', 'Finalizado por Solicitud del Usuario') THEN CAST(RequestFileHistories.CreationDate AS DATE) ELSE NULL END AS [Fecha Finalizado], CASE WHEN ESTADO.Name IN('Finalizado','Finalizado por Solicitud del Usuario') THEN CAST(RequestFileHistories.CreationDate AS Time(0)) ELSE NULL END [Hora Finalizado], CASE WHEN ESTADO.Name IN('Finalizado', 'Finalizado por Solicitud del Usuario') THEN RequestFileHistories.Reason ELSE NULL END AS [Observación Finalizado], RequestFilesRespuestaDefinitiva.ChannelId AS Canal_Respuesta_Final, RequestFilesRespuestaParcial.ChannelId AS Canal_Respuesta_Parcial, Users.Id AS USERID -- Identificador del usuario FROM dms.dbo.RequestFiles LEFT JOIN dms.dbo.RequestFileHistories ON RequestFileHistories.RequestFileId = RequestFiles.Id AND EXISTS (SELECT 1 FROM [Stage].[dbo].[RequestFileHistories_Stage] WHERE RequestFileHistories_Stage.RequestFileHistoriesId = RequestFileHistories.Id AND RequestFileHistories_Stage.RequestPosition = 1) LEFT JOIN dms.dbo.RequestFileHistories RequestFileHistories1 ON RequestFileHistories1.RequestFileId = RequestFiles.Id AND EXISTS (SELECT 1 FROM [Stage].[dbo].[RequestFileHistories_Stage] WHERE RequestFileHistories_Stage.RequestFileHistoriesId = RequestFileHistories1.Id AND RequestFileHistories_Stage.RequestPosition = 0) LEFT JOIN [Stage].[dbo].[Users_Stage] Users1 ON Users1.UserName = RequestFileHistories1.UserName --ok LEFT JOIN OpheliaSuite.dbo.WF_SEGUI_PEN ON WF_SEGUI_PEN.CAS_CONT = RequestFileHistories.CaseId --ok AND WF_SEGUI_PEN.SEG_SUBJ NOT LIKE '%VISUALIZAR INCONSISTENCIA%' LEFT JOIN [Stage].[dbo].[Users_Stage] Users ON Users.UserName = COALESCE(WF_SEGUI_PEN.SEG_UENC,RequestFileHistories.UserName,Users1.UserName) --ok --LEFT JOIN [Stage].[dbo].[Depentencias_Vicepresidencia] Dep ON RequestFileHistories.DependencyId = Dep.id --ok LEFT JOIN (SELECT Dependencies.Id, Dependencies.Name AS Dependencia, CASE WHEN Dependencies.Name in ('DIRECCIÓN SARLAFT', 'UNIDAD DE CONTROL INTERNO DISCIPLINARIO', 'AUDITORIA CORPORATIVA','GERENCIA DE RIESGOS') THEN Dependencies.Name WHEN Dependencies.Name = 'PRESIDENCIA' THEN 'PRESIDENCIA' WHEN N1.Name = 'PRESIDENCIA' THEN Dependencies.Name WHEN N1.Name like '%VICEPRESIDENCIA %' THEN N1.Name WHEN N2.Name like '%VICEPRESIDENCIA %' THEN N2.Name WHEN N3.Name like '%VICEPRESIDENCIA %' THEN N3.Name ELSE '' END AS Vicepresidencia FROM [DMS].[dbo].[Dependencies] LEFT JOIN dms.dbo.Dependencies N1 ON Dependencies.TopSection = N1.Id LEFT JOIN dms.dbo.Dependencies N2 ON N1.TopSection = N2.Id LEFT JOIN dms.dbo.Dependencies N3 ON N2.TopSection = N3.Id where Dependencies.State = '57DC632C-79D5-458A-845B-76F4859F3E75' ) Dep ON COALESCE(RequestFileHistories.DependencyId, RequestFileHistories1.DependencyId) = Dep.id LEFT JOIN ( SELECT Users.UserName, Dependencies.Name, ROW_NUMBER() OVER (PARTITION BY Users.UserName ORDER BY Dependencies.Name ASC) AS Rn FROM [Stage].[dbo].[Users_Stage] Users INNER JOIN DMS.DBO.UsersCompany ON Users.Id=UsersCompany.UserId INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id=UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State=TypeDetail.Id AND TypeDetail.Code = (SELECT MIN(TypeDetail.Code) FROM DMS.DBO.UsersCompany A INNER JOIN DMS.DBO.TypeDetail ON A.State=TypeDetail.Id WHERE UsersCompany.UserId = A.UserId GROUP BY A.UserId)) Dependencies1 ON RequestFileHistories1.UserName = Dependencies1.UserName --ok AND Dependencies1.Rn = '1' LEFT JOIN STAGE.DBO.RequestFilesExpirationDate ON RequestFilesExpirationDate.FileNumber=RequestFiles.FileNumber --OK LEFT JOIN DMS.DBO.TYPEORIGIN_VW ORIGEN ON RequestFiles.OriginId =ORIGEN.Id LEFT JOIN DMS.DBO.TYPEORIGIN_VW TIPORADICADO ON RequestFiles.RequestTypeId =TIPORADICADO.Id LEFT JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))= COALESCE(RequestFileHistories.status, RequestFileHistories1.status) --OK LEFT JOIN DMS.DBO.DocumentType ON DocumentType.Id=RequestFiles.DocumentTypeId LEFT JOIN DMS.DBO.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId --OK LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id=DMS_Procedures.NameTypeId --OK LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id=DMS_Procedures.ProcedureTypeId --OK LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id=DMS_Procedures.SpecificationTypeId --OK LEFT JOIN DMS.DBO.CANAL_VW CANAL ON CANAL.Id=RequestFiles.ChannelId LEFT JOIN DMS.DBO.Contacts Contacto ON Contacto.Id = RequestFiles.ContactId --OK LEFT JOIN DMS.DBO.Clients ON RequestFiles.ClientId=Clients.Id --OK LEFT JOIN DMS.DBO.Clients Clients1 ON Clients1.Id=Contacto.ClientId --OK LEFT JOIN DMS.DBO.TYPEPERSON_VW ON TYPEPERSON_VW.Id=Contacto.TypeContactId --OK LEFT JOIN DMS.DBO.TYPEPERSON_VW TYPEPERSON_VW1 ON TYPEPERSON_VW1.Id=Clients1.PersonTypeId --OK LEFT JOIN DMS.DBO.TYPEIDENTI_VW TIPODOCUMENTOREMITENTE ON Clients1.DocumentTypeId=TIPODOCUMENTOREMITENTE.Id --OK LEFT JOIN DMS.DBO.GeographicsLocationMun_VW CITY ON Contacto.CityId=CITY.Id --OK LEFT JOIN DMS.DBO.GeographicsLocatioDep_VW DEPARTMENT ON Contacto.DepartamentId = DEPARTMENT.Id --OK 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' 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' WHERE RequestFileHistories1.Status != 'e6d67e4a-f545-4d62-b882-5a38a0fc35e2' AND RequestFileHistories.Status != 'e6d67e4a-f545-4d62-b882-5a38a0fc35e2' AND (RequestFileHistories.ProcessCode != 'Combinación de Correspondencia - ' AND RequestFileHistories.ProcessName != 'Respuesta Parcial')
35064238286612088117973171290SELECT [r].[Id], [r].[CaseId], [r].[CreationDate], [r].[DependencyId], [r].[ProcessCode], [r].[ProcessName], [r].[Reason], [r].[RequestFileId], [r].[Status], [r].[UserName], [r0].[Id], [r0].[AnnexTypeId], [r0].[AppealRulingApplies], [r0].[ApproverName], [r0].[AssumeCost], [r0].[AttachDescription], [r0].[AttachmentTypeId], [r0].[Attachments], [r0].[BeginProcessCE], [r0].[CaseId], [r0].[Cellphone], [r0].[ChannelId], [r0].[ClientId], [r0].[ComplaintAttached], [r0].[ComplaintOrigin], [r0].[ContactId], [r0].[CourrierName], [r0].[CourrierNumber], [r0].[CrossReferenceDate], [r0].[CrossReferenceNumber], [r0].[CrossReferenceResponsibleId], [r0].[DaysPendingManagement], [r0].[DependencyId], [r0].[Description], [r0].[DestinyName], [r0].[DestinyNameId], [r0].[DocumentDate], [r0].[DocumentTypeId], [r0].[ExperationDate], [r0].[ExternalId], [r0].[FileName], [r0].[FileNumber], [r0].[FiledDate], [r0].[InformedId], [r0].[Location], [r0].[MassiveConsecutive], [r0].[MessageBody], [r0].[NamesCustomer], [r0].[NotesIncompleteInformation], [r0].[Observations], [r0].[OriginId], [r0].[Pages], [r0].[PerformanceId], [r0].[Phone], [r0].[Postal], [r0].[PqrsTypeId], [r0].[PQRSDAnalysisDecisionId], [r0].[PriorityId], [r0].[ProcedureId], [r0].[Reason], [r0].[ReasonId], [r0].[ReceiverCompany], [r0].[ReceiverDependency], [r0].[ReceiverName], [r0].[ReceivingInstanceId], [r0].[ReportedAttachedSmart], [r0].[ReportedSmart], [r0].[RepresentativeId], [r0].[RequestTypeId], [r0].[ResponseDate], [r0].[ResponseName], [r0].[ResponseTime], [r0].[ResposnseText], [r0].[Ruling], [r0].[SenderName], [r0].[SeriesId], [r0].[SIGEPDirectoryId], [r0].[SignatureTypeId], [r0].[SPCTypeId], [r0].[StatusId], [r0].[Subject], [r0].[SubseriesId], [r0].[TermDeadline], [r0].[ThemeId], [r0].[UserName], [r0].[UsersId], [r0].[VersionCCD], [r0].[VersionTRD], [d].[Id], [d].[ChiefDependencesId], [d].[ClosingDate], [d].[Code], [d].[CompaniesId], [d].[CostCenter], [d].[DependencyInCharge], [d].[Description], [d].[ModificateDate], [d].[ModificateUser], [d].[Name], [d].[State], [d].[Suffix], [d].[TopSection], [d].[Type], [d].[VersionCCD], [d].[VersionTRD], [d].[VersionTVD], [d0].[Id], [d0].[ChiefDependencesId], [d0].[ClosingDate], [d0].[Code], [d0].[CompaniesId], [d0].[CostCenter], [d0].[DependencyInCharge], [d0].[Description], [d0].[ModificateDate], [d0].[ModificateUser], [d0].[Name], [d0].[State], [d0].[Suffix], [d0].[TopSection], [d0].[Type], [d0].[VersionCCD], [d0].[VersionTRD], [d0].[VersionTVD], [t].[Id], [t].[CompanyId], [t].[DependenciesId], [t].[DocumentTypeId], [t].[SeriesId], [t].[StateId], [t].[SubSeriesId], [t].[Id0], [t].[Address], [t].[AgoraId], [t].[CityId], [t].[ClosingDate], [t].[Code], [t].[CompaniesTypeId], [t].[CompanyGroupId], [t].[ConstitutionDate], [t].[CorporateEmail], [t].[CountryId], [t].[DateInitialRetention], [t].[DepartmentId], [t].[EconomicActivityCode], [t].[ModificateDate], [t].[ModificateUser], [t].[Name], [t].[NIT], [t].[StateId0], [t].[WebSite] FROM [RequestFileHistories] AS [r] INNER JOIN [RequestFiles] AS [r0] ON [r].[RequestFileId] = [r0].[Id] LEFT JOIN [Dependencies] AS [d] ON [r0].[DependencyId] = [d].[Id] LEFT JOIN [Dependencies] AS [d0] ON [r].[DependencyId] = [d0].[Id] LEFT JOIN ( SELECT [c].[Id], [c].[CompanyId], [c].[DependenciesId], [c].[DocumentTypeId], [c].[SeriesId], [c].[StateId], [c].[SubSeriesId], [c0].[Id] AS [Id0], [c0].[Address], [c0].[AgoraId], [c0].[CityId], [c0].[ClosingDate], [c0].[Code], [c0].[CompaniesTypeId], [c0].[CompanyGroupId], [c0].[ConstitutionDate], [c0].[CorporateEmail], [c0].[CountryId], [c0].[DateInitialRetention], [c0].[DepartmentId], [c0].[EconomicActivityCode], [c0].[ModificateDate], [c0].[ModificateUser], [c0].[Name], [c0].[NIT], [c0].[StateId] AS [StateId0], [c0].[WebSite] FROM [CompanyStructures] AS [c] INNER JOIN [Companies] AS [c0] ON [c].[CompanyId] = [c0].[Id] ) AS [t] ON [d].[Id] = [t].[DependenciesId] WHERE ([r].[RequestFileId] = @__rrqf_Id_0) AND ([r].[UserName] = @__userName_1) ORDER BY [r].[Id], [r0].[Id], [d].[Id], [d0].[Id], [t].[Id], [t].[Id0]
679330073014861129472423468549SELECT DISTINCT RF.IdRadicado, RF.Radicado, RF.Fecha, CN.[Name] AS 'Canal', RF.[Tipo de persona], TD.Name AS 'Tipo de identificación', CL.NumberIdentification AS 'Número de identificación', RF.Entidad, RF.Destinatario AS 'Nombres y apellidos remitente', CL.Id AS 'Id Cliente', CT.Id AS 'Id Contacto', RF.País, RF.Departamento, RF.Ciudad, RF.Dirección, RF.[Correo electrónico], RF.Asunto, RF.Folios, RFD.Attachments AS 'Número de anexos', RF.[Descripción de anexos], RF.Compañía, RF.Dependencia, CONCAT(DP.NameSolicitud, ' / ', LTRIM(RTRIM(DP.NameDetalle)), IIF(ISNULL(DP.NameEspecificacion, '0') = '0', NULL, ' / '), DP.NameEspecificacion) AS 'Trámite', RFD.UserName AS 'Usuario Radicador', RF.FuncionarioResponsable 'Responsable', 'https://tinyurl.com/5e6yz5u9' AS QR FROM GETDATABYRADICATE_VW RF INNER JOIN REQUESTFILE_VW RFD ON RFD.Id = RF.IdRadicado INNER JOIN CANAL_VW CN ON CN.Id = RFD.ChannelId INNER JOIN CLIENTS_VW CL ON CL.Id = RFD.ClientId INNER JOIN CONTACTS_VW CT ON CT.Id = RFD.ContactId INNER JOIN TypeDetail TD ON TD.Id = CL.DocumentTypeId INNER JOIN DMSProcedureNew_VW DP ON RFD.ProcedureId = DP.IdProcedure WHERE RF.Radicado = @Radicado
67230523162454211569507460018SELECT DISTINCT RF.Radicado, RF.Fecha, RF.[Tipo de persona], RF.Entidad, RF.Destinatario, RF.País, RF.Departamento, RF.Ciudad, RF.Dirección, RF.[Correo electrónico], RF.Asunto, RF.[Cuerpo del mensaje], RF.Folios, RF.[Descripción de anexos], RF.[Canal de envío], RF.Elaboró, RF.Revisó, RF.Aprobó, RF.Compañía, RF.Dependencia, RF.Funcionario, RF.Cargo, RF.TFirma, RF.[Firma Firmante], RF.[Cargo destinatario], ISNULL (RF.CollaborativeWorkName, '1') AS 'CollaborativeWorkName', RF.CollaborativeWorkBody FROM GETDATABYRADICATE_VW RF WHERE RF.Radicado = @Radicado
1295869432958694324812792505StageSELECT DISTINCT RequestFiles.FileNumber AS Radicado ,CONVERT(DATE,RequestFiles.FiledDate) AS [Fecha Radicacion] ,TIPORADICADO.Name AS [Tipo Radicado] ,IIF(Users.Name+Users.Surnames IS NULL,'La información del usuario en el sistema ' + RequestFileHistories.UserName + ' no es correcta',CONCAT(Users.Name,' ', Users.Surnames ) ) AS [Usuario Actual] ,COALESCE(CASE WHEN DependenciesPrincipal2.Description LIKE 'VICEPRESIDENCIA%' THEN DependenciesPrincipal2.Description ELSE NULL END ,CASE WHEN DependenciesPrincipal1.Description LIKE 'VICEPRESIDENCIA%' THEN DependenciesPrincipal1.Description ELSE NULL END ,CASE WHEN DependenciesPrincipal.Description LIKE 'VICEPRESIDENCIA%' THEN DependenciesPrincipal.Description ELSE NULL END ,CASE WHEN Dependencies.Name LIKE 'VICEPRESIDENCIA%' THEN Dependencies.Name WHEN Dependencies.Name IN ('GERENCIA DE RIESGOS','PRESIDENCIA') THEN 'PRESIDENCIA' WHEN Dependencies.Name='DIRECCIÓN SARLAFT' THEN 'DIRECCIÓN SARLAFT' WHEN Dependencies.Name='UNIDAD DE CONTROL INTERNO DISCIPLINARIO' THEN 'UNIDAD DE CONTROL INTERNO DISCIPLINARIO' WHEN Dependencies.Name='AUDITORIA CORPORATIVA' THEN 'AUDITORIA CORPORATIVA' ELSE NULL END ) AS Vicepresidencia ,ISNULL(Dependencies.Name,'Usuario sin Dependencia') AS [Dependencia Actual] --,ESTADO.Name AS [Proceso] ,CASE WHEN ESTADO.name ='Digitalizado' THEN (SELECT top(1) Name --,CreationDate FROM dms.dbo.RequestFiles LEFT JOIN dms.dbo.RequestFileHistories ON RequestFileHistories.RequestFileId=RequestFiles.Id LEFT JOIN dms.dbo.TypeDetail ESTADO ON CONVERT(VARCHAR(40),ESTADO.Id)=RequestFileHistories.Status WHERE RequestFileHistories.RequestFileId=RequestFiles.Id --AND RequestFiles.FileNumber ='20240320167572' AND Name != 'Digitalizado' ORDER BY CreationDate DESC ) ELSE ESTADO.name END [PROCESO] ,ISNULL(DocumentType.Name ,'No Definido') [Tipo de Documento] ,CANAL.Name AS [Medio de Recepcion] ,TYPEPERSON_VW.Name AS [Tipo Remitente] ,CASE WHEN TYPEPERSON_VW.Name='Persona Natural' THEN CONCAT(Clients.NamesClients,' ',Clients.SurNames) ELSE BusinessName END AS [Remitente] ,TIPODOCUMENTOREMITENTE.Name [Tipo Documento Remitente] ,Clients.NumberIdentification AS [Documento Remitente] ,Clients.Address AS [Direccion Remitente] ,Clients.Mobile AS [Celular] ,Clients.Phone AS [Telefono] ,CITY.Description AS [Ciudad] ,DEPARTMENT.Description AS [Departamento] ,Clients.Email AS [Email] ,CONCAT(Users1.Name,' ', Users1.Surnames ) AS [Usuario Radicador] ,Dependencies1.Name AS [Dependencia Radicacion] ,RequestFilesExpirationDate.ExpirationDateFinal AS [Fecha Vencimiento] ,ORIGEN.Name AS [Tipo Comunicacion] ,DMS_Procedures.ResponseTime AS [Dias Habiles de Respuesta] ,RequestFiles.Pages AS [Folios] ,RequestFiles.Attachments AS [Anexos] ,CONCAT(NameType.Name,' ' ,ProcedureType.Name,' ' ,SpecificationType.Name ) AS [Tipificacion] ,RequestFiles.Subject AS[Asunto] ,COALESCE (CASE WHEN CONVERT(DATE,MAX(RequestFilesRespuestaDefinitiva.FiledDate)OVER (PARTITION BY RequestFiles.FileNumber)) <=CONVERT(DATE,RequestFilesExpirationDate.ExpirationDateFinal) THEN 'En Tiempo' END ,CASE WHEN CONVERT(DATE,MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER (PARTITION BY RequestFiles.FileNumber))>CONVERT(DATE,RequestFilesExpirationDate.ExpirationDateFinal) THEN 'En Tiempo' END ,CASE WHEN ESTADO.Name IN ('Finalizado','Envío electrónico','Comunicación pendiente por clasificar','Comunicación Clasificada','Pendiente en la dependencia','Finalizado por Solicitud del Usuario') AND ORIGEN.Name<>'PQRSD' THEN 'En Tiempo' END ,CASE WHEN ESTADO.Name IN ('Finalizado','Envío electrónico','Comunicación pendiente por clasificar','Comunicación Clasificada','Pendiente en la dependencia','Finalizado por Solicitud del Usuario') AND TIPORADICADO.Name='Salida' THEN 'En Tiempo' END ,CASE WHEN ESTADO.Name NOT IN ('Finalizado','Envío electrónico','Comunicación pendiente por clasificar','Comunicación Clasificada','Pendiente en la dependencia','Finalizado por Solicitud del Usuario') AND TIPORADICADO.Name='Salida' THEN 'Elaboración' END ,CASE WHEN RequestFilesExpirationDate.ProcedureDays>=IIF(MAX(RequestFilesRespuestaParcial.FiledDate) OVER (PARTITION BY RequestFiles.FileNumber) IS NOT NULL,13, ISNULL(DMS_Procedures.ResponseTime,RequestFiles.ResponseTime)-2) AND RequestFilesExpirationDate.ProcedureDays<=IIF(MAX(RequestFilesRespuestaParcial.FiledDate) OVER (PARTITION BY RequestFiles.FileNumber) IS NOT NULL,15, ISNULL(DMS_Procedures.ResponseTime,RequestFiles.ResponseTime)) THEN 'Proximo a Vencer' END ,CASE WHEN MAX(COALESCE(RequestFilesRespuestaDefinitiva.FiledDate,RequestFilesRespuestaParcial.FiledDate,GETDATE())) OVER(PARTITION BY RequestFiles.FileNumber) <CONVERT(DATE,RequestFilesExpirationDate.ExpirationDateFinal) AND RequestFilesExpirationDate.ProcedureDays<=IIF(MAX(RequestFilesRespuestaParcial.FiledDate) OVER (PARTITION BY RequestFiles.FileNumber) IS NOT NULL,15, ISNULL(DMS_Procedures.ResponseTime,RequestFiles.ResponseTime)) THEN 'En Tiempo' END ,CASE WHEN MAX(COALESCE(RequestFilesRespuestaDefinitiva.FiledDate,RequestFilesRespuestaParcial.FiledDate,GETDATE())) OVER(PARTITION BY RequestFiles.FileNumber) >CONVERT(DATE,RequestFilesExpirationDate.ExpirationDateFinal) THEN 'Vencido' END ,CASE WHEN MAX(COALESCE(RequestFilesRespuestaDefinitiva.FiledDate,RequestFilesRespuestaParcial.FiledDate,GETDATE())) OVER(PARTITION BY RequestFiles.FileNumber) <CONVERT(DATE,RequestFilesExpirationDate.ExpirationDateFinal) AND RequestFilesExpirationDate.ProcedureDays>IIF(MAX(RequestFilesRespuestaParcial.FiledDate) OVER (PARTITION BY RequestFiles.FileNumber) IS NOT NULL,15, ISNULL(DMS_Procedures.ResponseTime,RequestFiles.ResponseTime)) THEN 'Vencido' END ) [Estado Radicado] ,Users1.UserName AS UsuarioFiltro INTO #RadicacionVentUnicaAnuladosTemp FROM dms.dbo.RequestFiles LEFT JOIN dms.dbo.RequestFileHistories ON RequestFileHistories.RequestFileId=RequestFiles.Id AND RequestFileHistories.CreationDate=( SELECT MAX(CreationDate) FROM dms.dbo.RequestFiles A INNER JOIN DMS.dbo.RequestFileHistories B on A.id=B.RequestFileId WHERE A.FileNumber=RequestFiles.FileNumber AND b.Status NOT IN ('31B6159D-DE9D-4CBA-9508-4D9D4EE2FAF7','c143c3ed-f4f1-4524-ad59-80ff0f35cb9c')) LEFT JOIN DMS.DBO.RequestFileHistories RequestFileHistories1 ON RequestFileHistories1.RequestFileId=RequestFiles.Id AND RequestFileHistories1.CreationDate=( SELECT MIN(CreationDate) FROM DMS.DBO.RequestFileHistories A INNER JOIN dms.dbo.RequestFiles B ON A.RequestFileId=B.Id WHERE b.FileNumber=RequestFiles.FileNumber) LEFT JOIN DMS.DBO.Users Users1 ON Users1.UserName=RequestFileHistories1.UserName LEFT JOIN OpheliaSuite.dbo.WF_SEGUI_PEN ON WF_SEGUI_PEN.CAS_CONT=RequestFileHistories.CaseId AND WF_SEGUI_PEN.SEG_SUBJ NOT LIKE '%VISUALIZAR INCONSISTENCIA%' LEFT JOIN dms.dbo.Users ON Users.UserName=COALESCE(WF_SEGUI_PEN.SEG_UENC,RequestFileHistories.UserName,Users1.UserName) LEFT JOIN ( SELECT Dependencies.Id ,UserId ,MIN(Dependencies.Name) OVER (PARTITION BY UserId) Name ,MIN(CASE WHEN (Dependencies.Name) =Dependencies.Name THEN Dependencies.Code END) OVER (PARTITION BY UserId) Code ,MIN(CASE WHEN (Dependencies.Name) =Dependencies.Name THEN Dependencies.TopSection END) OVER (PARTITION BY UserId)TopSection ,UsersCompany.State FROM DMS.DBO.Users INNER JOIN DMS.DBO.UsersCompany ON Users.Id=UsersCompany.UserId INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id=UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State=TypeDetail.Id AND TypeDetail.Code = ( SELECT MIN(TypeDetail.Code) FROM DMS.DBO.UsersCompany A INNER JOIN DMS.DBO.TypeDetail ON A.State=TypeDetail.Id WHERE UsersCompany.UserId=A.UserId GROUP BY A.UserId ) ) Dependencies ON Users.Id=Dependencies.UserId LEFT JOIN ( SELECT Dependencies.Id ,UserId ,Users.UserName ,MIN(Dependencies.Name) OVER (PARTITION BY UserId) Name ,MIN(CASE WHEN (Dependencies.Name) =Dependencies.Name THEN Dependencies.Code END) OVER (PARTITION BY UserId) Code ,TopSection ,UsersCompany.State FROM DMS.DBO.Users INNER JOIN DMS.DBO.UsersCompany ON Users.Id=UsersCompany.UserId INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id=UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State=TypeDetail.Id AND TypeDetail.Code = (SELECT MIN(TypeDetail.Code) FROM DMS.DBO.UsersCompany A INNER JOIN DMS.DBO.TypeDetail ON A.State=TypeDetail.Id WHERE UsersCompany.UserId=A.UserId GROUP BY A.UserId ) ) Dependencies1 ON RequestFileHistories1.UserName=Dependencies1.UserName INNER JOIN RequestFilesExpirationDate ON RequestFilesExpirationDate.FileNumber=RequestFiles.FileNumber LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal ON DependenciesPrincipal.Id=Dependencies.TopSection LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal1 ON DependenciesPrincipal1.Id=DependenciesPrincipal.TopSection LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal2 ON DependenciesPrincipal2.Id=DependenciesPrincipal1.TopSection LEFT JOIN DMS.DBO.TYPEORIGIN_VW ORIGEN ON RequestFiles.OriginId =ORIGEN.Id LEFT JOIN DMS.DBO.TYPEORIGIN_VW TIPORADICADO ON RequestFiles.RequestTypeId =TIPORADICADO.Id LEFT JOIN dms.dbo.TYPESTATEREQUEST_VW ESTADO ON CONVERT(VARCHAR(40),ESTADO.Id)=RequestFileHistories.Status LEFT JOIN DMS.DBO.DocumentType ON DocumentType.Id=RequestFiles.DocumentTypeId LEFT JOIN DMS.DBO.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id=DMS_Procedures.ProcedureTypeId LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id=DMS_Procedures.SpecificationTypeId LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id=DMS_Procedures.NameTypeId --LEFT JOIN DMS_Desa.dbo.PQRSDType PqrsType ON PqrsType.Id=RequestFiles.PqrsTypeId LEFT JOIN DMS.DBO.CANAL_VW CANAL ON CANAL.Id=RequestFiles.ChannelId LEFT JOIN DMS.DBO.CLIENTS_VW Clients ON RequestFiles.ClientId=Clients.Id LEFT JOIN DMS.DBO.TYPEPERSON_VW ON TYPEPERSON_VW.Id=Clients.PersonTypeId LEFT JOIN DMS.DBO.[TYPEIDENTI_VW] TIPODOCUMENTOREMITENTE ON Clients.DocumentTypeId=TIPODOCUMENTOREMITENTE.Id LEFT JOIN DMS.DBO.GeographicsLocationMun_VW CITY ON Clients.CityId=CITY.Id LEFT JOIN DMS.DBO.GeographicsLocatioDep_VW DEPARTMENT ON Clients.DepartamentId=DEPARTMENT.Id LEFT JOIN dms.dbo.RelatedRequestFiles ON RelatedRequestFiles.ParentId =RequestFiles.Id LEFT JOIN dms.dbo.RequestFiles RequestFilesRespuestaDefinitiva ON RelatedRequestFiles.requestfileId =CONVERT(VARCHAR(40),RequestFilesRespuestaDefinitiva.Id) AND RequestFilesRespuestaDefinitiva.FiledDate IN ( SELECT MAX(AA.FiledDate) FROM dms.dbo.RequestFiles AA INNER JOIN dms.dbo.RelatedRequestFiles BB ON BB.RequestFileId=AA.Id INNER JOIN dms.dbo.RequestFiles CC ON BB.ParentId=CC.Id WHERE CC.FileNumber=RequestFiles.FileNumber AND AA.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND AA.ResposnseText=1 ) LEFT JOIN dms.dbo.RequestFiles RequestFilesRespuestaParcial ON RelatedRequestFiles.requestfileId =CONVERT(VARCHAR(40),RequestFilesRespuestaParcial.Id) AND RequestFilesRespuestaParcial.FiledDate IN ( SELECT MAX(AA.FiledDate) FROM dms.dbo.RequestFiles AA INNER JOIN dms.dbo.RelatedRequestFiles BB ON BB.RequestFileId=AA.Id INNER JOIN dms.dbo.RequestFiles CC ON BB.ParentId=CC.Id WHERE CC.FileNumber=RequestFiles.FileNumber AND AA.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND AA.ResposnseText=2 ) --WHERE FileNumber='20231143001303461' --WHERE ESTADO.Name IS NULL WHERE RequestFileHistories.Status ='E6D67E4A-F545-4D62-B882-5A38A0FC35E2'
827966675349583419199199681select distinct * from ( select RequestFiles . FileNumber as 'Radicado' , RequestFileHistories . UserName as 'Usuario DMS' , WF_SEGUI_PEN . SEG_UENC as 'Usuario BPM' , case when RequestFiles . OriginId = '2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' then 'PQRSD' else 'OTRO' end as 'Tipo Radicado' , case when RequestFileHistories . UserName = WF_SEGUI_PEN . SEG_UENC then 'IGUAL' else 'DIFERENTE' end VALIDACION from DMS . DBO . RequestFiles with ( NOLOCK ) left join dms . dbo . RequestFileHistories with ( NOLOCK ) on RequestFileHistories . RequestFileId = RequestFiles . Id and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from dms . dbo . RequestFileHistories A with ( NOLOCK ) where A . RequestFileId = RequestFileHistories . RequestFileId and a . Status not in ( @0 ) ) left join dms . dbo . Users with ( NOLOCK ) on Users . UserName = RequestFileHistories . UserName left join DMS . DBO . RelatedRequestFiles with ( NOLOCK ) on RelatedRequestFiles . ParentId = RequestFiles . Id left join DMS . DBO . RequestFiles RequestFiles1 with ( NOLOCK ) on RequestFiles1 . Id = RelatedRequestFiles . RequestFileId inner join OpheliaSuite . DBO . WF_SEGUI_PEN with ( NOLOCK ) on WF_SEGUI_PEN . CAS_CONT = RequestFileHistories . CaseId where RequestFileHistories . Status not in ( @1 , @2 ) and RequestFiles . RequestTypeId ! = @3 ) FDG where VALIDACION = @4
58026040729448977298661045587WITH 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
4121491971524194692807721126with 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 , @1 ) 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
5832145552636801111286290417SELECT [d].[Id], [d].[AvailabilityId], [d].[BoxId], [d].[CloseDate], [d].[CloseUser], [d].[Code], [d].[CompanyId], [d].[ConsultFrequencyId], [d].[CreationDate], [d].[CreationUser], [d].[CrossReference], [d].[DateVersion], [d].[DependencyId], [d].[Description], [d].[EndDate], [d].[ExternalId], [d].[Folios], [d].[IdStatusBeforeLocked], [d].[InUnificationProcess], [d].[InitialDate], [d].[InitialRetentionDate], [d].[InitialRetentionDateAC], [d].[Location], [d].[ModificateDate], [d].[NameReferencies], [d].[NoteScope], [d].[ParentId], [d].[PendingReorder], [d].[PrimaryValue], [d].[RetentionEndDate], [d].[RetentionEndDateAC], [d].[SecundaryValue], [d].[SeriesId], [d].[size], [d].[StateId], [d].[StateTransferId], [d].[SubseriesId], [d].[Support], [d].[Tomo], [d].[TopographicLocationDescription], [d].[TopographicLocationId], [d].[Version], [d].[VersionCCD], [d].[VersionTRD], [d].[VersionTVD], [d].[VolumeCount], [s].[Id], [s].[AccessClassificationId], [s].[Code], [s].[ConformationReferenceId], [s].[CoreArchiveStay], [s].[CreationDate], [s].[Description], [s].[DispositionDescription], [s].[DispositionTypeId], [s].[ElectronicSize], [s].[HasSubserie], [s].[ManagementArchiveStay], [s].[ModificateDate], [s].[ModificateUser], [s].[Name], [s].[PhysicalSize], [s].[PreservationTechTypeId], [s].[PreservationTypeId], [s].[Section], [s].[SerieStateId], [s].[TimeId], [s].[TimeMeasurenmentId], [s].[TopSectionId], [s].[Version], [s].[VersionCCD], [s].[VersionTRD], [s].[VersionTVD], [s0].[Id], [s0].[AccessClassificationId], [s0].[ClosingDate], [s0].[Code], [s0].[ConformationReferenceId], [s0].[CoreArchiveStay], [s0].[CreationDate], [s0].[Description], [s0].[DispositionDescription], [s0].[DispositionTypeId], [s0].[ElectronicSize], [s0].[ManagementArchiveStay], [s0].[ModificateDate], [s0].[ModificateUser], [s0].[Name], [s0].[PhysicalSize], [s0].[PreservationTechTypeId], [s0].[PreservationTypeId], [s0].[SerieId], [s0].[SubserieStateId], [s0].[TimeId], [s0].[TimeMeasurenmentId], [s0].[TopSection], [s0].[Version], [s0].[VersionCCD], [s0].[VersionTRD], [r].[Id], [r].[AccessClassificationId], [r].[Annexes], [r].[ArchivingUserId], [r].[Condition], [r].[DateDocument], [r].[DateIncorporation], [r].[DocumentConditionId], [r].[EndPage], [r].[ExternalFileNumber], [r].[FirstUseDate], [r].[Folios], [r].[Homepage], [r].[LastAccessDate], [r].[Name], [r].[Observation], [r].[Orden], [r].[ReferencesId], [r].[RequestFileId], [r].[size], [r].[SupportId], [r].[TypeDocumentId], [r].[UpdateDate], [r].[UrlLocation] FROM [DMS_References] AS [d] LEFT JOIN [Series] AS [s] ON [d].[SeriesId] = [s].[Id] LEFT JOIN [Subseries] AS [s0] ON [d].[SubseriesId] = [s0].[Id] LEFT JOIN [ReferencesRequestFile] AS [r] ON [d].[Id] = [r].[ReferencesId] WHERE [d].[Code] = @__get_Item_Code_0 ORDER BY [d].[Id], [s].[Id], [s0].[Id], [r].[Id]
3737089208475155351408370634StageSET @DiferenciaDias = ( SELECT COUNT(DISTINCT D.DIA_NOTR) FROM OpheliaSuite.dbo.GN_DIASN D INNER JOIN OpheliaSuite.dbo.GN_CCALE C ON D.CCA_CONT = C.CCA_CONT AND C.CCA_NOMB = 'CALENDARIO SGDEA' WHERE CONVERT(DATE, D.DIA_NOTR) BETWEEN @FechaInicial AND @FechaFinal )
819809368247617116417037454select convert ( VARCHAR , Radicado ) as Radicado , CAS_DESC , SEG_SUBJ , SEG_UENC , SEG_FREC , SEG_FLIM , convert ( VARCHAR , flu_cont ) as 'ProcessCode' , CAS_CONT , SEG_CONA , ETA_CONT , ETA_NOMB , SEG_UORI , VersionCCD from [TASKLIST] where Radicado in ( @0 , @1 , @2 , @3 , @4 , @5 , @6 , @7 , @8 , @9 , @10 , @11 , @12 , @13 , @14 , @15 , @16 , @17 , @18 , @19 , @20 , @21 , @22 , @23 , @24 , @25 , @26 , @27 , @28 , @29 , @30 , @31 , @32 , @33 , @34 , @35 , @36 , @37 , @38 , @39 , @40 , @41 , @42 , @43 , @44 , @45 , @46 , @47 , @48 , @49 , @50 , @51 , @52 , @53 , @54 , @55 , @56 , @57 , @58 , @59 , @60 , @61 , @62 , @63 , @64 , @65 , @66 , @67 , @68 , @69 , @70 , @71 , @72 , @73 , @74 , @75 , @76 , @77 , @78 , @79 , @80 , @81 , @82 , @83 , @84 , @85 , @86 , @87 , @88 , @89 , @90 , @91 , @92 , @93 , @94 , @95 , @96 , @97 , @98 ) and versionCCD = @99
11972255219722552892352179441StageSELECT FileNumber --,MAX(F.FechaTermino)ExpirationDate ,MAX(ISNULL(F1.FechaTermino,[FechaRadicacion]))ExpirationDateInitial --,CASE WHEN ExperationDate >= [FechaRadicacion] THEN ExperationDate ELSE MAX(ISNULL(F1.FechaTermino,[FechaRadicacion]))END ExpirationDateInitial --Se realiza ajuste a campo de acuerdo a validación con Julio INTO FECHAINICIALVENCIMIENTOTEMP FROM ( SELECT DISTINCT RequestFiles.FileNumber ,MIN(RequestFiles.FiledDate) [FechaRadicacion] ,MAX(CASE WHEN RequestFiles1.ResposnseText=2 THEN RequestFiles1.FiledDate END ) [FechaRespuestaParcialMaxima] ,MAX(CASE WHEN RequestFiles1.ResposnseText=1 THEN RequestFiles1.FiledDate END ) [FechaRespuestaFinalMaxima] ,MAX(DMS_Procedures.ResponseTime) ResponseTime --,RequestFiles.ExperationDate --,MAX(F1.FechaTermino) [ExpirationDateInitial] --INTO #FECHAINICIALVENCIMIENTO FROM DMS.dbo.RequestFiles LEFT JOIN DMS.dbo.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId LEFT JOIN DMS.dbo.RequestFileHistories ON RequestFileHistories.RequestFileId=RequestFiles.Id AND RequestFileHistories.CreationDate=(SELECT MAX(CreationDate) FROM DMS.dbo.RequestFileHistories A WHERE A.RequestFileId=RequestFileHistories.RequestFileId) LEFT JOIN DMS.dbo.Dependencies ON Dependencies.Id=RequestFileHistories.DependencyId LEFT JOIN dms.dbo.RelatedRequestFiles ON RelatedRequestFiles.ParentId =RequestFiles.Id LEFT JOIN dms.dbo.RequestFiles RequestFiles1 ON RelatedRequestFiles.requestfileId =CONVERT(VARCHAR(40),RequestFiles1.Id) --WHERE RequestFiles.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' --WHERE RequestFileHistories.CreationDate >= DATEADD(MONTH, -6, GETDATE()) --AND RequestFiles.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' --AND RequestFiles.FileNumber ='20230321376732' WHERE RequestFileHistories.Status <>'E6D67E4A-F545-4D62-B882-5A38A0FC35E2' --AND RequestFileHistories.CreationDate >= DATEADD(MONTH, -6, GETDATE()) --AND RequestFiles.FileNumber IN ('20240323449482','20241073468712','20241013458352') --AND RequestFiles.FileNumber IN ('20241014144082') --AND YEAR(RequestFiles.FiledDate) = 2024 --AND MONTH(RequestFiles.FiledDate) = 10 --AND DAY(RequestFiles.FiledDate) = 30 --AND RequestFiles.FiledDate <> '2024-10-29' --AND RequestFiles.FileNumber <> 0 GROUP BY RequestFiles.FileNumber --,RequestFiles.ExperationDate ,RequestFiles.FiledDate )Vencimiento --CROSS APPLY DBO.FechaTerminoSinDiasInhabiles (CONVERT(date,[FechaRespuestaParcialMaxima]+1),15) F CROSS APPLY DBO.FechaTerminoSinDiasInhabiles (CONVERT(DATE,[FechaRadicacion]+1),ResponseTime) F1 GROUP BY FileNumber
30518695287612965211262485SELECT 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
11859828518598285106157307031StageINSERT INTO VentanillaUnicaFinal ( [Id Tarea] ,Radicado ,[Fecha Radicacion] ,[Hora Radicacion] ,[Tipo de Documento] ,[Tipificacion] ,[Usuario Actual] ,[Vicepresidencia] ,[Dependencia Actual] ,[Asunto] ,[Medio de Recepcion] ,[Tipo Remitente] ,Remitente ,[Dependencia Radicacion] ,[Tipo Documento Remitente] ,[Documento Remitente] ,[Direccion Remitente] ,[Celular] ,[Telefono] ,[Tipo Radicado] ,[Ciudad] ,[Departamento] ,[Email] ,[Estado Tarea] ,[Fecha Vencimiento] ,[Usuario Radicador] ,[Dias Habiles de Respuesta] ,[Proceso] ,[AñoFil] ,[MesFil] ,[ProcesoFil] ,[DependenciaFil] ,[RN] ) SELECT * FROM ( SELECT WF_SEGUI_PEN.CAS_CONT AS [Id Tarea], RequestFiles.FileNumber AS [Radicado], CAST(RequestFileHistories.CreationDate AS DATE) AS [Fecha Radicacion], CAST(RequestFileHistories.CreationDate AS TIME) AS [Hora Radicacion], ISNULL(DocumentType.Name,'No Definido') [Tipo de Documento], CONCAT(NameType.Name,' ' ,ProcedureType.Name,' ' ,SpecificationType.Name ) AS [Tipificacion], CONCAT(Users_Stage.Name, ' ',Users_Stage.Surnames) AS [Usuario Actual], COALESCE( CASE WHEN DependenciesPrincipal2.Description LIKE 'VICEPRESIDENCIA%' THEN DependenciesPrincipal2.Description ELSE NULL END ,CASE WHEN DependenciesPrincipal1.Description LIKE 'VICEPRESIDENCIA%' THEN DependenciesPrincipal1.Description ELSE NULL END ,CASE WHEN DependenciesPrincipal.Description LIKE 'VICEPRESIDENCIA%' THEN DependenciesPrincipal.Description ELSE NULL END ,CASE WHEN Dependencies.name LIKE 'VICEPRESIDENCIA%' THEN Dependencies.name ELSE NULL END ) AS [Vicepresidencia], Dependencies.Name AS [Dependencia Actual], RequestFiles.Subject AS [Asunto], CANAL.Name AS [Medio de Recepcion], TipoRemitente.Name AS [Tipo Remitente], CASE WHEN TipoRemitente.Name IN ('Persona Natural', 'Apoderado / Representante Legal') THEN CASE WHEN Contacto.Names IS NOT NULL THEN CONCAT(Contacto.Names, Contacto.Surnames) WHEN Contacto.Names IS NULL AND Clients.NamesClients IS NOT NULL THEN CONCAT(Clients.NamesClients,' ',Clients.SurNames) ELSE CAST(ISNULL(Contacto.BusinessName,Clients.BusinessName) AS VARCHAR(160)) END WHEN TipoRemitente.Name = 'Persona Jurídica' THEN CASE WHEN Contacto.BusinessName IS NOT NULL THEN Contacto.BusinessName WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NOT NULL THEN Clients.BusinessName WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NULL THEN CONCAT(Contacto.Names, Contacto.Surnames) WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NULL AND Contacto.Names IS NULL THEN CONCAT(Clients.NamesClients,' ',Clients.SurNames) END ELSE CAST(ISNULL(Contacto.BusinessName,Clients.BusinessName) AS VARCHAR(160)) END [Remitente], Dependencies.Name AS [Dependencia Radicacion], TIPODOCUMENTOREMITENTE.Name AS [Tipo Documento Remitente], ISNULL(Contacto.NumberIdentification, Clients.NumberIdentification) AS [Documento Remitente], Clients.Address AS [Direccion Remitente], Clients.Mobile AS [Celular], Clients.Phone AS [Telefono],TIPORADICADO.Name AS [Tipo Radicado], CITY.Description [Ciudad], DEPARTMENT.Description AS [Departamento], Clients.Email AS [Email], CASE WHEN WF_SEGUI_PEN.SEG_FATI >= GETDATE() THEN 'Tareas a tiempo' WHEN WF_SEGUI_PEN.SEG_FLIM <= GETDATE() THEN 'Tareas vencidas' ELSE 'Tareas por vencer' END AS [Estado Tarea], CAST(RequestFiles.ExperationDate AS DATE) AS [Fecha Vencimiento], CONCAT(Users1.Name,' ', Users1.Surnames ) AS [Usuario Radicador], DMS_Procedures.ResponseTime AS [Dias Habiles de Respuesta], PROCESO.Name AS [Proceso], YEAR(RequestFiles.FiledDate) AS [AñoFil], MONTH(RequestFiles.FiledDate) AS [MesFil], ISNULL(ESTADO.Code,0) [ProcesoFil], ISNULL(Dependencies.Code,0) AS [DependenciaFil], ROW_NUMBER() OVER (PARTITION BY RequestFiles.FileNumber ORDER BY RequestFileHistories.CreationDate DESC) AS RN FROM OpheliaSuite.dbo.WF_SEGUI_PEN INNER JOIN OpheliaSuite.dbo.WF_SEGUI ON WF_SEGUI.CAS_CONT=WF_SEGUI_PEN.CAS_CONT AND WF_SEGUI.SEG_CONT=WF_SEGUI_PEN.SEG_CONT AND WF_SEGUI_PEN.SEG_SUBJ NOT LIKE '%VISUALIZAR INCONSISTENCIA%' LEFT JOIN DMS.DBO.RequestFileHistories ON RequestFileHistories.CaseId=WF_SEGUI_PEN.CAS_CONT AND RequestFileHistories.CreationDate = (SELECT MAX(CreationDate) FROM DMS.DBO.RequestFileHistories A WHERE A.CaseId=WF_SEGUI_PEN.CAS_CONT) LEFT JOIN DMS.DBO.RequestFiles ON RequestFiles.Id=RequestFileHistories.RequestFileId LEFT JOIN Users_Stage on Users_Stage.UserName = WF_SEGUI_PEN.SEG_UENC LEFT JOIN ( SELECT Dependencies.Id ,UserId ,MIN(Dependencies.Name) OVER (PARTITION BY UserId) Name ,MIN(CASE WHEN (Dependencies.Name) =Dependencies.Name THEN Dependencies.Code END) OVER (PARTITION BY UserId) Code ,MIN(CASE WHEN (Dependencies.Name) =Dependencies.Name THEN Dependencies.TopSection END) OVER (PARTITION BY UserId) TopSection ,UsersCompany.State FROM DMS.DBO.Users INNER JOIN DMS.DBO.UsersCompany ON Users.Id=UsersCompany.UserId INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id=UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State=TypeDetail.Id AND TypeDetail.Code = (SELECT MIN(TypeDetail.Code) FROM DMS.DBO.UsersCompany A INNER JOIN DMS.DBO.TypeDetail ON A.State=TypeDetail.Id WHERE UsersCompany.UserId=A.UserId GROUP BY A.UserId ) ) Dependencies ON Users_Stage.Id = Dependencies.UserId LEFT JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40)) = RequestFileHistories.Status LEFT JOIN dms.dbo.TypeDetail PROCESO ON CAST(PROCESO.Id AS VARCHAR(40)) = RequestFileHistories.Status AND PROCESO.Name != 'Digitalizado' LEFT JOIN DMS.DBO.DocumentType ON DocumentType.Id=RequestFiles.DocumentTypeId LEFT JOIN DMS.DBO.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id=DMS_Procedures.ProcedureTypeId LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id=DMS_Procedures.NameTypeId LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id=DMS_Procedures.SpecificationTypeId LEFT JOIN DMS.DBO.TypeDetail CANAL ON CANAL.Id=RequestFiles.ChannelId LEFT JOIN DMS.DBO.Clients ON RequestFiles.ClientId=Clients.Id LEFT JOIN DMS.DBO.Contacts Contacto ON RequestFiles.ContactId=Contacto.Id LEFT JOIN DMS.DBO.TypeDetail TipoRemitente ON TipoRemitente.Id= ISNULL(Contacto.TypeContactId,Clients.PersonTypeId) LEFT JOIN DMS.DBO.TypeDetail TIPODOCUMENTOREMITENTE ON Clients.DocumentTypeId=TIPODOCUMENTOREMITENTE.Id LEFT JOIN DMS.DBO.TypeDetail TIPORADICADO ON RequestFiles.RequestTypeId =TIPORADICADO.Id LEFT JOIN DMS.DBO.GeographicsLocation CITY ON Clients.CityId=CITY.Id LEFT JOIN DMS.DBO.GeographicsLocation DEPARTMENT ON Clients.DepartamentId=DEPARTMENT.Id LEFT JOIN DMS.DBO.Users Users1 ON Users1.UserName=RequestFileHistories.UserName LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal ON DependenciesPrincipal.Id=Dependencies.TopSection LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal1 ON DependenciesPrincipal1.Id=DependenciesPrincipal.TopSection LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal2 ON DependenciesPrincipal2.Id=DependenciesPrincipal1.TopSection ) AS C WHERE RN = 1
32715012439459092355934696DMSSELECT CAST(EX.Code AS VARCHAR(50)) AS 'Numero', CAST(EX.NameReferencies AS VARCHAR(255)) AS 'Nombre', CONVERT(VARCHAR(50), PrimerTomo.InitialDate, 120) AS 'FechaInicial', CONVERT(VARCHAR(50), UltimoTomo.EndDate, 120) AS 'FechaFinal', CAST(UltimoTomo.Tomo AS VARCHAR(10)) AS 'CantidadTomos' FROM DMS_References EX WITH (NOLOCK) INNER JOIN Series S WITH (NOLOCK) ON S.Id = EX.SeriesId LEFT JOIN Subseries SS WITH (NOLOCK) ON SS.Id = EX.SubseriesId INNER JOIN Dependencies D WITH (NOLOCK) ON D.Id = EX.DependencyId OUTER APPLY ( SELECT TOP 1 SU.InitialDate FROM DMS_ReferencesSummary SU WITH (NOLOCK) WHERE SU.ReferenceId = EX.Id ORDER BY SU.Tomo ASC ) AS PrimerTomo OUTER APPLY ( SELECT TOP 1 SU.EndDate, SU.Tomo FROM DMS_ReferencesSummary SU WITH (NOLOCK) WHERE SU.ReferenceId = EX.Id ORDER BY SU.Tomo DESC ) AS UltimoTomo WHERE EX.StateId = 'B2873D51-8C51-412C-8634-6ECC0FA12675' AND ( (@TipoBusqueda = 1 AND D.Id = @Id_Dependencia_GUID AND S.Id = @Serie_GUID AND ( (@IsSubserieIdNull = 1 AND SS.Id IS NULL) OR (@IsSubserieIdNull = 0 AND SS.Id = @Subserie_GUID) ) ) OR (@TipoBusqueda = 2 AND CAST(D.Code AS VARCHAR(50)) = @CodigoDependencia AND CAST(S.Code AS VARCHAR(50)) = @CodigoSerie_Normalized -- NUEVAS CONDICIONES PARA @VersionTRD y @VersionCCD --AND EX.VersionTRD = @VersionTRD -ESPERAR PARA HABILITAR DE ACUERDO AL REPORTE QUE SE PRESENTE AND EX.VersionCCD = @VersionCCD AND ( (@IsCodigoSubserieNull = 1 AND (SS.Code IS NULL OR CAST(SS.Code AS VARCHAR(50)) = '')) OR (@IsCodigoSubserieNull = 0 AND CAST(SS.Code AS VARCHAR(50)) = @CodigoSubserie_Normalized) ) ) ) ORDER BY EX.CreationDate DESC
373708915009104499971105056StageSET @ConteoDias = ( SELECT 1 FROM OpheliaSuite.dbo.GN_DIASN D INNER JOIN OpheliaSuite.dbo.GN_CCALE C ON D.CCA_CONT = C.CCA_CONT AND C.CCA_NOMB = 'CALENDARIO SGDEA' WHERE CONVERT(DATE, D.DIA_NOTR) = @FechaInicial )
13849149320861078330902385849SELECT COUNT(*) FROM [ReassignmentTask] AS [r] WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0

Estadisticas potencialmente desactualizadas

DatabaseNameSchemaNameTableNameStatisticNameLastUpdatedRowsModificationCounterModifiedPct
Stagesyssysrscols_WA_Sys_00000003_000000031/15/2024 2:59:56 PM20792832233136230.54
Stagesyssyscolpars_WA_Sys_00000007_000000299/26/2024 10:24:36 AM1891148098278317.40
DMS_2syssysrscols_WA_Sys_00000005_000000032/3/2023 12:45:16 PM263664478224460.62
DMS_2syssysrscols_WA_Sys_00000002_000000032/3/2023 12:45:16 PM263664478224460.62
DMS_2syssysrscolsclst2/3/2023 12:45:16 PM263664478224460.62
DMS_BK_20syssysrscols_WA_Sys_00000005_000000036/21/2023 4:03:31 PM304133457211002.04
DMS_BK_20syssysrscols_WA_Sys_00000002_000000036/21/2023 4:03:31 PM304133457211002.04
DMS_BK_20syssysrscolsclst6/21/2023 4:03:31 PM304133457211002.04
Stagesyssysrscols_WA_Sys_00000005_000000035/28/2025 9:59:29 AM27712604769400.07
Stagesyssysrscols_WA_Sys_00000002_000000035/28/2025 9:59:29 AM27712604759400.04
Stagesyssysrscolsclst5/28/2025 9:59:29 AM27712604759400.04
DMS_2syssysidxstats_WA_Sys_00000006_000000361/3/2023 11:26:45 AM1048672606417.94
DMS_2syssysiscols_WA_Sys_00000007_0000003710/13/2022 1:09:28 PM1131712726301.68
DMS_bk_040923syssysidxstats_WA_Sys_00000006_000000364/25/2023 12:45:14 PM1156638685524.91
DMS_BK_20syssysidxstats_WA_Sys_00000006_000000364/25/2023 12:45:14 PM1156598985181.49
DMS_BK_20syssysiscols_WA_Sys_00000007_000000376/15/2023 9:27:37 AM1500592803952.00
DMS_bk_040923syssysrscols_WA_Sys_00000005_000000038/30/2023 3:24:10 PM32721117663415.83
DMS_bk_040923syssysrscols_WA_Sys_00000002_000000038/30/2023 3:24:10 PM32721117663415.83
DMS_bk_040923syssysrscolsclst8/30/2023 3:24:10 PM32721117663415.83
DMS_BK_20syssysidxstats_WA_Sys_00000008_000000366/15/2023 9:27:36 AM1210403523334.88
DMSsyssysrscols_WA_Sys_00000005_000000035/27/2025 4:24:37 PM4016912532272.24
DMSsyssysrscols_WA_Sys_00000002_000000035/27/2025 4:24:37 PM4016912522272.21
DMSsyssysrscolsclst5/27/2025 4:24:37 PM4016912522272.21
DMS_bk_040923syssysiscols_WA_Sys_00000007_000000379/1/2023 12:45:32 AM1668232741395.32
DMS_bk_040923syssysidxstats_WA_Sys_00000008_000000369/1/2023 12:50:03 AM126211988949.92
Stagesyssysschobjs_WA_Sys_0000000B_000000226/24/2025 9:13:37 AM266920120753.84
StagedboRadicacionVentUnica_WA_Sys_00000004_1A6B4A056/3/2026 7:10:08 AM5247913737653712.22
StagedboRadicacionVentUnica_WA_Sys_0000000A_1A6B4A056/3/2026 7:10:12 AM5532253737653675.61
StagedboVentanillaUnicaFinal_WA_Sys_00000002_436E2AEF6/3/2026 12:38:12 AM2711531629821601.07
StagedboVentanillaUnicaFinal_WA_Sys_0000001C_436E2AEF6/3/2026 12:38:12 AM2711531629821601.07
StagedboVentanillaUnicaFinal_WA_Sys_00000003_436E2AEF6/3/2026 12:38:12 AM2711531629821601.07
StagedboVentanillaUnicaFinal_WA_Sys_00000020_436E2AEF6/3/2026 12:38:12 AM2711531629821601.07
StagedboVentanillaUnicaFinal_WA_Sys_0000001F_436E2AEF6/3/2026 12:38:12 AM2711531629821601.07
StagedboVentanillaUnicaFinal_WA_Sys_0000000B_436E2AEF6/3/2026 12:38:13 AM2711531629821601.07
StagedboRequestFileHistories_Stage_WA_Sys_00000002_2997B3A56/3/2026 12:38:07 AM373444022420200600.36
StagedboRequestFileHistories_StagePK__RequestF__3214EC07D95CCDCF6/3/2026 12:38:07 AM373444022420200600.36
StagedboRadicacionVentUnica_WA_Sys_00000022_1A6B4A056/3/2026 12:38:07 AM186722011210100600.36
StagedboUsers_Stage_WA_Sys_00000003_7EB777416/3/2026 12:38:13 AM361421684600.00
StagedboUsers_Stage_WA_Sys_00000004_7EB777416/3/2026 12:38:13 AM361421684600.00
StagedboRadicacionVentUnica_WA_Sys_00000005_1A6B4A056/3/2026 7:10:33 AM8437383737653442.99
DMSdboRelatedRequestFiles_WA_Sys_00000003_55DFB4D96/3/2026 3:04:00 AM5880462370627403.14
StagedboSmartSupervisionMom1PK_SmartSupervisionMom16/3/2026 12:38:13 AM19697885400.46
StagedboSmartSupervisionMom1_WA_Sys_00000030_641AF1A36/3/2026 12:38:13 AM19697885400.46
StagedboSmartSupervisionMom1_WA_Sys_00000008_641AF1A36/3/2026 12:38:13 AM19697885400.46
StagedboSmartSupervisionMom1_WA_Sys_00000032_641AF1A36/3/2026 12:38:13 AM19697885400.46
StagedboSmartSupervisionMom1_WA_Sys_00000031_641AF1A36/3/2026 12:38:13 AM19697885400.46
StagedboSmartSupervisionMom1_WA_Sys_00000018_641AF1A36/3/2026 12:38:13 AM19697885400.46
StagedboSmartSupervisionMom1_WA_Sys_00000013_641AF1A36/3/2026 12:38:13 AM19697885400.46
StagedboSmartSupervisionMom1_WA_Sys_00000017_641AF1A36/3/2026 12:38:13 AM19697885400.46
StagedboSmartSupervisionMom1_WA_Sys_00000006_641AF1A36/3/2026 12:38:13 AM19697885400.46
StagedbopqrsdConsolidated_WA_Sys_0000000D_34ABD5A36/3/2026 12:38:10 AM5363932146038400.09
StagedbopqrsdConsolidated_WA_Sys_0000003E_34ABD5A36/3/2026 12:38:10 AM5363932146038400.09
StagedboRadicacionVentUnicaPK__Radicaci__9D0D06F81FF70C136/3/2026 6:00:06 AM18684047474476400.05
Stagesyssysschobjs_WA_Sys_0000000A_000000226/24/2025 9:13:37 AM266910584396.55
StagedboRadicacionVentUnica_WA_Sys_00000008_1A6B4A056/3/2026 7:10:47 AM9948923737653375.68
StagedboRadicacionVentUnica_WA_Sys_00000009_1A6B4A056/3/2026 7:11:12 AM12703473737653294.22
StagedboRadicacionVentUnica_WA_Sys_0000000B_1A6B4A056/3/2026 7:11:21 AM15036373737653248.57
Stagesyssysiscols_WA_Sys_00000007_000000373/2/2026 10:04:26 AM10222343229.26
Stagesyssysschobjs_WA_Sys_00000009_000000221/22/2026 9:13:35 AM26845917220.45
StagedboRadicacionVentUnica_WA_Sys_0000000C_1A6B4A056/3/2026 7:11:34 AM17375413737653215.11
StagedboRadicacionVentUnica_WA_Sys_00000003_1A6B4A056/3/2026 7:10:31 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000021_1A6B4A056/3/2026 7:11:45 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000029_1A6B4A056/3/2026 7:11:45 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000027_1A6B4A056/3/2026 7:11:44 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000025_1A6B4A056/3/2026 7:11:44 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000023_1A6B4A056/3/2026 7:11:44 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_0000001F_1A6B4A056/3/2026 7:11:44 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_0000001E_1A6B4A056/3/2026 7:11:43 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_0000001D_1A6B4A056/3/2026 7:11:43 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_0000001C_1A6B4A056/3/2026 7:11:43 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000019_1A6B4A056/3/2026 7:11:43 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000016_1A6B4A056/3/2026 7:11:42 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000015_1A6B4A056/3/2026 7:11:42 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000014_1A6B4A056/3/2026 7:11:42 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000013_1A6B4A056/3/2026 7:11:42 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000012_1A6B4A056/3/2026 7:11:42 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000011_1A6B4A056/3/2026 7:11:42 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_00000010_1A6B4A056/3/2026 7:11:41 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_0000000F_1A6B4A056/3/2026 7:11:41 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_0000000D_1A6B4A056/3/2026 7:11:40 AM18684193737653200.04
StagedboRadicacionVentUnica_WA_Sys_0000000E_1A6B4A056/3/2026 7:11:41 AM18684193737653200.04
StagedbopqrsdConsolidated_WA_Sys_00000021_34ABD5A36/3/2026 6:15:06 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000020_34ABD5A36/3/2026 6:15:06 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_0000001F_34ABD5A36/3/2026 6:15:06 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_0000001E_34ABD5A36/3/2026 6:15:06 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_0000001D_34ABD5A36/3/2026 6:15:06 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_0000001A_34ABD5A36/3/2026 6:15:05 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000019_34ABD5A36/3/2026 6:15:05 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000018_34ABD5A36/3/2026 6:15:05 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000017_34ABD5A36/3/2026 6:15:05 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000016_34ABD5A36/3/2026 6:15:05 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000015_34ABD5A36/3/2026 6:15:05 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000014_34ABD5A36/3/2026 6:15:05 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000013_34ABD5A36/3/2026 6:15:05 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000012_34ABD5A36/3/2026 6:15:04 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000011_34ABD5A36/3/2026 6:15:04 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_00000010_34ABD5A36/3/2026 6:15:04 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_0000000F_34ABD5A36/3/2026 6:15:04 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_0000000C_34ABD5A36/3/2026 6:15:04 AM5365231073122200.01
StagedbopqrsdConsolidated_WA_Sys_0000000B_34ABD5A36/3/2026 6:15:04 AM5365231073122200.01

Indices faltantes sugeridos por SQL Server

DatabaseNameSchemaNameTableNameUserSeeksUserScansAvgTotalUserCostAvgUserImpactEstimatedImpactEqualityColumnsInequalityColumnsIncludedColumns
OpheliaSuitedboWF_SEGUI17004718.7799.9780195094.73[ETA_CONT][SEG_ESTE], [AUD_UFAC]
OpheliaSuitedboWF_SEGUI10601523.8096.4815583676.73[SEG_UENC], [SEG_ESTE][FLU_CONT], [ETA_CONT], [SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI]
OpheliaSuitedboWF_SEGUI8401064.4491.848211677.72[SEG_ESTE][SEG_UENC]
OpheliaSuitedboWF_SEGUI3001535.0478.393609947.15[SEG_ESTE][FLU_CONT], [ETA_CONT], [SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI], [SEG_UENC]
OpheliaSuitedboWF_SEGUI2401529.4796.803553268.93[FLU_CONT], [ETA_CONT], [SEG_UENC], [SEG_ESTE][SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI]
OpheliaSuitedboWF_SEGUI3301103.7295.393474381.89[SEG_UENC], [SEG_ESTE][FLU_CONT], [SEG_SUBJ]
DMSdboDMS_ReorderedDocuments619034.8899.482147543.24[ReferenceId][Tomo], [DateDocument], [Folios], [Size]
DMSdboDMS_ReorderedDocuments619034.5599.942137539.36[ReferenceId][CodeReference], [Tomo], [ReferenceRFId], [DateDocument], [Orden], [Folios], [Size], [HomePage], [EndPage], [CreationUser], [RegistrationDate], [ModificationUser], [ModificationDate]
OpheliaSuitedboWF_SEGUI1801080.1799.971943729.82[SEG_UENC][SEG_ESTE]
OpheliaSuitedboWF_SEGUI901353.5587.961071523.97[FLU_CONT], [ETA_CONT], [SEG_ESTE][SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI], [SEG_UENC]
OpheliaSuitedboWF_SEGUI801121.0096.45864962.39[SEG_UENC][SEG_ESTE][FLU_CONT]
OpheliaSuitedboWF_SEGUI60952.9188.08503594.23[EMP_CODI], [FLU_CONT], [ETA_CONT][SEG_FREC], [SEG_FLIM], [SEG_ESTE][SEG_SUBJ], [SEG_UORI], [SEG_UENC]
OpheliaSuitedboWF_SEGUI70641.9080.47361577.30[SEG_ESTE][ETA_CONT]
OpheliaSuitedboWF_SEGUI101216.9288.40107576.06[FLU_CONT], [SEG_UENC][SEG_ESTE]
DMSdboDMS_ReorderedDocuments27040.1697.43105642.04[ReferenceRFId][Orden], [HomePage], [EndPage]
DMSdboRequestFileHistories301755.2413.6371771.66[Status], [ProcessCode][RequestFileId], [CreationDate]
DMSdboDMS_ReorderedDocuments31020.2996.3560612.96[Tomo], [ReferenceRFId]
DMSdboDMS_ReorderedDocuments31020.2995.6960197.76[Tomo][ReferenceRFId]
DMSdboRequestFileHistories60135.4657.9647108.40[CreationDate][RequestFileId], [Reason], [Status]
DMSdboReviewDocumentCertification73401.8533.2545169.14[State][IdDocumentCertification], [IdDetailManagePeaceAndSave], [TypeUserApproving]
DMSdboDMS_Security27604.7530.3239727.47[UserName], [ValidateUser]
OpheliaSuitedboWF_SEGUI14025.5074.7226672.18[EMP_CODI], [SEG_CONA], [SEG_ESTE][FLU_CONT], [SEG_FREC]
DMSdboRequestFiles10398.2959.7823809.55[ChannelId][FiledDate], [OriginId][FileNumber], [Subject], [PqrsTypeId], [ExperationDate]
DMSdboDocumentType15603.9738.3723775.54[Version][Name], [Code]
DMSdboClassificationHistories103400.2390.2621893.64[DependencyCode][SubserieCode][ClassificationHeadId], [SerieCode]
DMSdboReviewDocumentCertification22201.1185.1021037.77[IdDocumentCertification][IdDetailManagePeaceAndSave], [IdUserApproving], [State], [CreationDate], [ModificationDate]
OpheliaSuitedboWF_SEGUI101351.2014.6519795.07[EMP_CODI], [FLU_CONT], [ETA_CONT], [SEG_ESTE][SEG_FREC][SEG_HREC]
OpheliaSuitedboWF_CASOS5037.4799.7118680.92[EMP_CODI], [USU_CODI][CAS_FECF][CAS_DESC], [FLU_CONT], [CAS_FLIM], [CAS_HLIM], [CAS_FECI], [CAS_HORI], [CAS_HORF], [CAS_ESTA]
OpheliaSuitedboWF_FETAP293100.1153.6217464.07[EMP_CODI], [PTL_CODI], [PTL_VERS]
OpheliaSuitedboWF_CASOS3044.1499.3013148.79[EMP_CODI], [USU_CODI][CAS_FECI], [CAS_FECF][CAS_DESC], [FLU_CONT], [CAS_FLIM], [CAS_HLIM], [CAS_HORI], [CAS_HORF], [CAS_ESTA]
DMSdboDMS_ReorderedDocuments6018.8699.7811290.77[ReferenceRFId][Tomo]
DMSdboRequestFiles20513.5210.0610332.05[UserName][FiledDate][FileNumber]
DMSdboClassificationHistories15600.7982.4710134.99[ClassificationHeadId][DependencyCode], [SerieCode], [SubserieCode]
DMSdboDMS_Procedures45501.5613.729749.61[ProcessVersion], [ProcessType][ProceduresStateId][ResponseTime], [ResponsibleUserId], [DependenciesId], [ProcedureTypeId], [NameTypeId]
DMSdboRequestFiles20513.529.209448.79[FileNumber], [FiledDate][UserName]
DMSdboRequestFiles10180.6949.919018.26[RequestTypeId], [MassiveConsecutive][StatusId][CaseId]
msdbdbosysjobactivity77500.1854.837685.70[job_id][next_scheduled_run_date]
DMSdboDMS_References131100.0685.026910.11[DependencyId], [SeriesId], [CompanyId], [NameReferencies], [StateId], [ParentId]
DMSdboDMS_References5012.0399.635992.61[PendingReorder]
StagedbopqrsdConsolidated1058.2298.725747.76[AñoFil], [UsuarioFil][MesFil][RADICADO], [FECHA_RADICADO], [HORA_RADICADO], [MEDIO_DE_RECEPCION], [TIPO_DE_PQR], [CAUSAL], [DETALLE_CAUSAL], [DETALLE_DESAGREGADO_CAUSAL], [NOMBRE_REMITENTE], [TIPO_DE_DOCUMENTO_REMITENTE], [DOCUMENTO_DE_REMITENTE], [DIRECCION_REMITENTE], [ASUNTO_RADICADO], [FUNCIONARIO_ACTUAL], [DEPENDENCIA_ACTUAL], [RADICADO_RESPUESTA_FINAL], [FECHA_DE_CONTESTACION], [ESTADO_ACTUAL], [TOTAL_DIAS_TRAMITE], [FECHA_DE_VENCIMIENTO], [MES/AÑO], [GESTION], [PROCESO], [FECHA_RESPUESTA_PARCIAL], [RADICADO_RESPUESTA_PARCIAL], [TIPO_DE_FRAUDE], [MODALIDAD_DE_FRAUDE], [MONTO_RECLAMADO], [MONTO_RECONOCIDO]
DMSdboRequestFiles10180.6927.174909.36[RequestTypeId], [MassiveConsecutive][StatusId][FileNumber], [FiledDate], [CaseId]
DMSdboSubseries67400.1261.244764.48[VersionTRD][Code], [Name]
DMSdboDMS_Security4204.5723.274467.79[UserName]
DMSdboCertificationTracing33700.2160.944380.65[IdDocumentCertification][IdStateDocumentCertification], [IdCase]
DMSdboDMS_Procedures20400.6730.504189.49[ProceduresStateId], [VisibleWeb][ResponsibleUserId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId], [ProcessVersion], [IdTheme], [IdBussinnes]
DMSdboRequestFilesClients5900.7388.583833.14[RequestFilesId][ContactId]
OpheliaSuitedboWF_CASOS1037.4699.693734.14[EMP_CODI], [USU_CODI][CAS_FECI][CAS_DESC], [FLU_CONT], [CAS_FLIM], [CAS_HLIM], [CAS_HORI], [CAS_FECF], [CAS_HORF], [CAS_ESTA]
DMSdboDMS_Procedures20400.6727.023711.47[VisibleWeb][ResponsibleUserId], [ProceduresStateId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId], [ProcessVersion], [IdTheme], [IdBussinnes]
DrivedboDRIVE_METADATA3601.0199.253608.52[FolderCode][BucketName], [FileId], [FileName], [CreationDate], [CreatedBy], [UpdatedBy], [LastUpdate], [Tags], [Size], [MicroAppCode], [Folder1], [Folder2], [MigrateStatus], [DriveId]
DMSdboClassificationHistories22800.2361.963194.69[ClassificationHeadId][DependencyCode], [SerieCode]

Indices no usados o de bajo uso

DatabaseNameSchemaNameTableNameIndexNameTypeDescUserSeeksUserScansUserLookupsUserUpdates
OpheliaSuitedboWF_IRUTAIDX_NC_WF_IRUTA_002NONCLUSTERED000360081
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_009NONCLUSTERED00085989
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_010NONCLUSTERED00085183
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_004NONCLUSTERED00014659
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_001NONCLUSTERED00014508
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_002NONCLUSTERED00014508
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_002NONCLUSTERED00014091
OpheliaSuitedboWF_PROCESS_QUEUEUX_WF_PROCESS_QUEUE_IDEMPOTENCYNONCLUSTERED0004229
DMSdboCasesRelationParentAndChildDX_NC_CasesRelationParentAndChild_ChildCaseNONCLUSTERED0002529
DMSdboReassignmentTaskIX_ReassignmentTask_JobIdNONCLUSTERED0001780
DMSdboReassignmentTaskIX_ReassignmentTask_RetryNONCLUSTERED0001780
DMSdboEventsIDX_NC_Events_001NONCLUSTERED0001598
OpheliaSuitedboWF_PROCESS_QUEUEIX_WF_PROCESS_QUEUE_CREATED_BYNONCLUSTERED0001349
DMSdboConsecutiveReferenceHistoryIDX_NC_ConsecutiveReferenceHistory_001NONCLUSTERED0001319
DMSdboRepresentativesIDX_NC_Representatives_002NONCLUSTERED00064
DMSdboRelatedTasksHistoryIDX_NC_RelatedTasksHistory_001NONCLUSTERED00021
DMSdboDMS_MassiveProcessLogIX_DMS_MassiveProcessLog_StateNONCLUSTERED00012

Deadlocks historicos - system_health

No hay datos.

Errores recientes SQL

LogDateProcessInfoText
6/3/2026 10:34:23 AMLogonError: 18456, Severity: 14, State: 8.
6/3/2026 10:34:23 AMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.2.44]
6/2/2026 2:54:54 PMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 2:54:54 PMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.179]
6/2/2026 2:54:50 PMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 2:54:50 PMLogonLogin 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 PMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 2:54:47 PMLogonLogin failed for user 'opheliadms'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.179]
6/2/2026 11:46:54 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:54 AMLogonLogin 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 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:44 AMLogonLogin 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 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:41 AMLogonLogin 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 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:21 AMLogonLogin 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 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:09 AMLogonLogin 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 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:05 AMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159]
6/1/2026 2:42:17 PMLogonError: 18456, Severity: 14, State: 8.
6/1/2026 2:42:17 PMLogonLogin 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 PMLogonError: 18456, Severity: 14, State: 8.
6/1/2026 2:41:49 PMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.25]
5/31/2026 6:02:58 AMspid6sWarning: Failure to calculate super-latch promotion threshold.
5/29/2026 2:58:25 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:58:25 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:58:19 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:58:19 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:58:12 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:58:12 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:58:02 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:58:02 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:57:56 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:57:56 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:53 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:57:53 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:49 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:57:49 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:47 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:57:47 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:46 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:57:46 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:43 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:57:43 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:34 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:57:34 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:19 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:19 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:57:18 AMLogonError: 18456, Severity: 14, State: 38.

Tareas Ophelia en cola por servidor (estado Q)

ServidorIPCantidad
10.238.99.15011
10.238.99.1519
10.238.99.15311

Indices fragmentados - todas las bases de datos (TOP 100 por impacto)

base_datosesquematablaindicetype_descfragmentacion_pctpage_counttamano_mbaccion_recomendada
OpheliaSuitedboWF_SEGUIPK_WF_SEGUICLUSTERED48.08636881649756.4REBUILD
DrivedboDRIVE_METADATAPK__DRIVE_ME__DED88B1C6A0453BFCLUSTERED90.648329716507.6REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_009NONCLUSTERED96.326517355091.7REBUILD
OpheliaSuitedboWF_SEGUIIN_WF_SEGUI_02NONCLUSTERED38.61141689611069.5REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_006NONCLUSTERED69.487565385910.5REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_002NONCLUSTERED44.5211576269044.0REBUILD
OpheliaSuitedboWF_LOGPLPK_WF_LOGPLCLUSTERED46.5810954128557.9REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_001NONCLUSTERED43.5211520879000.7REBUILD
OpheliaSuitedboWF_IRUTAPK_WF_IRUTACLUSTERED33.59132088910319.4REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_004NONCLUSTERED34.2712260269578.3REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_003NONCLUSTERED46.998878266936.1REBUILD
OpheliaSuitedboWF_IRUTAIDX_NC_WF_IRUTA_001NONCLUSTERED18.40155681612162.6REORGANIZE
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_007NONCLUSTERED33.977628315959.6REBUILD
DMSdboDMS_IndexesPK__DMS_Inde__3214EC0764BB43FACLUSTERED44.365513874307.7REBUILD
OpheliaSuitedboWF_IRUTAIDX_NC_WF_IRUTA_002NONCLUSTERED21.4511118898686.6REORGANIZE
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_010NONCLUSTERED95.362259701765.4REBUILD
DrivedboDRIVE_METADATAIX_DRIVE_METADATA_FolderCodeNONCLUSTERED86.542372771853.7REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_002NONCLUSTERED81.732438881905.4REBUILD
DrivedboDRIVE_METADATAUQ__DRIVE_ME__6F0F98BEF15CEBCCNONCLUSTERED67.762238961749.2REBUILD
DrivedboDRIVE_FOLDERPK__DRIVE_FO__DED88B1C73D9DEFECLUSTERED92.881597231247.8REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_008NONCLUSTERED8.16153392611983.8NO ACCION
OpheliaSuitedboWF_SEGUIIN_WF_SEGUI_01NONCLUSTERED5.26217305516977.0NO ACCION
OpheliaSuitedboWF_CASOSPK_WF_CASOSCLUSTERED47.761955021527.4REBUILD
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_003NONCLUSTERED65.171294781011.5REBUILD
DMSdboRequestEmailPK__tmp_ms_x__3214EC0709EC20FCCLUSTERED33.672187621709.1REBUILD
DMSdboPQRSDWebProcessLogPK__PQRSDWeb__3214EC07598FFB3BCLUSTERED19.513283342565.1REORGANIZE
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_004NONCLUSTERED95.0259163462.2REBUILD
DrivedboDRIVE_FOLDERIX_DRIVE_FOLDER_CodeNONCLUSTERED94.9659129461.9REBUILD
OpheliaSuitedboWF_FPLANIDX_NC_WF_FPLAN_001NONCLUSTERED19.852520291969.0REORGANIZE
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_001NONCLUSTERED42.71111516871.2REBUILD
DMSdboDMS_ReorderedDocumentsPK_DMS_ReorderedDocumentsCLUSTERED75.7450455394.2REBUILD
OpheliaSuitedboWF_FPLANPK_WF_FPLANCLUSTERED9.683925853067.1NO ACCION
DrivedboDRIVE_FOLDERUQ__DRIVE_FO__A25C5AA750312A26NONCLUSTERED73.0541452323.8REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_005NONCLUSTERED24.24112740880.8REORGANIZE
OpheliaSuitedboWF_FPLANUQ_WF_FPLAN_001NONCLUSTERED12.521890461476.9REORGANIZE
DMSdboReferencesRequestFileIDX_NC_ReferencesRequestFile_00NONCLUSTERED27.8983849655.1REORGANIZE
OpheliaSuitedboWF_FPLANIDX_NC_WF_FPLAN_002NONCLUSTERED6.853048432381.6NO ACCION
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_003NONCLUSTERED34.2657126446.3REBUILD
DMSdboReferencesRequestFilePK_ReferencesRequestFileCLUSTERED22.2086731677.6REORGANIZE
DMSdboRequestFilesStampedPK__RequestF__3214EC07BDB22205CLUSTERED47.2939501308.6REBUILD
OpheliaSuitedboWF_VBPERPK_WF_VBPERCLUSTERED45.8034389268.7REBUILD
DMSdboRequestFilesIDX_NC_RequestFiles_012NONCLUSTERED20.7568640536.3REORGANIZE
DMSdboRadicadeHistoryPK__tmp_ms_x__3214EC078C329747CLUSTERED23.3847220368.9REORGANIZE
DMSdboManagePeaceAndSaveDetailScopePK_ManagePeaceAndSaveDetailScopeCLUSTERED23.1947378370.1REORGANIZE
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_005NONCLUSTERED6.851589421241.7NO ACCION
DMSdboDMS_ReorderedDocumentsIX_DMS_ReorderedDocuments_001NONCLUSTERED46.1723497183.6REBUILD
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_005NONCLUSTERED25.1536750287.1REORGANIZE
DMSdboRequestFilesStampedIDX_NC_RequestFilesStamped_001NONCLUSTERED44.3918914147.8REBUILD
DMSdboDMS_IndexesIDX_NC_DMS_Indexes_002NONCLUSTERED17.2444207345.4REORGANIZE
DMSdboReferencesRequestFileIDX_NC_ReferencesRequestFile_002NONCLUSTERED47.9315375120.1REBUILD
DMSdboRequestEmailIDX_RequestEmailV_DateAffairSenderNONCLUSTERED30.6323849186.3REBUILD
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_011NONCLUSTERED12.9853582418.6REORGANIZE
DMSdboRequestFilesIDX_NC_RequestFiles_006NONCLUSTERED18.7634993273.4REORGANIZE
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_002NONCLUSTERED17.5434760271.6REORGANIZE
DMSdboContactsPK__Contacts__3214EC07786292A4CLUSTERED11.6451887405.4REORGANIZE
DMSdboDMS_ReferencesIDX_NC_DMS_References_007NONCLUSTERED48.091210394.6REBUILD
DMSdboDMS_IndexesIDX_NC_DMS_Indexes_001NONCLUSTERED19.7229285228.8REORGANIZE
DMSdboRequestFilesIDX_NC_RequestFiles_015NONCLUSTERED28.9017432136.2REORGANIZE
DMSdboRequestFilesIDX_NC_RequestFiles_013NONCLUSTERED25.9417418136.1REORGANIZE
DMSdboRequestFilesIDX_NC_RequestFiles_004NONCLUSTERED9.6744766349.7NO ACCION
DMSdboRequestFilesPK__tmp_ms_x__3214EC077390A34DCLUSTERED0.725538754327.1NO ACCION
StagedboRequestFilesExpirationDateidx_nc_RequestFilesExpirationDate_001NONCLUSTERED45.48871968.1REBUILD
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_002NONCLUSTERED14.8924648192.6REORGANIZE
DMSdboRadicadeHistoryIDX_NC_RadicadeHistory_002NONCLUSTERED26.9213415104.8REORGANIZE
OpheliaSuitedboWF_RCPROIN_WF_RCPRO_01NONCLUSTERED8.6640688317.9NO ACCION
DMSdboDMS_ReferencesSummaryPK_DMS_ReferencesSummaryCLUSTERED72.95478437.4REBUILD
DMSdboGeneralErrorsLogPK__GeneralE__3214EC07DE39B021CLUSTERED10.8230509238.4REORGANIZE
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_002NONCLUSTERED8.1839674310.0NO ACCION
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_001NONCLUSTERED14.3722500175.8REORGANIZE
DMSdboRadicadeHistoryIDX_NC_RadicadeHistory_001NONCLUSTERED14.2822120172.8REORGANIZE
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_001NONCLUSTERED7.5640536316.7NO ACCION
DMSdboRadicadeHistoryIDX_NC_RadicadeHistory_003NONCLUSTERED34.01899270.3REBUILD
OpheliaSuitedboWF_ICOMPPK_WF_ICOMPCLUSTERED3.0199699778.9NO ACCION
DMSdboRepresentativesPK_RepresentativesCLUSTERED44.96653751.1REBUILD
DMSdboRequestFilesIX_RequestFiles_FiledDateNONCLUSTERED26.991086584.9REORGANIZE
DMSdboRequestFilesDX_NC_RequestFiles_002NONCLUSTERED22.101266899.0REORGANIZE
DMSdboEventsPK__Events__3214EC07909701EDCLUSTERED29.27943273.7REORGANIZE
DMSdboRequestFilesIX_RequestFiles_MassiveConsecutiveNONCLUSTERED28.86940673.5REORGANIZE
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_003NONCLUSTERED6.5939568309.1NO ACCION
DrivedboFILE_METADATAPK_FILE_METADATACLUSTERED99.22229517.9REBUILD
DMSdboDMS_ReferencesPK__tmp_ms_x__3214EC0766F9A7BBCLUSTERED13.7216004125.0REORGANIZE
OpheliaSuitedboWF_RCPROPK_WF_RCPROCLUSTERED3.3464826506.5NO ACCION
DMSdboSmartReportedComplaintFilesPK__SmartRep__3214EC07AFE49E42CLUSTERED42.92503739.4REBUILD
DMSdboRepresentativesIDX_NC_Representatives_003NONCLUSTERED37.15581545.4REBUILD
DMSdboSmartProcessLogPK__SmartPro__3214EC07387BAEFFCLUSTERED46.94336426.3REBUILD
DMSdboDMS_ReferencesIDX_NC_DMS_References_009NONCLUSTERED41.31368928.8REBUILD
DMSdboManagePeaceAndSaveDetailScopeIDX_NC_ManagePeaceAndSaveDetailScope_001NONCLUSTERED5.2128316221.2NO ACCION
DMSdboConsecutiveReferenceHistoryPK__tmp_ms_x__3214EC07EE486E18CLUSTERED49.49276021.6REBUILD
DMSdboCasesRelationParentAndChildPK_CasesRelationParentAndChildCLUSTERED46.75263320.6REBUILD
DMSdboCopiesCommunicationIDX_NC_CopiesCommunication_001NONCLUSTERED24.14504139.4REORGANIZE
DMSdboReassignmentTaskIX_ReassignmentTask_JobIdNONCLUSTERED49.09203515.9REBUILD
DMSdboClientsIX_Clients_NumIdent_DocTypeNONCLUSTERED28.44343926.9REORGANIZE
DMSdboRepresentativesIDX_NC_Representatives_001NONCLUSTERED26.41364628.5REORGANIZE
DMSGDEAdboDIMRADICACIONPk_RadicacionCLUSTERED48.76184814.4REBUILD
DMSdboRequestFilesIDX_NC_RequestFiles_016NONCLUSTERED4.9617280135.0NO ACCION
DMSdboContactsIDX_NC_Contacts_001NONCLUSTERED12.63661351.7REORGANIZE
DMSdboClientsPK__Clients__3214EC075B672D4ACLUSTERED3.0325620200.2NO ACCION
DMSdboPQRSDWebProcessLogIX_PQRSDWebProcessLog_BeginQueueNONCLUSTERED17.04441834.5REORGANIZE
OpheliaSuitedboWF_PROCESS_QUEUEPK_WF_PROCESS_QUEUECLUSTERED0.6873544574.6NO ACCION
OpheliaSuitedboWF_DEVOLPK_WF_DEVOLCLUSTERED33.4511038.6REBUILD

Guía de mantenimiento de índices

CondiciónAcciónComentario
Fragmentación menor a 10%NO ACCIÓNNo justifica mantenimiento.
Fragmentación entre 10% y 30% y page_count >= 1000REORGANIZEOperación más liviana, normalmente online.
Fragmentación mayor o igual a 30% y page_count >= 1000REBUILDProgramar en ventana. Validar edición, espacio en disco, TempDB y log.
Índice pequeño con page_count menor a 1000NO ACCIÓNLa fragmentación en índices pequeños suele ser ruido.

Nota: para índices grandes como PK_WF_SEGUI, si el resultado recomienda REBUILD, no ejecutarlo en hora pico. Revisar espacio libre, TempDB, transaction log y si la edición permite ONLINE = ON.