DiagnÃ³stico SQL Server - DWSGDASQL2

Resumen Ejecutivo SQL

RAM libre8.9 GB

RAM total60 GB

CPU promedio29.16 %

Conexiones SQL3302

Disco promedio130652.14 %

Bloqueos activos3

Bases de datos20

Transacciones abiertas249

Tareas en cola (Q)46

Servidor SQL: SRVCLSGDEA\SGDEAPRY,1633

Host: DWSGDASQL2

Fecha: 05/26/2026 16:01:32

Alertas

Page Life Expectancy bajo (49 s)
Bloqueos activos: 3 sesiones bloqueadas
Conexiones totales altas: 3302
Tareas Ophelia en cola (estado Q): 46 - 10.238.99.150: 11 | 10.238.99.151: 4 | 10.238.99.153: 31
Transacciones abiertas detectadas: 249 (la mÃ¡s antigua lleva 26011 segundos)
Hay 28 entradas relevantes en el SQL Error Log

Recomendaciones

PLE bajo: revisa consultas con scans grandes, Ãndices faltantes o considera ampliar RAM.
Hay bloqueos activos. Revisa 'Bloqueos activos' y considera ajustar Ãndices, transacciones largas o nivel de aislamiento.
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	8.9

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.68	67.83
D:	TEMP	299.98	79.08	26.36
E:	DATA	5222.38	750.08	14.36
F:	LOG	299.98	245.94	81.98
G:	BACKUPS	499.98	321.91	64.38
Q:	New Volume	19.98	19.36	96.91
S:	Spool	299.98	288.17	96.06

Contadores de rendimiento - muestra 1 minuto

Counter	Min	Max	Average
\\dwsgdasql2\processor(_total)\% processor time	16.37	42.76	29.16
\\dwsgdasql2\memory\available mbytes	8902	9776	9248.75
\\dwsgdasql2\system\processor queue length	0	0	0
\\dwsgdasql2\physicaldisk(_total)\% disk time	72.32	506274.67	130652.14
\\dwsgdasql2\physicaldisk(_total)\current disk queue length	2	238	104.5

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	49	350398

Bases de datos

DatabaseName	State	RecoveryModel	CompatibilityLevel	SizeMB	CreateDate
OpheliaSuite	ONLINE	FULL	150	4432914	1/25/2023 11:42:38 AM
tempdb	ONLINE	SIMPLE	150	224378	5/26/2026 4:09:15 AM
DMS	ONLINE	FULL	150	93765	3/9/2024 11:45:05 PM
Stage	ONLINE	FULL	150	56149	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	1141
MicroSQL	DWSGDAAPP1	opheliadms	1065
MicroSQL	DWSGDAAPP1	ophelia	252
MicroSQL	DWSGDAAPP3	ophelia	247
MicroSQL	DWSGDAAPP2	opheliadms	145
MicroSQL	DWSGDAAPP2	ophelia	99
ODK	DWSGDAAPP3	ophelia	78
ODK	DWSGDAAPP1	ophelia	57
	DWSGDAAPP1	ophelia	24
Core Microsoft SqlClient Data Provider	DWSGDAAPP3	opheliadms	22
MicroSQL	DWSGDAMON2	ophelia	22
ODK	DWSGDAAPP2	ophelia	20
MicroSQL	DWSGDAAPP4	opheliadms	20
Core Microsoft SqlClient Data Provider	DWSGDAAPP1	opheliadms	19
.Net SqlClient Data Provider	FASECOLDAVM	monitoreosaas	10
	DWSGDAAPP2	ophelia	7
Core Microsoft SqlClient Data Provider	DWSGDAAPP2	opheliadms	7
Core Microsoft SqlClient Data Provider	DWSGDAAPP3	ophelia	6
Core Microsoft SqlClient Data Provider	DWSGDAAPP1	ophelia	6
	DWSGDAAPP3	ophelia	5
Core Microsoft SqlClient Data Provider	DWSGDAAPP2	ophelia	4
Core .Net SqlClient Data Provider	DWSGDAAPP3	ophelia	4
Core .Net SqlClient Data Provider	DWSGDAAPP3	Opheliasuitebi	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.5 (Microsoft Windows 10.0.17763 X64)	DWSGDAAPP3	ophelia	3
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)	DWSGDAAPP2	ophelia	3
Core Microsoft SqlClient Data Provider	DWSGDAMON2	opheliadms	3
Core .Net SqlClient Data Provider	DWSGDAAPP1	ophelia	3
Core Microsoft SqlClient Data Provider	DWSGDAAPP4	ophelia	2
Zabbix agent 2 MSSQL plugin	DWSGDASQL2	zbx_monitor	2
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
Core .Net SqlClient Data Provider	DWSGDAAPP1	Opheliasuitebi	1
Core .Net SqlClient Data Provider	DWSGDAAPP2	ophelia	1
.Net SqlClient Data Provider	DWSGDASQL2	ophelia	1
Microsoft SQL Server Management Studio - Consulta	DW-P10961	ophelia	1
Microsoft® Windows® Operating System	DWSGDASQL2	NT AUTHORITY\SYSTEM	1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)	DWSGDAAPP1	ophelia	1
MicroSQL	DWSGDAAPP3		1

Sesiones activas

session_id	login_name	host_name	program_name	status	command	wait_type	wait_time	cpu_time	logical_reads	DatabaseName
2995	Opheliasuitebi	DWSGDASQL1	Python	running	SELECT	CXCONSUMER	90459	20364	0	DMS
3000	DIGITALWARE\SCVSGDA-AGENT	SRVCLSGDEA	SQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 1)	running	INSERT	PAGEIOLATCH_SH	0	10089	791828	Stage
2806	ophelia	DWSGDASQL2	.Net SqlClient Data Provider	running	SELECT		0	19	25	master
56	NT AUTHORITY\SYSTEM	DWSGDASQL2	Microsoft® Windows® Operating System	running	EXECUTE	SP_SERVER_DIAGNOSTICS_SLEEP	49	3	85	master
2640		DWSGDAAPP3	MicroSQL	running	SELECT	ASYNC_NETWORK_IO	30	1	41	AgoraSSB
3369	ophelia	DWSGDAAPP1	MicroSQL	running	INSERT	LCK_M_X	25997	0	9	Drive
3232	ophelia	DWSGDAAPP3	MicroSQL	running	INSERT	LCK_M_X	22377	0	9	Drive
1214	ophelia	DWSGDAAPP3	MicroSQL	running	INSERT	LCK_M_X	25806	0	9	Drive

Bloqueos activos

BlockerSessionId	BlockedSessionId	wait_type	wait_time	DatabaseName	command	wait_resource
3369	1214	LCK_M_X	25831	Drive	INSERT	KEY: 17:72057594049134592 (f9fac8f40c5e)
3369	3232	LCK_M_X	22390	Drive	INSERT	KEY: 17:72057594049134592 (f9fac8f40c5e)
1730	3369	LCK_M_X	26010	Drive	INSERT	KEY: 17:72057594049134592 (f9fac8f40c5e)

Transacciones abiertas (> 5 seg)

SessionId	Host	Aplicacion	Usuario	InicioTransaccion	SegundosAbierta	TipoTransaccion	UltimaConsulta
403	DWSGDAAPP2		ophelia	5/26/2026 8:48:01 AM	26011	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	26010	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	26010	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	24136	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	23913	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	23895	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	23664	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	23587	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	23578	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	23425	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	23386	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	23358	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	23118	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	22991	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	22941	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	22941	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	22937	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	22656	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	22656	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	22613	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	22273	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	22063	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	21780	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	21749	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	21585	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	21465	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	21272	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	21180	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	21151	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	21085	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	20843	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	20843	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	20686	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	20621	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	20621	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	20597	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	20597	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	20498	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	20484	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	20391	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	20343	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	20333	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	20326	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	20179	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	20147	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	20112	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	19926	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	19875	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	19625	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	19587	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	19531	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	19480	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	19307	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	19298	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	19211	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	19211	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	19211	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	19211	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	19019	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	19019	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	18962	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	18864	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	18331	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	18331	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	18331	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	18330	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	18305	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	18097	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	18064	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	18064	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	18009	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	17999	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	17913	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	17524	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	17487	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	17353	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	17353	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	17301	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	17143	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	17097	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	16940	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	16940	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	16940	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	16781	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	16767	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	16681	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	16681	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	16672	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	16591	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	16411	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	16403	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	16398	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	16253	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	16253	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	16206	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	16052	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	15901	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	15864	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	15632	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	15604	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	15564	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	15546	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	15502	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	15455	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	15455	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	15455	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	15255	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	15083	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	15056	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	15056	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	14958	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	14860	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	14860	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	14795	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	14681	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	14681	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	14652	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	14299	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	14228	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	14122	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	14049	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	14049	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	14049	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	14045	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	13934	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	13934	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	13864	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	13762	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	13762	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	13609	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	13141	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	13141	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	12623	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	12415	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	12153	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	12153	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	12026	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	11604	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	11604	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	11263	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	11203	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	11055	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	11054	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	11018	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	10805	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	10683	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	10683	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	10329	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	9588	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	9337	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	9302	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	9200	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	8989	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	8949	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	8847	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	8847	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	8847	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	8847	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	8829	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	8739	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	8696	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	8659	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	8482	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	8365	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	8364	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	8202	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	8202	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	7911	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	7746	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	7666	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)
2291	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:07:13 PM	6859	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)
1942	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:09:52 PM	6700	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)
2620	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 2:12:02 PM	6570	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)
2622	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 2:13:05 PM	6507	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)
836	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:16:58 PM	6274	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)
2779	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:20:51 PM	6041	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)
824	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:20:51 PM	6041	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)
2543	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:21:16 PM	6016	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)
3177	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:24:37 PM	5815	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)
2784	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:29:24 PM	5528	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)
2391	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 2:29:30 PM	5522	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)
3212	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:29:38 PM	5514	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)
2691	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:30:29 PM	5463	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)
2693	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 2:30:35 PM	5457	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)
1921	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:30:35 PM	5457	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)
2763	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:30:36 PM	5456	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)
2541	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:31:08 PM	5424	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)
2109	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:32:22 PM	5350	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)
2245	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:33:25 PM	5287	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)
3042	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 2:33:32 PM	5280	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)
2993	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:34:19 PM	5233	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)
2131	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 2:35:39 PM	5153	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)
3229	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:36:29 PM	5103	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)
2416	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 2:41:35 PM	4797	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)
2103	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:42:52 PM	4720	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)
3337	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:42:52 PM	4720	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)
1611	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:42:52 PM	4720	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)
3334	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:42:52 PM	4720	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)
1170	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:42:52 PM	4720	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)
3266	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:43:09 PM	4703	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)
1590	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:43:29 PM	4683	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)
2042	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:44:19 PM	4633	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)
2698	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:44:29 PM	4623	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)
2759	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:45:07 PM	4585	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)
55	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 2:45:10 PM	4582	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)
881	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:45:10 PM	4582	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)
1822	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:46:12 PM	4520	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)
269	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 2:47:18 PM	4454	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)
3330	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:47:33 PM	4439	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)
2472	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:49:37 PM	4315	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)
3097	DWSGDAAPP2	MicroSQL	ophelia	5/26/2026 2:50:42 PM	4250	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)
1398	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 2:50:47 PM	4245	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)
2720	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:52:53 PM	4119	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)
3376	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 2:58:59 PM	3753	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)
167	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:00:00 PM	3692	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)
2411	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:00:33 PM	3659	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)
3303	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:05:45 PM	3347	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)
2739	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:08:22 PM	3190	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)
2678	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:08:24 PM	3188	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)
831	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:08:31 PM	3181	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)
2732	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:09:56 PM	3096	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)
3164	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:10:49 PM	3043	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)
3409	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:13:23 PM	2889	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)
2397	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:13:56 PM	2856	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)
3354	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:27:55 PM	2017	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)
3378	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:28:02 PM	2010	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)
3016	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:34:23 PM	1629	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)
1390	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:35:29 PM	1563	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)
2130	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:37:24 PM	1448	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)
902	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:39:43 PM	1309	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)
3249	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:41:07 PM	1225	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)
1946	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:41:35 PM	1197	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)
3223	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:43:17 PM	1095	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)
2544	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:44:26 PM	1026	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)
2900	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:46:18 PM	914	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)
2199	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:46:44 PM	888	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)
3377	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:47:14 PM	858	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)
3391	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 3:47:50 PM	822	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)
2725	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:53:48 PM	464	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)
2562	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 3:56:32 PM	300	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)
2995	DWSGDASQL1	Python	Opheliasuitebi	5/26/2026 4:00:00 PM	92	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
3000	SRVCLSGDEA	SQLAgent - TSQL JobStep (Job 0xEE83636B927D094E85469C764C60119E : Step 1)	DIGITALWARE\SCVSGDA-AGENT	5/26/2026 4:00:03 PM	89	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
1730	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 4:00:51 PM	41	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)
3369	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 4:00:52 PM	40	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)
1214	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 4:00:52 PM	40	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)
3232	DWSGDAAPP3	MicroSQL	ophelia	5/26/2026 4:00:53 PM	39	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)
3067	DWSGDAAPP2	Core Microsoft SqlClient Data Provider	opheliadms	5/26/2026 4:01:18 PM	14	Read/Write	(@__Parse_0 uniqueidentifier)SELECT [t].[Id], [t].[Code], [t].[Description], [t].[Detail], [t].[Name], [t].[ParentId], [t].[TypeHeadId] FROM [TypeDetail] AS [t] WHERE [t].[Id] = @__Parse_0
2865	DWSGDAAPP1	MicroSQL	ophelia	5/26/2026 4:01:18 PM	14	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)
1088	DWSGDAAPP3	Core Microsoft SqlClient Data Provider	opheliadms	5/26/2026 4:01:24 PM	8	Read/Write	(@__Parse_0 uniqueidentifier)SELECT [t].[Id], [t].[Code], [t].[Description], [t].[Detail], [t].[Name], [t].[ParentId], [t].[TypeHeadId] FROM [TypeDetail] AS [t] WHERE [t].[Id] = @__Parse_0

Wait Stats

wait_type	waiting_tasks_count	wait_time_ms	AvgWaitMs	signal_wait_time_ms
SOS_WORK_DISPATCHER	9236541	8017919110	868.00	8587973
CXPACKET	23771091	318243790	13.00	6991071
CXCONSUMER	39790534	215178354	5.00	18525964
PAGEIOLATCH_SH	6196575	103186421	16.00	961530
PAGEIOLATCH_EX	1152329	35638900	30.00	131666
ASYNC_NETWORK_IO	1159076	20712485	17.00	704484
SOS_SCHEDULER_YIELD	13743185	19865628	1.00	19838291
BPSORT	2475017	8793703	3.00	1358825
LATCH_EX	1840538	6509505	3.00	1069926
BACKUPBUFFER	1254595	6268654	4.00	166444
IO_COMPLETION	733142	5553440	7.00	58012
LCK_M_X	840	5060730	6024.00	1034
LCK_M_IS	168	3438354	20466.00	86
WRITELOG	374914	3127829	8.00	287285
BACKUPIO	330301	2403042	7.00	31856
ASYNC_IO_COMPLETION	87	2205520	25350.00	35
LCK_M_IX	463	2122402	4584.00	441
HTDELETE	198691	1491539	7.00	96634
RESERVED_MEMORY_ALLOCATION_EXT	654423450	1454956	0.00	0
LCK_M_SCH_M	136	1300808	9564.00	101

Top Queries CPU

Executions	CPUTimeMs	AvgCPUMs	ElapsedMs	LogicalReads	QueryText
4	3346723	836680	1114244	3211569	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
10527	2721800	258	3886439	121913648	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
911	2233412	2451	799961	46229336	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
1	1990894	1990894	411556	16858760	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
452	1951442	4317	744066	37378898	SELECT DISTINCT RF.IdRadicado, RF.Radicado, RF.Fecha, CN.[Name] AS 'Canal', RF.[Tipo de persona], TD.Name AS 'Tipo de identificación', CL.NumberIdentification AS 'Número de identificación', RF.Entidad, RF.Destinatario AS 'Nombres y apellidos remitente', CL.Id AS 'Id Cliente', CT.Id AS 'Id Contacto', RF.País, RF.Departamento, RF.Ciudad, RF.Dirección, RF.[Correo electrónico], RF.Asunto, RF.Folios, RFD.Attachments AS 'Número de anexos', RF.[Descripción de anexos], RF.Compañía, RF.Dependencia, CONCAT(DP.NameSolicitud, ' / ', LTRIM(RTRIM(DP.NameDetalle)), IIF(ISNULL(DP.NameEspecificacion, '0') = '0', NULL, ' / '), DP.NameEspecificacion) AS 'Trámite', RFD.UserName AS 'Usuario Radicador', RF.FuncionarioResponsable 'Responsable', 'https://tinyurl.com/5e6yz5u9' AS QR FROM GETDATABYRADICATE_VW RF INNER JOIN REQUESTFILE_VW RFD ON RFD.Id = RF.IdRadicado INNER JOIN CANAL_VW CN ON CN.Id = RFD.ChannelId INNER JOIN CLIENTS_VW CL ON CL.Id = RFD.ClientId INNER JOIN CONTACTS_VW CT ON CT.Id = RFD.ContactId INNER JOIN TypeDetail TD ON TD.Id = CL.DocumentTypeId INNER JOIN DMSProcedureNew_VW DP ON RFD.ProcedureId = DP.IdProcedure WHERE RF.Radicado = @Radicado
2627	1552188	590	2819261	45805216	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
2628	1544196	587	1995714	45410703	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) )
72	1440489	20006	374552	54197695	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
11086416	1244599	0	1325306	61918290	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 )
248	1192367	4807	403070	8172016	SELECT TD1.Name AS 'Origen', rf.FileNumber as 'Radicado', FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fradicacion', FORMAT(RF.ExperationDate, 'dd-MM-yyyy') AS 'Fvencimiento', CASE WHEN CAST(RF.ExperationDate AS DATE) > CAST(GETDATE() AS DATE) THEN 'Verde' ELSE 'Rojo' END AS 'ColorVencimiento', PR.Name AS 'Precepcion', (RA.Name + ' '+RA.Surnames) AS 'Radicador', TP.Name AS 'Tpersona', TD.Name AS 'Tident', CL.NumberIdentification AS 'Identificacion', ISNULL (CT.BusinessName, CL.BusinessName) AS 'Empresa', ISNULL (CT.Names, CL.NamesClients) AS 'Nombres', ISNULL (CT.SurNames, CL.SurNames) AS 'Apellidos', SX.Name AS 'Sexo', ISNULL (CONVERT (VARCHAR, CL.LGBTIQCommunity), '0') AS 'LGTBI', CE.Name AS 'Cespecial', ISNULL (CONVERT (VARCHAR, CL.AffiliatedFomag), '0') AS 'Afiliado', TA.Name AS 'Tafiliado', IR.Name AS 'Irecepcion', PA.Description AS 'Pais', DE.Description AS 'Departamento', CI.Description AS 'Ciudad', BA.Description AS 'Barrio', CT.Address AS 'Direccion', CT.PostalCode AS 'Postal', ISNULL (CT.Telephone, CL.Phone) AS 'Tel', ISNULL (CT.Mobile, CL.Mobile) AS 'Celular', ISNULL (CT.Email, CL.Email) AS 'Correo', AP.Names AS 'NApoderado', AP.Telephone AS 'TelApoderado', AP.Mobile AS 'CelApoderado', AP.Email AS 'CorreoApoderado', PAA.Description AS 'PaisApoderado', DEA.Description AS 'DepartamentoApoderado', CIA.Description AS 'CiudadApoderado', BAA.Description AS 'BarrioApoderado', AP.Address AS 'DirApoderado', AP.AddressOfficeAttorney AS 'DirOfiApoderado', TPQR.Name AS 'TIPOPQR', (TRA.NameSolicitud + ' / '+ TRA.NameDetalle + ' / ' + TRA.NameEspecificacion) AS 'Tramite', TRA.RESPONSETIME AS 'DiasGestón', D1.Name AS 'DependenciaResponsable', (US1.Name + ' '+US1.Surnames) AS 'Responsable', RF.Subject AS 'Asunto', RF.MessageBody AS 'Observaciones', FORMAT(RF.DocumentDate, 'dd-MM-yyyy') AS 'FechaDoc', RF.Pages AS 'Folios', RF.Attachments AS 'Anexos', TAX.Name AS 'TAnexo', RF.AttachDescription AS 'DAnexos', RF.CourrierName AS 'Courrier', RF.CourrierNumber AS 'Guia', RF.Location AS 'Location' FROM RequestFiles RF WITH (NOLOCK) INNER JOIN TypeDetail TD1 WITH (NOLOCK) ON TD1.Id=RF.OriginId INNER JOIN Users RA WITH (NOLOCK) ON RA.UserName=RF.UserName LEFT JOIN Representatives AP WITH (NOLOCK) ON AP.Id=RF.RepresentativeId LEFT JOIN TypeDetail PR WITH (NOLOCK) ON PR.Id=RF.ChannelId LEFT JOIN CLIENTS_VW CL WITH (NOLOCK) ON CL.Id = RF.ClientId LEFT JOIN Contacts CT WITH (NOLOCK) ON CT.Id = RF.ContactId LEFT JOIN TypeDetail TP WITH (NOLOCK) ON TP.Id = CL.PersonTypeId LEFT JOIN TypeDetail TD WITH (NOLOCK) ON TD.Id = CL.DocumentTypeId LEFT JOIN TypeDetail SX WITH (NOLOCK) ON SX.Id = CL.GenderId LEFT JOIN TypeDetail CE WITH (NOLOCK) ON CE.Id = CL.SpecialConditionId LEFT JOIN TypeDetail TA WITH (NOLOCK) ON TA.Id = CL.AffiliateTypeId LEFT JOIN TypeDetail IR WITH (NOLOCK) ON IR.Id = RF.ReceivingInstanceId LEFT JOIN GeographicsLocation PA WITH (NOLOCK) ON PA.Id = CT.CountryId LEFT JOIN GeographicsLocation DE WITH (NOLOCK) ON DE.Id = CT.DepartamentId LEFT JOIN GeographicsLocation CI WITH (NOLOCK) ON CI.Id = CT.CityId LEFT JOIN GeographicsLocation BA WITH (NOLOCK) ON BA.Id = CT.NeighBorhoodId LEFT JOIN GeographicsLocation PAA WITH (NOLOCK) ON PAA.Id = AP.CountryId LEFT JOIN GeographicsLocation DEA WITH (NOLOCK) ON DEA.Id = AP.DepartamentId LEFT JOIN GeographicsLocation CIA WITH (NOLOCK) ON CIA.Id = AP.CityId LEFT JOIN GeographicsLocation BAA WITH (NOLOCK) ON BAA.Id = AP.NeighBorhoodId LEFT JOIN TypeDetail TPQR WITH (NOLOCK) ON TPQR.Id = RF.PqrsTypeId INNER JOIN DMSProcedureNew_VW TRA WITH (NOLOCK) ON TRA.IdProcedure=RF.ProcedureId LEFT JOIN Dependencies D1 WITH (NOLOCK) ON D1.ID =TRA.IdDependencia LEFT JOIN USERS US1 WITH (NOLOCK) ON US1.ID= TRA.IdUsuario LEFT JOIN TypeDetail TAX WITH (NOLOCK) ON TAX.Id = RF.AttachmentTypeId LEFT JOIN Dependencies D WITH (NOLOCK) ON D.Id=RF.DependencyId WHERE RF.FileNumber= @RadicadoEntrada
1	1058024	1058024	296922	19797976	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
13983	1049197	75	1371018	124881432	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	907652	907652	471429	93458715	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')
1670	605563	362	804271	28867288	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
87	550613	6328	201670	5755837	SELECT DISTINCT RF.FiledDate AS 'FechaRadicacion', RF.ExperationDate AS 'Fvencimiento', RF.UserName AS 'Radicador', CONVERT(VARCHAR, RF.ReportedSmart) AS 'ReportedSmart2', RF.ComplaintOrigin AS 'OrigenSmart', IIF(PR.Code IS NULL, NULL, CONCAT(PR.Code, '\|', PR.[Name])) AS 'Precepción', -- PUNTO DE RECEPCION IIF(TP.Code IS NULL, NULL, CONCAT(TP.Code, '\|', TP.[Name])) AS 'Tpersona', IIF(TD.Code IS NULL, NULL, CONCAT(TD.Code, '\|', TD.[Name])) AS 'Tident', CL.NumberIdentification AS 'Identificacion', CT.BusinessName AS 'Empresa', CT.Names AS 'Nombres', CL.SurNames AS 'Apellidos', IIF(SX.Code IS NULL, NULL, CONCAT(SX.Code, '\|', SX.[Name])) AS 'Sexo', IIF(CL.LGBTIQCommunity IS NULL, 'false', IIF(CONVERT(VARCHAR(10), CL.LGBTIQCommunity) = '1', 'true', 'false')) AS 'LGTBI', IIF(CE.Code IS NULL, NULL, CONCAT(CE.Code, '\|', CE.[Name])) AS 'Cespecial', IIF(CL.AffiliatedFomag IS NULL, '2', IIF(CONVERT(VARCHAR(10), CL.AffiliatedFomag) = '0', '2', '1')) AS 'Afiliado', IIF(TA.Code IS NULL, NULL, CONCAT(TA.Code, '\|', TA.[Name])) AS 'Tafiliado', IIF(IR.Code IS NULL, NULL, CONCAT(IR.Code, '\|', IR.[Name])) AS 'Irecepcion', IIF(PA.IataCode IS NULL, NULL, CONCAT(PA.IataCode, '\|', PA.[Description])) AS 'Pais', IIF(DE.IataCode IS NULL, NULL, CONCAT(DE.IataCode, '\|', DE.[Description])) AS 'Departamento', IIF(CI.IataCode IS NULL, NULL, CONCAT(CI.IataCode, '\|', CI.[Description])) AS 'Ciudad', IIF(BA.IataCode IS NULL, NULL, CONCAT(BA.IataCode, '\|', BA.[Description])) AS 'Barrio', CT.[Address] AS 'Direccion', CT.PostalCode AS 'Postal', ISNULL(CT.Telephone, CL.Phone) AS 'Tel', ISNULL(CT.Mobile, CL.Mobile) AS 'Celular', ISNULL(CT.Email, CL.Email) AS 'Correo', APVC.NumberIdentification AS 'IdentificacionApoderado', IIF(APTP.Code IS NULL, NULL, CONCAT(APTP.Code, '\|', APTP.[Name])) AS 'TipoApoderado', AP.Names AS 'NombreCompletoApoderado', IIF(PAA.IataCode IS NULL, NULL, CONCAT(PAA.IataCode, '\|', PAA.[Description])) AS 'PaisApo', IIF(DEA.IataCode IS NULL, NULL, CONCAT(DEA.IataCode, '\|', DEA.[Description])) AS 'DepartamentoApo', IIF(CIA.IataCode IS NULL, NULL, CONCAT(CIA.IataCode, '\|', CIA.[Description])) AS 'CiudadApo', IIF(BAA.IataCode IS NULL, NULL, CONCAT(BAA.IataCode, '\|', BAA.[Description])) AS 'BarrioApo', AP.[Address] AS 'DireccionResiApo', AP.AddressOfficeAttorney AS 'DireccionOfiApo', AP.Telephone AS 'TelApo', AP.Mobile AS 'CelApo', AP.Email AS 'CorreoApo', IIF(TPQR.Code IS NULL, NULL, CONCAT(TPQR.Code, '\|', TPQR.[Name])) AS 'TIPOPQR', IIF(RF.ProcedureId IS NULL, NULL, CONCAT(RF.ProcedureId , '\|', [NameSolicitud], ' / ', [NameDetalle], ' / ', [NameEspecificacion])) AS 'Tramite', RF.ResponseTime AS 'DiasGestion', IIF(DP.Code IS NULL, NULL, CONCAT(DP.Code, '\|', DP.[Name])) AS 'Dependencia', CONCAT(SDE.[Responsible_UserName], '\|', SDE.[Responsable_Funcionario]) AS 'FunionarioResponsable', RF.[Subject] AS 'Asunto', RF.MessageBody AS 'Observaciones', RF.DocumentDate AS 'FechaDoc', RF.Pages AS 'Folios', RF.Attachments AS 'Anexos', TAX.Code AS 'TAnexo', RF.AttachDescription AS 'DAnexos', RF.CourrierName AS 'Courrier', RF.CourrierNumber AS 'Guia', RF.[Location] AS 'Location', IIF(RFH.Id IS NOT NULL, '1', '0') AS 'Reclasificado' FROM [dbo].[RequestFiles] RF WITH (NOLOCK) LEFT JOIN [dbo].[DEPENDENCIE_VW] DP WITH (NOLOCK) ON RF.DependencyId = DP.Id LEFT JOIN [dbo].[DMSProcedureNew_VW] SDE WITH (NOLOCK) ON RF.ProcedureId = SDE.IdProcedure LEFT JOIN [dbo].TypeDetail PR WITH (NOLOCK) ON PR.Id = RF.ChannelId LEFT JOIN [dbo].[CLIENTS_VW] CL WITH (NOLOCK) ON CL.Id = RF.ClientId LEFT JOIN [dbo].[CONTACTS_VW] CT WITH (NOLOCK) ON CT.Id = RF.ContactId LEFT JOIN [dbo].TypeDetail TP WITH (NOLOCK) ON TP.Id = CL.PersonTypeId LEFT JOIN [dbo].[TYPEIDENTI_VW] TD WITH (NOLOCK) ON TD.Id = CL.DocumentTypeId LEFT JOIN [dbo].[TYPEGENDER_VW] SX WITH (NOLOCK) ON SX.Id = CL.GenderId LEFT JOIN [dbo].TypeDetail CE WITH (NOLOCK) ON CE.Id = CL.SpecialConditionId LEFT JOIN [dbo].TypeDetail TA WITH (NOLOCK) ON TA.Id = CL.AffiliateTypeId LEFT JOIN [dbo].TypeDetail IR WITH (NOLOCK) ON IR.Id = RF.ReceivingInstanceId LEFT JOIN [dbo].[GEOGRAPHICSLOCATIOPAIS_VW] PA WITH (NOLOCK) ON PA.Id = CT.CountryId LEFT JOIN [dbo].[GEOGRAPHICSLOCATIODEP_VW] DE WITH (NOLOCK) ON DE.Id = CT.DepartamentId LEFT JOIN [dbo].[GEOGRAPHICSLOCATIONMUN_VW] CI WITH (NOLOCK) ON CI.Id = CT.CityId LEFT JOIN [dbo].[GEOGRAPHICSLOCATIOBARRIO_VW] BA WITH (NOLOCK) ON BA.Id = CT.NeighBorhoodId LEFT JOIN [dbo].Representatives AP WITH (NOLOCK) ON AP.Id = RF.RepresentativeId LEFT JOIN [dbo].[CLIENTS_VW] APVC WITH (NOLOCK) ON AP.ClientId = APVC.Id LEFT JOIN [dbo].[TYPEPERSON_VW] APTP WITH (NOLOCK) ON AP.TypeRepresentativeId = APTP.Id LEFT JOIN [dbo].[TYPEIDENTI_VW] TDA WITH (NOLOCK) ON TDA.Id = AP.DocumentTypeId LEFT JOIN [dbo].[GEOGRAPHICSLOCATIOPAIS_VW] PAA WITH (NOLOCK) ON PAA.Id = AP.CountryId LEFT JOIN [dbo].[GEOGRAPHICSLOCATIODEP_VW] DEA WITH (NOLOCK) ON DEA.Id = AP.DepartamentId LEFT JOIN [dbo].[GEOGRAPHICSLOCATIONMUN_VW] CIA WITH (NOLOCK) ON CIA.Id = AP.CityId LEFT JOIN [dbo].[GEOGRAPHICSLOCATIOBARRIO_VW] BAA WITH (NOLOCK) ON BAA.Id = AP.NeighBorhoodId LEFT JOIN [dbo].[TYPEPQRSD_VW] TPQR WITH (NOLOCK) ON TPQR.Id = RF.PqrsTypeId LEFT JOIN [dbo].TypeDetail TAX WITH (NOLOCK) ON TAX.Id = RF.AttachmentTypeId LEFT JOIN [dbo].[RequestFileHistories] RFH ON RF.Id = RFH.RequestFileId AND RFH.[Status] IN ('A50A8C7E-C6C9-432A-B104-45BDC9AC0172','AFAB971F-C0F8-4707-84C9-F8F3E9B1CF7E') WHERE RF.FileNumber = @NoRadicado
11	544031	49457	4966698	42403657	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
1592	512214	321	708167	28889353	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
1	408921	408921	179127	54111699	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
6	391844	65307	341383	13985243	SELECT DISTINCT RequestFiles.Id RequestFileId ,RequestFileIdParent ,CASE WHEN Status='914f4fcc-627c-49b0-8c67-75a21f826d31' THEN '1' --Finalizado --WHEN Status='7AD94AE5-6D29-4EC0-B846-2664C88A7D45' THEN '2' --Getión y Tramite --ELSE NULL END ResponseText ELSE '2' END ResponseText --18/10/2024 Se realiza ajuste de acuerdo a los diferentes posibles status que puede tener un radicado, se valida con Julio INTO #RADICADOSTEMP_ FROM RequestFiles INNER JOIN ( SELECT RequestFileId RequestFileIdParent --,REPLACE(RIGHT(RequestFileHistories.Reason, CHARINDEX(' ', REVERSE(RequestFileHistories.Reason)) - 1),'radicado','') AS reason ,CASE WHEN CHARINDEX(' ', RequestFileHistories.Reason) > 0 THEN REPLACE( REVERSE( SUBSTRING( REVERSE(RequestFileHistories.Reason), 1, CHARINDEX(' ', REVERSE(RequestFileHistories.Reason)) - 1 ) ), 'radicado', '' ) ELSE REPLACE(RequestFileHistories.Reason, 'radicado', '') END AS reason ,Status FROM RequestFileHistories INNER JOIN RequestFiles ON RequestFiles.ID=RequestFileHistories.RequestFileId AND OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' --AND CONVERT(DATE,RequestFileHistories.CreationDate) =CONVERT(DATE,GETDATE()) WHERE RequestFileHistories.Reason LIKE '%Se envía respuesta%' OR RequestFileHistories.Reason LIKE '%Se enviÃ³ respuesta%' --and RequestFileId='D1D39553-523A-4B4F-87F0-BD80A20B6A6A' --AND --where --RequestFiles.FileNumber='20231012303362' --)RADICADOS ON RADICADOS.Reason=RequestFiles.FileNumber --WHERE RequestFileId='B90E3FB9-304F-41C4-B124-251A6BC8B62F' )RADICADOS ON RADICADOS.reason=RequestFiles.FileNumber
1062	380698	358	470244	18355547	SELECT (U.Name + ' ' + U.SURNAMES) AS 'FUNCIONARIO', CC.FullName AS 'NOMBRES', CC.position AS 'CARGO', CASE WHEN CC.ENTITY = 'undefined' THEN NULL ELSE CC.ENTITY END AS 'ENTITY', RF.Filenumber FROM CopiesCommunication CC INNER JOIN RequestFiles RF ON RF.Id = CC.REQUESTFILEID LEFT JOIN Users U ON U.Id = CC.SERVANT WHERE RF.FileNumber = @radicado

Archivos SQL mÃ¡s pesados

DatabaseName	LogicalName	PhysicalName	FileType	SizeMB	MaxSizeMB	IsPercentGrowth
OpheliaSuite	OpheliaSuiteDMS	E:\SGDEA\OpheliaSuite.mdf	ROWS	4426566	-1	False
DMS	DMS	E:\SGDEA\DMS.mdf	ROWS	49903	-1	False
Stage	Stage_log	F:\LOG\Stage_log.ldf	LOG	42827	2097152	False
DMS	DMS_B	E:\SGDEA\DMS_B.ndf	ROWS	41418	-1	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
OpheliaSuite	OpheliaSuiteDMS_log	F:\LOG\OpheliaSuite_log.ldf	LOG	6347	2097152	False
DMS_bk_040923	DMS	E:\SGDEA\DMS_bk_040923.mdf	ROWS	5000	-1	False
DMS	DMS_log	F:\LOG\DMS_log.ldf	LOG	2443	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	11
10.238.99.151	4
10.238.99.153	31