2026-01-10 00:00:19.8333 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7437*/
Opportunity Out Of Stock By Outlet 
2026-01-10 00:15:19.8870 DFramework.Scheduler.TaskBase    /* Time Taken: 15546.9926*/
Opportunity Out Of Stock By Outlet 
2026-01-10 00:30:05.2844 DFramework.Database.Query    /* Time Taken: 670*/
[dbo].GenerateSystemAlerts 
2026-01-10 00:30:20.0970 DFramework.Scheduler.TaskBase    /* Time Taken: 15734.4971*/
Opportunity Out Of Stock By Outlet 
2026-01-10 00:45:19.9007 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7284*/
Opportunity Out Of Stock By Outlet 
2026-01-10 01:00:19.9075 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7399*/
Opportunity Out Of Stock By Outlet 
2026-01-10 01:15:19.9456 DFramework.Scheduler.TaskBase    /* Time Taken: 15531.3607*/
Opportunity Out Of Stock By Outlet 
2026-01-10 01:30:19.9992 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6174*/
Opportunity Out Of Stock By Outlet 
2026-01-10 01:45:20.2092 DFramework.Scheduler.TaskBase    /* Time Taken: 15765.7415*/
Opportunity Out Of Stock By Outlet 
2026-01-10 02:00:19.9816 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7403*/
Opportunity Out Of Stock By Outlet 
2026-01-10 02:15:05.2541 DFramework.Database.Query    /* Time Taken: 502*/
[dbo].GenerateSystemAlerts 
2026-01-10 02:15:20.0198 DFramework.Scheduler.TaskBase    /* Time Taken: 15546.9893*/
Opportunity Out Of Stock By Outlet 
2026-01-10 02:30:20.0266 DFramework.Scheduler.TaskBase    /* Time Taken: 15531.3632*/
Opportunity Out Of Stock By Outlet 
2026-01-10 02:45:20.0335 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7951*/
Opportunity Out Of Stock By Outlet 
2026-01-10 03:00:20.0560 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7469*/
Opportunity Out Of Stock By Outlet 
2026-01-10 03:15:20.0934 DFramework.Scheduler.TaskBase    /* Time Taken: 15531.3659*/
Opportunity Out Of Stock By Outlet 
2026-01-10 03:30:20.1791 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8687*/
Opportunity Out Of Stock By Outlet 
2026-01-10 03:45:20.1080 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7486*/
Opportunity Out Of Stock By Outlet 
2026-01-10 04:00:20.1149 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7366*/
Opportunity Out Of Stock By Outlet 
2026-01-10 04:15:20.1218 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7311*/
Opportunity Out Of Stock By Outlet 
2026-01-10 04:30:20.1443 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7463*/
Opportunity Out Of Stock By Outlet 
2026-01-10 04:45:20.1668 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7402*/
Opportunity Out Of Stock By Outlet 
2026-01-10 05:00:20.1892 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7463*/
Opportunity Out Of Stock By Outlet 
2026-01-10 05:15:20.2274 DFramework.Scheduler.TaskBase    /* Time Taken: 15531.3703*/
Opportunity Out Of Stock By Outlet 
2026-01-10 05:30:20.2343 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7445*/
Opportunity Out Of Stock By Outlet 
2026-01-10 05:45:20.2568 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7418*/
Opportunity Out Of Stock By Outlet 
2026-01-10 06:00:20.3105 DFramework.Scheduler.TaskBase    /* Time Taken: 15547.0025*/
Opportunity Out Of Stock By Outlet 
2026-01-10 06:15:20.3017 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7413*/
Opportunity Out Of Stock By Outlet 
2026-01-10 06:28:31.5735 DFramework.Database.Query    /* Time Taken: 569*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 06:28:34.2923 DFramework.Database.Query    /* Time Taken: 512*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 06:30:05.8711 DFramework.Database.Query    /* Time Taken: 788*/
[dbo].GenerateSystemAlerts 
2026-01-10 06:30:20.3243 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7489*/
Opportunity Out Of Stock By Outlet 
2026-01-10 06:30:32.3088 DFramework.Database.Query    /* Time Taken: 1042*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 06:45:20.3312 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.748*/
Opportunity Out Of Stock By Outlet 
2026-01-10 07:00:20.3694 DFramework.Scheduler.TaskBase    /* Time Taken: 15531.399*/
Opportunity Out Of Stock By Outlet 
2026-01-10 07:03:31.1680 DFramework.Database.Query    /* Time Taken: 554*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 07:03:32.1055 DFramework.Database.Query    /* Time Taken: 747*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 07:05:27.7471 DFramework.Database.Query    /* Time Taken: 674*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 07:05:29.6221 DFramework.Database.Query    /* Time Taken: 662*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 07:05:30.3096 DFramework.Database.Query    /* Time Taken: 673*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 07:05:30.5283 DFramework.Database.Query    /* Time Taken: 787*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 07:05:30.5283 DFramework.Database.Query    /* Time Taken: 789*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '2'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 07:05:30.5283 DFramework.Database.Query    /* Time Taken: 788*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 07:05:31.0440 DFramework.Database.Query    /* Time Taken: 1304*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 07:05:31.0440 DFramework.Database.Query    /* Time Taken: 1306*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 07:05:32.0909 DFramework.Database.Query    /* Time Taken: 638*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 07:15:20.3767 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7384*/
Opportunity Out Of Stock By Outlet 
2026-01-10 07:30:20.3832 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7482*/
Opportunity Out Of Stock By Outlet 
2026-01-10 07:45:20.4055 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7431*/
Opportunity Out Of Stock By Outlet 
2026-01-10 08:00:20.4280 DFramework.Scheduler.TaskBase    /* Time Taken: 15515.7405*/
Opportunity Out Of Stock By Outlet 
2026-01-10 08:15:21.0442 DFramework.Scheduler.TaskBase    /* Time Taken: 16109.4958*/
Opportunity Out Of Stock By Outlet 
2026-01-10 08:17:06.1856 DFramework.Database.Query    /* Time Taken: 736*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:17:07.6856 DFramework.Database.Query    /* Time Taken: 793*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:25:28.6738 DFramework.Database.Query    /* Time Taken: 717*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 08:25:28.6894 DFramework.Database.Query    /* Time Taken: 717*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 08:25:28.6894 DFramework.Database.Query    /* Time Taken: 718*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '2'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 08:25:28.6894 DFramework.Database.Query    /* Time Taken: 718*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '0'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 08:25:29.4082 DFramework.Database.Query    /* Time Taken: 649*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:30:20.4887 DFramework.Scheduler.TaskBase    /* Time Taken: 15531.3751*/
Opportunity Out Of Stock By Outlet 
2026-01-10 08:31:45.7550 DFramework.Database.Query    /* Time Taken: 715*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:31:46.4269 DFramework.Database.Query    /* Time Taken: 679*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:33:40.5684 DFramework.Database.Query    /* Time Taken: 567*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:33:42.5528 DFramework.Database.Query    /* Time Taken: 670*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:33:44.3185 DFramework.Database.Query    /* Time Taken: 501*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:33:45.2716 DFramework.Database.Query    /* Time Taken: 1004*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 08:33:47.2247 DFramework.Database.Query    /* Time Taken: 997*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:41:49.7597 DFramework.Database.Query    /* Time Taken: 542*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:41:51.0097 DFramework.Database.Query    /* Time Taken: 956*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:41:51.2284 DFramework.Database.Query    /* Time Taken: 679*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '4'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 08:41:51.3066 DFramework.Database.Query    /* Time Taken: 760*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '3'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 08:41:51.6659 DFramework.Database.Query    /* Time Taken: 655*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:41:55.1816 DFramework.Database.Query    /* Time Taken: 1043*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 08:45:05.7923 DFramework.Database.Query    /* Time Taken: 548*/
[dbo].GenerateSystemAlerts 
2026-01-10 08:45:20.5737 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8616*/
Opportunity Out Of Stock By Outlet 
2026-01-10 09:00:05.7678 DFramework.Database.Query    /* Time Taken: 510*/
[dbo].GenerateSystemAlerts 
2026-01-10 09:00:20.5492 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6297*/
Opportunity Out Of Stock By Outlet 
2026-01-10 09:15:05.7904 DFramework.Database.Query    /* Time Taken: 501*/
[dbo].GenerateSystemAlerts 
2026-01-10 09:15:20.5874 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2424*/
Opportunity Out Of Stock By Outlet 
2026-01-10 09:30:05.7972 DFramework.Database.Query    /* Time Taken: 512*/
[dbo].GenerateSystemAlerts 
2026-01-10 09:30:20.6723 DFramework.Scheduler.TaskBase    /* Time Taken: 15640.7443*/
Opportunity Out Of Stock By Outlet 
2026-01-10 09:36:00.7843 DFramework.Database.Query    /* Time Taken: 599*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 09:37:54.3477 DFramework.Database.Query    /* Time Taken: 776*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 09:37:56.2383 DFramework.Database.Query    /* Time Taken: 1007*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 09:37:58.6446 DFramework.Database.Query    /* Time Taken: 654*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 09:37:59.4571 DFramework.Database.Query    /* Time Taken: 806*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 09:45:05.8666 DFramework.Database.Query    /* Time Taken: 559*/
[dbo].GenerateSystemAlerts 
2026-01-10 09:45:20.7105 DFramework.Scheduler.TaskBase    /* Time Taken: 15656.3693*/
Opportunity Out Of Stock By Outlet 
2026-01-10 10:00:05.8735 DFramework.Database.Query    /* Time Taken: 535*/
[dbo].GenerateSystemAlerts 
2026-01-10 10:00:20.7798 DFramework.Scheduler.TaskBase    /* Time Taken: 15703.2411*/
Opportunity Out Of Stock By Outlet 
2026-01-10 10:15:05.8647 DFramework.Database.Query    /* Time Taken: 511*/
[dbo].GenerateSystemAlerts 
2026-01-10 10:15:20.6617 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6085*/
Opportunity Out Of Stock By Outlet 
2026-01-10 10:30:05.8871 DFramework.Database.Query    /* Time Taken: 512*/
[dbo].GenerateSystemAlerts 
2026-01-10 10:30:20.6841 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6153*/
Opportunity Out Of Stock By Outlet 
2026-01-10 10:45:05.9096 DFramework.Database.Query    /* Time Taken: 501*/
[dbo].GenerateSystemAlerts 
2026-01-10 10:45:20.6909 DFramework.Scheduler.TaskBase    /* Time Taken: 15546.9889*/
Opportunity Out Of Stock By Outlet 
2026-01-10 11:00:20.7291 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.618*/
Opportunity Out Of Stock By Outlet 
2026-01-10 11:04:08.9496 DFramework.Database.Query    /* Time Taken: 938*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 11:04:11.8715 DFramework.Database.Query    /* Time Taken: 804*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 11:10:40.6869 DFramework.Database.Query    /* Time Taken: 580*/
DECLARE @IsFileProcessed Int32
SET @IsFileProcessed = '0'
DECLARE @TaskNumber Int32
SET @TaskNumber = '1'
DECLARE @IsDeleted Int32
SET @IsDeleted = '0'
SELECT TOP 1000 IncomingFileId, GatewayId,GatewayMac,RawFileName,AzureContainerName,StartIndex,Tries, CreatedOn FROM IncomingFile
 WHERE [IsFileProcessed] = @IsFileProcessed AND [TaskNumber] = @TaskNumber AND [IsDeleted] = @IsDeleted
 
2026-01-10 11:10:46.0464 DFramework.Database.Query    /* Time Taken: 588*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 11:12:36.7347 DFramework.Database.Query    /* Time Taken: 556*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 11:12:37.7034 DFramework.Database.Query    /* Time Taken: 755*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 11:12:38.2660 DFramework.Database.Query    /* Time Taken: 559*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 11:12:41.2972 DFramework.Database.Query    /* Time Taken: 622*/
DECLARE @AssetPurityId Int32
SET @AssetPurityId = '3675808'
DECLARE @AssetId Int32
SET @AssetId = '118415'
DECLARE @StatusId Int32
SET @StatusId = '2'
DECLARE @PurityDateTime Date
SET @PurityDateTime = '1/8/2026 6:14:11 PM'
SELECT TOP 1 PurityDateTime, AssetPurityId, PlanogramId, Shelves, PurityStatus, AssetId, ImageReceivedFrom FROM AssetPurity
 WHERE [AssetPurityId] <= @AssetPurityId AND [AssetId] = @AssetId AND [StatusId] = @StatusId AND [PurityDateTime] > @PurityDateTime
 ORDER BY [PurityDateTime] DESC 
2026-01-10 11:15:05.9858 DFramework.Database.Query    /* Time Taken: 540*/
[dbo].GenerateSystemAlerts 
2026-01-10 11:15:20.7672 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2375*/
Opportunity Out Of Stock By Outlet 
2026-01-10 11:30:06.0552 DFramework.Database.Query    /* Time Taken: 582*/
[dbo].GenerateSystemAlerts 
2026-01-10 11:30:20.9459 DFramework.Scheduler.TaskBase    /* Time Taken: 15734.4956*/
Opportunity Out Of Stock By Outlet 
2026-01-10 11:45:06.3745 DFramework.Database.Query    /* Time Taken: 885*/
[dbo].GenerateSystemAlerts 
2026-01-10 11:45:20.8121 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2533*/
Opportunity Out Of Stock By Outlet 
2026-01-10 12:00:06.0377 DFramework.Database.Query    /* Time Taken: 524*/
[dbo].GenerateSystemAlerts 
2026-01-10 12:00:20.8190 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6159*/
Opportunity Out Of Stock By Outlet 
2026-01-10 12:15:06.0446 DFramework.Database.Query    /* Time Taken: 514*/
[dbo].GenerateSystemAlerts 
2026-01-10 12:15:20.8885 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4878*/
Opportunity Out Of Stock By Outlet 
2026-01-10 12:30:06.0671 DFramework.Database.Query    /* Time Taken: 512*/
[dbo].GenerateSystemAlerts 
2026-01-10 12:30:20.8641 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6411*/
Opportunity Out Of Stock By Outlet 
2026-01-10 12:45:06.3396 DFramework.Database.Query    /* Time Taken: 760*/
[dbo].GenerateSystemAlerts 
2026-01-10 12:45:20.8709 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6202*/
Opportunity Out Of Stock By Outlet 
2026-01-10 13:00:06.2214 DFramework.Database.Query    /* Time Taken: 632*/
[dbo].GenerateSystemAlerts 
2026-01-10 13:00:20.9090 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2411*/
Opportunity Out Of Stock By Outlet 
2026-01-10 13:15:06.1345 DFramework.Database.Query    /* Time Taken: 528*/
[dbo].GenerateSystemAlerts 
2026-01-10 13:15:20.9159 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6125*/
Opportunity Out Of Stock By Outlet 
2026-01-10 13:30:06.1414 DFramework.Database.Query    /* Time Taken: 509*/
[dbo].GenerateSystemAlerts 
2026-01-10 13:30:20.9384 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6203*/
Opportunity Out Of Stock By Outlet 
2026-01-10 13:45:06.1796 DFramework.Database.Query    /* Time Taken: 526*/
[dbo].GenerateSystemAlerts 
2026-01-10 13:45:20.9766 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8678*/
Opportunity Out Of Stock By Outlet 
2026-01-10 14:00:20.9367 DFramework.Scheduler.TaskBase    /* Time Taken: 15531.3685*/
Opportunity Out Of Stock By Outlet 
2026-01-10 14:15:20.9904 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6236*/
Opportunity Out Of Stock By Outlet 
2026-01-10 14:30:06.2313 DFramework.Database.Query    /* Time Taken: 526*/
[dbo].GenerateSystemAlerts 
2026-01-10 14:30:21.0752 DFramework.Scheduler.TaskBase    /* Time Taken: 15625.1196*/
Opportunity Out Of Stock By Outlet 
2026-01-10 14:45:06.2383 DFramework.Database.Query    /* Time Taken: 503*/
[dbo].GenerateSystemAlerts 
2026-01-10 14:45:21.0353 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.622*/
Opportunity Out Of Stock By Outlet 
2026-01-10 15:00:06.2764 DFramework.Database.Query    /* Time Taken: 516*/
[dbo].GenerateSystemAlerts 
2026-01-10 15:00:21.0578 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6149*/
Opportunity Out Of Stock By Outlet 
2026-01-10 15:15:06.2832 DFramework.Database.Query    /* Time Taken: 503*/
[dbo].GenerateSystemAlerts 
2026-01-10 15:15:21.0802 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6206*/
Opportunity Out Of Stock By Outlet 
2026-01-10 15:30:06.3214 DFramework.Database.Query    /* Time Taken: 529*/
[dbo].GenerateSystemAlerts 
2026-01-10 15:30:21.1028 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6184*/
Opportunity Out Of Stock By Outlet 
2026-01-10 15:45:06.3284 DFramework.Database.Query    /* Time Taken: 508*/
[dbo].GenerateSystemAlerts 
2026-01-10 15:45:21.1254 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6176*/
Opportunity Out Of Stock By Outlet 
2026-01-10 16:00:06.3665 DFramework.Database.Query    /* Time Taken: 515*/
[dbo].GenerateSystemAlerts 
2026-01-10 16:00:21.1479 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6308*/
Opportunity Out Of Stock By Outlet 
2026-01-10 16:15:06.3734 DFramework.Database.Query    /* Time Taken: 503*/
[dbo].GenerateSystemAlerts 
2026-01-10 16:15:21.1547 DFramework.Scheduler.TaskBase    /* Time Taken: 15546.9903*/
Opportunity Out Of Stock By Outlet 
2026-01-10 16:30:06.6146 DFramework.Database.Query    /* Time Taken: 733*/
[dbo].GenerateSystemAlerts 
2026-01-10 16:30:21.1929 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6149*/
Opportunity Out Of Stock By Outlet 
2026-01-10 16:45:06.4184 DFramework.Database.Query    /* Time Taken: 505*/
[dbo].GenerateSystemAlerts 
2026-01-10 16:45:21.4029 DFramework.Scheduler.TaskBase    /* Time Taken: 15750.121*/
Opportunity Out Of Stock By Outlet 
2026-01-10 17:00:06.4409 DFramework.Database.Query    /* Time Taken: 504*/
[dbo].GenerateSystemAlerts 
2026-01-10 17:00:21.2378 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6183*/
Opportunity Out Of Stock By Outlet 
2026-01-10 17:15:06.4634 DFramework.Database.Query    /* Time Taken: 507*/
[dbo].GenerateSystemAlerts 
2026-01-10 17:15:21.2447 DFramework.Scheduler.TaskBase    /* Time Taken: 15546.9964*/
Opportunity Out Of Stock By Outlet 
2026-01-10 17:30:06.6266 DFramework.Database.Query    /* Time Taken: 668*/
[dbo].GenerateSystemAlerts 
2026-01-10 17:30:21.4548 DFramework.Scheduler.TaskBase    /* Time Taken: 15734.4881*/
Opportunity Out Of Stock By Outlet 
2026-01-10 17:45:06.4929 DFramework.Database.Query    /* Time Taken: 519*/
[dbo].GenerateSystemAlerts 
2026-01-10 17:45:21.2899 DFramework.Scheduler.TaskBase    /* Time Taken: 15546.9917*/
Opportunity Out Of Stock By Outlet 
2026-01-10 18:00:06.6092 DFramework.Database.Query    /* Time Taken: 636*/
[dbo].GenerateSystemAlerts 
2026-01-10 18:00:21.4062 DFramework.Scheduler.TaskBase    /* Time Taken: 15640.7469*/
Opportunity Out Of Stock By Outlet 
2026-01-10 18:15:06.5223 DFramework.Database.Query    /* Time Taken: 529*/
[dbo].GenerateSystemAlerts 
2026-01-10 18:15:21.3662 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2455*/
Opportunity Out Of Stock By Outlet 
2026-01-10 18:30:06.5447 DFramework.Database.Query    /* Time Taken: 526*/
[dbo].GenerateSystemAlerts 
2026-01-10 18:30:21.3730 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6168*/
Opportunity Out Of Stock By Outlet 
2026-01-10 18:45:06.5514 DFramework.Database.Query    /* Time Taken: 513*/
[dbo].GenerateSystemAlerts 
2026-01-10 18:45:21.4109 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2494*/
Opportunity Out Of Stock By Outlet 
2026-01-10 19:00:06.6207 DFramework.Database.Query    /* Time Taken: 551*/
[dbo].GenerateSystemAlerts 
2026-01-10 19:00:21.4490 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8662*/
Opportunity Out Of Stock By Outlet 
2026-01-10 19:15:06.6900 DFramework.Database.Query    /* Time Taken: 600*/
[dbo].GenerateSystemAlerts 
2026-01-10 19:15:21.4402 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.242*/
Opportunity Out Of Stock By Outlet 
2026-01-10 19:30:06.6343 DFramework.Database.Query    /* Time Taken: 524*/
[dbo].GenerateSystemAlerts 
2026-01-10 19:30:21.4626 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2447*/
Opportunity Out Of Stock By Outlet 
2026-01-10 19:45:06.6723 DFramework.Database.Query    /* Time Taken: 537*/
[dbo].GenerateSystemAlerts 
2026-01-10 19:45:21.4849 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.247*/
Opportunity Out Of Stock By Outlet 
2026-01-10 20:00:06.6946 DFramework.Database.Query    /* Time Taken: 540*/
[dbo].GenerateSystemAlerts 
2026-01-10 20:00:21.4759 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6156*/
Opportunity Out Of Stock By Outlet 
2026-01-10 20:15:06.7326 DFramework.Database.Query    /* Time Taken: 572*/
[dbo].GenerateSystemAlerts 
2026-01-10 20:15:21.4983 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6174*/
Opportunity Out Of Stock By Outlet 
2026-01-10 20:30:07.2863 DFramework.Database.Query    /* Time Taken: 1121*/
[dbo].GenerateSystemAlerts 
2026-01-10 20:30:10.4425 DFramework.Database.Query    /* Time Taken: 615*/
DECLARE @AlertTypeIds AnsiString(8000)
SET @AlertTypeIds = '46,37,59,73,57'
DECLARE @ClientIds AnsiString(8000)
SET @ClientIds = '286,213,1494,471,224,295,338,335,421,1480,301,188,291,331,314,337,134,303,114,360,469,320,300,332,180,415,395,306,183,349,336,207,333,227,342,385,299,70,296,316,451,305,328,308,325,452'
DECLARE @StatusId Int32
SET @StatusId = '1'
SELECT ClientName, AlertType, AlertText, Location.Name AS [Location], Location.Code AS LocationCode, Asset.SerialNumber AS AssetSerialNumber, COALESCE(SmartDevice.SerialNumber, SD.SerialNumber) AS SmartDeviceSerial, AlertAt, AccountCoordinators.PrimaryEmail AS AccountCoordinator, AccountDirectors.PrimaryEmail AS AccountDirector, Alert.ClientId FROM Alert
											LEFT OUTER JOIN Client ON Client.ClientId = Alert.ClientId
											LEFT OUTER JOIN AlertType ON AlertType.AlertTypeId = Alert.AlertTypeId
											LEFT OUTER JOIN Location ON Location.LocationId = Alert.LocationId
											LEFT OUTER JOIN Asset ON Asset.AssetId = Alert.AssetId
											LEFT OUTER JOIN SmartDevice ON SmartDevice.SmartDeviceId = Alert.SmartDeviceId AND SmartDevice.IsGatewayDevice = 0
											LEFT OUTER JOIN vwSmartDeviceExceptSmartHubList AS SD ON dbo.Alert.AssetId = SD.LinkedAssetId AND SD.LinkedAssetId <> 0
											LEFT OUTER JOIN dbo.Security_User AS AccountDirectors ON Client.AccountDirectorId = AccountDirectors.UserId AND AccountDirectors.IsDeleted = 0 
											LEFT OUTER JOIN dbo.Security_User AS AccountCoordinators ON Client.AccountCoordinatorId = AccountCoordinators.UserId AND AccountCoordinators.IsDeleted = 0
										WHERE Alert.AlertTypeId IN (SELECT * FROM CsvToInt(@AlertTypeIds)) AND Alert.ClientId IN (SELECT * FROM CsvToInt(@ClientIds)) AND Alert.StatusId = @StatusId ORDER BY Alert.ClientId
 
2026-01-10 20:30:21.5051 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6209*/
Opportunity Out Of Stock By Outlet 
2026-01-10 20:45:06.7150 DFramework.Database.Query    /* Time Taken: 533*/
[dbo].GenerateSystemAlerts 
2026-01-10 20:45:21.5276 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6184*/
Opportunity Out Of Stock By Outlet 
2026-01-10 21:00:06.7375 DFramework.Database.Query    /* Time Taken: 532*/
[dbo].GenerateSystemAlerts 
2026-01-10 21:00:21.5657 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2459*/
Opportunity Out Of Stock By Outlet 
2026-01-10 21:15:06.7912 DFramework.Database.Query    /* Time Taken: 563*/
[dbo].GenerateSystemAlerts 
2026-01-10 21:15:21.6038 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8618*/
Opportunity Out Of Stock By Outlet 
2026-01-10 21:30:06.7512 DFramework.Database.Query    /* Time Taken: 501*/
[dbo].GenerateSystemAlerts 
2026-01-10 21:30:21.5950 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6222*/
Opportunity Out Of Stock By Outlet 
2026-01-10 21:45:06.8362 DFramework.Database.Query    /* Time Taken: 570*/
[dbo].GenerateSystemAlerts 
2026-01-10 21:45:21.6488 DFramework.Scheduler.TaskBase    /* Time Taken: 15593.8698*/
Opportunity Out Of Stock By Outlet 
2026-01-10 22:00:06.8118 DFramework.Database.Query    /* Time Taken: 525*/
[dbo].GenerateSystemAlerts 
2026-01-10 22:00:21.6713 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4933*/
Opportunity Out Of Stock By Outlet 
2026-01-10 22:15:06.8500 DFramework.Database.Query    /* Time Taken: 536*/
[dbo].GenerateSystemAlerts 
2026-01-10 22:15:21.6470 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6142*/
Opportunity Out Of Stock By Outlet 
2026-01-10 22:30:07.1381 DFramework.Database.Query    /* Time Taken: 807*/
[dbo].GenerateSystemAlerts 
2026-01-10 22:30:21.7164 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4973*/
Opportunity Out Of Stock By Outlet 
2026-01-10 22:45:06.8794 DFramework.Database.Query    /* Time Taken: 524*/
[dbo].GenerateSystemAlerts 
2026-01-10 22:45:21.7389 DFramework.Scheduler.TaskBase    /* Time Taken: 15609.4935*/
Opportunity Out Of Stock By Outlet 
2026-01-10 23:00:06.8704 DFramework.Database.Query    /* Time Taken: 511*/
[dbo].GenerateSystemAlerts 
2026-01-10 23:00:21.6987 DFramework.Scheduler.TaskBase    /* Time Taken: 15546.9866*/
Opportunity Out Of Stock By Outlet 
2026-01-10 23:15:06.9086 DFramework.Database.Query    /* Time Taken: 523*/
[dbo].GenerateSystemAlerts 
2026-01-10 23:15:21.9712 DFramework.Scheduler.TaskBase    /* Time Taken: 15797.0235*/
Opportunity Out Of Stock By Outlet 
2026-01-10 23:30:06.9156 DFramework.Database.Query    /* Time Taken: 512*/
[dbo].GenerateSystemAlerts 
2026-01-10 23:30:21.7439 DFramework.Scheduler.TaskBase    /* Time Taken: 15562.6196*/
Opportunity Out Of Stock By Outlet 
2026-01-10 23:45:06.9382 DFramework.Database.Query    /* Time Taken: 513*/
[dbo].GenerateSystemAlerts 
2026-01-10 23:45:21.7664 DFramework.Scheduler.TaskBase    /* Time Taken: 15578.2401*/
Opportunity Out Of Stock By Outlet