No hay datos.
| SessionId | Host | Aplicacion | Usuario | InicioTransaccion | SegundosAbierta | TipoTransaccion | UltimaConsulta |
|---|
| 65 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 7:08:16 AM | 10384 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 369 | DWSGDAAPP1 | MicroSQL | ophelia | 6/2/2026 7:36:48 AM | 8672 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 111 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 8:06:38 AM | 6882 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 628 | DWSGDAAPP3 | MicroSQL | ophelia | 6/2/2026 8:12:11 AM | 6549 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 719 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 8:12:11 AM | 6549 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 587 | DWSGDAAPP3 | MicroSQL | ophelia | 6/2/2026 8:21:22 AM | 5998 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 422 | DWSGDAAPP3 | MicroSQL | ophelia | 6/2/2026 8:25:44 AM | 5736 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 671 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 8:28:06 AM | 5594 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 543 | DWSGDAAPP1 | MicroSQL | ophelia | 6/2/2026 8:31:16 AM | 5404 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 440 | DWSGDAAPP1 | MicroSQL | ophelia | 6/2/2026 8:34:26 AM | 5214 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 432 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 8:37:01 AM | 5059 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 215 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 8:37:01 AM | 5059 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 580 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 8:40:21 AM | 4859 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 646 | DWSGDAAPP3 | MicroSQL | ophelia | 6/2/2026 8:47:46 AM | 4414 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 569 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 8:49:58 AM | 4282 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 298 | DWSGDAAPP1 | MicroSQL | ophelia | 6/2/2026 8:49:58 AM | 4282 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 560 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 8:50:54 AM | 4226 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 655 | DWSGDAAPP1 | MicroSQL | ophelia | 6/2/2026 8:54:30 AM | 4010 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 637 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 8:54:30 AM | 4010 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 408 | DWSGDAAPP3 | MicroSQL | ophelia | 6/2/2026 8:55:16 AM | 3964 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 297 | DWSGDAAPP3 | MicroSQL | ophelia | 6/2/2026 8:58:55 AM | 3745 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 703 | DWSGDAAPP1 | MicroSQL | ophelia | 6/2/2026 9:04:38 AM | 3402 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 545 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 9:04:38 AM | 3402 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 187 | DWSGDAAPP1 | MicroSQL | ophelia | 6/2/2026 9:11:57 AM | 2963 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 58 | DWSGDAAPP3 | MicroSQL | ophelia | 6/2/2026 9:15:34 AM | 2746 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 547 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 9:20:29 AM | 2451 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 563 | DWSGDAAPP1 | MicroSQL | ophelia | 6/2/2026 9:23:47 AM | 2253 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 722 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 9:24:53 AM | 2187 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 1289 | DWSGDAAPP3 | MicroSQL | ophelia | 6/2/2026 9:33:01 AM | 1699 | 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) |
| 741 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 9:33:01 AM | 1699 | 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) |
| 1211 | DWSGDAAPP1 | MicroSQL | ophelia | 6/2/2026 9:33:38 AM | 1662 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 706 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 9:42:42 AM | 1118 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 972 | DWSGDAAPP1 | MicroSQL | ophelia | 6/2/2026 9:42:42 AM | 1118 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 870 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 9:51:16 AM | 604 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| 473 | DWSGDAAPP2 | MicroSQL | ophelia | 6/2/2026 9:55:46 AM | 334 | Read/Write | (@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10) |
| Executions | CPUTimeMs | AvgCPUMs | ElapsedMs | LogicalReads | QueryText |
|---|
| 46 | 3738013 | 81261 | 3906992 | 50877181 | MERGE RequestFiles AS TGT
USING #RADICADOSTEMP2 AS SRC
ON TGT.id=SRC.RequestFileId
WHEN MATCHED THEN
UPDATE SET TGT.ResposnseText=SRC.ResponseText; |
| 169 | 3411546 | 20186 | 932292 | 132841269 | 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 |
| 46 | 3235811 | 70343 | 7620644 | 106269275 | 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 |
| 8 | 1499912 | 187489 | 501773 | 51710124 | WITH CTE AS (
SELECT
[Tipo Comunicacion] AS 'Tipo de comunicación',
R.Radicado,
[Fecha y Hora Radicacion],
WF.FLU_CONT AS 'Proceso',
CASE
WHEN WF.SEG_ESTE = 'E' THEN 'Ejecutada'
WHEN WF.SEG_ESTE = 'P' THEN 'Pendiente'
WHEN WF.SEG_ESTE = 'C' THEN 'Cancelada'
ELSE WF.SEG_ESTE
END AS 'Estado de la tarea',
WF.SEG_SUBJ AS 'Asunto',
TD.Name AS 'Estado del radicado',
RF.Massiveconsecutive AS 'Consecutivo masiva',
RF.CaseId AS 'Caso',
ROW_NUMBER() OVER (
PARTITION BY RF.Filenumber
ORDER BY
CASE
WHEN WF.SEG_ESTE = 'P' THEN 0
ELSE 1
END,
WF.AUD_UFAC DESC
) AS RN
FROM RadicacionVentUnica R
INNER JOIN DMS.dbo.RequestFiles RF ON R.RequestFilesId = RF.Id
INNER JOIN DMS.dbo.TypeDetail TD ON TD.Id = RF.StatusId AND TD.Id = '4E0AFDA4-7C90-4922-B590-53738FA95819'
INNER JOIN OpheliaSuite.dbo.WF_SEGUI WF ON WF.CAS_CONT = RF.CaseId
WHERE PROCESO = 'Radicado de entrada'
AND RADICADO NOT IN (
'20260320552732',
'20260320635702'
)
)
SELECT *
FROM CTE
WHERE RN = 1
ORDER BY [Fecha y Hora Radicacion] DESC |
| 2889 | 1395552 | 483 | 1945584 | 47641452 | WITH profiled_sessions as (
SELECT DISTINCT session_id profiled_session_id from sys.dm_exec_query_profiles
)
SELECT
[Session ID] = s.session_id,
[User Process] = CONVERT(CHAR(1), s.is_user_process),
[Login] = s.login_name,
[Database] = CASE WHEN s.database_id=0 THEN N'' ELSE ISNULL(db_name(s.database_id),N'') END,
[Task State] = ISNULL(t.task_state, N''),
[Command] = ISNULL(r.command, N''),
[Application] = ISNULL(s.program_name, N''),
[Wait Time (ms)] = ISNULL(w.wait_duration_ms, 0),
[Wait Type] = ISNULL(w.wait_type, N''),
[Wait Resource] = ISNULL(w.resource_description, N''),
[Blocked By] = ISNULL(CONVERT (varchar, w.blocking_session_id), ''),
[Head Blocker] =
CASE
-- session has an active request, is blocked, but is blocking others or session is idle but has an open tran and is blocking others
WHEN r2.session_id IS NOT NULL AND (r.blocking_session_id = 0 OR r.session_id IS NULL) THEN '1'
-- session is either not blocking someone, or is blocking someone but is blocked by another party
ELSE ''
END,
[Total CPU (ms)] = s.cpu_time,
[Total Physical I/O (MB)] = (s.reads + s.writes) * 8 / 1024,
[Memory Use (KB)] = s.memory_usage * (8192 / 1024),
[Open Transactions] = ISNULL(r.open_transaction_count,0),
[Login Time] = s.login_time,
[Last Request Start Time] = s.last_request_start_time,
[Host Name] = ISNULL(s.host_name, N''),
[Net Address] = ISNULL(c.client_net_address, N''),
[Execution Context ID] = ISNULL(t.exec_context_id, 0),
[Request ID] = ISNULL(r.request_id, 0),
[Workload Group] = ISNULL(g.name, N''),
[Profiled Session Id] = profiled_session_id
FROM sys.dm_exec_sessions s LEFT OUTER JOIN sys.dm_exec_connections c ON (s.session_id = c.session_id)
LEFT OUTER JOIN sys.dm_exec_requests r ON (s.session_id = r.session_id)
LEFT OUTER JOIN sys.dm_os_tasks t ON (r.session_id = t.session_id AND r.request_id = t.request_id)
OUTER APPLY
(
-- In some cases (e.g. parallel queries, also waiting for a worker), one thread can be flagged as
-- waiting for several different threads. This will cause that thread to show up in multiple rows
-- in our grid, which we don't want.
SELECT TOP 1 *
FROM sys.dm_os_waiting_tasks wt
WHERE wt.waiting_task_address = t.task_address
ORDER BY wt.wait_duration_ms desc
) w
LEFT OUTER JOIN sys.dm_exec_requests r2 ON (s.session_id = r2.blocking_session_id)
LEFT OUTER JOIN sys.dm_resource_governor_workload_groups g ON (g.group_id = s.group_id)
LEFT OUTER JOIN profiled_sessions ON profiled_session_id = s.session_id
ORDER BY s.session_id |
| 1 | 1229410 | 1229410 | 521080 | 94452232 | 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') |
| 269 | 1188682 | 4418 | 335543 | 19264974 | 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 |
| 1230 | 1020220 | 829 | 1150905 | 270 | SELECT target_data
FROM sys.dm_xe_session_targets xet WITH(nolock)
JOIN sys.dm_xe_sessions xes WITH(nolock)
ON xes.address = xet.event_session_address
WHERE xes.name = 'telemetry_xevents'
AND xet.target_name = 'ring_buffer' |
| 1 | 977625 | 977625 | 423552 | 117122591 | SELECT COUNT(DATACOUNT.Id) AS totalCount
FROM
(
SELECT DISTINCT RF.Id
FROM RequestFiles RF WITH(NOLOCK)
LEFT JOIN ReferencesRequestFile RRF WITH(NOLOCK) ON RRF.RequestFileId = RF.Id
LEFT JOIN DMS_References DR WITH(NOLOCK) ON DR.Id = RRF.ReferencesId
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 Dependencies D WITH(NOLOCK) ON D.Id = RF.DependencyId
-- Ajuste: eliminar duplicados reales antes del JOIN
LEFT JOIN (
SELECT DISTINCT
DependenciesId,
CompanyId
FROM CompanyStructures WITH(NOLOCK)
) CS 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 DistributionRequestFile DRF WITH(NOLOCK) ON DRF.RequestFileId = RF.Id
LEFT JOIN DistributionHeader DH WITH(NOLOCK) ON DH.Id = DRF.DistributionHeaderId
LEFT JOIN RequestFileDependencies RFD WITH(NOLOCK) ON RFD.RequestFileId = RF.Id
LEFT JOIN RelatedRequestFiles RELRF WITH(NOLOCK) ON RELRF.ParentId = RF.Id
LEFT JOIN MetadataRequestFiles MR WITH(NOLOCK) ON MR.RequestFilesId = RF.Id
LEFT JOIN RequestReviews RRW WITH(NOLOCK) ON RRW.RequestFileId = RF.Id
LEFT JOIN Users URW WITH(NOLOCK) ON URW.Id = RRW.UserReviewer WHERE MessageBody LIKE '%20253100402020561%') AS DATACOUNT |
| 10836 | 965399 | 89 | 1160913 | 97794900 | 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 | 917495 | 917495 | 224173 | 19797698 | 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 |
| 1 | 868934 | 868934 | 374098 | 117129921 | SELECT COUNT(DATACOUNT.Id) AS totalCount
FROM
(
SELECT DISTINCT RF.Id
FROM RequestFiles RF WITH(NOLOCK)
LEFT JOIN ReferencesRequestFile RRF WITH(NOLOCK) ON RRF.RequestFileId = RF.Id
LEFT JOIN DMS_References DR WITH(NOLOCK) ON DR.Id = RRF.ReferencesId
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 Dependencies D WITH(NOLOCK) ON D.Id = RF.DependencyId
-- Ajuste: eliminar duplicados reales antes del JOIN
LEFT JOIN (
SELECT DISTINCT
DependenciesId,
CompanyId
FROM CompanyStructures WITH(NOLOCK)
) CS 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 DistributionRequestFile DRF WITH(NOLOCK) ON DRF.RequestFileId = RF.Id
LEFT JOIN DistributionHeader DH WITH(NOLOCK) ON DH.Id = DRF.DistributionHeaderId
LEFT JOIN RequestFileDependencies RFD WITH(NOLOCK) ON RFD.RequestFileId = RF.Id
LEFT JOIN RelatedRequestFiles RELRF WITH(NOLOCK) ON RELRF.ParentId = RF.Id
LEFT JOIN MetadataRequestFiles MR WITH(NOLOCK) ON MR.RequestFilesId = RF.Id
LEFT JOIN RequestReviews RRW WITH(NOLOCK) ON RRW.RequestFileId = RF.Id
LEFT JOIN Users URW WITH(NOLOCK) ON URW.Id = RRW.UserReviewer WHERE MessageBody LIKE '%20253100403361541%') AS DATACOUNT |
| 36 | 602351 | 16731 | 622892 | 18848348 | with FilteredTables as ( select object_id from sys . tables where object_id > @0 ) insert into #IndexStats select stats . database_id , stats . object_id , stats . index_id , stats . partition_number , AVG ( stats . avg_fragmentation_in_percent ) as avg_fragmentation_in_percent , SUM ( stats . page_count ) * 8 as IndexSizeKb from FilteredTables as t inner join sys . dm_db_index_physical_stats ( DB_ID ( ) , null , null , null , @1 ) as stats on stats . object_id = t . object_id group by stats . database_id , stats . object_id , stats . index_id , stats . partition_number having SUM ( stats . page_count ) * 8 > = 1024 |
| 466 | 572356 | 1228 | 787496 | 20916530 | WITH FilteredTables AS (
SELECT
object_id
FROM sys.tables
WHERE object_id > 0
)
INSERT INTO #IndexStats
SELECT
stats.database_id,
stats.object_id,
stats.index_id,
stats.partition_number,
AVG(stats.avg_fragmentation_in_percent) AS avg_fragmentation_in_percent,
SUM(stats.page_count) * 8 AS IndexSizeKb
FROM FilteredTables AS t
INNER JOIN sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'LIMITED') AS stats ON stats.object_id = t.object_id
GROUP BY stats.database_id, stats.object_id, stats.index_id, stats.partition_number
HAVING SUM(stats.page_count) * 8 >= 1024 |
| 30 | 558859 | 18628 | 470022 | 161580970 | SELECT
TDO.[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',
RF.UserName AS 'Radicador',
CONVERT(VARCHAR, RF.ReportedSmart) AS 'ReportedSmart2',
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(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',
CL.[Address] AS 'Direccion',
CL.[OfficeAddress] AS 'DireccionOficina',
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.NumberIdentification AS 'IdentificacionApoderado',
IIF(APTP.Code IS NULL, NULL, CONCAT(APTP.Code, '|', APTP.[Name])) AS 'TipoApoderado',
AP.Names AS 'NApoderado',
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 'DirOfiApoderado',
AP.Telephone AS 'TelApoderado',
AP.Mobile AS 'CelApoderado',
AP.Email AS 'CorreoApoderado',
IIF(RF.ProcedureId IS NULL, NULL, CONCAT(RF.ProcedureId , '|', CONCAT_WS('/', SDE.[NameSolicitud], SDE.[NameDetalle], SDE.[NameEspecificacion]))) AS 'Tramite',
TRA.RESPONSETIME AS 'DiasGestón',
IIF(DP.Code IS NULL, NULL, CONCAT(DP.Code, '|', DP.[Name])) AS 'DependenciaResponsable',
CONCAT(SDE.[Responsible_UserName], '|', SDE.[Responsable_Funcionario]) 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',
IIF(TAX.Code IS NULL, NULL, CONCAT(TAX.Code, '|', TAX.[Name])) AS 'TAnexo',
RF.AttachDescription AS 'DAnexos',
RF.CourrierName AS 'Courrier',
RF.CourrierNumber AS 'Guia',
RF.[Location] AS 'Location'
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].[DMS_Procedures] TRA WITH (NOLOCK) ON TRA.Id = RF.ProcedureId
LEFT JOIN [dbo].Representatives AP WITH (NOLOCK) ON AP.Id = RF.RepresentativeId
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].[TypeDetail] TDO WITH (NOLOCK) ON TDO.Id = RF.OriginId
WHERE RF.FileNumber = @RadicadoEntrada |
| 1240 | 442973 | 357 | 539758 | 367533 | SELECT
CONVERT(uniqueidentifier, HASHBYTES('MD2', rankTable.[sql_handle])) as [qhash],
rankTable.[sql_handle] as [qhandle],
st.[text],
rankTable.[plan_count],
rankTable.[execution_count],
DATEADD(second, DATEDIFF(second, GETDATE(), GETUTCDATE()), rankTable.[last_execution_time]) AS [last_execution_time],
rankTable.[avg_worker_time],
rankTable.[last_worker_time],
rankTable.[avg_physical_reads],
rankTable.[avg_logical_reads],
rankTable.[avg_logical_writes],
rankTable.[avg_elapsed_time],
rankTable.[last_elapsed_time],
s.[session_id],
s.[login_name],
s.[host_name],
s.[host_process_id],
rankTable.[dbid],
rankTable.[dbname]
FROM (
SELECT
innerTable.*,
[plan].[dbid],
[plan].[dbname],
ROW_NUMBER() OVER (PARTITION BY [plan].[dbid] ORDER BY [avg_worker_time] DESC) AS [_rank_db_worker_time],
ROW_NUMBER() OVER (PARTITION BY [plan].[dbid] ORDER BY [avg_logical_reads] DESC) AS [_rank_db_logical_reads],
ROW_NUMBER() OVER (PARTITION BY [plan].[dbid] ORDER BY [avg_logical_writes] DESC) AS [_rank_db_logical_writes],
ROW_NUMBER() OVER (ORDER BY [avg_physical_reads] DESC) AS [_rank_physical_reads],
ROW_NUMBER() OVER (ORDER BY [avg_elapsed_time] DESC) AS [_rank_elapsed_time]
FROM (
SELECT
qs.[sql_handle],
SUM(qs_plan.[plan_count]) as [plan_count],
SUM(qs.[execution_count]) as [execution_count],
MAX(qs.[last_execution_time]) as [last_execution_time],
SUM(qs.[total_worker_time]) / SUM(qs.execution_count) / 1000 as [avg_worker_time],
AVG(qs.[last_worker_time]) / 1000 as [last_worker_time],
SUM(qs.[total_physical_reads]) / SUM(qs.execution_count) as [avg_physical_reads],
SUM(qs.[total_logical_reads]) / SUM(qs.execution_count) as [avg_logical_reads],
SUM(qs.[total_logical_writes]) / SUM(qs.execution_count) as [avg_logical_writes],
SUM(qs.[total_elapsed_time]) / SUM(qs.execution_count) / 1000 as [avg_elapsed_time],
AVG(qs.[last_elapsed_time]) / 1000 as [last_elapsed_time],
MAX ([plan_handle]) as [plan_handle]
FROM sys.dm_exec_query_stats AS qs
LEFT JOIN (
SELECT
COUNT(DISTINCT [plan_handle]) as [plan_count],
[query_hash],
[query_plan_hash]
FROM sys.dm_exec_query_stats
GROUP BY [query_hash], [query_plan_hash]
) as [qs_plan]
ON qs_plan.[query_hash] = qs.[query_hash]
AND qs_plan.[query_plan_hash] = qs.[query_plan_hash]
WHERE [total_worker_time] > 0
AND [last_execution_time] > DATEADD(SECOND,-5 * 300,GETDATE())
GROUP BY qs.[sql_handle]
) AS [innerTable]
OUTER APPLY (
SELECT
value AS [dbid],
DB_NAME(CONVERT(int, value)) as [dbname]
FROM sys.dm_exec_plan_attributes(innerTable.plan_handle)
WHERE [attribute] = 'dbid'
) AS [plan]
) AS [rankTable]
CROSS APPLY sys.dm_exec_sql_text(rankTable.[sql_handle]) st
LEFT JOIN sys.dm_exec_requests r
ON rankTable.[sql_handle] = r.[sql_handle]
LEFT JOIN sys.dm_exec_sessions s
ON s.[session_id] = r.[session_id]
WHERE
rankTable.[dbname] NOT IN ('')
AND (
[_rank_db_worker_time] <= 10
OR [_rank_db_logical_reads] <= 10
OR [_rank_db_logical_writes] <= 10
OR [_rank_physical_reads] <= 10
OR [_rank_elapsed_time] <= 10
) |
| 3731148 | 348326 | 0 | 376550 | 20817810 | 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
) |
| 135 | 328603 | 2434 | 93439 | 6120833 | 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 | 297595 | 297595 | 358564 | 14831490 | 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 |
| 11783 | 295607 | 25 | 412651 | 12660286 | SELECT COUNT(*)
FROM [ReassignmentTask] AS [r]
WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0 |