Diagnóstico SQL Server - DWSGDASQL2

Resumen Ejecutivo SQL

RAM libre7.92 GB
RAM total60 GB
CPU promedio28.36 %
Conexiones SQL2773
Disco promedio37.98 %
Bloqueos activos0
Bases de datos20
Transacciones abiertas120
Tareas en cola (Q)30

Servidor SQL: SRVCLSGDEA\SGDEAPRY,1633

Host: DWSGDASQL2

Fecha: 06/01/2026 14:01:26

Alertas

Recomendaciones

Información del sistema

CSNameCaptionVersionLastBootUpTimeTotalRAMGBFreeRAMGB
DWSGDASQL2Microsoft Windows Server 2019 Standard10.0.177635/24/2026 12:01:11 AM607.92

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.667.78
D:TEMP299.9879.1426.38
E:DATA5222.38716.3513.72
F:LOG299.98265.0288.34
G:BACKUPS499.98321.9164.38
Q:New Volume19.9819.3696.91
S:Spool299.98257.4885.83

Contadores de rendimiento - muestra 1 minuto

CounterMinMaxAverage
\\dwsgdasql2\processor(_total)\% processor time17.3241.1828.36
\\dwsgdasql2\memory\available mbytes636670906708.58
\\dwsgdasql2\system\processor queue length000
\\dwsgdasql2\physicaldisk(_total)\% disk time4.73230.637.98
\\dwsgdasql2\physicaldisk(_total)\current disk queue length051.5

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
61439449994500035302394

Bases de datos

DatabaseNameStateRecoveryModelCompatibilityLevelSizeMBCreateDate
OpheliaSuiteONLINEFULL15044628661/25/2023 11:42:38 AM
tempdbONLINESIMPLE1502243785/29/2026 2:36:28 AM
DMSONLINEFULL150979893/9/2024 11:45:05 PM
StageONLINEFULL150365575/8/2023 11:39:48 AM
DriveONLINEFULL1503458811/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
MicroSQLDWSGDAAPP2opheliadms739
MicroSQLDWSGDAAPP1opheliadms704
MicroSQLDWSGDAAPP3opheliadms699
MicroSQLDWSGDAAPP2ophelia117
MicroSQLDWSGDAAPP3ophelia108
MicroSQLDWSGDAAPP1ophelia90
ODKDWSGDAAPP1ophelia64
ODKDWSGDAAPP3ophelia50
MicroSQLDWSGDAAPP4opheliadms38
ODKDWSGDAAPP2ophelia37
Core Microsoft SqlClient Data ProviderDWSGDAAPP2opheliadms17
Core Microsoft SqlClient Data ProviderDWSGDAAPP3opheliadms14
Core Microsoft SqlClient Data ProviderDWSGDAAPP1opheliadms12
.Net SqlClient Data ProviderFASECOLDAVMmonitoreosaas5
Core .Net SqlClient Data ProviderDWSGDAAPP2ophelia4
DWSGDAAPP1ophelia4
Core Microsoft SqlClient Data ProviderDWSGDAAPP2ophelia4
Core Microsoft SqlClient Data ProviderDWSGDAAPP1ophelia4
Microsoft SQL Server Management Studio - QueryDW-P1722ophelia4
Microsoft SQL Server Management Studio - ConsultaDW-P10961ophelia3
Microsoft SQL Server Management Studio - ConsultaDW-P10966ophelia3
Core .Net SqlClient Data ProviderDWSGDAAPP3ophelia3
Core Microsoft SqlClient Data ProviderDWSGDAAPP3ophelia3
Microsoft SQL Server Management StudioDW-P10966ophelia3
DWSGDAAPP3ophelia3
Core .Net SqlClient Data ProviderDWSGDAAPP1ophelia3
Microsoft SQL Server Management Studio - QueryDW-P10840ophelia3
DWSGDAAPP2ophelia2
Core Microsoft SqlClient Data ProviderDWSGDAAPP4ophelia2
Microsoft SQL Server Management StudioDWSGDASQL2DIGITALWARE\DominnigM2
Microsoft SQL Server Management Studio - QueryDW-P10785ophelia2
Microsoft SQL Server Management Studio - QueryDWSGDASQL2DIGITALWARE\JeisonCR1
Microsoft® Windows® Operating SystemDWSGDASQL2NT AUTHORITY\SYSTEM1
Microsoft SQL Server Management StudioDWSGDASQL2DIGITALWARE\JeisonCR1
Microsoft SQL Server Management Studio - QueryDW-P10704ophelia1
Microsoft SQL Server Management StudioDW-P1722ophelia1
Core .Net SqlClient Data ProviderDWSGDAAPP3Opheliasuitebi1
Core Microsoft SqlClient Data ProviderDWSGDAMON2opheliadms1
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP1ophelia1
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP2ophelia1
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP3ophelia1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP1ophelia1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP2ophelia1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP3ophelia1
Microsoft SQL Server Management StudioDW-P10704ophelia1
Microsoft SQL Server Management StudioDW-P10785ophelia1
Microsoft SQL Server Management StudioDW-P10840ophelia1
.Net SqlClient Data ProviderDWSGDASQL2ophelia1
Core .Net SqlClient Data ProviderDWSGDAAPP1Opheliasuitebi1
Core .Net SqlClient Data ProviderDWSGDAAPP2Opheliasuitebi1
MicroSQLDWSGDAAPP31
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
51NT AUTHORITY\SYSTEMDWSGDASQL2Microsoft® Windows® Operating SystemrunningEXECUTESP_SERVER_DIAGNOSTICS_SLEEP9137633master
1557opheliaDWSGDASQL2.Net SqlClient Data ProviderrunningSELECT0100master
1484DWSGDAAPP3MicroSQLrunningSELECTASYNC_NETWORK_IO72231AgoraSSB

Bloqueos activos

No hay datos.

Transacciones abiertas (> 5 seg)

SessionIdHostAplicacionUsuarioInicioTransaccionSegundosAbiertaTipoTransaccionUltimaConsulta
206DWSGDAAPP2MicroSQLophelia6/1/2026 7:37:21 AM23044Read/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)
101DWSGDAAPP3MicroSQLophelia6/1/2026 7:39:05 AM22940Read/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)
276DWSGDAAPP1MicroSQLophelia6/1/2026 7:45:04 AM22581Read/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)
207DWSGDAAPP2MicroSQLophelia6/1/2026 8:09:07 AM21138Read/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)
495DWSGDAAPP3MicroSQLophelia6/1/2026 8:21:05 AM20420Read/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)
309DWSGDAAPP3MicroSQLophelia6/1/2026 8:24:14 AM20231Read/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)
456DWSGDAAPP2MicroSQLophelia6/1/2026 8:24:15 AM20230Read/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)
502DWSGDAAPP2MicroSQLophelia6/1/2026 8:26:29 AM20096Read/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)
488DWSGDAAPP3MicroSQLophelia6/1/2026 8:27:03 AM20062Read/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)
459DWSGDAAPP2MicroSQLophelia6/1/2026 8:27:03 AM20062Read/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)
547DWSGDAAPP1MicroSQLophelia6/1/2026 8:30:29 AM19856Read/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)
512DWSGDAAPP3MicroSQLophelia6/1/2026 8:30:29 AM19856Read/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)
491DWSGDAAPP2MicroSQLophelia6/1/2026 8:31:25 AM19800Read/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)
267DWSGDAAPP1MicroSQLophelia6/1/2026 8:33:07 AM19698Read/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)
520DWSGDAAPP3MicroSQLophelia6/1/2026 8:33:07 AM19698Read/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)
541DWSGDAAPP1MicroSQLophelia6/1/2026 8:34:02 AM19643Read/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)
238DWSGDAAPP1MicroSQLophelia6/1/2026 8:36:45 AM19480Read/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)
454DWSGDAAPP2MicroSQLophelia6/1/2026 8:37:58 AM19407Read/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)
498DWSGDAAPP3MicroSQLophelia6/1/2026 8:37:58 AM19407Read/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)
606DWSGDAAPP1MicroSQLophelia6/1/2026 8:46:49 AM18876Read/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)
446DWSGDAAPP2MicroSQLophelia6/1/2026 8:46:49 AM18876Read/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)
514DWSGDAAPP3MicroSQLophelia6/1/2026 8:49:07 AM18738Read/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)
336DWSGDAAPP1MicroSQLophelia6/1/2026 8:49:07 AM18738Read/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)
144DWSGDAAPP1MicroSQLophelia6/1/2026 8:49:25 AM18720Read/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/1/2026 8:57:08 AM18257Read/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)
87DWSGDAAPP1MicroSQLophelia6/1/2026 9:00:00 AM18085Read/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)
250DWSGDAAPP3MicroSQLophelia6/1/2026 9:00:41 AM18044Read/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)
443DWSGDAAPP3MicroSQLophelia6/1/2026 9:04:10 AM17835Read/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)
397DWSGDAAPP3MicroSQLophelia6/1/2026 9:05:22 AM17763Read/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)
490DWSGDAAPP2MicroSQLophelia6/1/2026 9:05:22 AM17763Read/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)
74DWSGDAAPP3MicroSQLophelia6/1/2026 9:05:54 AM17731Read/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)
649DWSGDAAPP1MicroSQLophelia6/1/2026 9:08:29 AM17576Read/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)
252DWSGDAAPP1MicroSQLophelia6/1/2026 9:15:23 AM17162Read/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)
819DWSGDAAPP3MicroSQLophelia6/1/2026 9:15:23 AM17162Read/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)
438DWSGDAAPP2MicroSQLophelia6/1/2026 9:21:06 AM16819Read/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)
173DWSGDAAPP3MicroSQLophelia6/1/2026 9:30:14 AM16271Read/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)
261DWSGDAAPP1MicroSQLophelia6/1/2026 9:31:20 AM16205Read/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)
904DWSGDAAPP3MicroSQLophelia6/1/2026 9:35:06 AM15979Read/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)
771DWSGDAAPP1MicroSQLophelia6/1/2026 9:42:34 AM15531Read/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)
329DWSGDAAPP3MicroSQLophelia6/1/2026 9:44:51 AM15394Read/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)
772DWSGDAAPP1MicroSQLophelia6/1/2026 9:47:15 AM15250Read/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)
765DWSGDAAPP1MicroSQLophelia6/1/2026 9:47:16 AM15249Read/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)
225DWSGDAAPP1MicroSQLophelia6/1/2026 10:00:25 AM14460Read/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)
668DWSGDAAPP2MicroSQLophelia6/1/2026 10:04:15 AM14230Read/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)
702DWSGDAAPP1MicroSQLophelia6/1/2026 10:04:20 AM14225Read/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)
743DWSGDAAPP1MicroSQLophelia6/1/2026 10:04:20 AM14225Read/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)
1249DWSGDAAPP2MicroSQLophelia6/1/2026 10:08:15 AM13990Read/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)
411DWSGDAAPP3MicroSQLophelia6/1/2026 10:09:12 AM13933Read/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)
122DWSGDAAPP3MicroSQLophelia6/1/2026 10:09:12 AM13933Read/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)
1323DWSGDAAPP2MicroSQLophelia6/1/2026 10:09:12 AM13933Read/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)
817DWSGDAAPP3MicroSQLophelia6/1/2026 10:11:45 AM13780Read/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)
583DWSGDAAPP2MicroSQLophelia6/1/2026 10:13:57 AM13648Read/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)
1704DWSGDAAPP1MicroSQLophelia6/1/2026 10:16:42 AM13483Read/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)
1311DWSGDAAPP1MicroSQLophelia6/1/2026 10:20:03 AM13282Read/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)
1821DWSGDAAPP1MicroSQLophelia6/1/2026 10:21:04 AM13221Read/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)
1739DWSGDAAPP1MicroSQLophelia6/1/2026 10:23:17 AM13088Read/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)
500DWSGDAAPP3MicroSQLophelia6/1/2026 10:23:17 AM13088Read/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)
1761DWSGDAAPP1MicroSQLophelia6/1/2026 10:35:22 AM12363Read/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)
1232DWSGDAAPP1MicroSQLophelia6/1/2026 10:35:27 AM12358Read/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)
1428DWSGDAAPP3MicroSQLophelia6/1/2026 10:36:05 AM12320Read/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)
274DWSGDAAPP1MicroSQLophelia6/1/2026 10:36:17 AM12308Read/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)
1580DWSGDAAPP3MicroSQLophelia6/1/2026 10:38:06 AM12199Read/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)
410DWSGDAAPP1MicroSQLophelia6/1/2026 10:38:06 AM12199Read/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)
1335DWSGDAAPP2MicroSQLophelia6/1/2026 10:40:53 AM12032Read/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)
781DWSGDAAPP3MicroSQLophelia6/1/2026 10:44:19 AM11826Read/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)
1785DWSGDAAPP2MicroSQLophelia6/1/2026 10:46:32 AM11693Read/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)
890DWSGDAAPP2MicroSQLophelia6/1/2026 10:48:33 AM11572Read/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)
694DWSGDAAPP3MicroSQLophelia6/1/2026 10:52:49 AM11316Read/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)
1333DWSGDAAPP2MicroSQLophelia6/1/2026 10:53:07 AM11298Read/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)
1243DWSGDAAPP2MicroSQLophelia6/1/2026 10:53:14 AM11291Read/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)
1091DWSGDAAPP2MicroSQLophelia6/1/2026 10:55:11 AM11174Read/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)
735DWSGDAAPP2MicroSQLophelia6/1/2026 11:05:13 AM10572Read/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)
678DWSGDAAPP3MicroSQLophelia6/1/2026 11:06:21 AM10504Read/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)
165DWSGDAAPP3MicroSQLophelia6/1/2026 11:07:04 AM10461Read/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)
1711DWSGDAAPP1MicroSQLophelia6/1/2026 11:07:04 AM10461Read/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)
522DWSGDAAPP3MicroSQLophelia6/1/2026 11:15:30 AM9955Read/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)
530DWSGDAAPP2MicroSQLophelia6/1/2026 11:21:18 AM9607Read/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)
202DWSGDAAPP3MicroSQLophelia6/1/2026 11:23:55 AM9450Read/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)
1577DWSGDAAPP3MicroSQLophelia6/1/2026 11:25:33 AM9352Read/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)
1143DWSGDAAPP2MicroSQLophelia6/1/2026 11:25:58 AM9327Read/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)
611DWSGDAAPP3MicroSQLophelia6/1/2026 11:26:24 AM9301Read/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)
449DWSGDAAPP2MicroSQLophelia6/1/2026 11:30:03 AM9082Read/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)
426DWSGDAAPP2MicroSQLophelia6/1/2026 11:33:40 AM8865Read/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)
521DWSGDAAPP2MicroSQLophelia6/1/2026 11:42:40 AM8325Read/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)
1806DWSGDAAPP1MicroSQLophelia6/1/2026 11:54:16 AM7629Read/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)
955DWSGDAAPP2MicroSQLophelia6/1/2026 11:56:28 AM7497Read/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)
685DWSGDAAPP3MicroSQLophelia6/1/2026 11:56:38 AM7487Read/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)
946DWSGDAAPP3MicroSQLophelia6/1/2026 12:00:01 PM7284Read/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)
1177DWSGDAAPP3MicroSQLophelia6/1/2026 12:00:01 PM7284Read/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)
1842DWSGDAAPP1MicroSQLophelia6/1/2026 12:00:20 PM7265Read/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)
452DWSGDAAPP2MicroSQLophelia6/1/2026 12:05:16 PM6969Read/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)
1297DWSGDAAPP2MicroSQLophelia6/1/2026 12:07:36 PM6829Read/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)
497DWSGDAAPP3MicroSQLophelia6/1/2026 12:13:06 PM6499Read/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)
821DWSGDAAPP3MicroSQLophelia6/1/2026 12:23:51 PM5854Read/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)
1290DWSGDAAPP1MicroSQLophelia6/1/2026 12:25:27 PM5758Read/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)
868DWSGDAAPP3MicroSQLophelia6/1/2026 12:29:53 PM5492Read/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)
469DWSGDAAPP1MicroSQLophelia6/1/2026 12:29:53 PM5492Read/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)
1129DWSGDAAPP1MicroSQLophelia6/1/2026 12:35:10 PM5175Read/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)
2440DWSGDAAPP3MicroSQLophelia6/1/2026 12:36:10 PM5115Read/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)
1296DWSGDAAPP1MicroSQLophelia6/1/2026 12:39:38 PM4907Read/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)
1748DWSGDAAPP1MicroSQLophelia6/1/2026 12:43:15 PM4690Read/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)
2019DWSGDAAPP2MicroSQLophelia6/1/2026 12:43:39 PM4666Read/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)
1424DWSGDAAPP3MicroSQLophelia6/1/2026 12:46:40 PM4485Read/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)
418DWSGDAAPP3MicroSQLophelia6/1/2026 12:48:12 PM4393Read/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)
282DWSGDAAPP1MicroSQLophelia6/1/2026 12:48:21 PM4384Read/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)
776DWSGDAAPP3MicroSQLophelia6/1/2026 12:48:21 PM4384Read/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)
2378DWSGDAAPP2MicroSQLophelia6/1/2026 12:48:21 PM4384Read/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)
554DWSGDAAPP2MicroSQLophelia6/1/2026 12:48:21 PM4384Read/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)
566DWSGDAAPP2MicroSQLophelia6/1/2026 12:48:21 PM4384Read/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)
1337DWSGDAAPP2MicroSQLophelia6/1/2026 12:49:38 PM4307Read/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)
377DWSGDAAPP3MicroSQLophelia6/1/2026 12:53:45 PM4060Read/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)
545DWSGDAAPP1MicroSQLophelia6/1/2026 12:59:42 PM3703Read/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)
684DWSGDAAPP3MicroSQLophelia6/1/2026 1:00:18 PM3667Read/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)
2118DWSGDAAPP2MicroSQLophelia6/1/2026 1:00:18 PM3667Read/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)
1846DWSGDAAPP1MicroSQLophelia6/1/2026 1:00:55 PM3630Read/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)
1525DWSGDAAPP3MicroSQLophelia6/1/2026 1:17:02 PM2663Read/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)
1276DWSGDAAPP2MicroSQLophelia6/1/2026 1:24:30 PM2215Read/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)
2582DWSGDAAPP3MicroSQLophelia6/1/2026 1:34:11 PM1634Read/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)
1109DWSGDAAPP3MicroSQLophelia6/1/2026 1:58:24 PM181Read/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)
2688DWSGDAAPP1MicroSQLophelia6/1/2026 1:59:56 PM89Read/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)

Wait Stats

wait_typewaiting_tasks_countwait_time_msAvgWaitMssignal_wait_time_ms
SOS_WORK_DISPATCHER34439784352282943341022.0013185622
CXPACKET591787194894538048.0018475275
CXCONSUMER872161853810416564.0030724119
PREEMPTIVE_XE_DISPATCHER38567020328556734.000
BACKUPBUFFER42949237921570718.004607818
PAGEIOLATCH_SH19210718536546472.001351663
BACKUPIO15492044124579526.001155809
ASYNC_NETWORK_IO27032813953650114.00808418
SOS_SCHEDULER_YIELD38272702358995510.0035803624
ASYNC_IO_COMPLETION22531535498140157.0050
LCK_M_IS8271154802513963.00549
PARALLEL_REDO_WORKER_WAIT_WORK1690398108029516.0021139
BPSORT4282430103047852.001420756
LATCH_EX410222385424992.001760332
LCK_M_S91764524017036.00293
LCK_M_X93141661994474.002321
PAGEIOLATCH_EX121289740208713.00115232
WRITELOG81376037237384.00385498
IO_COMPLETION79243629594593.0029214
RESERVED_MEMORY_ALLOCATION_EXT97916847927195630.000

Top Queries CPU

ExecutionsCPUTimeMsAvgCPUMsElapsedMsLogicalReadsQueryText
2405018342209091193349186818682SELECT [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
3286691395563765064718390587INSERT 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
165921201413721428697148821071SELECT 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]
11096856109685648746792966591INSERT 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')
11075909107590940970295356100INSERT 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')
17106102662413125381439940629SELECT DISTINCT RequestFiles.Id RequestFileId ,RequestFileIdParent ,CASE WHEN Status='914f4fcc-627c-49b0-8c67-75a21f826d31' THEN '1' --Finalizado --WHEN Status='7AD94AE5-6D29-4EC0-B846-2664C88A7D45' THEN '2' --Getión y Tramite --ELSE NULL END ResponseText ELSE '2' END ResponseText --18/10/2024 Se realiza ajuste de acuerdo a los diferentes posibles status que puede tener un radicado, se valida con Julio INTO #RADICADOSTEMP_ FROM RequestFiles INNER JOIN ( SELECT RequestFileId RequestFileIdParent --,REPLACE(RIGHT(RequestFileHistories.Reason, CHARINDEX(' ', REVERSE(RequestFileHistories.Reason)) - 1),'radicado','') AS reason ,CASE WHEN CHARINDEX(' ', RequestFileHistories.Reason) > 0 THEN REPLACE( REVERSE( SUBSTRING( REVERSE(RequestFileHistories.Reason), 1, CHARINDEX(' ', REVERSE(RequestFileHistories.Reason)) - 1 ) ), 'radicado', '' ) ELSE REPLACE(RequestFileHistories.Reason, 'radicado', '') END AS reason ,Status FROM RequestFileHistories INNER JOIN RequestFiles ON RequestFiles.ID=RequestFileHistories.RequestFileId AND OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' --AND CONVERT(DATE,RequestFileHistories.CreationDate) =CONVERT(DATE,GETDATE()) WHERE RequestFileHistories.Reason LIKE '%Se envía respuesta%' OR RequestFileHistories.Reason LIKE '%Se envió respuesta%' --and RequestFileId='D1D39553-523A-4B4F-87F0-BD80A20B6A6A' --AND --where --RequestFiles.FileNumber='20231012303362' --)RADICADOS ON RADICADOS.Reason=RequestFiles.FileNumber --WHERE RequestFileId='B90E3FB9-304F-41C4-B124-251A6BC8B62F' )RADICADOS ON RADICADOS.reason=RequestFiles.FileNumber
11060524106052427348619946113SELECT 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
178498654999291342319162354MERGE RequestFiles AS TGT USING #RADICADOSTEMP2 AS SRC ON TGT.id=SRC.RequestFileId WHEN MATCHED THEN UPDATE SET TGT.ResposnseText=SRC.ResponseText;
1438829745577152428525270222INSERT INTO [dbo].[RequestFiles]            ([Id],[ClientId],[ProcedureId],[FileNumber],[FiledDate],[RequestTypeId],[StatusId],[Subject],[ResponseDate],[DestinyNameId],[ResponseTime]            ,[DependencyId],[Pages],[Description],[UserName],[Attachments],[NamesCustomer],[Phone],[ChannelId],[MessageBody],[SenderName],[Postal]            ,[ReceiverName],[ReceiverCompany],[ReceiverDependency],[SeriesId],[SubseriesId],[DestinyName],[Reason],[ApproverName],[ResposnseText],[ResponseName]            ,[CourrierName],[CourrierNumber],[PqrsTypeId],[Cellphone],[AttachDescription],[OriginId],[CaseId],[DocumentTypeId],[ExperationDate],[ContactId]            ,[Location],[DaysPendingManagement],[TermDeadline],[ThemeId],[ReasonId],[PerformanceId],[PQRSDAnalysisDecisionId],[SPCTypeId],[AssumeCost]            ,[InformedId],[Observations],[PriorityId],[NotesIncompleteInformation],[SIGEPDirectoryId],[Ruling],[AppealRulingApplies],[AcceptTerms],[ExternalId]            ,[MassiveConsecutive],[CrossReferenceNumber],[CrossReferenceResponsibleId],[CrossReferenceDate],[AnnexTypeId],[DocumentDate],[SignatureTypeId]            ,[FileName],[AttachmentTypeId],[ReceivingInstanceId],[UsersId],[ComplaintAttached],[ComplaintOrigin],[ReportedSmart],[ReportedAttachedSmart]            ,[BeginProcessCE],[Ip],[Captcha],[CollaborativeWorkName],[CollaborativeWorkBody],[RepresentativeId],[ClientRepresentativeRelatedId],[CollaboratorDependencyId],[ValidateCase], [RadicateOrion],[VersionCCD],[VersionTRD])      SELECT @IdReqFile,[ClientId],[ProcedureId],[FileNumber],[FiledDate],[RequestTypeId],[StatusId],[Subject],[ResponseDate],[DestinyNameId]       ,[ResponseTime],[DependencyId],[Pages],[Description],[UserName],[Attachments],[NamesCustomer],[Phone],[ChannelId],[MessageBody]       ,[SenderName],[Postal],[ReceiverName],[ReceiverCompany],[ReceiverDependency],[SeriesId],[SubseriesId],[DestinyName],[Reason]       ,[ApproverName],[ResposnseText],[ResponseName],[CourrierName],[CourrierNumber],[PqrsTypeId],[Cellphone],[AttachDescription],[OriginId]       ,[CaseId],[DocumentTypeId],[ExperationDate],[ContactId],[Location],[DaysPendingManagement],[TermDeadline],[ThemeId],[ReasonId]       ,[PerformanceId],[PQRSDAnalysisDecisionId],[SPCTypeId],[AssumeCost],[InformedId],[Observations],[PriorityId],[NotesIncompleteInformation]       ,[SIGEPDirectoryId],[Ruling],[AppealRulingApplies],[AcceptTerms],[ExternalId],[MassiveConsecutive],[CrossReferenceNumber],[CrossReferenceResponsibleId]       ,[CrossReferenceDate],[AnnexTypeId],[DocumentDate],[SignatureTypeId],[FileName],[AttachmentTypeId],[ReceivingInstanceId],[UsersId]       ,[ComplaintAttached],[ComplaintOrigin],[ReportedSmart],[ReportedAttachedSmart],[BeginProcessCE],[Ip],[Captcha],[CollaborativeWorkName],[CollaborativeWorkBody] ,[RepresentativeId],[ClientRepresentativeRelatedId],[CollaboratorDependencyId],[ValidateCase],[RadicateOrion],[VersionCCD],[VersionTRD]       FROM [dbo].[RadicateInfo_tmp]       WHERE [Id] = @IdRadicateTmp
1439824059572101427925083864IF EXISTS ( SELECT 1 FROM dbo.RequestFiles r INNER JOIN inserted i ON rtrim(Ltrim(r.FileNumber)) = rtrim(Ltrim(i.FileNumber)) WHERE r.Id <> i.Id -- Excluir el mismo registro recién insertado (actualización) )
993810582816902312112SELECT 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'
43682846158801776792448733SELECT TOP (1) TDP.Code AS 'Tipo de persona', TDI.Code AS 'Tipo de identificación', CL.NamesClients AS 'Nombres', CL.SurNames AS 'Apellidos', CL.BusinessName AS 'Nombre Entidad / Empresa', TD3.Code AS 'Sexo', cl.LGBTIQCommunity AS 'LGBTIQ+', TD4.Code AS 'Condición especial', cl.AffiliatedFomag AS 'Afiliado a FOMAG', TD5.Code AS 'Tipo de afiliado', TD6.Code AS 'Instancia de recepción', glp.IataCode AS 'País', gld.IataCode AS 'Departamento', glc.IataCode AS 'Ciudad', GLB.IataCode AS 'Barrio', CL.Address AS 'Dirección', CL.OfficeAddress AS 'Dirección oficina', RF.Postal AS 'Código postal', CL.Phone AS 'Teléfono y extensión', cl.Mobile AS 'Celular', CL.Email AS 'Correo electrónico' FROM CLIENTS_VW CL LEFT JOIN GeographicsLocatioPais_VW glp ON glp.Id = CL.CountryTypeId LEFT JOIN GeographicsLocatioDep_VW gld ON gld.Id = CL.DepartamentId LEFT JOIN GeographicsLocationMun_VW glc on glc.Id = CL.CityId LEFT JOIN GeographicsLocatioBarrio_VW GLB ON GLB.Id = CL.NeighBorhoodId LEFT JOIN TYPEPERSON_VW TDP ON TDP.Id = CL.PersonTypeId LEFT JOIN TYPEIDENTI_VW TDI ON TDI.Id = CL.DocumentTypeId LEFT JOIN TYPEGENDER_VW TD3 ON TD3.Id = CL.GenderId LEFT JOIN TYPESPECIALCONDITION_VW TD4 ON TD4.Id = CL.SpecialConditionId LEFT JOIN TYPEAFFILIATE_VW TD5 ON TD5.Id = CL.AffiliateTypeId LEFT JOIN REQUESTFILE_VW RF ON RF.CLientId = CL.Id LEFT JOIN TYPEINSTARECEP_VW TD6 ON TD6.Id = RF.ReceivingInstanceId INNER JOIN ( SELECT CLients.NumberIdentification , MAX(CreationDate) AS FechaMaxima FROM CLIENTS_VW CLients WHERE CLients.NumberIdentification=@Identificacion GROUP BY CLients.NumberIdentification ) Recientes ON Recientes.NumberIdentification=CL.NumberIdentification AND Recientes.FechaMaxima=CL.CreationDate WHERE CL.NumberIdentification = @Identificacion
5588209611261065040231184150SET @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 )
356045701727362514918301615with 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
145867864191396290654174241select RequestFiles . FileNumber , convert ( VARCHAR , RequestFiles . FiledDate ) Z from RequestFiles left join RequestFileHistories on RequestFiles . Id = RequestFileHistories . RequestFileId and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from dms . dbo . RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @0 ) ) left join TypeDetail on TypeDetail . Id = RequestFileHistories . Status where RequestFileHistories . UserName = @1 and TypeDetail . Name < > @2
151767351767321099952725746INSERT INTO [dbo].[pqrsdConsolidated] ([RADICADO], [FECHA_RADICADO], [HORA_RADICADO], [MEDIO_DE_RECEPCION], [DEPENDENCIA_ASIGNADA], [DEPENDENCIA_DE_RADICACION], [USUARIO_RADICADOR], [TIPO_DE_PQR], [CAUSAL], [DETALLE_CAUSAL], [DETALLE_DESAGREGADO_CAUSAL], [NOMBRE_REMITENTE], [CONDICION_ESPECIAL], [TIPO_PERSONA], [TIPO_DE_DOCUMENTO_REMITENTE], [DOCUMENTO_DE_REMITENTE], [DIRECCION_REMITENTE], [BARRIO_REMITENTE], [CIUDAD_REMITENTE], [DEPARTAMENTO_REMITENTE], [EMAIL_REMITENTE], [TELEFONO_REMITENTE], [CELULAR_REMITENTE], [USUARIO_FOMAG], [ENTE_REMITENTE], [ASUNTO_RADICADO], [FUNCIONARIO_ACTUAL], [DEPENDENCIA_ACTUAL], [FECHA_DE_TRAMITE_PQR], [TRAMITE_PROCEDENTE], [TRAMITE_A_FAVOR_DEL_CONSUMIDOR_O_LA_ENTIDAD], [TRMTE_ACEPTADO_POR_LA_ENTIDAD], [TRMTE_RECHAZADO_POR_LA_ENTIDAD], [TRMTE_REMTDO_A_SUPERFINANCIERA], [TRMTE_RECTIFICADO_POR_ENTIDAD], [TRAMITE_DESISTIDO], [RADICADO_RESPUESTA_FINAL], [FECHA_DE_CONTESTACION], [MEDIO_DE_CONTESTACION], [DEPENDENCIA_QUE_CONTESTA], [USUARIO_QUE_CONTESTA], [ESTADO_ACTUAL], [TOTAL_DIAS_TRAMITE], [FECHA_DE_VENCIMIENTO], [MES/AÑO], [ESTADO_DEL_TRAMITE], [GESTION], [PROCESO], [USUARIO_QUE_ARCHIVA], [FECHA_RESPUESTA_PARCIAL], [TIPO DE RESPUESTA], [DIAS_RESPUESTA_PARCIAL], [FECHA_DE_VENCIMIENTO_FINAL], [RADICADO_RESPUESTA_PARCIAL], [REVISION], [APROBACION], [AREA], [AñoFil], [MesFil], [DependenciaFil], [UsuarioFil], [RowNum], [TIPO_DE_FRAUDE], [MODALIDAD_DE_FRAUDE], [MONTO_RECLAMADO], [MONTO_RECONOCIDO]) SELECT * FROM ( SELECT CAST(RequestFiles.FileNumber AS VARCHAR(30)) AS [RADICADO] ,CAST(RequestFiles.FiledDate AS DATE) AS [FECHA_RADICADO] ,CONVERT(VARCHAR(8), RequestFiles.FiledDate, 108) AS [HORA_RADICADO] ,CAST(CANAL.Name AS VARCHAR(30)) AS [MEDIO_DE_RECEPCION] ,CAST(COALESCE(Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_ASIGNADA] ,CAST(COALESCE(IIF(Users1.UserName='DEFENSOR','GERENCIA DE SERVICIO AL CLIENTE', Dependencies1.Name), Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_DE_RADICACION] ,CAST(CONCAT(Users1.Name, ' ', Users1.Surnames) AS VARCHAR(50)) AS [USUARIO_RADICADOR] ,CAST(PqrsType.Name AS VARCHAR(40)) AS [TIPO_DE_PQR] ,CAST(NameType.Name AS VARCHAR(140)) AS [CAUSAL] ,CAST(ProcedureType.Name AS VARCHAR(140)) AS [DETALLE_CAUSAL] ,CAST(REPLACE(REPLACE(SpecificationType.Name, CHAR(13), ''), CHAR(10), '') AS VARCHAR(140)) AS [DETALLE_DESAGREGADO_CAUSAL] ,CASE WHEN TipoPersona.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(250)) END WHEN TipoPersona.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 WHEN TipoPersona.Name = 'Anónimo' THEN 'Anónimo' ELSE CAST(ISNULL(Contacto.BusinessName,Clients.BusinessName) AS VARCHAR(250)) END AS [NOMBRE_REMITENTE] ,SpecialCondition.Name AS [CONDICION_ESPECIAL] ,CAST(ISNULL(TipoPersona.Name, TP.Name) AS VARCHAR(40)) AS [TIPO_PERSONA] ,CAST(TIPODOCUMENTOREMITENTE.Name AS VARCHAR(80)) AS [TIPO_DE_DOCUMENTO_REMITENTE] ,ISNULL(Contacto.NumberIdentification, Clients.NumberIdentification) AS [DOCUMENTO_DE_REMITENTE] ---Se actualiza para resolver caso aranda 55437 JULIOCF ,CAST(Contacto.Address AS VARCHAR(160)) AS [DIRECCION_REMITENTE] ,CAST(NeighBorhood.Description AS VARCHAR(80)) AS [BARRIO_REMITENTE] ,CAST(ISNULL(C.Description, CITY.Description) AS VARCHAR(60)) AS [CIUDAD_REMITENTE] ,CAST(ISNULL(D.Description, DEPARTMENT.Description) AS VARCHAR(80)) AS [DEPARTAMENTO_REMITENTE] --,CAST(ISNULL(Contacto.Email, Clients.Email) AS VARCHAR(80)) AS [EMAIL_REMITENTE] ,CASE WHEN TipoPersona.Name != 'Anónimo' THEN CAST(ISNULL(Contacto.Email, Clients.Email) AS VARCHAR(80)) WHEN TipoPersona.Name = 'Anónimo' AND RequestFilesRespuestaDefinitiva.FileNumber IS NOT NULL THEN CAST( ISNULL(ContactoRespDef.Email, ClienteRespDef.Email) AS VARCHAR(80) ) WHEN TipoPersona.Name = 'Anónimo' AND RequestFilesRespuestaParcial.FileNumber IS NOT NULL THEN CAST( ISNULL(ContactoRespPar.Email, ClienteRespPar.Email) AS VARCHAR(80) ) WHEN TipoPersona.Name = 'Anónimo' THEN 'servicioalcliente@fiduprevisora.com.co' END AS [EMAIL_REMITENTE] ,CAST(Contacto.Telephone AS VARCHAR(15)) AS [TELEFONO_REMITENTE] ,CAST(Contacto.Mobile AS VARCHAR(15)) AS [CELULAR_REMITENTE] ,CAST(ISNULL(AffiliateTypeC.Code, AffiliateType.Code) AS VARCHAR(15)) AS [USUARIO_FOMAG] ,CAST(ReceivingInstance.Description AS VARCHAR(50)) AS [ENTE_REMITENTE] ,CAST(REPLACE(REPLACE(RequestFiles.Subject, CHAR(13), ''), CHAR(10), '') AS VARCHAR(700)) AS [ASUNTO_RADICADO] ,CAST(IIF(CONCAT(Users.Name, ' ', Users.Surnames) = '', CONCAT(Users1.Name, ' ', Users1.Surnames), CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(50)) AS [FUNCIONARIO_ACTUAL] ,CAST(COALESCE(Dependencies4.Name, Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_ACTUAL] ,CAST(SmartAddicionalRequestFiles.CreationDateSmart AS DATE) AS [FECHA_DE_TRAMITE_PQR] ,CAST(SmartAddicionalRequestFiles.ComingFromProcedure AS VARCHAR(2)) AS [TRAMITE_PROCEDENTE] ,CAST(SmartAddicionalRequestFiles.FavorConsumerProcedure AS VARCHAR(30)) AS [TRAMITE_A_FAVOR_DEL_CONSUMIDOR_O_LA_ENTIDAD] ,CAST(Acceptance.Name AS VARCHAR(80)) AS [TRMTE_ACEPTADO_POR_LA_ENTIDAD] ,CAST(SmartAddicionalRequestFiles.RefusedEntityProcedure AS VARCHAR(2)) AS [TRMTE_RECHAZADO_POR_LA_ENTIDAD] ,CAST(SmartAddicionalRequestFiles.SuperFRemittedProcedure AS VARCHAR(2)) AS [TRMTE_REMTDO_A_SUPERFINANCIERA] ,CAST(rectification.Name AS VARCHAR(100)) AS [TRMTE_RECTIFICADO_POR_ENTIDAD] ,CAST(ComplaintWithdrawal.Description AS VARCHAR(40)) AS [TRAMITE_DESISTIDO] ,CAST(RequestFilesRespuestaDefinitiva.FileNumber AS VARCHAR(30)) AS [RADICADO_RESPUESTA_FINAL] ,CAST(ISNULL(RequestFilesRespuestaDefinitiva.FiledDate, RequestFilesRespuestaParcial.FiledDate) AS DATE) AS [FECHA_DE_CONTESTACION] ,CAST(MAX(CANAL1.Name) OVER (PARTITION BY RequestFiles.FileNumber) AS VARCHAR(30)) AS [MEDIO_DE_CONTESTACION] ,CAST(COALESCE(Dependencies4.Name, Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_QUE_CONTESTA] ,CAST(IIF(CONCAT(Users.Name, ' ', Users.Surnames) = '', CONCAT(Users1.Name, ' ', Users1.Surnames), CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(50)) AS [USUARIO_QUE_CONTESTA] ,CASE WHEN COALESCE( CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) <= CAST(RequestFiles.ExperationDate AS DATE) THEN 'TRAMITADO OPORTUNAMENTE' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) > CAST(RequestFiles.ExperationDate AS DATE) THEN 'TRAMITADO EXTEMPORALMENTE' END, CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND CAST(RequestFiles.ExperationDate AS DATE) < GETDATE() - 1 THEN 'VENCIDO' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL --AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) IN (0,1,2,3) AND DA.[DiasHabiles] IN (0, 1, 2, 3) --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848 THEN 'PROXIMO A VENCER' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL --AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) > 3 AND DA.[DiasHabiles] >3 --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848 THEN 'EN TIEMPO' END ) IN ('VENCIDO', 'TRAMITADO EXTEMPORALMENTE') THEN 'INOPORTUNO' ELSE 'OPORTUNO' END AS [ESTADO_ACTUAL] ,RequestFilesExpirationDate.ProcedureDays AS [TOTAL_DIAS_TRAMITE] ,CAST(RequestFiles.ExperationDate AS DATE)[FECHA_DE_VENCIMIENTO] ,CAST(CONCAT(DATENAME(MONTH, DATEADD(MONTH, MONTH(RequestFiles.FiledDate) - 1, '1900-01-01')), ' - ', YEAR(RequestFiles.FiledDate)) AS VARCHAR(20)) AS [MES/AÑO] ,COALESCE( CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) <= CAST(RequestFiles.ExperationDate AS DATE) THEN 'TRAMITADO OPORTUNAMENTE' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) > CAST(RequestFiles.ExperationDate AS DATE) THEN 'TRAMITADO EXTEMPORALMENTE' END, CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND CAST(RequestFiles.ExperationDate AS DATE) < GETDATE() - 1 THEN 'VENCIDO' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL --AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) IN ( 0, 1, 2, 3) AND DA.[DiasHabiles] IN (0, 1, 2, 3) --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848 THEN 'PROXIMO A VENCER' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL --AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) > 3 AND DA.[DiasHabiles] > 3 --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848 THEN 'EN TIEMPO' END ) AS [ESTADO_DEL_TRAMITE] ,CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL THEN 'Tramitado' ELSE 'Pendiente' END AS [GESTION] ,ESTADO.Name AS [PROCESO] ,CAST(CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL THEN MAX(IIF(CONCAT(Users2.Name, ' ', Users2.Surnames) = '', NULL, CONCAT(Users2.Name, ' ', Users2.Surnames))) OVER (PARTITION BY RequestFiles.FileNumber) END AS VARCHAR(50)) AS [USUARIO_QUE_ARCHIVA] ,CAST(RequestFilesRespuestaParcial.FiledDate AS DATE) AS [FECHA_RESPUESTA_PARCIAL] ,CASE WHEN RequestFilesRespuestaParcial.FiledDate IS NOT NULL AND RequestFilesRespuestaDefinitiva.FiledDate IS NULL THEN 'Respuesta Parcial' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL THEN 'Respuesta Definitiva' END AS [TIPO_DE_RESPUESTA] ,CASE WHEN RequestFilesRespuestaParcial.FiledDate IS NOT NULL AND Users1.UserName ='DEFENSOR' THEN 8 WHEN RequestFilesRespuestaParcial.FiledDate IS NOT NULL THEN 15 END AS [DIAS_RESPUESTA_PARCIAL] ,CAST(RequestFiles.ExperationDate AS DATE) AS [FECHA_DE_VENCIMIENTO_FINAL] ,CAST(RequestFilesRespuestaParcial.FileNumber AS VARCHAR(30)) AS [RADICADO_RESPUESTA_PARCIAL] ,USuarioRevision.Funcionario AS [REVISION] ,USuarioAprobacion.Funcionario AS [APROBACION] ,CAST(COALESCE(Dependencies4.Name, Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [AREA] ,CAST(YEAR(RequestFiles.FiledDate) AS INT) AS [AñoFil] ,CAST(MONTH(RequestFiles.FiledDate) AS INT) AS [MesFil] ,MAX(ISNULL(Dependencies.Code, '0')) OVER (PARTITION BY RequestFiles.FileNumber) AS [DependenciaFil] ,Users.UserName AS [UsuarioFil] ,ROW_NUMBER() OVER (PARTITION BY RequestFiles.FileNumber ORDER BY RequestFiles.FiledDate DESC) AS RowNum -- Add campos Circular 19 ,Circular19.[TIPO_DE_FRAUDE] AS [TIPO_DE_FRAUDE] ,Circular19.[MODALIDAD_DE_FRAUDE] AS [MODALIDAD_DE_FRAUDE] ,Circular19.[MONTO_RECLAMADO] AS [MONTO_RECLAMADO] ,Circular19.[MONTO_RECONOCIDO] AS [MONTO_RECONOCIDO] FROM dms.dbo.RequestFiles WITH (NOLOCK) --Unión con RequestFileHistories para obtener la historia más reciente 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', --Se agregan los siguientes estados por caso SAC 960781 '4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425' ,'8d6acd5a-d128-45b0-b1a5-f9c0fef90708','EF7B7E43-9151-422A-9A2C-6E3B6C53BC85') AND (ProcessCode != 'Combinación de Correspondencia - ' AND ProcessName != 'Respuesta Parcial') AND ProcessCode !='615' ) AS RequestFileHistories ON RequestFileHistories.RequestFileId=RequestFiles.Id AND RequestFileHistories.MaxReg = 1 AND RequestFileHistories.DependencyId IS NOT NULL ------ Unión con RequestFileHistories1 para obtener la historia más antigua LEFT JOIN ( SELECT ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate ASC) AS MinReg ,RequestFileId ,CreationDate ,DependencyId ,UserName FROM dms.dbo.RequestFileHistories WHERE ProcessCode !='615' ) AS RequestFileHistories1 ON RequestFileHistories1.RequestFileId=RequestFiles.Id AND RequestFileHistories1.MinReg = 1 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%' AND FLU_CONT !=100 LEFT JOIN [Stage].[dbo].[Users_Stage] Users ON Users.UserName=ISNULL(WF_SEGUI_PEN.SEG_UENC,RequestFileHistories.UserName) LEFT JOIN [Stage].[dbo].[Users_Stage] Users1 ON Users1.UserName=RequestFileHistories1.UserName LEFT JOIN dms.dbo.Dependencies Dependencies3 ON Dependencies3.Id=RequestFileHistories.DependencyId LEFT JOIN ( --Subconsulta para obtener el nombre de la dependencia asociada al usuario SELECT UserId ,Dependencies.Name ,CASE WHEN (Dependencies.Name) =Dependencies.Name THEN Dependencies.Code END Code ,ROW_NUMBER() OVER (PARTITION BY UserId ORDER BY Code) NUMROW 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 )Dependencies ON Users.Id=Dependencies.UserId AND Dependencies.NUMROW=1 LEFT JOIN dms.dbo.Dependencies Dependencies1 ON Dependencies1.Id=RequestFileHistories1.DependencyId LEFT JOIN dms.dbo.Dependencies Dependencies4 ON RequestFileHistories.DependencyId = Dependencies4.Id LEFT JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))=RequestFileHistories.Status 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 Contacto.Id = RequestFiles.ContactId LEFT JOIN DMS.dbo.TypeDetail SpecialCondition ON Clients.SpecialConditionId = SpecialCondition.ID LEFT JOIN dms.dbo.TypeDetail TIPODOCUMENTOREMITENTE ON Clients.DocumentTypeId=TIPODOCUMENTOREMITENTE.Id LEFT JOIN dms.dbo.GeographicsLocation CITY ON Clients.CityId=CITY.Id LEFT JOIN dms.dbo.GeographicsLocation C ON Contacto.CityId = C.ID LEFT JOIN dms.dbo.GeographicsLocation DEPARTMENT ON Clients.DepartamentId=DEPARTMENT.Id LEFT JOIN dms.dbo.GeographicsLocation D ON Contacto.DepartamentId = D.ID LEFT JOIN dms.dbo.GeographicsLocation NeighBorhood ON Clients.NeighBorhoodId=NeighBorhood.Id LEFT JOIN dms.dbo.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id=DMS_Procedures.NameTypeId LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id=DMS_Procedures.ProcedureTypeId LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id=DMS_Procedures.SpecificationTypeId LEFT JOIN DMS.dbo.PQRSDType PqrsType ON PqrsType.Id=RequestFiles.PqrsTypeId LEFT JOIN dms.dbo.TypeDetail AffiliateTypeC ON Contacto.AffiliateTypeId = AffiliateTypeC.ID LEFT JOIN dms.dbo.TypeDetail AffiliateType ON Clients.AffiliateTypeId=CAST(AffiliateType.Id AS VARCHAR(40)) LEFT JOIN dms.dbo.TypeDetail ReceivingInstance ON RequestFiles.ReceivingInstanceId=CAST(ReceivingInstance.Id AS VARCHAR(40)) LEFT JOIN dms.dbo.SmartAddicionalRequestFiles ON SmartAddicionalRequestFiles.RequestFilesId=RequestFiles.Id LEFT JOIN dms.dbo.TypeDetail Acceptance ON SmartAddicionalRequestFiles.Acceptance=CAST(Acceptance.Id AS VARCHAR(40)) LEFT JOIN dms.dbo.TypeDetail ComplaintWithdrawal ON SmartAddicionalRequestFiles.ComplaintWithdrawal=CAST(ComplaintWithdrawal.Id AS VARCHAR(40)) LEFT JOIN dms.dbo.TypeDetail Rectification ON SmartAddicionalRequestFiles.Rectification = CAST(Rectification .Id AS VARCHAR(40)) LEFT JOIN RequestFilesExpirationDate ON RequestFilesExpirationDate.FileNumber=RequestFiles.FileNumber LEFT JOIN (--LEFT JOIN con RequestFileHistoriesRevision para obtener la última revisión de la respuesta SELECT UserName,RequestFileId,ROW_NUMBER() OVER(PARTITION BY RequestFileId ORDER BY CreationDate DESC,RequestFileId,UserName)NumberFile FROM dms.dbo.RequestFileHistories A inner JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))=a.Status AND ESTADO.name IN ('Respuesta en revisión') )RequestFileHistoriesRevision ON RequestFiles.Id=RequestFileHistoriesRevision.RequestFileId AND RequestFileHistoriesRevision.NumberFile=1 LEFT JOIN (--LEFT JOIN con RequestFileHistoriesAprobacion para obtener la última aprobación de la respuesta SELECT UserName,RequestFileId,ROW_NUMBER() OVER(PARTITION BY RequestFileId ORDER BY CreationDate DESC,RequestFileId,UserName)NumberFile FROM dms.dbo.RequestFileHistories A inner JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))=a.Status AND ESTADO.name IN ('Respuesta aprobada') )RequestFileHistoriesAprobacion ON RequestFiles.Id=RequestFileHistoriesAprobacion.RequestFileId AND RequestFileHistoriesAprobacion.NumberFile=1 LEFT JOIN dms.dbo.USERS_VW USuarioRevision ON USuarioRevision.UserName= RequestFileHistoriesRevision.UserName LEFT JOIN dms.dbo.USERS_VW USuarioAprobacion ON USuarioAprobacion.UserName= RequestFileHistoriesAprobacion.UserName LEFT JOIN (--LEFT JOIN con RequestFilesRespuestaParcial y RequestFilesRespuestaDefinitiva para obtener las respuestas parciales y definitivas SELECT B.ParentId,C.FiledDate,C.FileNumber,ChannelId,ContactId,ClientId,UserName,ROW_NUMBER() OVER(PARTITION BY B.ParentId ORDER BY C.FiledDate ASC,C.FileNumber,B.ParentId,ChannelId,UserName)NumberFile FROM dms.dbo.RelatedRequestFiles B INNER JOIN dms.dbo.RequestFiles C ON B.RequestFileId=C.Id WHERE C.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND C.ResposnseText=2)RequestFilesRespuestaParcial ON RequestFiles.Id=RequestFilesRespuestaParcial.ParentId AND RequestFilesRespuestaParcial.NumberFile=1 LEFT JOIN (-- LEFT JOIN con otras respuestas definitivas para obtener la última respuesta definitiva SELECT B.ParentId,C.FiledDate,C.FileNumber,ChannelId,ContactId,ClientId,UserName,ROW_NUMBER() OVER(PARTITION BY B.ParentId ORDER BY C.FiledDate DESC,C.FileNumber,B.ParentId,ChannelId,UserName)NumberFile FROM dms.dbo.RelatedRequestFiles B INNER JOIN dms.dbo.RequestFiles C ON B.RequestFileId=C.Id WHERE C.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND C.ResposnseText=1) RequestFilesRespuestaDefinitiva ON RequestFiles.Id=RequestFilesRespuestaDefinitiva.ParentId AND RequestFilesRespuestaDefinitiva.NumberFile=1 -- Contacto respuesta definitiva LEFT JOIN dms.dbo.Contacts ContactoRespDef ON ContactoRespDef.Id = RequestFilesRespuestaDefinitiva.ContactId LEFT JOIN dms.dbo.Clients ClienteRespDef ON ClienteRespDef.Id = RequestFilesRespuestaDefinitiva.ClientId -- Contacto respuesta parcial LEFT JOIN dms.dbo.Contacts ContactoRespPar ON ContactoRespPar.Id = RequestFilesRespuestaParcial.ContactId LEFT JOIN dms.dbo.Clients ClienteRespPar ON ClienteRespPar.Id = RequestFilesRespuestaParcial.ClientId -- LEFT JOIN dms.dbo.TypeDetail CANAL1 ON CANAL1.Id=ISNULL(RequestFilesRespuestaDefinitiva.ChannelId,RequestFilesRespuestaParcial.ChannelId) LEFT JOIN [Stage].[dbo].[Users_Stage] Users2 ON Users2.UserName=ISNULL(RequestFilesRespuestaParcial.UserName,RequestFilesRespuestaDefinitiva.UserName) LEFT JOIN DMS.DBO.TypeDetail TipoPersona ON TipoPersona.Id=Clients.PersonTypeId LEFT JOIN DMS.DBO.TypeDetail TP ON Contacto.TypeContactId = TP.ID --Consulta adiciona los campos de la actualización circular 19 LEFT JOIN ( SELECT RequestFilesId, FraudTypeName.Name AS [TIPO_DE_FRAUDE], FraudModalityName.Name AS [MODALIDAD_DE_FRAUDE], FORMAT(ISNULL(ClaimedAmount, 0), 'N0', 'es-CO') AS [MONTO_RECLAMADO], FORMAT(ISNULL(RecognizedAmount, 0), 'N0', 'es-CO') AS [MONTO_RECONOCIDO] FROM DMS.DBO.SmartAddicionalRequestFiles LEFT JOIN DMS.DBO.TypeDetail AS FraudTypeName ON SmartAddicionalRequestFiles.FraudType = FraudTypeName.Id AND FraudTypeName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB754' LEFT JOIN DMS.DBO.TypeDetail AS FraudModalityName ON SmartAddicionalRequestFiles.FraudModality = FraudModalityName.Id AND FraudModalityName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB758') AS Circular19 ON RequestFiles.Id = Circular19.RequestFilesId --Tabla de días habiles para calcular el campo de Estado_Tramite LEFT JOIN STAGE.DBO.DiasHabiles DA ON RequestFiles.id = DA.id WHERE --RequestFilesExpirationDate.FileNumber IS NOT NULL RequestFiles.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' AND ESTADO.name NOT IN ('Anulado','Solicitud de anulación') ) AS CF WHERE CF.RowNum = 1
10250525749531546167319251SELECT 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
375448410119559219616828795WITH 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
142877442877420317652566255INSERT INTO [dbo].[pqrsdConsolidated] ([RADICADO], [FECHA_RADICADO], [HORA_RADICADO], [MEDIO_DE_RECEPCION], [DEPENDENCIA_ASIGNADA], [DEPENDENCIA_DE_RADICACION], [USUARIO_RADICADOR], [TIPO_DE_PQR], [CAUSAL], [DETALLE_CAUSAL], [DETALLE_DESAGREGADO_CAUSAL], [NOMBRE_REMITENTE], [CONDICION_ESPECIAL], [TIPO_PERSONA], [TIPO_DE_DOCUMENTO_REMITENTE], [DOCUMENTO_DE_REMITENTE], [DIRECCION_REMITENTE], [BARRIO_REMITENTE], [CIUDAD_REMITENTE], [DEPARTAMENTO_REMITENTE], [EMAIL_REMITENTE], [TELEFONO_REMITENTE], [CELULAR_REMITENTE], [USUARIO_FOMAG], [ENTE_REMITENTE], [ASUNTO_RADICADO], [FUNCIONARIO_ACTUAL], [DEPENDENCIA_ACTUAL], [FECHA_DE_TRAMITE_PQR], [TRAMITE_PROCEDENTE], [TRAMITE_A_FAVOR_DEL_CONSUMIDOR_O_LA_ENTIDAD], [TRMTE_ACEPTADO_POR_LA_ENTIDAD], [TRMTE_RECHAZADO_POR_LA_ENTIDAD], [TRMTE_REMTDO_A_SUPERFINANCIERA], [TRMTE_RECTIFICADO_POR_ENTIDAD], [TRAMITE_DESISTIDO], [RADICADO_RESPUESTA_FINAL], [FECHA_DE_CONTESTACION], [MEDIO_DE_CONTESTACION], [DEPENDENCIA_QUE_CONTESTA], [USUARIO_QUE_CONTESTA], [ESTADO_ACTUAL], [TOTAL_DIAS_TRAMITE], [FECHA_DE_VENCIMIENTO], [MES/AÑO], [ESTADO_DEL_TRAMITE], [GESTION], [PROCESO], [USUARIO_QUE_ARCHIVA], [FECHA_RESPUESTA_PARCIAL], [TIPO DE RESPUESTA], [DIAS_RESPUESTA_PARCIAL], [FECHA_DE_VENCIMIENTO_FINAL], [RADICADO_RESPUESTA_PARCIAL], [REVISION], [APROBACION], [AREA], [AñoFil], [MesFil], [DependenciaFil], [UsuarioFil], [RowNum], [TIPO_DE_FRAUDE], [MODALIDAD_DE_FRAUDE], [MONTO_RECLAMADO], [MONTO_RECONOCIDO]) SELECT * FROM ( SELECT CAST(RequestFiles.FileNumber AS VARCHAR(30)) AS [RADICADO] ,CAST(RequestFiles.FiledDate AS DATE) AS [FECHA_RADICADO] ,CONVERT(VARCHAR(8), RequestFiles.FiledDate, 108) AS [HORA_RADICADO] ,CAST(CANAL.Name AS VARCHAR(30)) AS [MEDIO_DE_RECEPCION] ,CAST(COALESCE(Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_ASIGNADA] ,CAST(COALESCE(IIF(Users1.UserName='DEFENSOR','GERENCIA DE SERVICIO AL CLIENTE', Dependencies1.Name), Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_DE_RADICACION] ,CAST(CONCAT(Users1.Name, ' ', Users1.Surnames) AS VARCHAR(50)) AS [USUARIO_RADICADOR] ,CAST(PqrsType.Name AS VARCHAR(40)) AS [TIPO_DE_PQR] ,CAST(NameType.Name AS VARCHAR(140)) AS [CAUSAL] ,CAST(ProcedureType.Name AS VARCHAR(140)) AS [DETALLE_CAUSAL] ,CAST(REPLACE(REPLACE(SpecificationType.Name, CHAR(13), ''), CHAR(10), '') AS VARCHAR(140)) AS [DETALLE_DESAGREGADO_CAUSAL] ,CASE WHEN TipoPersona.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(250)) END WHEN TipoPersona.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 WHEN TipoPersona.Name = 'Anónimo' THEN 'Anónimo' ELSE CAST(ISNULL(Contacto.BusinessName,Clients.BusinessName) AS VARCHAR(250)) END AS [NOMBRE_REMITENTE] ,SpecialCondition.Name AS [CONDICION_ESPECIAL] ,CAST(ISNULL(TipoPersona.Name, TP.Name) AS VARCHAR(40)) AS [TIPO_PERSONA] ,CAST(TIPODOCUMENTOREMITENTE.Name AS VARCHAR(80)) AS [TIPO_DE_DOCUMENTO_REMITENTE] ,ISNULL(Contacto.NumberIdentification, Clients.NumberIdentification) AS [DOCUMENTO_DE_REMITENTE] ---Se actualiza para resolver caso aranda 55437 JULIOCF ,CAST(Contacto.Address AS VARCHAR(160)) AS [DIRECCION_REMITENTE] ,CAST(NeighBorhood.Description AS VARCHAR(80)) AS [BARRIO_REMITENTE] ,CAST(ISNULL(C.Description, CITY.Description) AS VARCHAR(60)) AS [CIUDAD_REMITENTE] ,CAST(ISNULL(D.Description, DEPARTMENT.Description) AS VARCHAR(80)) AS [DEPARTAMENTO_REMITENTE] --,CAST(ISNULL(Contacto.Email, Clients.Email) AS VARCHAR(80)) AS [EMAIL_REMITENTE] ,CASE WHEN TipoPersona.Name != 'Anónimo' THEN CAST(ISNULL(Contacto.Email, Clients.Email) AS VARCHAR(80)) WHEN TipoPersona.Name = 'Anónimo' AND RequestFilesRespuestaDefinitiva.FileNumber IS NOT NULL THEN CAST( ISNULL(ContactoRespDef.Email, ClienteRespDef.Email) AS VARCHAR(80) ) WHEN TipoPersona.Name = 'Anónimo' AND RequestFilesRespuestaParcial.FileNumber IS NOT NULL THEN CAST( ISNULL(ContactoRespPar.Email, ClienteRespPar.Email) AS VARCHAR(80) ) WHEN TipoPersona.Name = 'Anónimo' THEN 'servicioalcliente@fiduprevisora.com.co' END AS [EMAIL_REMITENTE] ,CAST(Contacto.Telephone AS VARCHAR(15)) AS [TELEFONO_REMITENTE] ,CAST(Contacto.Mobile AS VARCHAR(15)) AS [CELULAR_REMITENTE] ,CAST(ISNULL(AffiliateTypeC.Code, AffiliateType.Code) AS VARCHAR(15)) AS [USUARIO_FOMAG] ,CAST(ReceivingInstance.Description AS VARCHAR(50)) AS [ENTE_REMITENTE] ,CAST(REPLACE(REPLACE(RequestFiles.Subject, CHAR(13), ''), CHAR(10), '') AS VARCHAR(700)) AS [ASUNTO_RADICADO] ,CAST(IIF(CONCAT(Users.Name, ' ', Users.Surnames) = '', CONCAT(Users1.Name, ' ', Users1.Surnames), CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(50)) AS [FUNCIONARIO_ACTUAL] ,CAST(COALESCE(Dependencies4.Name, Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_ACTUAL] ,CAST(SmartAddicionalRequestFiles.CreationDateSmart AS DATE) AS [FECHA_DE_TRAMITE_PQR] ,CAST(SmartAddicionalRequestFiles.ComingFromProcedure AS VARCHAR(2)) AS [TRAMITE_PROCEDENTE] ,CAST(SmartAddicionalRequestFiles.FavorConsumerProcedure AS VARCHAR(30)) AS [TRAMITE_A_FAVOR_DEL_CONSUMIDOR_O_LA_ENTIDAD] ,CAST(Acceptance.Name AS VARCHAR(80)) AS [TRMTE_ACEPTADO_POR_LA_ENTIDAD] ,CAST(SmartAddicionalRequestFiles.RefusedEntityProcedure AS VARCHAR(2)) AS [TRMTE_RECHAZADO_POR_LA_ENTIDAD] ,CAST(SmartAddicionalRequestFiles.SuperFRemittedProcedure AS VARCHAR(2)) AS [TRMTE_REMTDO_A_SUPERFINANCIERA] ,CAST(rectification.Name AS VARCHAR(100)) AS [TRMTE_RECTIFICADO_POR_ENTIDAD] ,CAST(ComplaintWithdrawal.Description AS VARCHAR(40)) AS [TRAMITE_DESISTIDO] ,CAST(RequestFilesRespuestaDefinitiva.FileNumber AS VARCHAR(30)) AS [RADICADO_RESPUESTA_FINAL] ,CAST(ISNULL(RequestFilesRespuestaDefinitiva.FiledDate, RequestFilesRespuestaParcial.FiledDate) AS DATE) AS [FECHA_DE_CONTESTACION] ,CAST(MAX(CANAL1.Name) OVER (PARTITION BY RequestFiles.FileNumber) AS VARCHAR(30)) AS [MEDIO_DE_CONTESTACION] ,CAST(COALESCE(Dependencies4.Name, Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_QUE_CONTESTA] ,CAST(IIF(CONCAT(Users.Name, ' ', Users.Surnames) = '', CONCAT(Users1.Name, ' ', Users1.Surnames), CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(50)) AS [USUARIO_QUE_CONTESTA] ,CASE WHEN COALESCE( CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) <= CAST(RequestFiles.ExperationDate AS DATE) THEN 'TRAMITADO OPORTUNAMENTE' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) > CAST(RequestFiles.ExperationDate AS DATE) THEN 'TRAMITADO EXTEMPORALMENTE' END, CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND CAST(RequestFiles.ExperationDate AS DATE) < GETDATE() - 1 THEN 'VENCIDO' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL --AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) IN (0,1,2,3) AND DA.[DiasHabiles] IN (0, 1, 2, 3) --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848 THEN 'PROXIMO A VENCER' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL --AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) > 3 AND DA.[DiasHabiles] >3 --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848 THEN 'EN TIEMPO' END ) IN ('VENCIDO', 'TRAMITADO EXTEMPORALMENTE') THEN 'INOPORTUNO' ELSE 'OPORTUNO' END AS [ESTADO_ACTUAL] ,RequestFilesExpirationDate.ProcedureDays AS [TOTAL_DIAS_TRAMITE] ,CAST(RequestFiles.ExperationDate AS DATE)[FECHA_DE_VENCIMIENTO] ,CAST(CONCAT(DATENAME(MONTH, DATEADD(MONTH, MONTH(RequestFiles.FiledDate) - 1, '1900-01-01')), ' - ', YEAR(RequestFiles.FiledDate)) AS VARCHAR(20)) AS [MES/AÑO] ,COALESCE( CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) <= CAST(RequestFiles.ExperationDate AS DATE) THEN 'TRAMITADO OPORTUNAMENTE' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) > CAST(RequestFiles.ExperationDate AS DATE) THEN 'TRAMITADO EXTEMPORALMENTE' END, CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND CAST(RequestFiles.ExperationDate AS DATE) < GETDATE() - 1 THEN 'VENCIDO' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL --AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) IN ( 0, 1, 2, 3) AND DA.[DiasHabiles] IN (0, 1, 2, 3) --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848 THEN 'PROXIMO A VENCER' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL --AND DATEDIFF(DAY, GETDATE(), CAST(RequestFiles.ExperationDate AS DATE)) > 3 AND DA.[DiasHabiles] > 3 --Se realiza ajuste donde se tiene en cuenta solo los días laborales 966848 THEN 'EN TIEMPO' END ) AS [ESTADO_DEL_TRAMITE] ,CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL THEN 'Tramitado' ELSE 'Pendiente' END AS [GESTION] ,ESTADO.Name AS [PROCESO] ,CAST(CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL THEN MAX(IIF(CONCAT(Users2.Name, ' ', Users2.Surnames) = '', NULL, CONCAT(Users2.Name, ' ', Users2.Surnames))) OVER (PARTITION BY RequestFiles.FileNumber) END AS VARCHAR(50)) AS [USUARIO_QUE_ARCHIVA] ,CAST(RequestFilesRespuestaParcial.FiledDate AS DATE) AS [FECHA_RESPUESTA_PARCIAL] ,CASE WHEN RequestFilesRespuestaParcial.FiledDate IS NOT NULL AND RequestFilesRespuestaDefinitiva.FiledDate IS NULL THEN 'Respuesta Parcial' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL THEN 'Respuesta Definitiva' END AS [TIPO_DE_RESPUESTA] ,CASE WHEN RequestFilesRespuestaParcial.FiledDate IS NOT NULL AND Users1.UserName ='DEFENSOR' THEN 8 WHEN RequestFilesRespuestaParcial.FiledDate IS NOT NULL THEN 15 END AS [DIAS_RESPUESTA_PARCIAL] ,CAST(RequestFiles.ExperationDate AS DATE) AS [FECHA_DE_VENCIMIENTO_FINAL] ,CAST(RequestFilesRespuestaParcial.FileNumber AS VARCHAR(30)) AS [RADICADO_RESPUESTA_PARCIAL] ,USuarioRevision.Funcionario AS [REVISION] ,USuarioAprobacion.Funcionario AS [APROBACION] ,CAST(COALESCE(Dependencies4.Name, Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [AREA] ,CAST(YEAR(RequestFiles.FiledDate) AS INT) AS [AñoFil] ,CAST(MONTH(RequestFiles.FiledDate) AS INT) AS [MesFil] ,MAX(ISNULL(Dependencies.Code, '0')) OVER (PARTITION BY RequestFiles.FileNumber) AS [DependenciaFil] ,Users.UserName AS [UsuarioFil] ,ROW_NUMBER() OVER (PARTITION BY RequestFiles.FileNumber ORDER BY RequestFiles.FiledDate DESC) AS RowNum -- Add campos Circular 19 ,Circular19.[TIPO_DE_FRAUDE] AS [TIPO_DE_FRAUDE] ,Circular19.[MODALIDAD_DE_FRAUDE] AS [MODALIDAD_DE_FRAUDE] ,Circular19.[MONTO_RECLAMADO] AS [MONTO_RECLAMADO] ,Circular19.[MONTO_RECONOCIDO] AS [MONTO_RECONOCIDO] FROM dms.dbo.RequestFiles WITH (NOLOCK) --Unión con RequestFileHistories para obtener la historia más reciente 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', --Se agregan los siguientes estados por caso SAC 960781 '4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425' ,'8d6acd5a-d128-45b0-b1a5-f9c0fef90708','EF7B7E43-9151-422A-9A2C-6E3B6C53BC85') AND (ProcessCode != 'Combinación de Correspondencia - ' AND ProcessName != 'Respuesta Parcial') AND ProcessCode !='615' ) AS RequestFileHistories ON RequestFileHistories.RequestFileId=RequestFiles.Id AND RequestFileHistories.MaxReg = 1 AND RequestFileHistories.DependencyId IS NOT NULL ------ Unión con RequestFileHistories1 para obtener la historia más antigua LEFT JOIN ( SELECT ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate ASC) AS MinReg ,RequestFileId ,CreationDate ,DependencyId ,UserName FROM dms.dbo.RequestFileHistories WHERE ProcessCode !='615' ) AS RequestFileHistories1 ON RequestFileHistories1.RequestFileId=RequestFiles.Id AND RequestFileHistories1.MinReg = 1 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%' AND FLU_CONT !=100 LEFT JOIN [Stage].[dbo].[Users_Stage] Users ON Users.UserName=ISNULL(WF_SEGUI_PEN.SEG_UENC,RequestFileHistories.UserName) LEFT JOIN [Stage].[dbo].[Users_Stage] Users1 ON Users1.UserName=RequestFileHistories1.UserName LEFT JOIN dms.dbo.Dependencies Dependencies3 ON Dependencies3.Id=RequestFileHistories.DependencyId LEFT JOIN ( --Subconsulta para obtener el nombre de la dependencia asociada al usuario SELECT UserId ,Dependencies.Name ,CASE WHEN (Dependencies.Name) =Dependencies.Name THEN Dependencies.Code END Code ,ROW_NUMBER() OVER (PARTITION BY UserId ORDER BY Code) NUMROW 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 )Dependencies ON Users.Id=Dependencies.UserId AND Dependencies.NUMROW=1 LEFT JOIN dms.dbo.Dependencies Dependencies1 ON Dependencies1.Id=RequestFileHistories1.DependencyId LEFT JOIN dms.dbo.Dependencies Dependencies4 ON RequestFileHistories.DependencyId = Dependencies4.Id LEFT JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))=RequestFileHistories.Status 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 Contacto.Id = RequestFiles.ContactId LEFT JOIN DMS.dbo.TypeDetail SpecialCondition ON Clients.SpecialConditionId = SpecialCondition.ID LEFT JOIN dms.dbo.TypeDetail TIPODOCUMENTOREMITENTE ON Clients.DocumentTypeId=TIPODOCUMENTOREMITENTE.Id LEFT JOIN dms.dbo.GeographicsLocation CITY ON Clients.CityId=CITY.Id LEFT JOIN dms.dbo.GeographicsLocation C ON Contacto.CityId = C.ID LEFT JOIN dms.dbo.GeographicsLocation DEPARTMENT ON Clients.DepartamentId=DEPARTMENT.Id LEFT JOIN dms.dbo.GeographicsLocation D ON Contacto.DepartamentId = D.ID LEFT JOIN dms.dbo.GeographicsLocation NeighBorhood ON Clients.NeighBorhoodId=NeighBorhood.Id LEFT JOIN dms.dbo.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id=DMS_Procedures.NameTypeId LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id=DMS_Procedures.ProcedureTypeId LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id=DMS_Procedures.SpecificationTypeId LEFT JOIN DMS.dbo.PQRSDType PqrsType ON PqrsType.Id=RequestFiles.PqrsTypeId LEFT JOIN dms.dbo.TypeDetail AffiliateTypeC ON Contacto.AffiliateTypeId = AffiliateTypeC.ID LEFT JOIN dms.dbo.TypeDetail AffiliateType ON Clients.AffiliateTypeId=CAST(AffiliateType.Id AS VARCHAR(40)) LEFT JOIN dms.dbo.TypeDetail ReceivingInstance ON RequestFiles.ReceivingInstanceId=CAST(ReceivingInstance.Id AS VARCHAR(40)) LEFT JOIN dms.dbo.SmartAddicionalRequestFiles ON SmartAddicionalRequestFiles.RequestFilesId=RequestFiles.Id LEFT JOIN dms.dbo.TypeDetail Acceptance ON SmartAddicionalRequestFiles.Acceptance=CAST(Acceptance.Id AS VARCHAR(40)) LEFT JOIN dms.dbo.TypeDetail ComplaintWithdrawal ON SmartAddicionalRequestFiles.ComplaintWithdrawal=CAST(ComplaintWithdrawal.Id AS VARCHAR(40)) LEFT JOIN dms.dbo.TypeDetail Rectification ON SmartAddicionalRequestFiles.Rectification = CAST(Rectification .Id AS VARCHAR(40)) LEFT JOIN RequestFilesExpirationDate ON RequestFilesExpirationDate.FileNumber=RequestFiles.FileNumber LEFT JOIN (--LEFT JOIN con RequestFileHistoriesRevision para obtener la última revisión de la respuesta SELECT UserName,RequestFileId,ROW_NUMBER() OVER(PARTITION BY RequestFileId ORDER BY CreationDate DESC,RequestFileId,UserName)NumberFile FROM dms.dbo.RequestFileHistories A inner JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))=a.Status AND ESTADO.name IN ('Respuesta en revisión') )RequestFileHistoriesRevision ON RequestFiles.Id=RequestFileHistoriesRevision.RequestFileId AND RequestFileHistoriesRevision.NumberFile=1 LEFT JOIN (--LEFT JOIN con RequestFileHistoriesAprobacion para obtener la última aprobación de la respuesta SELECT UserName,RequestFileId,ROW_NUMBER() OVER(PARTITION BY RequestFileId ORDER BY CreationDate DESC,RequestFileId,UserName)NumberFile FROM dms.dbo.RequestFileHistories A inner JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))=a.Status AND ESTADO.name IN ('Respuesta aprobada') )RequestFileHistoriesAprobacion ON RequestFiles.Id=RequestFileHistoriesAprobacion.RequestFileId AND RequestFileHistoriesAprobacion.NumberFile=1 LEFT JOIN dms.dbo.USERS_VW USuarioRevision ON USuarioRevision.UserName= RequestFileHistoriesRevision.UserName LEFT JOIN dms.dbo.USERS_VW USuarioAprobacion ON USuarioAprobacion.UserName= RequestFileHistoriesAprobacion.UserName LEFT JOIN (--LEFT JOIN con RequestFilesRespuestaParcial y RequestFilesRespuestaDefinitiva para obtener las respuestas parciales y definitivas SELECT B.ParentId,C.FiledDate,C.FileNumber,ChannelId,ContactId,ClientId,UserName,ROW_NUMBER() OVER(PARTITION BY B.ParentId ORDER BY C.FiledDate ASC,C.FileNumber,B.ParentId,ChannelId,UserName)NumberFile FROM dms.dbo.RelatedRequestFiles B INNER JOIN dms.dbo.RequestFiles C ON B.RequestFileId=C.Id WHERE C.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND C.ResposnseText=2)RequestFilesRespuestaParcial ON RequestFiles.Id=RequestFilesRespuestaParcial.ParentId AND RequestFilesRespuestaParcial.NumberFile=1 LEFT JOIN (-- LEFT JOIN con otras respuestas definitivas para obtener la última respuesta definitiva SELECT B.ParentId,C.FiledDate,C.FileNumber,ChannelId,ContactId,ClientId,UserName,ROW_NUMBER() OVER(PARTITION BY B.ParentId ORDER BY C.FiledDate DESC,C.FileNumber,B.ParentId,ChannelId,UserName)NumberFile FROM dms.dbo.RelatedRequestFiles B INNER JOIN dms.dbo.RequestFiles C ON B.RequestFileId=C.Id WHERE C.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND C.ResposnseText=1) RequestFilesRespuestaDefinitiva ON RequestFiles.Id=RequestFilesRespuestaDefinitiva.ParentId AND RequestFilesRespuestaDefinitiva.NumberFile=1 -- Contacto respuesta definitiva LEFT JOIN dms.dbo.Contacts ContactoRespDef ON ContactoRespDef.Id = RequestFilesRespuestaDefinitiva.ContactId LEFT JOIN dms.dbo.Clients ClienteRespDef ON ClienteRespDef.Id = RequestFilesRespuestaDefinitiva.ClientId -- Contacto respuesta parcial LEFT JOIN dms.dbo.Contacts ContactoRespPar ON ContactoRespPar.Id = RequestFilesRespuestaParcial.ContactId LEFT JOIN dms.dbo.Clients ClienteRespPar ON ClienteRespPar.Id = RequestFilesRespuestaParcial.ClientId -- LEFT JOIN dms.dbo.TypeDetail CANAL1 ON CANAL1.Id=ISNULL(RequestFilesRespuestaDefinitiva.ChannelId,RequestFilesRespuestaParcial.ChannelId) LEFT JOIN [Stage].[dbo].[Users_Stage] Users2 ON Users2.UserName=ISNULL(RequestFilesRespuestaParcial.UserName,RequestFilesRespuestaDefinitiva.UserName) LEFT JOIN DMS.DBO.TypeDetail TipoPersona ON TipoPersona.Id=Clients.PersonTypeId LEFT JOIN DMS.DBO.TypeDetail TP ON Contacto.TypeContactId = TP.ID --Consulta adiciona los campos de la actualización circular 19 LEFT JOIN ( SELECT RequestFilesId, FraudTypeName.Name AS [TIPO_DE_FRAUDE], FraudModalityName.Name AS [MODALIDAD_DE_FRAUDE], FORMAT(ISNULL(ClaimedAmount, 0), 'N0', 'es-CO') AS [MONTO_RECLAMADO], FORMAT(ISNULL(RecognizedAmount, 0), 'N0', 'es-CO') AS [MONTO_RECONOCIDO] FROM DMS.DBO.SmartAddicionalRequestFiles LEFT JOIN DMS.DBO.TypeDetail AS FraudTypeName ON SmartAddicionalRequestFiles.FraudType = FraudTypeName.Id AND FraudTypeName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB754' LEFT JOIN DMS.DBO.TypeDetail AS FraudModalityName ON SmartAddicionalRequestFiles.FraudModality = FraudModalityName.Id AND FraudModalityName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB758') AS Circular19 ON RequestFiles.Id = Circular19.RequestFilesId --Tabla de días habiles para calcular el campo de Estado_Tramite LEFT JOIN STAGE.DBO.DiasHabiles DA ON RequestFiles.id = DA.id WHERE --RequestFilesExpirationDate.FileNumber IS NOT NULL RequestFiles.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' AND ESTADO.name NOT IN ('Anulado','Solicitud de anulación') ) AS CF WHERE CF.RowNum = 1
165923961592347055417707462SELECT COUNT(*) FROM [ReassignmentTask] AS [r] WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0

Archivos SQL más pesados

DatabaseNameLogicalNamePhysicalNameFileTypeSizeMBMaxSizeMBIsPercentGrowth
OpheliaSuiteOpheliaSuiteDMSE:\SGDEA\OpheliaSuite.mdfROWS4459206-1False
DMSDMSE:\SGDEA\DMS.mdfROWS51887-1False
DMSDMS_BE:\SGDEA\DMS_B.ndfROWS43338-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
StageStage_logF:\LOG\Stage_log.ldfLOG257392097152False
tempdbtemp9D:\TEMPDB\temp9.mdfROWS23991-1False
tempdbtemp4D:\TEMPDB\temp4.mdfROWS21358-1False
tempdbtemp11D:\TEMPDB\temp11.mdfROWS13169-1False
tempdbtempdevD:\TEMPDB\tempdev.mdfROWS12644-1False
StageStageE:\SGDEA\Stage.mdfROWS10817-1False
DMS_bk_040923DMSE:\SGDEA\DMS_bk_040923.mdfROWS5000-1False
OpheliaSuiteOpheliaSuiteDMS_logF:\LOG\OpheliaSuite_log.ldfLOG36592097152False
DMSDMS_logF:\LOG\DMS_log.ldfLOG27632097152False
DMS_BK_20DMSE:\SGDEA\DMS_BK_20.mdfROWS2184-1False
AgoraSSBAgoraE:\SGDEA\Agora.mdfROWS436-1False

Errores recientes SQL

LogDateProcessInfoText
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 AMLogonError: 18456, Severity: 14, State: 38.
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:53 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:49 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:47 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:46 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:43 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:34 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: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.
5/29/2026 2:57:18 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:57:10 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:10 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:57:03 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:03 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:56:56 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:56:56 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:56:51 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:56:51 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:56:49 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:56:49 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:56:48 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:56:48 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:56:46 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:56:46 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:56:43 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:56:43 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:56:33 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:56:33 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:56:32 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:56:32 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:56:19 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:56:19 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:56:17 AMLogonError: 18456, Severity: 14, State: 38.

Tareas Ophelia en cola por servidor (estado Q)

ServidorIPCantidad
10.238.99.1508
10.238.99.1518
10.238.99.15314