Diagnóstico SQL Server - DWSGDASQL2

Resumen Ejecutivo SQL

RAM libre7.63 GB
RAM total60 GB
CPU promedio27.05 %
Conexiones SQL5195
Disco promedio167.53 %
Bloqueos activos0
Bases de datos20
Transacciones abiertas149
Tareas en cola (Q)192

Servidor SQL: SRVCLSGDEA\SGDEAPRY,1633

Host: DWSGDASQL2

Fecha: 05/28/2026 16:01:21

Alertas

Recomendaciones

Información del sistema

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

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.7867.88
D:TEMP299.9879.0826.36
E:DATA5222.38725.3413.89
F:LOG299.98246.282.07
G:BACKUPS499.98321.9164.38
Q:New Volume19.9819.3696.91
S:Spool299.98285.8195.28

Contadores de rendimiento - muestra 1 minuto

CounterMinMaxAverage
\\dwsgdasql2\processor(_total)\% processor time16.5147.1727.05
\\dwsgdasql2\memory\available mbytes783083418055.5
\\dwsgdasql2\system\processor queue length040.33
\\dwsgdasql2\physicaldisk(_total)\% disk time65.79780.25167.53
\\dwsgdasql2\physicaldisk(_total)\current disk queue length4117.17

Información SQL Server

ServerNameEditionProductLevelProductVersionCollationStartTime
SRVCLSGDEA\SGDEAPRYEnterprise Edition: Core-based Licensing (64-bit)RTM15.0.4316.3SQL_Latin1_General_CP1_CI_AS5/27/2026 10:52:23 PM

Memoria SQL

PhysicalMemoryMBCommittedMBCommittedTargetMBPageLifeExpectancySecBufferCacheHitRatio
614394499945000119434729

Bases de datos

DatabaseNameStateRecoveryModelCompatibilityLevelSizeMBCreateDate
OpheliaSuiteONLINEFULL15044553141/25/2023 11:42:38 AM
tempdbONLINESIMPLE1502243785/27/2026 10:53:39 PM
DMSONLINEFULL1501006133/9/2024 11:45:05 PM
StageONLINEFULL150516815/8/2023 11:39:48 AM
DriveONLINEFULL1503471611/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
msdbONLINEFULL1502649/24/2019 2:21:42 PM
ImperiumReportCacheONLINEFULL1502402/28/2026 8:36:43 PM
EstructuraImportacionONLINEFULL1501122/24/2024 11:16:01 AM
AgoraSSB_OLDONLINEFULL150825/29/2024 3:42:38 PM
DMS_2ONLINEFULL150811/31/2023 8:44:52 AM
DBAONLINEFULL150809/29/2023 9:16:16 AM
modelONLINEFULL150804/8/2003 9:13:36 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
MicroSQLDWSGDAAPP3opheliadms1345
MicroSQLDWSGDAAPP1opheliadms1325
MicroSQLDWSGDAAPP2opheliadms1261
MicroSQLDWSGDAAPP1ophelia232
MicroSQLDWSGDAAPP3ophelia219
ODKDWSGDAAPP1ophelia178
ODKDWSGDAAPP3ophelia167
MicroSQLDWSGDAAPP2ophelia136
ODKDWSGDAAPP2ophelia125
Core Microsoft SqlClient Data ProviderDWSGDAAPP2opheliadms23
Core Microsoft SqlClient Data ProviderDWSGDAAPP1opheliadms23
Core Microsoft SqlClient Data ProviderDWSGDAAPP3opheliadms22
DWSGDAAPP1ophelia22
MicroSQLDWSGDAAPP4opheliadms22
.Net SqlClient Data ProviderFASECOLDAVMmonitoreosaas10
DWSGDAAPP2ophelia6
Core Microsoft SqlClient Data ProviderDWSGDAAPP2ophelia5
Core Microsoft SqlClient Data ProviderDWSGDAAPP1ophelia5
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP2ophelia4
Core Microsoft SqlClient Data ProviderDWSGDAAPP3ophelia4
Microsoft SQL Server Management Studio - QueryDWSGDASQL2DIGITALWARE\JeisonCR3
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP3ophelia3
Microsoft SQL Server Management Studio - QueryDW-P10785ophelia3
Core .Net SqlClient Data ProviderDWSGDAAPP3ophelia3
DWSGDAAPP3ophelia3
Core .Net SqlClient Data ProviderDWSGDAAPP2ophelia3
Core .Net SqlClient Data ProviderDWSGDAAPP1ophelia2
Core Microsoft SqlClient Data ProviderDWSGDAAPP4ophelia2
Core Microsoft SqlClient Data ProviderDWSGDAAPP4opheliadms2
Core Microsoft SqlClient Data ProviderDWSGDAMON2opheliadms2
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP1ophelia2
Microsoft SQL Server Management Studio - QueryDW-P10840ophelia2
Microsoft SQL Server Management StudioDWSGDASQL2DIGITALWARE\DominnigM2
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP3ophelia2
Microsoft SQL Server Management Studio - QueryDW-P1722ophelia2
MicroSQLDWSGDAAPP21
Microsoft SQL Server Management Studio - Transact-SQL IntelliSenseDW-P10785ophelia1
Microsoft® Windows® Operating SystemDWSGDASQL2NT AUTHORITY\SYSTEM1
ODKDWSGDAAPP21
PythonDWSGDASQL1Opheliasuitebi1
SQLAgent - Contained AGSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLAgent - Email LoggerSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLAgent - Generic RefresherSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLAgent - Job invocation engineSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 1)SRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLServerCEIPSRVCLSGDEANT SERVICE\SQLTELEMETRY$SGDEAPRY1
Zabbix agent 2 MSSQL pluginDWSGDASQL2zbx_monitor1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP1ophelia1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP2ophelia1
Microsoft SQL Server Management StudioDW-P10704ophelia1
Microsoft SQL Server Management StudioDW-P10966ophelia1
Microsoft SQL Server Management StudioDW-P10967ophelia1
Microsoft SQL Server Management StudioDWSGDASQL2DIGITALWARE\JeisonCR1
Microsoft SQL Server Management Studio - ConsultaDW-P10961ophelia1
Microsoft SQL Server Management Studio - QueryDW-P10704ophelia1
Microsoft SQL Server Management Studio - QueryDW-P10933ophelia1
Microsoft SQL Server Management Studio - QueryDW-P10967ophelia1
Core .Net SqlClient Data ProviderDWSGDAAPP1Opheliasuitebi1
Core .Net SqlClient Data ProviderDWSGDAAPP2Opheliasuitebi1
.Net SqlClient Data ProviderDWSGDASQL2ophelia1

Sesiones activas

session_idlogin_namehost_nameprogram_namestatuscommandwait_typewait_timecpu_timelogical_readsDatabaseName
4977OpheliasuitebiDWSGDASQL1PythonrunningSELECTCXCONSUMER80116195150DMS
4695DIGITALWARE\SCVSGDA-AGENTSRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 1)runningINSERTPAGEIOLATCH_SH59066850227Stage
4350DWSGDAAPP2MicroSQLrunningSELECT087420351OpheliaSuite
5176opheliaDWSGDASQL2.Net SqlClient Data ProviderrunningSELECT0520master
51NT AUTHORITY\SYSTEMDWSGDASQL2Microsoft® Windows® Operating SystemrunningEXECUTESP_SERVER_DIAGNOSTICS_SLEEP923275master
5246opheliaDWSGDAAPP1runningINSERTPAGEIOLATCH_EX603OpheliaSuite

Bloqueos activos

No hay datos.

Transacciones abiertas (> 5 seg)

SessionIdHostAplicacionUsuarioInicioTransaccionSegundosAbiertaTipoTransaccionUltimaConsulta
564DWSGDAAPP3MicroSQLophelia5/28/2026 12:15:30 PM13551Read/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)
947DWSGDAAPP3MicroSQLophelia5/28/2026 12:16:46 PM13475Read/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)
1275DWSGDAAPP3MicroSQLophelia5/28/2026 12:17:28 PM13433Read/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)
3200DWSGDAAPP1MicroSQLophelia5/28/2026 12:20:45 PM13236Read/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)
2158DWSGDAAPP1MicroSQLophelia5/28/2026 12:22:19 PM13142Read/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)
2215DWSGDAAPP1MicroSQLophelia5/28/2026 12:23:59 PM13042Read/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)
2354DWSGDAAPP2MicroSQLophelia5/28/2026 12:27:45 PM12816Read/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)
2976DWSGDAAPP2MicroSQLophelia5/28/2026 12:40:21 PM12060Read/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)
2279DWSGDAAPP1MicroSQLophelia5/28/2026 12:41:01 PM12020Read/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)
3195DWSGDAAPP1MicroSQLophelia5/28/2026 12:41:40 PM11981Read/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)
2716DWSGDAAPP3MicroSQLophelia5/28/2026 12:42:19 PM11942Read/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)
1250DWSGDAAPP2MicroSQLophelia5/28/2026 12:42:45 PM11916Read/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)
1309DWSGDAAPP2MicroSQLophelia5/28/2026 12:43:23 PM11878Read/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)
2036DWSGDAAPP2MicroSQLophelia5/28/2026 12:43:29 PM11872Read/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)
1344DWSGDAAPP3MicroSQLophelia5/28/2026 12:45:10 PM11771Read/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)
2325DWSGDAAPP1MicroSQLophelia5/28/2026 12:46:57 PM11664Read/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)
2933DWSGDAAPP3MicroSQLophelia5/28/2026 12:52:17 PM11344Read/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)
1439DWSGDAAPP1MicroSQLophelia5/28/2026 12:53:23 PM11278Read/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)
2383DWSGDAAPP1MicroSQLophelia5/28/2026 12:56:05 PM11116Read/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)
1339DWSGDAAPP3MicroSQLophelia5/28/2026 12:57:43 PM11018Read/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)
3253DWSGDAAPP1MicroSQLophelia5/28/2026 1:12:21 PM10140Read/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)
341DWSGDAAPP3MicroSQLophelia5/28/2026 1:18:36 PM9765Read/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)
1734DWSGDAAPP3MicroSQLophelia5/28/2026 1:22:15 PM9546Read/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)
2562DWSGDAAPP2MicroSQLophelia5/28/2026 1:25:56 PM9325Read/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)
755DWSGDAAPP3MicroSQLophelia5/28/2026 1:37:09 PM8652Read/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)
3401DWSGDAAPP1MicroSQLophelia5/28/2026 1:42:34 PM8327Read/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)
3513DWSGDAAPP3MicroSQLophelia5/28/2026 1:42:34 PM8327Read/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)
3573DWSGDAAPP1MicroSQLophelia5/28/2026 1:42:34 PM8327Read/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)
1273DWSGDAAPP3MicroSQLophelia5/28/2026 2:01:18 PM7203Read/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)
3611DWSGDAAPP2MicroSQLophelia5/28/2026 2:09:59 PM6682Read/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)
2105DWSGDAAPP1MicroSQLophelia5/28/2026 2:11:29 PM6592Read/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)
2935DWSGDAAPP3MicroSQLophelia5/28/2026 2:24:28 PM5813Read/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)
1809DWSGDAAPP2MicroSQLophelia5/28/2026 2:28:37 PM5564Read/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)
4067DWSGDAAPP3MicroSQLophelia5/28/2026 2:34:15 PM5226Read/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)
2289DWSGDAAPP1MicroSQLophelia5/28/2026 2:36:47 PM5074Read/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)
3624DWSGDAAPP2MicroSQLophelia5/28/2026 2:44:54 PM4587Read/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)
1731DWSGDAAPP1MicroSQLophelia5/28/2026 2:45:23 PM4558Read/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)
3882DWSGDAAPP1MicroSQLophelia5/28/2026 2:49:47 PM4294Read/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)
4086DWSGDAAPP1MicroSQLophelia5/28/2026 2:50:06 PM4275Read/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)
3272DWSGDAAPP2MicroSQLophelia5/28/2026 2:51:30 PM4191Read/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)
2679DWSGDAAPP3MicroSQLophelia5/28/2026 2:51:30 PM4191Read/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)
3457DWSGDAAPP3MicroSQLophelia5/28/2026 2:51:54 PM4167Read/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)
3468DWSGDAAPP3MicroSQLophelia5/28/2026 2:51:54 PM4167Read/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)
3915DWSGDAAPP3MicroSQLophelia5/28/2026 2:51:59 PM4162Read/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)
3056DWSGDAAPP2MicroSQLophelia5/28/2026 2:53:31 PM4070Read/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)
1601DWSGDAAPP3MicroSQLophelia5/28/2026 2:59:23 PM3718Read/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)
2375DWSGDAAPP3MicroSQLophelia5/28/2026 2:59:28 PM3713Read/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)
3496DWSGDAAPP1MicroSQLophelia5/28/2026 3:00:44 PM3637Read/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)
2786DWSGDAAPP3MicroSQLophelia5/28/2026 3:01:35 PM3586Read/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)
3548DWSGDAAPP2MicroSQLophelia5/28/2026 3:01:35 PM3586Read/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)
4255DWSGDAAPP1MicroSQLophelia5/28/2026 3:01:49 PM3572Read/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)
4195DWSGDAAPP1MicroSQLophelia5/28/2026 3:01:50 PM3571Read/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)
3748DWSGDAAPP3MicroSQLophelia5/28/2026 3:03:15 PM3486Read/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)
3318DWSGDAAPP3MicroSQLophelia5/28/2026 3:03:17 PM3484Read/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)
3918DWSGDAAPP3MicroSQLophelia5/28/2026 3:06:48 PM3273Read/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)
773DWSGDAAPP2MicroSQLophelia5/28/2026 3:07:26 PM3235Read/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)
4375DWSGDAAPP3MicroSQLophelia5/28/2026 3:10:35 PM3046Read/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)
3867DWSGDAAPP3MicroSQLophelia5/28/2026 3:10:54 PM3027Read/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)
2444DWSGDAAPP2MicroSQLophelia5/28/2026 3:13:13 PM2888Read/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)
3458DWSGDAAPP3MicroSQLophelia5/28/2026 3:13:28 PM2873Read/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)
2891DWSGDAAPP1MicroSQLophelia5/28/2026 3:16:27 PM2694Read/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)
3174DWSGDAAPP1MicroSQLophelia5/28/2026 3:16:27 PM2694Read/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)
3818DWSGDAAPP1MicroSQLophelia5/28/2026 3:16:27 PM2694Read/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)
1172DWSGDAAPP1MicroSQLophelia5/28/2026 3:16:27 PM2694Read/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)
3302DWSGDAAPP1MicroSQLophelia5/28/2026 3:16:35 PM2686Read/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)
1452DWSGDAAPP2MicroSQLophelia5/28/2026 3:18:38 PM2563Read/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)
1171DWSGDAAPP2MicroSQLophelia5/28/2026 3:20:14 PM2467Read/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)
1560DWSGDAAPP3MicroSQLophelia5/28/2026 3:21:02 PM2419Read/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)
3131DWSGDAAPP3MicroSQLophelia5/28/2026 3:22:03 PM2358Read/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)
3505DWSGDAAPP3MicroSQLophelia5/28/2026 3:22:43 PM2318Read/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)
4254DWSGDAAPP1MicroSQLophelia5/28/2026 3:24:25 PM2216Read/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)
1221DWSGDAAPP3MicroSQLophelia5/28/2026 3:26:06 PM2115Read/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)
3279DWSGDAAPP1MicroSQLophelia5/28/2026 3:26:19 PM2102Read/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)
2952DWSGDAAPP2MicroSQLophelia5/28/2026 3:27:48 PM2013Read/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)
4510DWSGDAAPP3MicroSQLophelia5/28/2026 3:29:16 PM1925Read/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)
4422DWSGDAAPP2MicroSQLophelia5/28/2026 3:32:58 PM1703Read/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)
3808DWSGDAAPP3MicroSQLophelia5/28/2026 3:32:58 PM1703Read/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)
3462DWSGDAAPP1MicroSQLophelia5/28/2026 3:33:10 PM1691Read/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)
4252DWSGDAAPP1MicroSQLophelia5/28/2026 3:33:13 PM1688Read/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)
566DWSGDAAPP3MicroSQLophelia5/28/2026 3:34:02 PM1639Read/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)
4297DWSGDAAPP1MicroSQLophelia5/28/2026 3:34:12 PM1629Read/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)
3717DWSGDAAPP1MicroSQLophelia5/28/2026 3:34:12 PM1629Read/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)
1666DWSGDAAPP3MicroSQLophelia5/28/2026 3:34:16 PM1625Read/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)
3843DWSGDAAPP1MicroSQLophelia5/28/2026 3:34:47 PM1594Read/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)
4020DWSGDAAPP3MicroSQLophelia5/28/2026 3:35:05 PM1576Read/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)
1105DWSGDAAPP3MicroSQLophelia5/28/2026 3:35:16 PM1565Read/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)
3575DWSGDAAPP2MicroSQLophelia5/28/2026 3:36:07 PM1514Read/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)
3478DWSGDAAPP3MicroSQLophelia5/28/2026 3:36:34 PM1487Read/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)
4507DWSGDAAPP1MicroSQLophelia5/28/2026 3:36:38 PM1483Read/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)
4433DWSGDAAPP2MicroSQLophelia5/28/2026 3:37:22 PM1439Read/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)
4242DWSGDAAPP2Core Microsoft SqlClient Data Provideropheliadms5/28/2026 3:37:25 PM1436Read/Write(@p0 uniqueidentifier,@p1 varchar(8000),@p2 datetime,@p3 varchar(100),@p4 int,@p5 uniqueidentifier)SET NOCOUNT ON; DECLARE @inserted0 TABLE ([Id] uniqueidentifier, [_Position] [int]); MERGE [RequestReviews] USING ( VALUES (@p0, @p1, @p2, @p3, @p4, @p5, 0)) AS i ([RequestFileId], [ReviewComments], [ReviewDate], [ReviewNumber], [ReviewResult], [UserReviewer], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([RequestFileId], [ReviewComments], [ReviewDate], [ReviewNumber], [ReviewResult], [UserReviewer]) VALUES (i.[RequestFileId], i.[ReviewComments], i.[ReviewDate], i.[ReviewNumber], i.[ReviewResult], i.[UserReviewer]) OUTPUT INSERTED.[Id], i._Position INTO @inserted0; SELECT [t].[Id] FROM [RequestReviews] t INNER JOIN @inserted0 i ON ([t].[Id] = [i].[Id]) ORDER BY [i].[_Position];
1342DWSGDAAPP3MicroSQLophelia5/28/2026 3:37:35 PM1426Read/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)
1291DWSGDAAPP2MicroSQLophelia5/28/2026 3:37:49 PM1412Read/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)
3939DWSGDAAPP1MicroSQLophelia5/28/2026 3:37:54 PM1407Read/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)
2827DWSGDAAPP2MicroSQLophelia5/28/2026 3:37:54 PM1407Read/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)
4245DWSGDAAPP1MicroSQLophelia5/28/2026 3:37:57 PM1404Read/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)
1427DWSGDAAPP3MicroSQLophelia5/28/2026 3:38:39 PM1362Read/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)
3931DWSGDAAPP3MicroSQLophelia5/28/2026 3:38:41 PM1360Read/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)
2286DWSGDAAPP3MicroSQLophelia5/28/2026 3:38:42 PM1359Read/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)
4338DWSGDAAPP2MicroSQLophelia5/28/2026 3:38:42 PM1359Read/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)
2714DWSGDAAPP3MicroSQLophelia5/28/2026 3:40:38 PM1243Read/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)
4091DWSGDAAPP3MicroSQLophelia5/28/2026 3:40:52 PM1229Read/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)
3799DWSGDAAPP1MicroSQLophelia5/28/2026 3:41:06 PM1215Read/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)
2674DWSGDAAPP3MicroSQLophelia5/28/2026 3:41:06 PM1215Read/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)
4651DWSGDAAPP3Core Microsoft SqlClient Data Provideropheliadms5/28/2026 3:41:12 PM1209Read/Write(@p0 uniqueidentifier,@p1 varchar(8000),@p2 datetime,@p3 varchar(100),@p4 int,@p5 uniqueidentifier)SET NOCOUNT ON; DECLARE @inserted0 TABLE ([Id] uniqueidentifier, [_Position] [int]); MERGE [RequestReviews] USING ( VALUES (@p0, @p1, @p2, @p3, @p4, @p5, 0)) AS i ([RequestFileId], [ReviewComments], [ReviewDate], [ReviewNumber], [ReviewResult], [UserReviewer], _Position) ON 1=0 WHEN NOT MATCHED THEN INSERT ([RequestFileId], [ReviewComments], [ReviewDate], [ReviewNumber], [ReviewResult], [UserReviewer]) VALUES (i.[RequestFileId], i.[ReviewComments], i.[ReviewDate], i.[ReviewNumber], i.[ReviewResult], i.[UserReviewer]) OUTPUT INSERTED.[Id], i._Position INTO @inserted0; SELECT [t].[Id] FROM [RequestReviews] t INNER JOIN @inserted0 i ON ([t].[Id] = [i].[Id]) ORDER BY [i].[_Position];
1343DWSGDAAPP3MicroSQLophelia5/28/2026 3:41:52 PM1169Read/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)
1252DWSGDAAPP3MicroSQLophelia5/28/2026 3:41:52 PM1169Read/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)
1253DWSGDAAPP3MicroSQLophelia5/28/2026 3:41:52 PM1169Read/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)
4466DWSGDAAPP2MicroSQLophelia5/28/2026 3:41:52 PM1169Read/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)
4132DWSGDAAPP1MicroSQLophelia5/28/2026 3:42:06 PM1155Read/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)
3273DWSGDAAPP1MicroSQLophelia5/28/2026 3:43:00 PM1101Read/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)
1945DWSGDAAPP3MicroSQLophelia5/28/2026 3:44:02 PM1039Read/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)
4374DWSGDAAPP2MicroSQLophelia5/28/2026 3:44:21 PM1020Read/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)
3839DWSGDAAPP1MicroSQLophelia5/28/2026 3:44:26 PM1015Read/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)
3440DWSGDAAPP1MicroSQLophelia5/28/2026 3:44:51 PM990Read/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)
3956DWSGDAAPP3MicroSQLophelia5/28/2026 3:44:52 PM989Read/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)
4686DWSGDAAPP3MicroSQLophelia5/28/2026 3:44:52 PM989Read/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)
2108DWSGDAAPP2MicroSQLophelia5/28/2026 3:45:28 PM953Read/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)
4071DWSGDAAPP3MicroSQLophelia5/28/2026 3:45:28 PM953Read/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)
3216DWSGDAAPP3MicroSQLophelia5/28/2026 3:45:44 PM937Read/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)
450DWSGDAAPP3MicroSQLophelia5/28/2026 3:47:18 PM843Read/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)
3797DWSGDAAPP3MicroSQLophelia5/28/2026 3:48:31 PM770Read/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)
2841DWSGDAAPP2MicroSQLophelia5/28/2026 3:48:31 PM770Read/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)
4767DWSGDAAPP1MicroSQLophelia5/28/2026 3:48:36 PM765Read/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)
4166DWSGDAAPP1MicroSQLophelia5/28/2026 3:48:46 PM755Read/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)
4290DWSGDAAPP2MicroSQLophelia5/28/2026 3:49:25 PM716Read/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)
3293DWSGDAAPP2MicroSQLophelia5/28/2026 3:49:32 PM709Read/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)
1229DWSGDAAPP2MicroSQLophelia5/28/2026 3:49:35 PM706Read/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)
1498DWSGDAAPP3MicroSQLophelia5/28/2026 3:51:05 PM616Read/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)
3444DWSGDAAPP3MicroSQLophelia5/28/2026 3:53:34 PM467Read/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)
4979DWSGDAAPP1ophelia5/28/2026 3:53:40 PM461Read/Write(@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(26),@_3 INT)SELECT PTL_REGI FROM WF_FPLAN WHERE EMP_CODI= @ AND CAS_CONT= @_1 AND PTL_CODI= @_2 AND PTL_VERS= @_3
3514DWSGDAAPP3MicroSQLophelia5/28/2026 3:55:35 PM346Read/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)
1767DWSGDAAPP3MicroSQLophelia5/28/2026 3:57:36 PM225Read/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)
1264DWSGDAAPP3MicroSQLophelia5/28/2026 3:57:36 PM225Read/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)
4521DWSGDAAPP3MicroSQLophelia5/28/2026 3:59:00 PM141Read/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)
4977DWSGDASQL1PythonOpheliasuitebi5/28/2026 4:00:00 PM81Read/Write(@0 varchar(8000),@1 varchar(8000),@2 varchar(8000))select RequestFiles . FileNumber , convert ( VARCHAR , RequestFiles . FiledDate ) Z from RequestFiles left join RequestFileHistories on RequestFiles . Id = RequestFileHistories . RequestFileId and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from dms . dbo . RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @0 ) ) left join TypeDetail on TypeDetail . Id = RequestFileHistories . Status where RequestFileHistories . UserName = @1 and TypeDetail . Name < > @2
4695SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 1)DIGITALWARE\SCVSGDA-AGENT5/28/2026 4:00:02 PM79Read/WriteCREATE PROCEDURE [dbo].[VentanillaUnica] AS /* SP REFACTORIZADO POR JUAN DIEGO GARZÓN 2/24/2025: MEJORAS: - Eliminación de MERGE , CTE y DELETE despues de la consulta principal - Reducción de tiempos con la utilización del CTE FilteredFileRequestHistories_CTE previo a la consulta principal 2 Minutos 25 Segundos => 30 Segundos - Reducción de codigo gracias a INTO y DROP TABLE - Escritura según las buenas prácticas en los alias de los campos - Modificación de CONVERT por CAST - Eliminación de valores NULL => 'Aun no se ha registrado numero de radicado' en el campo Radicado - Eliminación Radicados repetidos en la tabla final - */ BEGIN -- Verificar si la tabla existe IF OBJECT_ID('dbo.VentanillaUnicaFinal', 'U') IS NOT NULL BEGIN -- Si la tabla existe, eliminar los datos existentes TRUNCATE TABLE dbo.VentanillaUnicaFinal END ELSE BEGIN -- Si la tabla no existe, crearla CREATE TABLE [dbo].[VentanillaUnicaFinal]( [Id Tarea] [varchar](40) NULL, [Radicado] [varchar](100) NULL, [Fecha Radicacion] [date] NULL, [Hora Radicacion] [time](7) NULL, [Tipo de Documento] [varchar](500) NULL, [Tipificacion] [varchar](652) NULL, [Usuario Actual] [nvarchar](511) NULL, [Vicepresidencia] [varchar](500) NULL, [Dependencia Actual] [varchar](500) NULL, [Asunto] [varchar](max) NULL, [Medio de Recepcion] [varchar](2000) NULL, [Tipo Remitente] [varchar](2000) NULL, [Remitente] [varchar](801) NULL, [Dependencia Radicacion] [varchar](500) NULL, [Tipo Documento Remitente] [varchar](2000) NULL, [Documento Remitente] [varchar](20) NULL, [Direccion Remitente] [varchar](500) NULL, [Celular] [varchar](50) NULL, [Telefono] [varchar](50) NULL, [Tipo Radicado] [varchar](2000) NULL, [Ciudad] [varchar](500) NULL, [Departamento] [varchar](500) NULL, [Email] [varchar](500) NULL, [Estado Tarea] [varchar](17) NULL, [Fecha Vencimiento] [date] NULL, [Usuario Radicador] [varchar](201) NULL, [Dias Habiles de Respuesta] [int] NULL, [Proceso] [varchar](2000) NULL, [AñoFil] [int] NULL, [MesFil] [int] NULL, [ProcesoFil] [varchar](40) NULL, [DependenciaFil] [varchar](40) NULL, [RN] [int] NOT NULL ) END END; -- Insertar los datos en la tabla [VentanillaUnicaFinal] INSERT INTO VentanillaUnicaFinal ( [Id Tarea] ,Radicado ,[Fecha Radicacion] ,[Hora Radicacion] ,[Tipo de Documento] ,[Tipificacion] ,[Usuario Actual] ,[Vicepresidencia] ,[Dependencia Actual] ,[Asunto] ,[Medio de Recepcion] ,[Tipo Remitente] ,Remitente ,[Dependencia Radicacion] ,[Tipo Documento Remitente] ,[Documento Remitente] ,[Direccion Remitente] ,[Celular] ,[Telefono] ,[Tipo Radicado] ,[Ciudad] ,[Departamento] ,[Email] ,[Estado Tarea] ,[Fecha Vencimiento] ,[Usuario Radicador] ,[Dias Habiles de Respuesta] ,[Proceso] ,[AñoFil] ,[MesFil] ,[ProcesoFil] ,[DependenciaFil] ,[RN] ) SELECT * FROM ( SELECT WF_SEGUI_PEN.CAS_CONT AS [Id Tarea], RequestFiles.FileNumber AS [Radicado], CAST(RequestFileHistories.CreationDate AS DATE) AS [Fecha Radicacion], CAST(RequestFileHistories.CreationDate AS TIME) AS [Hora Radicacion], ISNULL(DocumentType.Name,'No Definido') [Tipo de Documento], CONCAT(NameType.Name,' ' ,ProcedureType.Name,' ' ,SpecificationType.Name ) AS [Tipificacion], CONCAT(Users_Stage.Name, ' ',Users_Stage.Surnames) AS [Usuario Actual], COALESCE( CASE WHEN DependenciesPrincipal2.Description LIKE 'VICEPRESIDENCIA%' THEN DependenciesPrincipal2.Description ELSE NULL END ,CASE WHEN DependenciesPrincipal1.Description LIKE 'VICEPRESIDENCIA%' THEN DependenciesPrincipal1.Description ELSE NULL END ,CASE WHEN DependenciesPrincipal.Description LIKE 'VICEPRESIDENCIA%' THEN DependenciesPrincipal.Description ELSE NULL END ,CASE WHEN Dependencies.name LIKE 'VICEPRESIDENCIA%' THEN Dependencies.name ELSE NULL END ) AS [Vicepresidencia], Dependencies.Name AS [Dependencia Actual], RequestFiles.Subject AS [Asunto], CANAL.Name AS [Medio de Recepcion], TipoRemitente.Name AS [Tipo Remitente], CASE WHEN TipoRemitente.Name IN ('Persona Natural', 'Apoderado / Representante Legal') THEN CASE WHEN Contacto.Names IS NOT NULL THEN CONCAT(Contacto.Names, Contacto.Surnames) WHEN Contacto.Names IS NULL AND Clients.NamesClients IS NOT NULL THEN CONCAT(Clients.NamesClients,' ',Clients.SurNames) ELSE CAST(ISNULL(Contacto.BusinessName,Clients.BusinessName) AS VARCHAR(160)) END WHEN TipoRemitente.Name = 'Persona Jurídica' THEN CASE WHEN Contacto.BusinessName IS NOT NULL THEN Contacto.BusinessName WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NOT NULL THEN Clients.BusinessName WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NULL THEN CONCAT(Contacto.Names, Contacto.Surnames) WHEN Contacto.BusinessName IS NULL AND Clients.BusinessName IS NULL AND Contacto.Names IS NULL THEN CONCAT(Clients.NamesClients,' ',Clients.SurNames) END ELSE CAST(ISNULL(Contacto.BusinessName,Clients.BusinessName) AS VARCHAR(160)) END [Remitente], Dependencies.Name AS [Dependencia Radicacion], TIPODOCUMENTOREMITENTE.Name AS [Tipo Documento Remitente], ISNULL(Contacto.NumberIdentification, Clients.NumberIdentification) AS [Documento Remitente], Clients.Address AS [Direccion Remitente], Clients.Mobile AS [Celular], Clients.Phone AS [Telefono],TIPORADICADO.Name AS [Tipo Radicado], CITY.Description [Ciudad], DEPARTMENT.Description AS [Departamento], Clients.Email AS [Email], CASE WHEN WF_SEGUI_PEN.SEG_FATI >= GETDATE() THEN 'Tareas a tiempo' WHEN WF_SEGUI_PEN.SEG_FLIM <= GETDATE() THEN 'Tareas vencidas' ELSE 'Tareas por vencer' END AS [Estado Tarea], CAST(RequestFiles.ExperationDate AS DATE) AS [Fecha Vencimiento], CONCAT(Users1.Name,' ', Users1.Surnames ) AS [Usuario Radicador], DMS_Procedures.ResponseTime AS [Dias Habiles de Respuesta], PROCESO.Name AS [Proceso], YEAR(RequestFiles.FiledDate) AS [AñoFil], MONTH(RequestFiles.FiledDate) AS [MesFil], ISNULL(ESTADO.Code,0) [ProcesoFil], ISNULL(Dependencies.Code,0) AS [DependenciaFil], ROW_NUMBER() OVER (PARTITION BY RequestFiles.FileNumber ORDER BY RequestFileHistories.CreationDate DESC) AS RN FROM OpheliaSuite.dbo.WF_SEGUI_PEN INNER JOIN OpheliaSuite.dbo.WF_SEGUI ON WF_SEGUI.CAS_CONT=WF_SEGUI_PEN.CAS_CONT AND WF_SEGUI.SEG_CONT=WF_SEGUI_PEN.SEG_CONT AND WF_SEGUI_PEN.SEG_SUBJ NOT LIKE '%VISUALIZAR INCONSISTENCIA%' LEFT JOIN DMS.DBO.RequestFileHistories ON RequestFileHistories.CaseId=WF_SEGUI_PEN.CAS_CONT AND RequestFileHistories.CreationDate = (SELECT MAX(CreationDate) FROM DMS.DBO.RequestFileHistories A WHERE A.CaseId=WF_SEGUI_PEN.CAS_CONT) LEFT JOIN DMS.DBO.RequestFiles ON RequestFiles.Id=RequestFileHistories.RequestFileId LEFT JOIN Users_Stage on Users_Stage.UserName = WF_SEGUI_PEN.SEG_UENC LEFT JOIN ( SELECT Dependencies.Id ,UserId ,MIN(Dependencies.Name) OVER (PARTITION BY UserId) Name ,MIN(CASE WHEN (Dependencies.Name) =Dependencies.Name THEN Dependencies.Code END) OVER (PARTITION BY UserId) Code ,MIN(CASE WHEN (Dependencies.Name) =Dependencies.Name THEN Dependencies.TopSection END) OVER (PARTITION BY UserId) TopSection ,UsersCompany.State FROM DMS.DBO.Users INNER JOIN DMS.DBO.UsersCompany ON Users.Id=UsersCompany.UserId INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id=UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State=TypeDetail.Id AND TypeDetail.Code = (SELECT MIN(TypeDetail.Code) FROM DMS.DBO.UsersCompany A INNER JOIN DMS.DBO.TypeDetail ON A.State=TypeDetail.Id WHERE UsersCompany.UserId=A.UserId GROUP BY A.UserId ) ) Dependencies ON Users_Stage.Id = Dependencies.UserId LEFT JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40)) = RequestFileHistories.Status LEFT JOIN dms.dbo.TypeDetail PROCESO ON CAST(PROCESO.Id AS VARCHAR(40)) = RequestFileHistories.Status AND PROCESO.Name != 'Digitalizado' LEFT JOIN DMS.DBO.DocumentType ON DocumentType.Id=RequestFiles.DocumentTypeId LEFT JOIN DMS.DBO.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id=DMS_Procedures.ProcedureTypeId LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id=DMS_Procedures.NameTypeId LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id=DMS_Procedures.SpecificationTypeId LEFT JOIN DMS.DBO.TypeDetail CANAL ON CANAL.Id=RequestFiles.ChannelId LEFT JOIN DMS.DBO.Clients ON RequestFiles.ClientId=Clients.Id LEFT JOIN DMS.DBO.Contacts Contacto ON RequestFiles.ContactId=Contacto.Id LEFT JOIN DMS.DBO.TypeDetail TipoRemitente ON TipoRemitente.Id= ISNULL(Contacto.TypeContactId,Clients.PersonTypeId) LEFT JOIN DMS.DBO.TypeDetail TIPODOCUMENTOREMITENTE ON Clients.DocumentTypeId=TIPODOCUMENTOREMITENTE.Id LEFT JOIN DMS.DBO.TypeDetail TIPORADICADO ON RequestFiles.RequestTypeId =TIPORADICADO.Id LEFT JOIN DMS.DBO.GeographicsLocation CITY ON Clients.CityId=CITY.Id LEFT JOIN DMS.DBO.GeographicsLocation DEPARTMENT ON Clients.DepartamentId=DEPARTMENT.Id LEFT JOIN DMS.DBO.Users Users1 ON Users1.UserName=RequestFileHistories.UserName LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal ON DependenciesPrincipal.Id=Dependencies.TopSection LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal1 ON DependenciesPrincipal1.Id=DependenciesPrincipal.TopSection LEFT JOIN DMS.DBO.Dependencies DependenciesPrincipal2 ON DependenciesPrincipal2.Id=DependenciesPrincipal1.TopSection ) AS C WHERE RN = 1
5231DWSGDAAPP3ophelia5/28/2026 4:01:09 PM12Read/Write(@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL, PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH FROM WF_PSWET WHERE PAR_TYPE='HEADER' AND EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2
5225DWSGDAAPP3ophelia5/28/2026 4:01:09 PM12Read/Write(@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL, PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH FROM WF_PSWET WHERE PAR_TYPE='HEADER' AND EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2
5210DWSGDAAPP1ophelia5/28/2026 4:01:12 PM9Read/Write(@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL, PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH FROM WF_PSWET WHERE PAR_TYPE='HEADER' AND EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2
5228DWSGDAAPP1ophelia5/28/2026 4:01:13 PM8Read/Write(@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL, PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH FROM WF_PSWET WHERE PAR_TYPE='HEADER' AND EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2
5232DWSGDAAPP1ophelia5/28/2026 4:01:13 PM8Read/Write(@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(15),@_3 INT)SELECT PTL_REGI FROM WF_FPLAN WHERE EMP_CODI= @ AND CAS_CONT= @_1 AND PTL_CODI= @_2 AND PTL_VERS= @_3
5235DWSGDAAPP1ophelia5/28/2026 4:01:13 PM8Read/Write(@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(36),@_3 VARCHAR(36),@_4 INT,@_5 INT,@_6 VARCHAR(44),@_7 VARCHAR(1),@_8 DATETIME2(7),@_9 DATETIME2(7),@_10 DATETIME2(7),@_11 DATETIME2(7),@_12 FLOAT,@_13 VARCHAR(1),@_14 VARCHAR(1),@_15 VARCHAR(11),@_16 VARCHAR(11),@_17 VARCHAR(MAX),@_18 VARCHAR(1),@_19 VARCHAR(MAX),@_20 VARCHAR(1),@_21 VARCHAR(1),@_22 VARCHAR(11),@_23 DATETIME2(7),@_24 VARCHAR(1),@_25 INT,@_26 DATETIME2(7),@_27 VARCHAR(13))INSERT INTO WF_SEGUI (EMP_CODI,CAS_CONT,SEG_CONT,SEG_CONA,FLU_CONT,ETA_CONT, SEG_SUBJ,SEG_PRIO,SEG_FREC,SEG_HREC,SEG_FLIM,SEG_HLIM,SEG_DIAE,SEG_ESTC, SEG_ABRE,SEG_UORI,SEG_UENC,SEG_COME,SEG_ESTE,SEG_ERRO,SEG_RECO,AUD_ESTA,AUD_USUA,AUD_UFAC,SEG_ALER,SEG_INTE,SEG_FATI,SEG_IPAD) VALUES ( @ , @_1 , @_2 , @_3 , @_4 , @_5 , @_6 , @_7 , @_8 , @_9 , @_10 , @_11 , @_12 , @_13 , @_14 , @_15 , @_16 , @_17 , @_18 , @_19 , @_20 , @_21 , @_22 , @_23 , @_24 , @_25 , @_26 , @_27 )
4454DWSGDAAPP2ophelia5/28/2026 4:01:15 PM6Read/WriteSELECT PAR_CAAR,PAR_CACC,PAR_CAPO,PAR_NLCR,PAR_COSE,PAR_TISE, PAR_VESE,PAR_NLUP,PAR_NQBE,PAR_HOST,PAR_PCOR,PAR_MAIL,PAR_CLMA, PAR_USSL,PAR_UTLS,PAR_ADJU,PAR_MTAM,PAR_USMS,PAR_IKAC,PAR_UKAC, PAR_APIK,PAR_TESE,PAR_UAGO,PAR_UAPO,PAR_USER,PAR_UFTR,PAR_UTAR, PAR_INTE,AUD_UFAC,PAR_AGOR,PAR_LOGS,PAR_BLOQ FROM GN_INSTA
4855DWSGDAAPP1Core Microsoft SqlClient Data Provideropheliadms5/28/2026 4:01:15 PM6Read/Write(@__get_Item_Code_0 varchar(500))SELECT [d].[Id], [d].[AvailabilityId], [d].[BoxId], [d].[CloseDate], [d].[CloseUser], [d].[Code], [d].[CompanyId], [d].[ConsultFrequencyId], [d].[CreationDate], [d].[CreationUser], [d].[CrossReference], [d].[DateVersion], [d].[DependencyId], [d].[Description], [d].[EndDate], [d].[ExternalId], [d].[Folios], [d].[IdStatusBeforeLocked], [d].[InUnificationProcess], [d].[InitialDate], [d].[InitialRetentionDate], [d].[InitialRetentionDateAC], [d].[Location], [d].[ModificateDate], [d].[NameReferencies], [d].[NoteScope], [d].[ParentId], [d].[PendingReorder], [d].[PrimaryValue], [d].[RetentionEndDate], [d].[RetentionEndDateAC], [d].[SecundaryValue], [d].[SeriesId], [d].[size], [d].[StateId], [d].[StateTransferId], [d].[SubseriesId], [d].[Support], [d].[Tomo], [d].[TopographicLocationDescription], [d].[TopographicLocationId], [d].[Version], [d].[VersionCCD], [d].[VersionTRD], [d].[VersionTVD], [d].[VolumeCount], [s].[Id], [s].[AccessClassificationId], [s].[Code], [s].[ConformationReferenceId], [s].[CoreArchiveStay], [s].[CreationDate], [s].[Description], [s].[DispositionDescription], [s].[DispositionTypeId], [s].[ElectronicSize], [s].[HasSubserie], [s].[ManagementArchiveStay], [s].[ModificateDate], [s].[ModificateUser], [s].[Name], [s].[PhysicalSize], [s].[PreservationTechTypeId], [s].[PreservationTypeId], [s].[Section], [s].[SerieStateId], [s].[TimeId], [s].[TimeMeasurenmentId], [s].[TopSectionId], [s].[Version], [s].[VersionCCD], [s].[VersionTRD], [s].[VersionTVD], [s0].[Id], [s0].[AccessClassificationId], [s0].[ClosingDate], [s0].[Code], [s0].[ConformationReferenceId], [s0].[CoreArchiveStay], [s0].[CreationDate], [s0].[Description], [s0].[DispositionDescription], [s0].[DispositionTypeId], [s0].[ElectronicSize], [s0].[ManagementArchiveStay], [s0].[ModificateDate], [s0].[ModificateUser], [s0].[Name], [s0].[PhysicalSize], [s0].[PreservationTechTypeId], [s0].[PreservationTypeId], [s0].[SerieId], [s0].[SubserieStateId], [s0].[TimeId], [s0].[TimeMeasurenmentId], [s0].[TopSection], [s0].[Version], [s0].[VersionCCD], [s0].[VersionTRD], [r].[Id], [r].[AccessClassificationId], [r].[Annexes], [r].[ArchivingUserId], [r].[Condition], [r].[DateDocument], [r].[DateIncorporation], [r].[DocumentConditionId], [r].[EndPage], [r].[ExternalFileNumber], [r].[FirstUseDate], [r].[Folios], [r].[Homepage], [r].[LastAccessDate], [r].[Name], [r].[Observation], [r].[Orden], [r].[ReferencesId], [r].[RequestFileId], [r].[size], [r].[SupportId], [r].[TypeDocumentId], [r].[UpdateDate], [r].[UrlLocation] FROM [DMS_References] AS [d] LEFT JOIN [Series] AS [s] ON [d].[SeriesId] = [s].[Id] LEFT JOIN [Subseries] AS [s0] ON [d].[SubseriesId] = [s0].[Id] LEFT JOIN [ReferencesRequestFile] AS [r] ON [d].[Id] = [r].[ReferencesId] WHERE [d].[Code] = @__get_Item_Code_0 ORDER BY [d].[Id], [s].[Id], [s0].[Id], [r].[Id]
2938DWSGDAAPP2Core Microsoft SqlClient Data Provideropheliadms5/28/2026 4:01:15 PM6Read/Write(@p0 uniqueidentifier,@p1 uniqueidentifier,@p2 uniqueidentifier,@p3 uniqueidentifier,@p4 datetime,@p5 datetime,@p6 datetime,@p7 nvarchar(4000),@p8 varchar(500),@p9 uniqueidentifier,@p10 varchar(500),@p11 varchar(1000),@p12 uniqueidentifier,@p13 varchar(200),@p14 datetime,@p15 int,@p16 uniqueidentifier,@p17 varchar(500),@p18 varchar(500),@p19 uniqueidentifier,@p20 int,@p21 uniqueidentifier,@p22 uniqueidentifier,@p23 datetime)SET NOCOUNT ON; INSERT INTO [DMS_Indexes] ([Id], [ArchivingUser], [CaseId], [CreationUser], [DateClosed], [DateFiled], [DateOpened], [DeletedInDrive], [Description], [DocumentTypeId], [FileName], [FilePath], [FormatId], [Keywords], [LastAccessDate], [Order], [ReferenceRFId], [ScopingNotes], [SignHash], [SignId], [Size], [SummaryFunctionId], [SupportId], [UpdateDate]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23);
5218DWSGDAAPP2ophelia5/28/2026 4:01:15 PM6Read/Write(@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT ETA_ASUN,GAB_CONT,ETA_INST,ETA_CRIA,ETA_PCOM,ETA_PDEL, ETA_PSEG,ETA_PRIO,ETA_MTIE,ETA_DLIM,ETA_HLIM,ETA_CLIM,ETA_DREC, ETA_HREC,ETA_CREC,ETA_POSX,ETA_POSY,ETA_INIC,ETA_SECS,ETA_RECO, ETA_MACC,CCA_CONT,ETA_EMAI,ETA_TABL,ETA_CAMP,ETA_ANTE,ETA_MASU, ETA_CRIS,ETA_ANTS,ETA_NOTI,ETA_SNOT,ETA_APAR,ETA_VMIN,ETA_VMAX, ETA_COST,FLU_COND,ETA_ACOR,ETA_MCOR,WEB_CONT,MWE_CONT,ETA_ARCH, REG_CONT,PLA_CONT,DPL_CONT,ETA_EJEC,ETA_TPLA,ETA_ADJU,ETA_ATDO, ETA_APLA,ETA_ADPR,ETA_TTAR,PLA_COND,DGR_CONU,DGR_CONA,ETA_DEST, ETA_SSQL,DPL_COND,ETA_TLIM,ETA_TESP,ETA_TARC,ETA_SARC,ETA_OSEP, ETA_ODAT,ETA_IENC,PME_CONT,ETA_EXTE,ETA_TFIN,ETA_TTES,DPL_CON1, DPL_CON2,DPL_CON3,ETA_CDOC,ETA_CLEC,ETA_TCON,ETA_CCES,ETA_CSMS, ETA_DSMS,ETA_ESMS,ETA_CEMA,ETA_DEMA,PTL_CODI,PTL_VERS,DPT_CODI, PTL_CODA,PTL_VERA,DPT_CODA,PTL_CODD,PTL_VERD,DPT_CODD,PTL_CODE, PTL_VERE,DPT_COD1,DPT_COD2,DPT_COD3,DPT_COD4,DPT_COD5,DPT_COD6, WSE_CODE,ETA_ADDP,DPG_CODU,DPG_CODA,ETA_VSER,ETA_TREG, ETA_TIES,ETA_CLES,ETA_DLES,ETA_HLES,ETA_TCAL,ETA_DALE,ETA_HALE FROM WF_ETAPA WITH (NOLOCK) WHERE EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2
5216DWSGDAAPP2ophelia5/28/2026 4:01:15 PM6Read/Write(@ VARCHAR(981),@_1 VARCHAR(136),@_2 VARCHAR(13),@_3 SMALLINT,@_4 VARCHAR(36),@_5 VARCHAR(36))UPDATE WF_SEGUI SET SEG_INTE=ISNULL(SEG_INTE,0)+1 ,SEG_DATA= @ ,SEG_RESU= @_1 ,SEG_IPAD= @_2 WHERE EMP_CODI= @_3 AND CAS_CONT= @_4 AND SEG_CONT= @_5
5242DWSGDAAPP1ophelia5/28/2026 4:01:16 PM5Read/Write(@ SMALLINT,@_1 VARCHAR(36))SELECT CAS_DESC,USU_CODI,CAS_PRIO,CAS_FECI,CAS_HORI,CAS_FLIM,CAS_HLIM FROM WF_CASOS WHERE EMP_CODI= @ AND CAS_CONT= @_1

Wait Stats

wait_typewaiting_tasks_countwait_time_msAvgWaitMssignal_wait_time_ms
SOS_WORK_DISPATCHER114329599541176574834.0012032174
CXCONSUMER4865763758080225511.009866464
CXPACKET1487249332369760621.005001083
PAGEIOLATCH_SH820497017895119821.001027895
LCK_M_X29987660335325551.005074
PAGEIOLATCH_EX7727127398134195.00245738
PREEMPTIVE_XE_DISPATCHER17508796132992918.000
IO_COMPLETION7067762443233066.00577462
LCK_M_IX16972949639017381.003731
ASYNC_NETWORK_IO12492392126469517.00656072
SOS_SCHEDULER_YIELD14596429191956851.0019164491
BACKUPBUFFER1539701117167577.00155874
LCK_M_U194709105808467.002434
WRITELOG602671661869710.00447138
BPSORT149572955336193.00783536
BACKUPIO411091532237112.0036741
LATCH_EX90558252565735.00706094
LCK_M_IS264471574617862.00139
ASYNC_IO_COMPLETION78431533255324.0023
LCK_M_S68540850725963.004928

Top Queries CPU

ExecutionsCPUTimeMsAvgCPUMsElapsedMsLogicalReadsQueryText
39142655666678325855367963460IF 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) )
36082434085674400991963209383INSERT 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
169551234835721601630151833620SELECT 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]
2821203033426643121320121447SELECT 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
34531198874347200251860011768select distinct (u.name + ' '+ u.Surnames) AS Revisor from RequestReviews rv INNER JOIN Users u ON u.Id=rv.UserReviewer INNER JOIN RequestFiles rf ON rf.Id=rv.RequestFileId where FileNumber=@radicado
928296111737730129627551819980SET @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 )
35911271403139178763919028588SELECT DISTINCT RFD.Radicado AS 'Radicado', RFD.Fecha AS 'Fecha', T.NameType_Description AS 'Trámite', RFD.[Tipo de persona] AS 'Tipo de persona', TD.[Name] AS 'Tratamiento', RFD.Entidad AS 'Entidad', RFD.Destinatario AS 'Destinatario', RFD.Asunto AS 'Asunto', RFD.[Cuerpo del mensaje] AS 'Cuerpo del mensaje', RFD.Elaboró AS 'Elaboró', RFD.Revisó AS 'Revisó', RFD.Aprobó AS 'Aprobó', RFD.Compañía AS 'Compañía', RFD.Dependencia AS 'Dependencia', RFD.Funcionario AS 'Funcionario', RFD.Cargo AS 'Cargo', RFD.Folios AS 'Folios', RFD.[Descripción de anexos] AS 'Descripción de anexos', RFD.[Canal de envío] AS 'Canal de envío', RFD.Dirección AS 'Dirección', RFD.País AS 'Pais', RFD.Departamento AS 'Departamento', RFD.Ciudad AS 'Ciudad', RFD.[Correo electrónico] AS 'Correo electrónico', RFD.TFirma AS 'TFirma', RFD.[Firma Firmante] as 'Firma Firmante', RF.UserName FROM GETDATABYRADICATE_VW RFD INNER JOIN REQUESTFILE_VW RF ON RF.Id=RFD.IdRadicado INNER JOIN DMSProcedure_VW T ON T.IdProcedure = RF.ProcedureId INNER JOIN CONTACTS_VW C ON C.Id=RF.ContactId LEFT JOIN TYPETREATMENT_VW TD ON TD.Id = C.TreatmentId WHERE RF.FileNumber = @Radicado
1103203010320304701451288676SELECT DISTINCT RF.Id AS id , RF.FileNumber AS fileNumber , RF.FiledDate AS filedDate , RF.Subject AS subject , DP.Id AS procedureId , REPLACE(ISNULL(CONCAT(NameType.name,'',' / ',ISNULL(ProcedureType.NameDetalle,''),' / ',ISNULL(Specification.NameEspecificacion,UPPER(DP.name))),''), ' / / ','') AS 'procedure' , Cl.Id AS clientId --, ISNULL(COALESCE(CLUpdate.BusinessName, CL.BusinessName), CONCAT(COALESCE(CLUpdate.NamesClients, CL.NamesClients),' ',ISNULL(COALESCE(CLUpdate.Surnames, CL.Surnames),''))) AS client , ISNULL(CT.BusinessName,CONCAT(ISNULL(CT.Names,''),' ',ISNULL(CT.Surnames,''),'')) AS client     , CT.Id AS contactId , ISNULL(COALESCE(CLUpdate.NumberIdentification, CL.NumberIdentification), '') AS numberIdentificatioClient , CT.NumberIdentification AS numberIdentificatioContact , CASE WHEN CT.Id IS NULL THEN '' WHEN CT.Surnames IS NULL THEN CT.Names ELSE CONCAT(CT.Names, '', CT.Surnames) END AS contact , C.Id AS companyId , ISNULL(C.Name, '') AS company , D.Id AS dependencyId , ISNULL(COALESCE(CollaboratorDependency.Name,D.Name), '') AS dependency , S.Id AS serieId , ISNULL(S.Name, '') AS serie , SS.Id AS subSerieId , ISNULL(SS.Name, '') AS subSerie , DT.Id AS documentTypeId , ISNULL(DT.Name, '') AS documentType , '' AS referenceName , TDS.Id AS stateId , ISNULL(TDS.Name, '') AS state , TDO.Id AS originId , ISNULL(TDO.Name, '') AS origin , ISNULL(CONCAT(U.Name,'',ISNULL(U.Surnames,'')),'') AS responsible , ISNULL(RF.ExperationDate,'') AS experationDate , RF.CaseId AS caseId FROM RequestFiles RF WITH(NOLOCK) LEFT JOIN DocumentType DT WITH(NOLOCK) ON DT.Id = RF.DocumentTypeId LEFT JOIN TypeDetail TDO WITH(NOLOCK) ON TDO.Id = RF.OriginId LEFT JOIN Clients CL WITH(NOLOCK) ON CL.Id = RF.ClientId LEFT JOIN ClientsUpdate CLUpdate WITH(NOLOCK) ON CLUpdate.Id = RF.ClientId LEFT JOIN Dependencies D WITH(NOLOCK) ON D.Id = RF.DependencyId LEFT JOIN Dependencies CollaboratorDependency WITH(NOLOCK) ON CollaboratorDependency.Id = RF.CollaboratorDependencyId LEFT JOIN CompanyStructures CS WITH(NOLOCK) ON CS.DependenciesId = D.Id LEFT JOIN Companies C WITH(NOLOCK) ON C.Id = CS.CompanyId LEFT JOIN Series S WITH(NOLOCK) ON S.Id = RF.SeriesId LEFT JOIN Subseries SS WITH(NOLOCK) ON SS.Id = RF.SubseriesId LEFT JOIN Users U WITH(NOLOCK) ON U.UserName = RF.ReceiverName LEFT JOIN DMS_Procedures DP WITH(NOLOCK) ON DP.Id = RF.ProcedureId LEFT JOIN TypeDetail TDS WITH(NOLOCK) ON TDS.Id = RF.StatusId LEFT JOIN Contacts CT WITH(NOLOCK) ON CT.Id = RF.ContactId LEFT JOIN REQUESTS_VW NameType ON NameType.IdSolicitud = DP.NameTypeId LEFT JOIN DRDETAILREQUEST_VW ProcedureType ON ProcedureType.IdDetalle = DP.ProcedureTypeId LEFT JOIN SPECIFICATIONTYPE_VW Specification ON Specification.IdEspecificacion = DP.SpecificationTypeId ORDER BY RF.FiledDate OFFSET (@iPageNum -1 ) * @iPageSize ROWS FETCH NEXT @iPageSize ROWS ONLY
680547013424592293238543275WITH CTE AS ( SELECT [Tipo Comunicacion] AS 'Tipo de comunicación', R.Radicado, [Fecha y Hora Radicacion], WF.FLU_CONT AS 'Proceso', CASE WHEN WF.SEG_ESTE = 'E' THEN 'Ejecutada' WHEN WF.SEG_ESTE = 'P' THEN 'Pendiente' WHEN WF.SEG_ESTE = 'C' THEN 'Cancelada' ELSE WF.SEG_ESTE END AS 'Estado de la tarea', WF.SEG_SUBJ AS 'Asunto', TD.Name AS 'Estado del radicado', RF.Massiveconsecutive AS 'Consecutivo masiva', RF.CaseId AS 'Caso', ROW_NUMBER() OVER ( PARTITION BY RF.Filenumber ORDER BY CASE WHEN WF.SEG_ESTE = 'P' THEN 0 ELSE 1 END, WF.AUD_UFAC DESC ) AS RN FROM RadicacionVentUnica R INNER JOIN DMS.dbo.RequestFiles RF ON R.RequestFilesId = RF.Id INNER JOIN DMS.dbo.TypeDetail TD ON TD.Id = RF.StatusId AND TD.Id = '4E0AFDA4-7C90-4922-B590-53738FA95819' INNER JOIN OpheliaSuite.dbo.WF_SEGUI WF ON WF.CAS_CONT = RF.CaseId WHERE PROCESO = 'Radicado de entrada' AND RADICADO NOT IN ( '20260320552732', '20260320635702' ) ) SELECT * FROM CTE WHERE RN = 1 ORDER BY [Fecha y Hora Radicacion] DESC
55620881124178672633404170WITH RowCTE AS ( -- Último registro por RequestFileId SELECT RequestFileId, RequestFileHistoriesId, 1 AS RequestPosition FROM ( SELECT RequestFileHistories.RequestFileId AS [RequestFileId], RequestFileHistories.Id AS [RequestFileHistoriesId], ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS [RowNumberDate] FROM dms.dbo.RequestFileHistories WHERE Status NOT IN ( '31B6159D-DE9D-4CBA-9508-4D9D4EE2FAF7', 'C143C3ED-F4F1-4524-AD59-80FF0F35CB9C', '9337A841-5E78-4C45-B1BE-9607B0833F5C', '56D07A62-76F6-4AB3-A26F-E18C949CBA60', '59536473-5BE9-4D7D-9CD8-D3FCB7A8D652', 'E6D67E4A-F545-4D62-B882-5A38A0FC35E2', '80878642-DF5B-4A9C-B42B-3F8A3682FCB0'--, 'D626C7EB-1090-468A-B1E7-24DD2FC0C40F' ) AND ProcessCode != '2' ) AS Ends WHERE RowNumberDate = 1 UNION ALL -- Primer registro por RequestFileId SELECT RequestFileId, RequestFileHistoriesId, 0 AS RequestPosition FROM ( SELECT RequestFileHistories.RequestFileId AS [RequestFileId], RequestFileHistories.Id AS [RequestFileHistoriesId], ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate ASC) AS [RowNumberDate] FROM dms.dbo.RequestFileHistories --WHERE Status NOT IN ( -- '31B6159D-DE9D-4CBA-9508-4D9D4EE2FAF7', 'C143C3ED-F4F1-4524-AD59-80FF0F35CB9C', -- '9337A841-5E78-4C45-B1BE-9607B0833F5C', '56D07A62-76F6-4AB3-A26F-E18C949CBA60', -- '59536473-5BE9-4D7D-9CD8-D3FCB7A8D652', 'E6D67E4A-F545-4D62-B882-5A38A0FC35E2', -- '80878642-DF5B-4A9C-B42B-3F8A3682FCB0', 'D626C7EB-1090-468A-B1E7-24DD2FC0C40F' --) --AND ProcessCode != '2' ) AS Init WHERE RowNumberDate = 1 ) -- Insertar datos en la tabla Stage INSERT INTO Stage.dbo.RequestFileHistories_Stage (RequestFileId, RequestFileHistoriesId, RequestPosition) SELECT RequestFileId, RequestFileHistoriesId, RequestPosition FROM RowCTE WHERE RequestFileId NOT IN (SELECT RequestFileId FROM dms.dbo.RequestFileHistories WHERE Status = 'e6d67e4a-f545-4d62-b882-5a38a0fc35e2')
1355554842734426777850215939select 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
238533845224371432310783844SELECT DISTINCT RF.Radicado, RF.Fecha, RF.[Tipo de persona], RF.Entidad, RF.Destinatario, RF.País, RF.Departamento, RF.Ciudad, RF.Dirección, RF.[Correo electrónico], RF.Asunto, RF.[Cuerpo del mensaje], RF.Folios, RF.[Descripción de anexos], RF.[Canal de envío], RF.Elaboró, RF.Revisó, RF.Aprobó, RF.Compañía, RF.Dependencia, RF.Funcionario, RF.Cargo, RF.TFirma, RF.[Firma Firmante], RF.[Cargo destinatario], ISNULL (RF.CollaborativeWorkName, '1') AS 'CollaborativeWorkName', RF.CollaborativeWorkBody FROM GETDATABYRADICATE_VW RF WHERE RF.Radicado = @Radicado
244792271996713872918393378SELECT [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
188614743192564821020095366SELECT COUNT(*) FROM [ReassignmentTask] AS [r] WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0
3254466083143189628690989683SELECT [d].[Id], [d].[AvailabilityId], [d].[BoxId], [d].[CloseDate], [d].[CloseUser], [d].[Code], [d].[CompanyId], [d].[ConsultFrequencyId], [d].[CreationDate], [d].[CreationUser], [d].[CrossReference], [d].[DateVersion], [d].[DependencyId], [d].[Description], [d].[EndDate], [d].[ExternalId], [d].[Folios], [d].[IdStatusBeforeLocked], [d].[InUnificationProcess], [d].[InitialDate], [d].[InitialRetentionDate], [d].[InitialRetentionDateAC], [d].[Location], [d].[ModificateDate], [d].[NameReferencies], [d].[NoteScope], [d].[ParentId], [d].[PendingReorder], [d].[PrimaryValue], [d].[RetentionEndDate], [d].[RetentionEndDateAC], [d].[SecundaryValue], [d].[SeriesId], [d].[size], [d].[StateId], [d].[StateTransferId], [d].[SubseriesId], [d].[Support], [d].[Tomo], [d].[TopographicLocationDescription], [d].[TopographicLocationId], [d].[Version], [d].[VersionCCD], [d].[VersionTRD], [d].[VersionTVD], [d].[VolumeCount], [s].[Id], [s].[AccessClassificationId], [s].[Code], [s].[ConformationReferenceId], [s].[CoreArchiveStay], [s].[CreationDate], [s].[Description], [s].[DispositionDescription], [s].[DispositionTypeId], [s].[ElectronicSize], [s].[HasSubserie], [s].[ManagementArchiveStay], [s].[ModificateDate], [s].[ModificateUser], [s].[Name], [s].[PhysicalSize], [s].[PreservationTechTypeId], [s].[PreservationTypeId], [s].[Section], [s].[SerieStateId], [s].[TimeId], [s].[TimeMeasurenmentId], [s].[TopSectionId], [s].[Version], [s].[VersionCCD], [s].[VersionTRD], [s].[VersionTVD], [s0].[Id], [s0].[AccessClassificationId], [s0].[ClosingDate], [s0].[Code], [s0].[ConformationReferenceId], [s0].[CoreArchiveStay], [s0].[CreationDate], [s0].[Description], [s0].[DispositionDescription], [s0].[DispositionTypeId], [s0].[ElectronicSize], [s0].[ManagementArchiveStay], [s0].[ModificateDate], [s0].[ModificateUser], [s0].[Name], [s0].[PhysicalSize], [s0].[PreservationTechTypeId], [s0].[PreservationTypeId], [s0].[SerieId], [s0].[SubserieStateId], [s0].[TimeId], [s0].[TimeMeasurenmentId], [s0].[TopSection], [s0].[Version], [s0].[VersionCCD], [s0].[VersionTRD], [r].[Id], [r].[AccessClassificationId], [r].[Annexes], [r].[ArchivingUserId], [r].[Condition], [r].[DateDocument], [r].[DateIncorporation], [r].[DocumentConditionId], [r].[EndPage], [r].[ExternalFileNumber], [r].[FirstUseDate], [r].[Folios], [r].[Homepage], [r].[LastAccessDate], [r].[Name], [r].[Observation], [r].[Orden], [r].[ReferencesId], [r].[RequestFileId], [r].[size], [r].[SupportId], [r].[TypeDocumentId], [r].[UpdateDate], [r].[UrlLocation] FROM [DMS_References] AS [d] LEFT JOIN [Series] AS [s] ON [d].[SeriesId] = [s].[Id] LEFT JOIN [Subseries] AS [s0] ON [d].[SubseriesId] = [s0].[Id] LEFT JOIN [ReferencesRequestFile] AS [r] ON [d].[Id] = [r].[ReferencesId] WHERE [d].[Code] = @__get_Item_Code_0 ORDER BY [d].[Id], [s].[Id], [s0].[Id], [r].[Id]
279434093981458184713513342SELECT COUNT(*) FROM [WF_PROCESS_QUEUE] AS [w] WHERE [w].[STATUS] = N'PROCESSING' AND ([w].[LAST_HEARTBEAT] IS NULL OR DATEDIFF(minute, [w].[LAST_HEARTBEAT], @__now_1) <= @___heartbeatTimeoutMinutes_2)
279414009321452803813679452SELECT TOP(@__p_0) [w].[QUEUE_ID] FROM [WF_PROCESS_QUEUE] AS [w] WHERE [w].[STATUS] = N'PENDING' AND [w].[RETRY_COUNT] < [w].[MAX_RETRIES] ORDER BY [w].[PRIORITY] DESC, [w].[CREATED_DATE]
136993936993914368953269105INSERT 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
118936901131046619521709634SELECT D.NAME AS 'Dependencia' , RF.FileNumber AS 'Radicado' , RF.FiledDate AS 'Fecha' , CONCAT(isnull(RF.Pages,0), 'F/', isnull(RF.Attachments,0), 'ADJ/', RF.ReceiverName, '/', RF.UserName) AS 'Concatenado' FROM RequestFiles RF WITH(NOLOCK) LEFT JOIN Dependencies D WITH(NOLOCK) ON D.ID=RF.DependencyId WHERE RF.FileNumber=@fileNumber
53521357042743545110776713SELECT 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

Archivos SQL más pesados

DatabaseNameLogicalNamePhysicalNameFileTypeSizeMBMaxSizeMBIsPercentGrowth
OpheliaSuiteOpheliaSuiteDMSE:\SGDEA\OpheliaSuite.mdfROWS4445254-1False
DMSDMSE:\SGDEA\DMS.mdfROWS51759-1False
DMSDMS_BE:\SGDEA\DMS_B.ndfROWS43210-1False
StageStage_logF:\LOG\Stage_log.ldfLOG355312097152False
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
tempdbtemp9D:\TEMPDB\temp9.mdfROWS23991-1False
tempdbtemp4D:\TEMPDB\temp4.mdfROWS21358-1False
StageStageE:\SGDEA\Stage.mdfROWS16149-1False
tempdbtemp11D:\TEMPDB\temp11.mdfROWS13169-1False
tempdbtempdevD:\TEMPDB\tempdev.mdfROWS12644-1False
OpheliaSuiteOpheliaSuiteDMS_logF:\LOG\OpheliaSuite_log.ldfLOG100592097152False
DMSDMS_logF:\LOG\DMS_log.ldfLOG56432097152False
DMS_bk_040923DMSE:\SGDEA\DMS_bk_040923.mdfROWS5000-1False
DMS_BK_20DMSE:\SGDEA\DMS_BK_20.mdfROWS2184-1False
AgoraSSBAgoraE:\SGDEA\Agora.mdfROWS436-1False

Errores recientes SQL

LogDateProcessInfoText
5/28/2026 12:04:29 PMLogonError: 18456, Severity: 14, State: 5.
5/28/2026 12:04:29 PMLogonLogin failed for user 'opheliasuite'. Reason: Could not find a login matching the name provided. [CLIENT: 10.212.132.189]
5/27/2026 10:54:58 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:58 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:56 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:56 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/27/2026 10:54:55 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:55 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:55 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:55 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/27/2026 10:54:55 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:55 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/27/2026 10:54:55 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:55 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:51 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:51 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/27/2026 10:54:47 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:47 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:41 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:41 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'Drive'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:39 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:39 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:34 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:34 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/27/2026 10:54:28 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:28 PMLogonLogin failed for user 'opheliadms'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:27 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:27 PMLogonLogin failed for user 'opheliadms'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.153]
5/27/2026 10:54:27 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:27 PMLogonLogin failed for user 'opheliadms'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.151]
5/27/2026 10:54:27 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:27 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.151]
5/27/2026 10:54:25 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:25 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.153]
5/27/2026 10:54:25 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:25 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:20 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:20 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:19 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:19 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/27/2026 10:54:19 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:19 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/27/2026 10:54:19 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:19 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:19 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:19 PMLogonLogin failed for user 'opheliadms'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.150]
5/27/2026 10:54:19 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:19 PMLogonLogin failed for user 'opheliadms'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.151]
5/27/2026 10:54:16 PMLogonError: 18456, Severity: 14, State: 38.
5/27/2026 10:54:16 PMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]

Tareas Ophelia en cola por servidor (estado Q)

ServidorIPCantidad
10.238.99.1507
10.238.99.1516
10.238.99.153179