DiagnÃ³stico SQL Server - DWSGDASQL2

Resumen Ejecutivo SQL

RAM libre9.86 GB

RAM total60 GB

CPU promedio28.83 %

Conexiones SQL2536

Disco promedio56657.51 %

Bloqueos activos0

Bases de datos20

Transacciones abiertas175

Tareas en cola (Q)52

Servidor SQL: SRVCLSGDEA\SGDEAPRY,1633

Host: DWSGDASQL2

Fecha: 05/26/2026 14:01:26

Alertas

Page Life Expectancy bajo (15 s)
Conexiones totales altas: 2536
Tareas Ophelia en cola (estado Q): 52 - 10.238.99.150: 20 | 10.238.99.151: 4 | 10.238.99.153: 28
Transacciones abiertas detectadas: 175 (la mÃ¡s antigua lleva 18804 segundos)
Hay 28 entradas relevantes en el SQL Error Log

Recomendaciones

PLE bajo: revisa consultas con scans grandes, Ãndices faltantes o considera ampliar RAM.
Conteo de conexiones alto: revisa pooling de conexiones en aplicaciones cliente.
Hay tareas acumuladas en WF_SEGU2 con estado Q. Verificar que los workers de Ophelia esten activos en cada servidor y que no haya errores de procesamiento.
Revisar la secciÃ³n 'Transacciones abiertas'. Transacciones largas pueden causar bloqueos, crecimiento de TLog y degradar el rendimiento.
AplicaciÃ³n con mÃ¡s conexiones: MicroSQL desde DWSGDAAPP3.

InformaciÃ³n del sistema

CSName	Caption	Version	LastBootUpTime	TotalRAMGB	FreeRAMGB
DWSGDASQL2	Microsoft Windows Server 2019 Standard	10.0.17763	5/24/2026 12:01:11 AM	60	9.86

CPU

Name	NumberOfCores	NumberOfLogicalProcessors	MaxClockSpeed
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz	2	2	2900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz	2	2	2900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz	2	2	2900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz	2	2	2900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz	2	2	2900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz	2	2	2900

Discos

DeviceID	VolumeName	SizeGB	FreeGB	FreePercent
C:		179.4	121.69	67.83
D:	TEMP	299.98	79.08	26.36
E:	DATA	5222.38	752.03	14.4
F:	LOG	299.98	256.5	85.51
G:	BACKUPS	499.98	321.91	64.38
Q:	New Volume	19.98	19.36	96.91
S:	Spool	299.98	298.34	99.45

Contadores de rendimiento - muestra 1 minuto

Counter	Min	Max	Average
\\dwsgdasql2\processor(_total)\% processor time	12.13	51.38	28.83
\\dwsgdasql2\memory\available mbytes	10487	10678	10610.25
\\dwsgdasql2\system\processor queue length	0	5	0.67
\\dwsgdasql2\physicaldisk(_total)\% disk time	53.23	246432.59	56657.51
\\dwsgdasql2\physicaldisk(_total)\current disk queue length	0	255	46.17

InformaciÃ³n SQL Server

ServerName	Edition	ProductLevel	ProductVersion	Collation	StartTime
SRVCLSGDEA\SGDEAPRY	Enterprise Edition: Core-based Licensing (64-bit)	RTM	15.0.4316.3	SQL_Latin1_General_CP1_CI_AS	5/26/2026 4:08:50 AM

Memoria SQL

PhysicalMemoryMB	CommittedMB	CommittedTargetMB	PageLifeExpectancySec	BufferCacheHitRatio
61439	44999	45000	15	33734

Bases de datos

DatabaseName	State	RecoveryModel	CompatibilityLevel	SizeMB	CreateDate
OpheliaSuite	ONLINE	FULL	150	4428562	1/25/2023 11:42:38 AM
tempdb	ONLINE	SIMPLE	150	224378	5/26/2026 4:09:15 AM
DMS	ONLINE	FULL	150	93509	3/9/2024 11:45:05 PM
Stage	ONLINE	FULL	150	48021	5/8/2023 11:39:48 AM
Drive	ONLINE	FULL	150	34668	11/9/2023 7:00:50 PM
DMS_bk_040923	ONLINE	FULL	150	5011	9/4/2023 11:54:28 AM
DMS_BK_20	ONLINE	FULL	150	2195	6/21/2023 3:24:03 PM
AgoraSSB	ONLINE	FULL	150	540	12/1/2023 10:18:55 PM
msdb	ONLINE	FULL	150	264	9/24/2019 2:21:42 PM
EstructuraImportacion	ONLINE	FULL	150	112	2/24/2024 11:16:01 AM
ImperiumReportCache	ONLINE	FULL	150	112	2/28/2026 8:36:43 PM
AgoraSSB_OLD	ONLINE	FULL	150	82	5/29/2024 3:42:38 PM
DMS_2	ONLINE	FULL	150	81	1/31/2023 8:44:52 AM
model	ONLINE	FULL	150	80	4/8/2003 9:13:36 AM
DBA	ONLINE	FULL	150	80	9/29/2023 9:16:16 AM
DMSGDEA	ONLINE	FULL	150	76	6/23/2023 10:34:45 AM
DWMaintenance	ONLINE	FULL	150	35	2/6/2023 4:32:54 PM
ProcessTable	ONLINE	FULL	150	19	1/25/2023 11:41:51 AM
Calendario	ONLINE	FULL	150	11	1/25/2023 11:40:30 AM
master	ONLINE	SIMPLE	150	6	4/8/2003 9:13:36 AM

Conexiones por aplicaciÃ³n

program_name	host_name	login_name	connections
MicroSQL	DWSGDAAPP3	opheliadms	850
MicroSQL	DWSGDAAPP1	opheliadms	786
MicroSQL	DWSGDAAPP1	ophelia	181
MicroSQL	DWSGDAAPP3	ophelia	150
MicroSQL	DWSGDAAPP2	opheliadms	111
ODK	DWSGDAAPP1	ophelia	97
ODK	DWSGDAAPP3	ophelia	82
MicroSQL	DWSGDAAPP2	ophelia	77
ODK	DWSGDAAPP2	ophelia	29
	DWSGDAAPP1	ophelia	26
	DWSGDAAPP3	ophelia	24
Core Microsoft SqlClient Data Provider	DWSGDAAPP3	opheliadms	17
MicroSQL	DWSGDAAPP4	opheliadms	16
Core Microsoft SqlClient Data Provider	DWSGDAAPP1	opheliadms	12
.Net SqlClient Data Provider	FASECOLDAVM	monitoreosaas	10
Core Microsoft SqlClient Data Provider	DWSGDAAPP2	opheliadms	8
	DWSGDAAPP2	ophelia	7
Core Microsoft SqlClient Data Provider	DWSGDAAPP3	ophelia	6
Core Microsoft SqlClient Data Provider	DWSGDAAPP1	ophelia	5
Core .Net SqlClient Data Provider	DWSGDAAPP1	ophelia	4
Core .Net SqlClient Data Provider	DWSGDAAPP3	ophelia	4
Core Microsoft SqlClient Data Provider	DWSGDAMON2	opheliadms	4
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)	DWSGDAAPP1	ophelia	4
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)	DWSGDAAPP3	ophelia	4
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)	DWSGDAAPP2	ophelia	2
Core .Net SqlClient Data Provider	DWSGDAAPP2	ophelia	2
Core Microsoft SqlClient Data Provider	DWSGDAAPP2	ophelia	2
Core Microsoft SqlClient Data Provider	DWSGDAAPP4	ophelia	2
Core .Net SqlClient Data Provider	DWSGDAAPP3	Opheliasuitebi	1
Core .Net SqlClient Data Provider	DWSGDAAPP1	Opheliasuitebi	1
.Net SqlClient Data Provider	DWSGDASQL2	ophelia	1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)	DWSGDAAPP1	ophelia	1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)	DWSGDAAPP3	ophelia	1
Microsoft® Windows® Operating System	DWSGDASQL2	NT AUTHORITY\SYSTEM	1
Python	DWSGDASQL1	Opheliasuitebi	1
SQLAgent - Contained AG	SRVCLSGDEA	DIGITALWARE\SCVSGDA-AGENT	1
SQLAgent - Email Logger	SRVCLSGDEA	DIGITALWARE\SCVSGDA-AGENT	1
SQLAgent - Generic Refresher	SRVCLSGDEA	DIGITALWARE\SCVSGDA-AGENT	1
SQLAgent - Job invocation engine	SRVCLSGDEA	DIGITALWARE\SCVSGDA-AGENT	1
SQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 1)	SRVCLSGDEA	DIGITALWARE\SCVSGDA-AGENT	1
SQLServerCEIP	SRVCLSGDEA	NT SERVICE\SQLTELEMETRY$SGDEAPRY	1
Zabbix agent 2 MSSQL plugin	DWSGDASQL2	zbx_monitor	1

Sesiones activas

session_id	login_name	host_name	program_name	status	command	wait_type	wait_time	cpu_time	logical_reads	DatabaseName
2264	Opheliasuitebi	DWSGDASQL1	Python	running	SELECT	CXCONSUMER	84037	26339	0	DMS
1456	DIGITALWARE\SCVSGDA-AGENT	SRVCLSGDEA	SQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 1)	running	INSERT	PAGEIOLATCH_SH	0	9267	773919	Stage
2357	ophelia	DWSGDASQL2	.Net SqlClient Data Provider	running	SELECT		0	11	0	master
56	NT AUTHORITY\SYSTEM	DWSGDASQL2	Microsoft® Windows® Operating System	running	EXECUTE	SP_SERVER_DIAGNOSTICS_SLEEP	531	3	85	master

Bloqueos activos

No hay datos.

Transacciones abiertas (> 5 seg)

SessionId	Host	Aplicacion	Usuario	InicioTransaccion	SegundosAbierta	TipoTransaccion	UltimaConsulta
403	DWSGDAAPP2		ophelia	5/26/2026 8:48:01 AM	18804	Read/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
1353	DWSGDAAPP2		ophelia	5/26/2026 8:48:02 AM	18803	Read/Write	(@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(20))SELECT PTL_REGI FROM WF_FPLAN WHERE EMP_CODI= @ AND CAS_CONT= @_1 AND PTL_CODI= @_2
1358	DWSGDAAPP2		ophelia	5/26/2026 8:48:02 AM	18803	Read/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
200	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 9:19:16 AM	16929	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
548	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 9:22:59 AM	16706	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
351	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 9:23:17 AM	16688	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
76	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 9:27:08 AM	16457	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
242	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 9:28:25 AM	16380	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
683	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 9:28:34 AM	16371	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
237	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 9:31:07 AM	16218	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
275	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 9:31:46 AM	16179	Read/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)
681	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 9:32:14 AM	16151	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
459	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 9:36:14 AM	15911	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
98	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 9:38:21 AM	15784	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
377	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 9:39:11 AM	15734	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
382	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 9:39:11 AM	15734	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
487	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 9:39:15 AM	15730	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
300	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 9:43:56 AM	15449	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
102	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 9:43:56 AM	15449	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
491	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 9:44:39 AM	15406	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
407	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 9:50:19 AM	15066	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
139	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 9:53:49 AM	14856	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
371	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 9:58:32 AM	14573	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
725	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 9:59:03 AM	14542	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
150	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:01:47 AM	14378	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
620	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:03:47 AM	14258	Read/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)
483	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:07:00 AM	14065	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
426	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:08:32 AM	13973	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
175	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:09:01 AM	13944	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
467	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:10:07 AM	13878	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
450	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:14:09 AM	13636	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
445	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:14:09 AM	13636	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
787	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 10:16:46 AM	13479	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
801	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 10:17:51 AM	13414	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
821	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:17:51 AM	13414	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
411	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:18:15 AM	13390	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
532	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:18:15 AM	13390	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
672	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:19:54 AM	13291	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
99	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:20:08 AM	13277	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
319	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:21:41 AM	13184	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
498	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:22:29 AM	13136	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
832	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:22:39 AM	13126	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
54	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 10:22:46 AM	13119	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
214	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:25:13 AM	12972	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
170	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:25:45 AM	12940	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
512	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 10:26:20 AM	12905	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
125	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:29:26 AM	12719	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
854	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:30:17 AM	12668	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
198	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:34:27 AM	12418	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
131	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:35:05 AM	12380	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
396	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:36:01 AM	12324	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
814	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:36:52 AM	12273	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1033	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:39:45 AM	12100	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
813	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:39:54 AM	12091	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1019	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:41:21 AM	12004	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1023	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:41:21 AM	12004	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
776	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:41:21 AM	12004	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1079	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 10:41:21 AM	12004	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
245	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:44:33 AM	11812	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
253	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:44:33 AM	11812	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
581	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:45:30 AM	11755	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
138	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:47:08 AM	11657	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
596	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 10:56:01 AM	11124	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
533	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:56:01 AM	11124	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
166	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:56:01 AM	11124	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1061	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 10:56:02 AM	11123	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1144	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 10:56:27 AM	11098	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
441	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 10:59:55 AM	10890	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1063	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:00:28 AM	10857	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1070	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:00:28 AM	10857	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
481	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:01:23 AM	10802	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
391	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:01:33 AM	10792	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
381	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:02:59 AM	10706	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
984	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:09:28 AM	10317	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
968	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:10:05 AM	10280	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
835	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:12:19 AM	10146	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
826	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:12:19 AM	10146	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
568	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:13:11 AM	10094	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
137	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 11:15:49 AM	9936	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
257	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:16:35 AM	9890	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
127	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:19:12 AM	9733	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
164	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:19:12 AM	9733	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
540	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 11:19:12 AM	9733	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1029	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:21:51 AM	9574	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
312	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:22:05 AM	9560	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
476	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:23:31 AM	9474	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
475	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:23:31 AM	9474	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1631	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:23:40 AM	9465	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
668	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:25:01 AM	9384	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1700	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:28:01 AM	9204	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
134	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:28:09 AM	9196	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
156	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:28:14 AM	9191	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
287	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:30:39 AM	9046	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1981	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:30:39 AM	9046	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1839	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:31:26 AM	8999	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2091	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:34:00 AM	8845	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1982	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:36:31 AM	8694	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
517	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:37:08 AM	8657	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
952	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:41:00 AM	8425	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1403	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:41:28 AM	8397	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
394	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:42:08 AM	8357	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
956	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:42:26 AM	8339	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
428	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:43:10 AM	8295	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
521	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:43:57 AM	8248	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
518	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:43:57 AM	8248	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2090	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:43:57 AM	8248	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
158	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:47:17 AM	8048	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1861	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:50:09 AM	7876	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2081	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:50:36 AM	7849	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1901	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:50:36 AM	7849	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1387	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:52:14 AM	7751	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
977	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:53:52 AM	7653	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1779	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:53:52 AM	7653	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
455	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:54:57 AM	7588	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2016	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:56:51 AM	7474	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
976	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 11:56:51 AM	7474	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2000	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 11:57:20 AM	7445	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
132	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:03:13 PM	7092	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1709	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:04:24 PM	7021	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2142	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 12:06:10 PM	6915	Read/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)
1021	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:07:23 PM	6842	Read/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)
905	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:07:23 PM	6842	Read/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)
289	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:07:23 PM	6842	Read/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)
324	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 12:07:27 PM	6838	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1322	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:09:18 PM	6727	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
959	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:09:18 PM	6727	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
572	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:10:28 PM	6657	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
966	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:12:10 PM	6555	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1042	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:12:10 PM	6555	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
75	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:14:43 PM	6402	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2085	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:22:31 PM	5934	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1902	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:22:31 PM	5934	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1354	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:31:09 PM	5416	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1383	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:34:37 PM	5208	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
523	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:38:59 PM	4946	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
622	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:38:59 PM	4946	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1068	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:41:06 PM	4819	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1420	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:48:08 PM	4397	Read/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)
2233	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 12:48:08 PM	4397	Read/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)
436	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:53:49 PM	4056	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
978	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:54:49 PM	3996	Read/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)
2464	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:57:17 PM	3848	Read/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)
1786	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 12:57:18 PM	3847	Read/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)
2195	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 12:57:54 PM	3811	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
219	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:01:27 PM	3598	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2265	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 1:03:29 PM	3476	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2403	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:03:29 PM	3476	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
256	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:09:23 PM	3122	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1898	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:21:44 PM	2381	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2080	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 1:25:55 PM	2130	Read/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)
2401	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:26:30 PM	2095	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
303	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:28:12 PM	1993	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
584	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 1:31:43 PM	1782	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
499	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:32:23 PM	1742	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2482	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:34:05 PM	1640	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2484	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 1:34:05 PM	1640	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2490	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 1:34:05 PM	1640	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1621	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 1:34:05 PM	1640	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
105	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 1:34:23 PM	1622	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
194	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 1:35:53 PM	1532	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
286	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:36:36 PM	1489	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2369	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 1:37:13 PM	1452	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
861	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:40:10 PM	1275	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2356	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 1:42:07 PM	1158	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2436	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:42:08 PM	1157	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1460	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 1:44:50 PM	995	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
817	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 1:44:50 PM	995	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
375	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:49:41 PM	704	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2152	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 1:52:26 PM	539	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1792	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 1:53:46 PM	459	Read/Write	(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2264	DWSGDASQL1	Python	Opheliasuitebi	5/26/2026 2:00:00 PM	85	Read/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
1456	SRVCLSGDEA	SQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 1)	DIGITALWARE\SCVSGDA-AGENT	5/26/2026 2:00:03 PM	82	Read/Write	CREATE 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
2329	DWSGDAAPP1		ophelia	5/26/2026 2:01:13 PM	12	Read/Write	(@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL, PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH FROM WF_PSWET WHERE PAR_TYPE='HEADER' AND EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2
2362	DWSGDAAPP3		ophelia	5/26/2026 2:01:18 PM	7	Read/Write	(@ SMALLINT,@_1 VARCHAR(36),@_2 VARCHAR(36),@_3 VARCHAR(36),@_4 INT,@_5 INT,@_6 VARCHAR(38),@_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(6),@_16 VARCHAR(6),@_17 VARCHAR(MAX),@_18 VARCHAR(1),@_19 VARCHAR(MAX),@_20 VARCHAR(1),@_21 VARCHAR(1),@_22 VARCHAR(6),@_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 )
2355	DWSGDAAPP1		ophelia	5/26/2026 2:01:19 PM	6	Read/Write	(@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL, PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH FROM WF_PSWET WHERE PAR_TYPE='HEADER' AND EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2

Wait Stats

wait_type	waiting_tasks_count	wait_time_ms	AvgWaitMs	signal_wait_time_ms
SOS_WORK_DISPATCHER	7031676	6411883212	911.00	5298460
CXPACKET	19111149	279367003	14.00	5596903
CXCONSUMER	32579015	191834731	5.00	15428840
PAGEIOLATCH_SH	4824367	91118017	18.00	744618
PAGEIOLATCH_EX	946038	28214780	29.00	88621
ASYNC_NETWORK_IO	878715	14608720	16.00	442833
SOS_SCHEDULER_YIELD	10305197	12604209	1.00	12580344
BACKUPBUFFER	1254595	6268654	4.00	166444
BPSORT	1713751	5919593	3.00	886729
IO_COMPLETION	649254	5504065	8.00	53940
LCK_M_X	625	4562795	7300.00	381
LATCH_EX	1329918	4293112	3.00	690750
LCK_M_IS	124	2647702	21352.00	58
BACKUPIO	330301	2403042	7.00	31856
ASYNC_IO_COMPLETION	87	2205520	25350.00	35
WRITELOG	251438	2105366	8.00	172331
HTDELETE	157054	1377211	8.00	70714
LCK_M_SCH_M	108	1282240	11872.00	81
RESERVED_MEMORY_ALLOCATION_EXT	512480576	1011422	0.00	0
HTREPARTITION	252313	860540	3.00	121779

Top Queries CPU

Executions	CPUTimeMs	AvgCPUMs	ElapsedMs	LogicalReads	QueryText
5	11509324	2301864	2998931	84417035	INSERT INTO dbo.DiasHabiles (Id, DiasHabiles) SELECT R.Id, (COUNT(D.Fecha) * CASE WHEN R.ExperationDate >= CAST(GETDATE() AS DATE) THEN 1 ELSE -1 END) - 1 AS DiasHabiles FROM dms.dbo.RequestFiles AS R LEFT JOIN ( SELECT ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS MaxReg ,RequestFileId ,CreationDate ,DependencyId ,CaseId ,UserName ,Status FROM dms.dbo.RequestFileHistories WHERE Status NOT IN ('31B6159D-DE9D-4CBA-9508-4D9D4EE2FAF7','C143C3ED-F4F1-4524-AD59-80FF0F35CB9C' ,'9337A841-5E78-4C45-B1BE-9607B0833F5C','56D07A62-76F6-4AB3-A26F-E18C949CBA60' ,'59536473-5BE9-4D7D-9CD8-D3FCB7A8D652','9BD808F4-6E9F-4710-B789-19FE1CE8C55A' ,'4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425' --estados de fraude ,'8d6acd5a-d128-45b0-b1a5-f9c0fef90708','EF7B7E43-9151-422A-9A2C-6E3B6C53BC85') ) AS RequestFileHistories ON RequestFileHistories.RequestFileId=R.Id AND RequestFileHistories.MaxReg = 1 AND RequestFileHistories.DependencyId IS NOT NULL LEFT JOIN #DiasHabiles AS D ON D.Fecha BETWEEN CASE WHEN R.ExperationDate >= CAST(GETDATE() AS DATE) THEN CAST(GETDATE() AS DATE) ELSE R.ExperationDate END AND CASE WHEN R.ExperationDate >= CAST(GETDATE() AS DATE) THEN R.ExperationDate ELSE CAST(GETDATE() AS DATE) END WHERE RequestFileHistories.Status NOT IN ('e6d67e4a-f545-4d62-b882-5a38a0fc35e2', '80878642-df5b-4a9c-b42b-3f8a3682fcb0') AND R.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' GROUP BY R.Id, R.ExperationDate
6762	1774837	262	2412844	77830708	SELECT TOP(1) [r].[Id], [r].[DependencyId], [r].[FileNumber], [r].[ResponseDate], [r].[StatusId], [r].[VersionCCD], [r].[VersionTRD] FROM [RequestFiles] AS [r] WHERE [r].[FileNumber] = @request_FileNumber
1837	1105020	601	2062041	32024540	INSERT 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
1838	1099307	598	1403066	31752380	IF 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) )
9237139	1058245	0	1120978	51590870	SET @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 )
115	1005252	8741	337190	3911490	SELECT FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fecha radicado' , RF.FileNumber AS 'Radicado' , RF.[Subject] AS 'Asunto' FROM [dbo].[REQUESTFILE_VW] RF INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = RF.ClientId WHERE C.NumberIdentification = @NIdentification ORDER BY Radicado DESC
1	983464	983464	487784	93395052	INSERT INTO Stage.dbo.RadicacionVentUnica SELECT RequestFiles.Id as [RequestFilesId], RequestFiles.FileNumber AS [Radicado], -- Número de radicación CAST(RequestFiles.FiledDate AS DATETIME) AS [Fecha y Hora Radicacion], CAST(RequestFiles.FiledDate AS DATE) AS [Fecha Radicacion], -- Fecha de radicación CAST(RequestFiles.FiledDate AS TIME(0)) AS [Hora Radicacion], -- Hora de radicación TIPORADICADO.Name AS [Tipo Radicado], -- Tipo de radicación -- Determinar el usuario actual IIF(Users.Name + Users.Surnames IS NULL, 'La información del usuario en el sistema ' + COALESCE(WF_SEGUI_PEN.SEG_UENC, RequestFileHistories.UserName, Users1.UserName) + ' no es correcta', CONCAT(Users.Name, ' ', Users.Surnames) ) AS [Usuario Actual], dep.Vicepresidencia AS [Vicepresidencia], -- Vicepresidencia dep.Dependencia AS [Dependencia Actual], -- Dependencia actual ESTADO.Name AS [PROCESO], -- Estado del proceso ISNULL(DocumentType.Name, 'No Definido') AS [Tipo de Documento], -- Tipo de documento -- Definir el medio de recepción CASE WHEN TIPORADICADO.Name = 'Comunicación Interna' THEN 'Correo electrónico' ELSE CANAL.Name END AS [Medio de Recepcion], --Determinar el tipo de remitente ISNULL(TYPEPERSON_VW.Name, TYPEPERSON_VW1.Name) AS [Tipo Remitente], --Determinar el remitente CASE WHEN TYPEPERSON_VW.Name = 'Anónimo' OR TYPEPERSON_VW1.Name = 'Anónimo' THEN 'Anónimo' WHEN TYPEPERSON_VW.Name IN ('Persona Natural', 'Apoderado / Representante Legal') --OR TYPEPERSON_VW1.Name IN ('Persona Natural', 'Apoderado / Representante Legal') --THEN IIF(CONCAT(Contacto.Names, ' ', Contacto.Surnames) IS NULL, CONCAT(Clients.NamesClients, ' ', Clients.SurNames), CONCAT(Clients1.NamesClients, ' ', Clients1.SurNames)) --113839 Aranda 12-09-2025 donde se evidencia error en remitente por lo cual se realiza validación que priorice el dato de contacto THEN COALESCE(IIF (Contacto.Names IS NOT NULL OR Contacto.SurNames IS NOT NULL, CONCAT(Contacto.Names, ' ', Contacto.SurNames),NULL), IIF(Clients.NamesClients IS NOT NULL OR Clients.SurNames IS NOT NULL, CONCAT(Clients.NamesClients, ' ', Clients.SurNames),NULL), IIF(Clients1.NamesClients IS NOT NULL OR Clients1.SurNames IS NOT NULL, CONCAT(Clients1.NamesClients, ' ', Clients1.SurNames),NULL) ) ELSE CASE WHEN Contacto.BusinessName IS NOT NULL THEN Contacto.BusinessName WHEN Clients.BusinessName IS NOT NULL THEN Clients.BusinessName WHEN Clients1.BusinessName IS NOT NULL THEN Clients1.BusinessName ELSE IIF(CONCAT(Contacto.Names, ' ', Contacto.Surnames) IS NULL, CONCAT(Clients.NamesClients, ' ', Clients.SurNames), CONCAT(Clients1.NamesClients, ' ', Clients1.SurNames)) END END AS [Remitente], TIPODOCUMENTOREMITENTE.Name AS [Tipo Documento Remitente], -- Tipo de documento del remitente ISNULL(Contacto.NumberIdentification, Clients1.NumberIdentification) AS [Documento Remitente], -- Número de identificación del remitente ISNULL(Contacto.Address, Clients.Address) AS [Direccion Remitente], -- Dirección del remitente ISNULL(Contacto.Mobile, Clients.Mobile) AS [Celular], -- Celular del remitente ISNULL(Contacto.Telephone, Clients.Phone) AS [Telefono], -- Teléfono del remitente CITY.Description AS [Ciudad], -- Ciudad del remitente DEPARTMENT.Description AS [Departamento], -- Departamento del remitente ISNULL(Contacto.Email, Clients1.Email) AS [Email], -- Email del remitente -- Información sobre la radicación CONCAT(Users1.Name, ' ', Users1.Surnames) AS [Usuario Radicador], -- Usuario que radicó Dependencies1.Name AS [Dependencia Radicacion], -- Dependencia donde se radicó CAST(RequestFiles.ExperationDate AS DATE) AS [Fecha Vencimiento], -- Fecha de vencimiento CAST(RequestFiles.ExperationDate AS Time(0)) AS [Hora Vencimiento], -- Hora de vencimiento ORIGEN.Name AS [Tipo Comunicacion], -- Tipo de comunicación DMS_Procedures.ResponseTime AS [Dias Habiles de Respuesta], -- Días hábiles para respuesta -- Documentos adjuntos RequestFiles.Pages AS [Folios], -- Cantidad de folios RequestFiles.Attachments AS [Anexos], -- Cantidad de anexos -- Tipificación del procedimiento CONCAT(NameType.Name, ' ', ProcedureType.Name, ' ', SpecificationType.Name) AS [Tipificacion], -- Información del asunto RequestFiles.Subject AS [Asunto], -- Asunto del radicado -- Estado del radicado COALESCE( CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CONVERT(DATE,RequestFilesRespuestaDefinitiva.FiledDate) <=CONVERT(DATE,RequestFiles.ExperationDate)--22/10/2024 Se cambia campo RequestFilesExpirationDate.ExpirationDateFinal THEN 'En Tiempo'--'TRAMITADO OPORTUNAMENTE' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND CONVERT(DATE,RequestFilesRespuestaDefinitiva.FiledDate)>CONVERT(DATE,RequestFiles.ExperationDate) THEN 'Vencido'--'TRAMITADO EXTEMPORALMENTE' END ,CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND CONVERT(DATE,RequestFiles.ExperationDate) < GETDATE()-1 THEN 'Vencido' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND DATEDIFF(DAY,GETDATE(),CONVERT(DATE,RequestFiles.ExperationDate)) IN (0,1,2,3) THEN 'Proximo a Vencer' WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND DATEDIFF(DAY,GETDATE(),CONVERT(DATE,RequestFiles.ExperationDate)) >3 THEN 'En Tiempo' END ,CASE WHEN ESTADO.Name NOT IN ('Finalizado','Envío electrónico','Comunicación pendiente por clasificar','Comunicación Clasificada','Pendiente en la dependencia','Finalizado por Solicitud del Usuario') AND TIPORADICADO.Name='Salida' THEN 'Elaboración' END )[Estado Radicado], --COALESCE( -- -- Si existe fecha de radicación, evaluamos si fue en tiempo o vencido -- CASE -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL -- AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) <= CAST(RequestFiles.ExperationDate AS DATE) -- THEN 'En Tiempo' -- Tramitado oportunamente -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL -- AND CAST(RequestFilesRespuestaDefinitiva.FiledDate AS DATE) > CAST(RequestFiles.ExperationDate AS DATE) -- THEN 'Vencido' -- Tramitado extemporáneamente -- END, -- -- Si no existe fecha de radicación, evaluamos su estado según la fecha de expiración -- CASE -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND CAST(RequestFiles.ExperationDate AS DATE) < DATEADD(DAY, -1, GETDATE()) -- THEN 'Vencido' -- La expiración ya pasó -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND RequestFiles.ExperationDate - GETDATE() BETWEEN 0 AND 3 -- THEN 'Próximo a Vencer' -- Expira en los próximos 3 días -- WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NULL AND RequestFiles.ExperationDate - GETDATE() > 3 -- THEN 'En Tiempo' -- Todavía en plazo -- END, -- -- Si el estado no es final y es un radicado de salida, se considera en "Elaboración" -- CASE -- WHEN ESTADO.Name NOT IN ( -- 'Finalizado', 'Envío electrónico', 'Comunicación pendiente por clasificar', -- 'Comunicación Clasificada', 'Pendiente en la dependencia', 'Finalizado por Solicitud del Usuario' -- ) -- AND TIPORADICADO.Name = 'Salida' -- THEN 'Elaboración' -- END --) AS [Estado Radicado], -- Información adicional Users1.UserName AS UsuarioFiltro, CAST(MAX(RequestFilesRespuestaParcial.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) AS VARCHAR(30)) AS [Respuesta Parcial], CAST(MAX(RequestFilesRespuestaParcial.FiledDate) OVER(PARTITION BY RequestFiles.FiledDate) AS DATE) AS [Fecha Respuesta Parcial], -- Validaciones de respuestas finales CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND RequestFiles.RequestTypeId = '5449808C-16FF-4BDE-98C7-4C04C76B221B' THEN CAST(MAX(RequestFilesRespuestaDefinitiva.FileNumber) OVER (PARTITION BY RequestFiles.FileNumber) AS VARCHAR(30)) ELSE NULL END AS [Respuesta Final], CASE WHEN RequestFilesRespuestaDefinitiva.FiledDate IS NOT NULL AND RequestFiles.RequestTypeId = '5449808C-16FF-4BDE-98C7-4C04C76B221B' THEN CAST(MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER (PARTITION BY RequestFiles.FiledDate) AS DATE) ELSE NULL END AS [Fecha Respuesta Final], -- Información sobre finalización CASE WHEN ESTADO.Name IN('Finalizado', 'Finalizado por Solicitud del Usuario') THEN CAST(RequestFileHistories.CreationDate AS DATE) ELSE NULL END AS [Fecha Finalizado], CASE WHEN ESTADO.Name IN('Finalizado','Finalizado por Solicitud del Usuario') THEN CAST(RequestFileHistories.CreationDate AS Time(0)) ELSE NULL END [Hora Finalizado], CASE WHEN ESTADO.Name IN('Finalizado', 'Finalizado por Solicitud del Usuario') THEN RequestFileHistories.Reason ELSE NULL END AS [Observación Finalizado], RequestFilesRespuestaDefinitiva.ChannelId AS Canal_Respuesta_Final, RequestFilesRespuestaParcial.ChannelId AS Canal_Respuesta_Parcial, Users.Id AS USERID -- Identificador del usuario FROM dms.dbo.RequestFiles LEFT JOIN dms.dbo.RequestFileHistories ON RequestFileHistories.RequestFileId = RequestFiles.Id AND EXISTS (SELECT 1 FROM [Stage].[dbo].[RequestFileHistories_Stage] WHERE RequestFileHistories_Stage.RequestFileHistoriesId = RequestFileHistories.Id AND RequestFileHistories_Stage.RequestPosition = 1) LEFT JOIN dms.dbo.RequestFileHistories RequestFileHistories1 ON RequestFileHistories1.RequestFileId = RequestFiles.Id AND EXISTS (SELECT 1 FROM [Stage].[dbo].[RequestFileHistories_Stage] WHERE RequestFileHistories_Stage.RequestFileHistoriesId = RequestFileHistories1.Id AND RequestFileHistories_Stage.RequestPosition = 0) LEFT JOIN [Stage].[dbo].[Users_Stage] Users1 ON Users1.UserName = RequestFileHistories1.UserName --ok LEFT JOIN OpheliaSuite.dbo.WF_SEGUI_PEN ON WF_SEGUI_PEN.CAS_CONT = RequestFileHistories.CaseId --ok AND WF_SEGUI_PEN.SEG_SUBJ NOT LIKE '%VISUALIZAR INCONSISTENCIA%' LEFT JOIN [Stage].[dbo].[Users_Stage] Users ON Users.UserName = COALESCE(WF_SEGUI_PEN.SEG_UENC,RequestFileHistories.UserName,Users1.UserName) --ok --LEFT JOIN [Stage].[dbo].[Depentencias_Vicepresidencia] Dep ON RequestFileHistories.DependencyId = Dep.id --ok LEFT JOIN (SELECT Dependencies.Id, Dependencies.Name AS Dependencia, CASE WHEN Dependencies.Name in ('DIRECCIÓN SARLAFT', 'UNIDAD DE CONTROL INTERNO DISCIPLINARIO', 'AUDITORIA CORPORATIVA','GERENCIA DE RIESGOS') THEN Dependencies.Name WHEN Dependencies.Name = 'PRESIDENCIA' THEN 'PRESIDENCIA' WHEN N1.Name = 'PRESIDENCIA' THEN Dependencies.Name WHEN N1.Name like '%VICEPRESIDENCIA %' THEN N1.Name WHEN N2.Name like '%VICEPRESIDENCIA %' THEN N2.Name WHEN N3.Name like '%VICEPRESIDENCIA %' THEN N3.Name ELSE '' END AS Vicepresidencia FROM [DMS].[dbo].[Dependencies] LEFT JOIN dms.dbo.Dependencies N1 ON Dependencies.TopSection = N1.Id LEFT JOIN dms.dbo.Dependencies N2 ON N1.TopSection = N2.Id LEFT JOIN dms.dbo.Dependencies N3 ON N2.TopSection = N3.Id where Dependencies.State = '57DC632C-79D5-458A-845B-76F4859F3E75' ) Dep ON COALESCE(RequestFileHistories.DependencyId, RequestFileHistories1.DependencyId) = Dep.id LEFT JOIN ( SELECT Users.UserName, Dependencies.Name, ROW_NUMBER() OVER (PARTITION BY Users.UserName ORDER BY Dependencies.Name ASC) AS Rn FROM [Stage].[dbo].[Users_Stage] Users INNER JOIN DMS.DBO.UsersCompany ON Users.Id=UsersCompany.UserId INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id=UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State=TypeDetail.Id AND TypeDetail.Code = (SELECT MIN(TypeDetail.Code) FROM DMS.DBO.UsersCompany A INNER JOIN DMS.DBO.TypeDetail ON A.State=TypeDetail.Id WHERE UsersCompany.UserId = A.UserId GROUP BY A.UserId)) Dependencies1 ON RequestFileHistories1.UserName = Dependencies1.UserName --ok AND Dependencies1.Rn = '1' LEFT JOIN STAGE.DBO.RequestFilesExpirationDate ON RequestFilesExpirationDate.FileNumber=RequestFiles.FileNumber --OK LEFT JOIN DMS.DBO.TYPEORIGIN_VW ORIGEN ON RequestFiles.OriginId =ORIGEN.Id LEFT JOIN DMS.DBO.TYPEORIGIN_VW TIPORADICADO ON RequestFiles.RequestTypeId =TIPORADICADO.Id LEFT JOIN dms.dbo.TypeDetail ESTADO ON CAST(ESTADO.Id AS VARCHAR(40))= COALESCE(RequestFileHistories.status, RequestFileHistories1.status) --OK LEFT JOIN DMS.DBO.DocumentType ON DocumentType.Id=RequestFiles.DocumentTypeId LEFT JOIN DMS.DBO.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId --OK LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id=DMS_Procedures.NameTypeId --OK LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id=DMS_Procedures.ProcedureTypeId --OK LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id=DMS_Procedures.SpecificationTypeId --OK LEFT JOIN DMS.DBO.CANAL_VW CANAL ON CANAL.Id=RequestFiles.ChannelId LEFT JOIN DMS.DBO.Contacts Contacto ON Contacto.Id = RequestFiles.ContactId --OK LEFT JOIN DMS.DBO.Clients ON RequestFiles.ClientId=Clients.Id --OK LEFT JOIN DMS.DBO.Clients Clients1 ON Clients1.Id=Contacto.ClientId --OK LEFT JOIN DMS.DBO.TYPEPERSON_VW ON TYPEPERSON_VW.Id=Contacto.TypeContactId --OK LEFT JOIN DMS.DBO.TYPEPERSON_VW TYPEPERSON_VW1 ON TYPEPERSON_VW1.Id=Clients1.PersonTypeId --OK LEFT JOIN DMS.DBO.TYPEIDENTI_VW TIPODOCUMENTOREMITENTE ON Clients1.DocumentTypeId=TIPODOCUMENTOREMITENTE.Id --OK LEFT JOIN DMS.DBO.GeographicsLocationMun_VW CITY ON Contacto.CityId=CITY.Id --OK LEFT JOIN DMS.DBO.GeographicsLocatioDep_VW DEPARTMENT ON Contacto.DepartamentId = DEPARTMENT.Id --OK LEFT JOIN (SELECT CC.Id, AA.FiledDate, AA.FileNumber, AA.ChannelId, ROW_NUMBER() OVER (PARTITION BY BB.ParentId ORDER BY AA.FiledDate DESC) AS RN FROM dms.dbo.RequestFiles AA INNER JOIN dms.dbo.RelatedRequestFiles BB ON BB.RequestFileId=AA.Id INNER JOIN dms.dbo.RequestFiles CC ON BB.ParentId=CC.Id WHERE AA.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND AA.ResposnseText=1 ) RequestFilesRespuestaDefinitiva ON RequestFiles.Id = RequestFilesRespuestaDefinitiva.Id AND RequestFilesRespuestaDefinitiva.RN = '1' LEFT JOIN (SELECT CC.Id, AA.FiledDate, AA.FileNumber, AA.ChannelId, ROW_NUMBER() OVER (PARTITION BY BB.ParentId ORDER BY AA.FiledDate DESC) AS RN FROM dms.dbo.RequestFiles AA INNER JOIN dms.dbo.RelatedRequestFiles BB ON BB.RequestFileId=AA.Id INNER JOIN dms.dbo.RequestFiles CC ON BB.ParentId=CC.Id WHERE AA.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND AA.ResposnseText=2 ) RequestFilesRespuestaParcial ON RequestFiles.Id = RequestFilesRespuestaParcial.Id AND RequestFilesRespuestaParcial.RN = '1' WHERE RequestFileHistories1.Status != 'e6d67e4a-f545-4d62-b882-5a38a0fc35e2' AND RequestFileHistories.Status != 'e6d67e4a-f545-4d62-b882-5a38a0fc35e2' AND (RequestFileHistories.ProcessCode != 'Combinación de Correspondencia - ' AND RequestFileHistories.ProcessName != 'Respuesta Parcial')
48	949214	19775	238279	36122757	SELECT [w].[EMP_CODI], [w].[CAS_CONT], [w].[SEG_CONT], [w].[AUD_ESTA], [w].[AUD_UFAC], [w].[AUD_USUA], [w].[ETA_CONT], [w].[FLU_CONT], [w].[SEG_ABRE], [w].[SEG_AENV], [w].[SEG_ALER], [w].[SEG_COME], [w].[SEG_CONA], [w].[SEG_DATA], [w].[SEG_DIAD], [w].[SEG_DIAE], [w].[SEG_DIAR], [w].[SEG_EANT], [w].[SEG_ERRO], [w].[SEG_ESTC], [w].[SEG_ESTE], [w].[SEG_FATI], [w].[SEG_FCUL], [w].[SEG_FENC], [w].[SEG_FIEJ], [w].[SEG_FLIM], [w].[SEG_FREC], [w].[SEG_HCUL], [w].[SEG_HLIM], [w].[SEG_HREC], [w].[SEG_IDCH], [w].[SEG_INTE], [w].[SEG_IPAD], [w].[SEG_PRIO], [w].[SEG_RECO], [w].[SEG_RESU], [w].[SEG_SUBJ], [w].[SEG_UALA], [w].[SEG_UENC], [w].[SEG_UORI] FROM [WF_SEGUI] AS [w] WHERE [w].[EMP_CODI] = @companyCode AND [w].[SEG_IPAD] = @localIp AND [w].[SEG_ESTE] = N'Q' AND [w].[SEG_FENC] < @queuingDate AND [w].[SEG_FREC] >= @creationDate
1	941008	941008	206700	19765500	SELECT FileNumber --,MAX(F.FechaTermino)ExpirationDate ,MAX(ISNULL(F1.FechaTermino,[FechaRadicacion]))ExpirationDateInitial --,CASE WHEN ExperationDate >= [FechaRadicacion] THEN ExperationDate ELSE MAX(ISNULL(F1.FechaTermino,[FechaRadicacion]))END ExpirationDateInitial --Se realiza ajuste a campo de acuerdo a validación con Julio INTO FECHAINICIALVENCIMIENTOTEMP FROM ( SELECT DISTINCT RequestFiles.FileNumber ,MIN(RequestFiles.FiledDate) [FechaRadicacion] ,MAX(CASE WHEN RequestFiles1.ResposnseText=2 THEN RequestFiles1.FiledDate END ) [FechaRespuestaParcialMaxima] ,MAX(CASE WHEN RequestFiles1.ResposnseText=1 THEN RequestFiles1.FiledDate END ) [FechaRespuestaFinalMaxima] ,MAX(DMS_Procedures.ResponseTime) ResponseTime --,RequestFiles.ExperationDate --,MAX(F1.FechaTermino) [ExpirationDateInitial] --INTO #FECHAINICIALVENCIMIENTO FROM DMS.dbo.RequestFiles LEFT JOIN DMS.dbo.DMS_Procedures ON DMS_Procedures.Id=RequestFiles.ProcedureId LEFT JOIN DMS.dbo.RequestFileHistories ON RequestFileHistories.RequestFileId=RequestFiles.Id AND RequestFileHistories.CreationDate=(SELECT MAX(CreationDate) FROM DMS.dbo.RequestFileHistories A WHERE A.RequestFileId=RequestFileHistories.RequestFileId) LEFT JOIN DMS.dbo.Dependencies ON Dependencies.Id=RequestFileHistories.DependencyId LEFT JOIN dms.dbo.RelatedRequestFiles ON RelatedRequestFiles.ParentId =RequestFiles.Id LEFT JOIN dms.dbo.RequestFiles RequestFiles1 ON RelatedRequestFiles.requestfileId =CONVERT(VARCHAR(40),RequestFiles1.Id) --WHERE RequestFiles.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' --WHERE RequestFileHistories.CreationDate >= DATEADD(MONTH, -6, GETDATE()) --AND RequestFiles.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' --AND RequestFiles.FileNumber ='20230321376732' WHERE RequestFileHistories.Status <>'E6D67E4A-F545-4D62-B882-5A38A0FC35E2' --AND RequestFileHistories.CreationDate >= DATEADD(MONTH, -6, GETDATE()) --AND RequestFiles.FileNumber IN ('20240323449482','20241073468712','20241013458352') --AND RequestFiles.FileNumber IN ('20241014144082') --AND YEAR(RequestFiles.FiledDate) = 2024 --AND MONTH(RequestFiles.FiledDate) = 10 --AND DAY(RequestFiles.FiledDate) = 30 --AND RequestFiles.FiledDate <> '2024-10-29' --AND RequestFiles.FileNumber <> 0 GROUP BY RequestFiles.FileNumber --,RequestFiles.ExperationDate ,RequestFiles.FiledDate )Vencimiento --CROSS APPLY DBO.FechaTerminoSinDiasInhabiles (CONVERT(date,[FechaRespuestaParcialMaxima]+1),15) F CROSS APPLY DBO.FechaTerminoSinDiasInhabiles (CONVERT(DATE,[FechaRadicacion]+1),ResponseTime) F1 GROUP BY FileNumber
11638	900134	77	1165777	103932945	SELECT TOP(@__p_2) [r].[Id], [r].[CaseCode], [r].[CompanyCode], [r].[CompletedAt], [r].[CreatedAt], [r].[DependencyCode], [r].[ErrorMessage], [r].[FileNumber], [r].[JobId], [r].[LastErrorAt], [r].[MaxRetries], [r].[NextRetryAt], [r].[ProcessCode], [r].[ProcessName], [r].[ProcessingServer], [r].[Reason], [r].[ReassignBPM], [r].[ReassignDMS], [r].[RetryCount], [r].[StartedAt], [r].[Status], [r].[StatusId], [r].[TrackingCode], [r].[UserExecutor], [r].[UserToReassign] FROM [ReassignmentTask] AS [r] WHERE [r].[ProcessingServer] = @__serverIp_0 AND ([r].[Status] = N'Pending' OR ([r].[Status] = N'Failed' AND [r].[RetryCount] < [r].[MaxRetries] AND [r].[NextRetryAt] IS NOT NULL AND [r].[NextRetryAt] <= @__now_1)) ORDER BY [r].[CreatedAt]
1	857418	857418	166847	833673	SELECT 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
350	817865	2336	283976	17768406	SELECT DISTINCT RF.Radicado, RF.Fecha, RF.[Tipo de persona], RF.Entidad, RF.Destinatario, RF.País, RF.Departamento, RF.Ciudad, RF.Dirección, RF.[Correo electrónico], RF.Asunto, RF.[Cuerpo del mensaje], RF.Folios, RF.[Descripción de anexos], RF.[Canal de envío], RF.Elaboró, RF.Revisó, RF.Aprobó, RF.Compañía, RF.Dependencia, RF.Funcionario, RF.Cargo, RF.TFirma, RF.[Firma Firmante], RF.[Cargo destinatario], ISNULL (RF.CollaborativeWorkName, '1') AS 'CollaborativeWorkName', RF.CollaborativeWorkBody FROM GETDATABYRADICATE_VW RF WHERE RF.Radicado = @Radicado
122	809484	6635	273139	4101944	SELECT FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fecha radicado' , RF.FileNumber AS 'Radicado' , RF.[Subject] AS 'Asunto' FROM [dbo].[REQUESTFILE_VW] RF INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = RF.ClientId WHERE C.NumberIdentification = @NIdentification ORDER BY Radicado DESC
1	609097	609097	2836686	130236165	SELECT * FROM dbo.V_RPTG_Radicados WHERE Radicado <> '0'
9	445763	49529	4598895	34690696	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
4	386675	96668	193170	6830538	WITH 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')
1051	382532	363	492530	18163971	select 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
1	382023	382023	171821	55112947	INSERT 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
1117	368874	330	496942	20263808	SELECT D.NAME AS 'Dependencia' , RF.FileNumber AS 'Radicado' , RF.FiledDate AS 'Fecha' , CONCAT(isnull(RF.Pages,0), 'F/', isnull(RF.Attachments,0), 'ADJ/', RF.ReceiverName, '/', RF.UserName) AS 'Concatenado' FROM RequestFiles RF WITH(NOLOCK) LEFT JOIN Dependencies D WITH(NOLOCK) ON D.ID=RF.DependencyId WHERE RF.FileNumber=@fileNumber
87	341604	3926	95478	2856409	SELECT FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fecha radicado' , RF.FileNumber AS 'Radicado' , RF.[Subject] AS 'Asunto' FROM [dbo].[REQUESTFILE_VW] RF INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = RF.ClientId WHERE C.NumberIdentification = @NIdentification ORDER BY Radicado DESC

Archivos SQL mÃ¡s pesados

DatabaseName	LogicalName	PhysicalName	FileType	SizeMB	MaxSizeMB	IsPercentGrowth
OpheliaSuite	OpheliaSuiteDMS	E:\SGDEA\OpheliaSuite.mdf	ROWS	4424582	-1	False
DMS	DMS	E:\SGDEA\DMS.mdf	ROWS	49903	-1	False
DMS	DMS_B	E:\SGDEA\DMS_B.ndf	ROWS	41418	-1	False
Stage	Stage_log	F:\LOG\Stage_log.ldf	LOG	34699	2097152	False
Drive	Drive	E:\SGDEA\Drive.mdf	ROWS	34484	-1	False
tempdb	temp6	D:\TEMPDB\temp6.mdf	ROWS	31071	-1	False
tempdb	temp7	D:\TEMPDB\temp7.mdf	ROWS	30755	-1	False
tempdb	temp5	D:\TEMPDB\temp5.mdf	ROWS	30735	-1	False
tempdb	temp10	D:\TEMPDB\temp10.mdf	ROWS	30709	-1	False
tempdb	temp8	D:\TEMPDB\temp8.mdf	ROWS	29267	-1	False
tempdb	temp9	D:\TEMPDB\temp9.mdf	ROWS	23991	-1	False
tempdb	temp4	D:\TEMPDB\temp4.mdf	ROWS	21358	-1	False
Stage	Stage	E:\SGDEA\Stage.mdf	ROWS	13321	-1	False
tempdb	temp11	D:\TEMPDB\temp11.mdf	ROWS	13169	-1	False
tempdb	tempdev	D:\TEMPDB\tempdev.mdf	ROWS	12644	-1	False
DMS_bk_040923	DMS	E:\SGDEA\DMS_bk_040923.mdf	ROWS	5000	-1	False
OpheliaSuite	OpheliaSuiteDMS_log	F:\LOG\OpheliaSuite_log.ldf	LOG	3979	2097152	False
DMS	DMS_log	F:\LOG\DMS_log.ldf	LOG	2187	2097152	False
DMS_BK_20	DMS	E:\SGDEA\DMS_BK_20.mdf	ROWS	2184	-1	False
AgoraSSB	Agora	E:\SGDEA\Agora.mdf	ROWS	436	-1	False

Errores recientes SQL

LogDate	ProcessInfo	Text
5/26/2026 4:09:53 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:53 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.150]
5/26/2026 4:09:53 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:53 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.171]
5/26/2026 4:09:53 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:53 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.151]
5/26/2026 4:09:52 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:52 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.153]
5/26/2026 4:09:30 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:30 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.150]
5/26/2026 4:09:30 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:30 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.151]
5/26/2026 4:09:29 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:29 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.153]
5/26/2026 4:09:23 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:23 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.171]
5/26/2026 4:09:16 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:16 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.150]
5/26/2026 4:09:15 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:15 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.151]
5/26/2026 4:09:15 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:09:15 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'DMS'. [CLIENT: 10.238.99.153]
5/26/2026 4:08:52 AM	Logon	Error: 18456, Severity: 14, State: 38.
5/26/2026 4:08:52 AM	Logon	Login failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'Drive'. [CLIENT: 10.238.99.150]
5/26/2026 4:08:52 AM	Server	The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SRVCLSGDEA.DigitalWare.com.co:SGDEAPRY ] for the SQL Server service. Windows return code: 0x2098, state: 20. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
5/26/2026 4:08:52 AM	Server	The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SRVCLSGDEA.DigitalWare.com.co:1633 ] for the SQL Server service. Windows return code: 0x2098, state: 20. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
5/26/2026 4:08:50 AM	Server	Registry startup parameters: -d E:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\master.mdf -e E:\DATA\MSSQL15.SGDEAPRY\MSSQL\Log\ERRORLOG -l E:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\mastlog.ldf
5/26/2026 4:08:50 AM	Server	Logging SQL Server messages in file 'E:\DATA\MSSQL15.SGDEAPRY\MSSQL\Log\ERRORLOG'.

Tareas Ophelia en cola por servidor (estado Q)

ServidorIP	Cantidad
10.238.99.150	20
10.238.99.151	4
10.238.99.153	28