Stage 2 — Data · Amlesh.Singh@kwglobal.com

Dispatched View full job

Recipient: Amlesh.Singh@kwglobal.com (Amlesh Singh) · Template: AssociateSummary · Job: 96A9F645-3406-461A-83CC-FB33ECE192D8

Stage 2 — Data

Fetched 2026-07-25 02:31:34.510434 · 20098 bytes

Associates 1 App Usage 38 Web Usage 16 Category Usage 12 Timesheet 2
Associates · 1 row(s) × 22 column(s)
UserIdCompanyIdUserNameUserEmailTotalTimeTotalDeskTimeDeskTimeProductiveTimeUnProductiveTimeNeutralTimeNoImpactTimeTotalIdleTimeMostUsedAppsCommitsWorkItemsActivityLoggedWorkItemsIsAttendanceBasedOnTrackingIsUserHavingShiftStartTimeFinishTimeMessageEnumIsNoImpactEnabled
21AD8549-6102-4109-BB52-C88A03D7D570 6E919CFE-74DD-4EBC-8665-3C0D44866649 Sanjeet Kumar Sanjeet.Kumar@kwglobal.com 6h 25m 6h 24m 384 3h 40m 0h 0m 2h 44m 0h 0m 0h 0m <ApplicationReports><ApplicationReportModel><ApplicationName>Idle (Meeting)</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>sheridan.jira.com</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>outlook.cloud.microsoft</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>Idle (Meeting)</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>Idle (Meeting)</ApplicationName></ApplicationReportModel></ApplicationReports> True True 11:30 AM 05:55 PM 0 False
App Usage · 38 row(s) × 6 column(s)
ApplicationNameTotalDurationPercentageProductivityRankingUserNameEmployeeNumber
firefox 03:24:08 25.66 Productive Amlesh Singh 42452
Idle (Meeting) 01:51:10 13.97 Neutral Amlesh Singh 42452
TimeChamp 00:45:19 5.70 Productive Amlesh Singh 42452
EXCEL 00:43:14 5.43 Productive Amlesh Singh 42452
OUTLOOK 00:34:58 4.40 Productive Amlesh Singh 42452
iPSMonitor 00:30:47 3.87 Neutral Amlesh Singh 42452
explorer 00:27:52 3.50 Productive Amlesh Singh 42452
ms-teams 00:22:45 2.86 Productive Amlesh Singh 42452
mstsc 00:05:37 0.71 Productive Amlesh Singh 42452
FoxitPDFEditor 00:03:14 0.41 Productive Amlesh Singh 42452
ShellHost 00:02:17 0.29 Productive Amlesh Singh 42452
jp2launcher 00:02:00 0.25 Neutral Amlesh Singh 42452
ShellExperienceHost 00:01:58 0.25 Productive Amlesh Singh 42452
chrome 00:01:39 0.21 Productive Amlesh Singh 42452
SnippingTool 00:00:59 0.12 Productive Amlesh Singh 42452
Notepad 00:00:48 0.10 Productive Amlesh Singh 42452
ApplicationFrameHost 00:00:44 0.09 Productive Amlesh Singh 42452
WINWORD 00:00:35 0.07 Productive Amlesh Singh 42452
SearchHost 00:00:28 0.06 Productive Amlesh Singh 42452
mspaint 00:00:08 0.02 Productive Amlesh Singh 42452
java 00:00:07 0.01 Neutral Amlesh Singh 42452
StartMenuExperienceHost 00:00:04 0.01 Productive Amlesh Singh 42452
timedoctor2 00:00:03 0.01 Productive Amlesh Singh 42452
Idle (Meeting) 02:44:08 20.63 Neutral Sanjeet Kumar 47602
ms-teams 00:27:39 3.48 Productive Sanjeet Kumar 47602
POWERPNT 00:22:55 2.88 Productive Sanjeet Kumar 47602
mstsc 00:13:46 1.73 Productive Sanjeet Kumar 47602
msedge 00:10:29 1.32 Productive Sanjeet Kumar 47602
EXCEL 00:06:18 0.79 Productive Sanjeet Kumar 47602
explorer 00:04:58 0.62 Productive Sanjeet Kumar 47602
TimeChamp 00:03:40 0.46 Productive Sanjeet Kumar 47602
SnippingTool 00:00:15 0.03 Productive Sanjeet Kumar 47602
ShellHost 00:00:08 0.02 Productive Sanjeet Kumar 47602
CredentialUIBroker 00:00:07 0.01 Productive Sanjeet Kumar 47602
SearchHost 00:00:06 0.01 Productive Sanjeet Kumar 47602
LockApp 00:00:03 0.01 Productive Sanjeet Kumar 47602
BingWallpaper 00:00:02 0.00 Neutral Sanjeet Kumar 47602
M365Copilot 00:00:01 0.00 Productive Sanjeet Kumar 47602
Web Usage · 16 row(s) × 6 column(s)
ApplicationNameTotalDurationPercentageProductivityRankingUserNameEmployeeNumber
sheridan.jira.com 00:38:33 22.86 Productive Amlesh Singh 42452
assist.zoho.in 00:00:11 0.11 Neutral Amlesh Singh 42452
assist.zoho.in 00:00:11 0.11 Productive Amlesh Singh 42452
sheridan.jira.com 00:50:29 29.94 Productive Sanjeet Kumar 47602
outlook.cloud.microsoft 00:46:28 27.55 Productive Sanjeet Kumar 47602
www.youtube.com 00:19:39 11.65 Productive Sanjeet Kumar 47602
www.dell.com 00:06:28 3.83 Productive Sanjeet Kumar 47602
msedge 00:02:49 1.67 Productive Sanjeet Kumar 47602
www.bing.com 00:01:32 0.91 Productive Sanjeet Kumar 47602
teams.cloud.microsoft 00:00:44 0.43 Productive Sanjeet Kumar 47602
www.msn.com 00:00:25 0.25 Productive Sanjeet Kumar 47602
accounts.google.com 00:00:23 0.23 Productive Sanjeet Kumar 47602
aka.ms 00:00:20 0.20 Productive Sanjeet Kumar 47602
www.hemmersbach.com 00:00:17 0.17 Productive Sanjeet Kumar 47602
mail.google.com 00:00:07 0.07 Productive Sanjeet Kumar 47602
gmail.com 00:00:02 0.02 Productive Sanjeet Kumar 47602
Category Usage · 12 row(s) × 5 column(s)
ApplicationCategoryNameTotalDurationPercentageUserNameEmployeeNumber
Office Apps 05:03 31.595 Amlesh Singh 42452
Others 02:24 15.016 Amlesh Singh 42452
PRINT ACCOUNT_IDC 01:41 10.532 Amlesh Singh 42452
Development 00:21 2.190 Amlesh Singh 42452
Work Apps/URLs 00:06 0.626 Amlesh Singh 42452
HE and STM Apps 00:02 0.209 Amlesh Singh 42452
BackGround 00:00 0.000 Amlesh Singh 42452
PRINT ACCOUNT_IDC 03:22 21.064 Sanjeet Kumar 47602
Others 02:44 17.101 Sanjeet Kumar 47602
Work Apps/URLs 00:13 1.356 Sanjeet Kumar 47602
Office Apps 00:03 0.313 Sanjeet Kumar 47602
HE and STM Apps 00:00 0.000 Sanjeet Kumar 47602
Timesheet · 2 row(s) × 56 column(s)
TimeSheetIdUserIdUserNameTeamNameIsNoImpactEnabledRoleNameReportToEmployeeNameReportToEmployeeMailShiftDepartmentNameMobileNoDateActiveTimeInSecProductiveTimeInSecUnProductiveTimeInSecNeutralTimeInSecNoImpactTimeInSecTotalIdleTimeUserBreaksCountEmployeeNameUserProfileImageTimeZoneIdLunchBreakEndTimeLunchBreakStartTimeInTimeInTimeAbbreviationOutTimeAbbreviationLunchStartAbbreviationLunchEndAbbreviationInTimeTimeZoneOutTimeTimeZoneLunchStartTimeZoneLunchEndTimeZoneOutTimePunchCardBasedLatestInsertedTrackerDateLunchBreakDiffUsersBreakTimeIsNextDaySpentTimeDiffTotalOfflineTimeLunchTimeInSecUsersBreakTimeInSecEmployeeNumberLoggedTimeAttendanceStatusBranchNameDesktopNameTotalSpentTimeFullDayMinimumHoursHalfDayMinimumHoursAbsentDayMinimumHoursAttendanceAbsentTimeAttendanceHalfOrFullDayTimeIsAttendacneBasedOnPercentageTotalTimeInSec
8D27DB6A-C11D-4DE2-AB30-1C13A391B380 F4E91544-2B17-4462-ADB8-A6E77A859921 amlesh.singh@kwglobal.com KGL False Manager Jaisingh Varma Jaisingh.Varma@kwglobal.com 09:00 IST - 17:30 IST Support Function (IT)-System Admin 2026-07-24T00:00:00 32813 24155 0 8658 0 0 0 Amlesh Singh C527B633-9FB6-4D9F-BE87-5172DBE87D18 2026-07-24T10:53:21.590509+05:30 2026-07-24T20:00:14.794785+05:30 False 0 32813 0 0 42452 KGL-IT XINNDNLEN0123 101.11 7.0 3.0 3.0 546 546 False 32813
8BEBFE70-C42E-490E-AFA0-121DC6386CD4 21AD8549-6102-4109-BB52-C88A03D7D570 Sanjeet.Kumar@kwglobal.com KGL False User Amlesh Singh Amlesh.Singh@kwglobal.com 08:30 IST - 17:30 IST Support Function (IT)-System Admin 2026-07-24T00:00:00 23070 13220 0 9850 0 0 0 Sanjeet Kumar C527B633-9FB6-4D9F-BE87-5172DBE87D18 2026-07-24T11:30:32.895295+05:30 2026-07-24T17:55:04.250286+05:30 False 0 23072 2 0 47602 KGL-IT XINNDDELL0899 71.11 8.0 4.0 4.0 384 384 False 23072
Meta · non-tabular fields
{
  "row_counts": {
    "app_usage": 38,
    "associates": 1,
    "category_usage": 12,
    "timesheet": 2,
    "web_usage": 16
  },
  "soft_labels": {
    "ActionLabel": "Action",
    "ActionsLabel": "Actions",
    "ActualShiftLabel": "Actual Shift",
    "ActualWorkingHoursLabel": "Actual Working Hours",
    "AuditActivityLabel": "Audit activity",
    "AuditAnalyticsLabel": "Audit analytics",
    "AuditLabel": "Audit",
    "AuditQuestionLabel": "Question",
    "AuditQuestionsLabel": "Question",
    "AuditReportLabel": "Audit report",
    "AuditReportsLabel": "Audit reports",
    "AuditsLabel": "Audits",
    "AvgOnlineHoursLabel": "Avg Online Hours",
    "AvgProductiveHoursLabel": "Avg Productive Hours",
    "AvgTotalHoursLabel": "Avg Total Hours",
    "AvgWorkingHoursLabel": "Avg Working Hours",
    "AwayHoursLabel": "Away Hours",
    "ClaimedTimeLabel": "Claimed Time",
    "CompanyId": "6E919CFE-74DD-4EBC-8665-3C0D44866649",
    "CompletedWorkItemsLabel": "Completed Work Items",
    "ConductLabel": "Conduct",
    "ConductsLabel": "Conducts",
    "CreatedDateTime": "2026-03-28 14:50:11.710000",
    "DeadlineLabel": "Deadline",
    "DeadlinesLabel": "Deadlines",
    "DescriptionLabel": "Description",
    "EmployeeCodeLabel": "Employee Code",
    "EmployeeLabel": "Employee",
    "EmployeesLabel": "Employees",
    "EndTimeLabel": "End Time",
    "EndingBalanceLabel": "Ending Balance",
    "EstimateLabel": "Estimate",
    "EstimatedTimeLabel": "Estimated time",
    "EstimatesLabel": "Estimates",
    "EstimationLabel": "Estimation",
    "EstimationsLabel": "Estimations",
    "ExpectedWorkingHoursLabel": "Expected Working Hours",
    "ExtensionLabel": "Extension",
    "ExtensionsLabel": "Extensions",
    "GoalLabel": "Module",
    "GoalsLabel": "Modules",
    "IdleHoursLabel": "Idle Hours",
    "IdleHoursPercentLabel": "Idle Hours %",
    "IdleLabel": "Idle",
    "LocationLabel": "Location",
    "NeutralHoursLabel": "Neutral Hours",
    "NeutralHoursPercentLabel": "Neutral Hours %",
    "NeutralLabel": "Neutral",
    "NeutralTAFSLabel": "Neutral(TAFS)",
    "NeutralTOSLabel": "Neutral(TOS)",
    "NewWorkItemsLabel": "New Work Items",
    "NoImpactHoursLabel": "No Impact Hours",
    "NoImpactHoursPercentLabel": "No Impact Hours %",
    "NoImpactLabel": "No Impact",
    "NoImpactTAFSLabel": "NoImpact(TAFS)",
    "NoImpactTOSLabel": "NoImpact(TOS)",
    "NonProductiveHoursLabel": "Non-Productive Hours",
    "NonProductiveHoursPercentLabel": "Non-Productive Hours %",
    "NonProductiveLabel": "Non-productive",
    "NonProductiveTAFSLabel": "NonProductive(TAFS)",
    "NonProductiveTOSLabel": "NonProductive(TOS)",
    "OfflineHoursLabel": "Offline Hours",
    "OfflineLabel": "Offline",
    "OfflineTAFSLabel": "Offline(TAFS)",
    "OnHoldLabel": "On Hold",
    "OnlineHoursLabel": "Online Hours",
    "OpeningBalanceLabel": "Opening Balance",
    "ProductiveHoursLabel": "Productive Hours",
    "ProductiveHoursPercentLabel": "Productive Hours %",
    "ProductiveLabel": "Productive",
    "ProductiveTAFSLabel": "Productive(TAFS)",
    "ProductiveTOSLabel": "Productive(TOS)",
    "ProjectLabel": "Project",
    "ProjectsLabel": "Projects",
    "ReportLabel": "Report",
    "ReportsLabel": "Reports",
    "RunLabel": "Test run",
    "RunsLabel": "Test runs",
    "ScenarioLabel": "Test suite",
    "ScenariosLabel": "Test suites",
    "ScheduledVsActualsLabel": "Scheduled vs Actuals",
    "SchedulesLabel": "Schedules",
    "SoftLabelConfigurationId": "85ACDD48-80CB-4FE0-90FD-29B06E7EE87A",
    "StartTimeLabel": "Start Time",
    "TakenBackByClientLabel": "Taken Back by Client",
    "TeamLabel": "Team",
    "TeamNameLabel": "Team Name",
    "TeamsLabel": "Teams",
    "TestReportLabel": "Test report",
    "TestReportsLabel": "Test reports",
    "TimeAwayFromSystemTAFSLabel": "TimeAwayFromSystem(TAFS)",
    "TimeOnSystemTOSLabel": "TimeOnSystem(TOS)",
    "TimeStamp": "b\u0027\\x00\\x00\\x00\\x00\\x009K\\xf9\u0027",
    "TimelineLabel": "Timeline",
    "TotalHoursLabel": "Total Hours",
    "TotalHoursPercentLabel": "Total Hours %",
    "UserNameLabel": "Username",
    "UserStoriesLabel": "Tasks",
    "UserStoryLabel": "Task",
    "VersionLabel": "Version",
    "VersionsLabel": "Versions",
    "WorkItemTypeLabel": "Task Type",
    "WorkItemTypesLabel": "Task Types",
    "WorkingHoursLabel": "Working Hours",
    "WorkingHoursPercentLabel": "Working Hours %"
  }
}
Raw JSON
{"associates": [{"UserId": "21AD8549-6102-4109-BB52-C88A03D7D570", "CompanyId": "6E919CFE-74DD-4EBC-8665-3C0D44866649", "UserName": "Sanjeet Kumar", "UserEmail": "Sanjeet.Kumar@kwglobal.com", "TotalTime": "6h 25m", "TotalDeskTime": "6h 24m", "DeskTime": 384, "ProductiveTime": "3h 40m", "UnProductiveTime": "0h 0m", "NeutralTime": "2h 44m", "NoImpactTime": "0h 0m", "TotalIdleTime": "0h 0m", "MostUsedApps": "<ApplicationReports><ApplicationReportModel><ApplicationName>Idle (Meeting)</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>sheridan.jira.com</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>outlook.cloud.microsoft</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>Idle (Meeting)</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>Idle (Meeting)</ApplicationName></ApplicationReportModel></ApplicationReports>", "Commits": null, "WorkItemsActivity": null, "LoggedWorkItems": null, "IsAttendanceBasedOnTracking": true, "IsUserHavingShift": true, "StartTime": "11:30 AM", "FinishTime": "05:55 PM", "MessageEnum": 0, "IsNoImpactEnabled": false}], "app_usage": [{"ApplicationName": "firefox", "TotalDuration": "03:24:08", "Percentage": "25.66", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "Idle (Meeting)", "TotalDuration": "01:51:10", "Percentage": "13.97", "ProductivityRanking": "Neutral", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "TimeChamp", "TotalDuration": "00:45:19", "Percentage": "5.70", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "EXCEL", "TotalDuration": "00:43:14", "Percentage": "5.43", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "OUTLOOK", "TotalDuration": "00:34:58", "Percentage": "4.40", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "iPSMonitor", "TotalDuration": "00:30:47", "Percentage": "3.87", "ProductivityRanking": "Neutral", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "explorer", "TotalDuration": "00:27:52", "Percentage": "3.50", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "ms-teams", "TotalDuration": "00:22:45", "Percentage": "2.86", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "mstsc", "TotalDuration": "00:05:37", "Percentage": "0.71", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "FoxitPDFEditor", "TotalDuration": "00:03:14", "Percentage": "0.41", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "ShellHost", "TotalDuration": "00:02:17", "Percentage": "0.29", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "jp2launcher", "TotalDuration": "00:02:00", "Percentage": "0.25", "ProductivityRanking": "Neutral", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "ShellExperienceHost", "TotalDuration": "00:01:58", "Percentage": "0.25", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "chrome", "TotalDuration": "00:01:39", "Percentage": "0.21", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "SnippingTool", "TotalDuration": "00:00:59", "Percentage": "0.12", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "Notepad", "TotalDuration": "00:00:48", "Percentage": "0.10", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "ApplicationFrameHost", "TotalDuration": "00:00:44", "Percentage": "0.09", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "WINWORD", "TotalDuration": "00:00:35", "Percentage": "0.07", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "SearchHost", "TotalDuration": "00:00:28", "Percentage": "0.06", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "mspaint", "TotalDuration": "00:00:08", "Percentage": "0.02", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "java", "TotalDuration": "00:00:07", "Percentage": "0.01", "ProductivityRanking": "Neutral", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "StartMenuExperienceHost", "TotalDuration": "00:00:04", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "timedoctor2", "TotalDuration": "00:00:03", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "Idle (Meeting)", "TotalDuration": "02:44:08", "Percentage": "20.63", "ProductivityRanking": "Neutral", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "ms-teams", "TotalDuration": "00:27:39", "Percentage": "3.48", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "POWERPNT", "TotalDuration": "00:22:55", "Percentage": "2.88", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "mstsc", "TotalDuration": "00:13:46", "Percentage": "1.73", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "msedge", "TotalDuration": "00:10:29", "Percentage": "1.32", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "EXCEL", "TotalDuration": "00:06:18", "Percentage": "0.79", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "explorer", "TotalDuration": "00:04:58", "Percentage": "0.62", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "TimeChamp", "TotalDuration": "00:03:40", "Percentage": "0.46", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "SnippingTool", "TotalDuration": "00:00:15", "Percentage": "0.03", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "ShellHost", "TotalDuration": "00:00:08", "Percentage": "0.02", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "CredentialUIBroker", "TotalDuration": "00:00:07", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "SearchHost", "TotalDuration": "00:00:06", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "LockApp", "TotalDuration": "00:00:03", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "BingWallpaper", "TotalDuration": "00:00:02", "Percentage": "0.00", "ProductivityRanking": "Neutral", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "M365Copilot", "TotalDuration": "00:00:01", "Percentage": "0.00", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}], "web_usage": [{"ApplicationName": "sheridan.jira.com", "TotalDuration": "00:38:33", "Percentage": "22.86", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "assist.zoho.in", "TotalDuration": "00:00:11", "Percentage": "0.11", "ProductivityRanking": "Neutral", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "assist.zoho.in", "TotalDuration": "00:00:11", "Percentage": "0.11", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "sheridan.jira.com", "TotalDuration": "00:50:29", "Percentage": "29.94", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "outlook.cloud.microsoft", "TotalDuration": "00:46:28", "Percentage": "27.55", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "www.youtube.com", "TotalDuration": "00:19:39", "Percentage": "11.65", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "www.dell.com", "TotalDuration": "00:06:28", "Percentage": "3.83", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "msedge", "TotalDuration": "00:02:49", "Percentage": "1.67", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "www.bing.com", "TotalDuration": "00:01:32", "Percentage": "0.91", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "teams.cloud.microsoft", "TotalDuration": "00:00:44", "Percentage": "0.43", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "www.msn.com", "TotalDuration": "00:00:25", "Percentage": "0.25", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "accounts.google.com", "TotalDuration": "00:00:23", "Percentage": "0.23", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "aka.ms", "TotalDuration": "00:00:20", "Percentage": "0.20", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "www.hemmersbach.com", "TotalDuration": "00:00:17", "Percentage": "0.17", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "mail.google.com", "TotalDuration": "00:00:07", "Percentage": "0.07", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "gmail.com", "TotalDuration": "00:00:02", "Percentage": "0.02", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}], "category_usage": [{"ApplicationCategoryName": "Office Apps", "TotalDuration": "05:03", "Percentage": "31.595", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "Others", "TotalDuration": "02:24", "Percentage": "15.016", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "PRINT ACCOUNT_IDC", "TotalDuration": "01:41", "Percentage": "10.532", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "Development", "TotalDuration": "00:21", "Percentage": "2.190", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "Work Apps/URLs", "TotalDuration": "00:06", "Percentage": "0.626", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "HE and STM Apps", "TotalDuration": "00:02", "Percentage": "0.209", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "BackGround", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "PRINT ACCOUNT_IDC", "TotalDuration": "03:22", "Percentage": "21.064", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationCategoryName": "Others", "TotalDuration": "02:44", "Percentage": "17.101", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationCategoryName": "Work Apps/URLs", "TotalDuration": "00:13", "Percentage": "1.356", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationCategoryName": "Office Apps", "TotalDuration": "00:03", "Percentage": "0.313", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationCategoryName": "HE and STM Apps", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}], "timesheet": [{"TimeSheetId": "8D27DB6A-C11D-4DE2-AB30-1C13A391B380", "UserId": "F4E91544-2B17-4462-ADB8-A6E77A859921", "UserName": "amlesh.singh@kwglobal.com", "TeamName": "KGL", "IsNoImpactEnabled": false, "RoleName": " Manager", "ReportToEmployeeName": "Jaisingh Varma", "ReportToEmployeeMail": "Jaisingh.Varma@kwglobal.com", "Shift": "09:00 IST - 17:30 IST", "DepartmentName": "Support Function (IT)-System Admin", "MobileNo": null, "Date": "2026-07-24T00:00:00", "ActiveTimeInSec": 32813, "ProductiveTimeInSec": 24155, "UnProductiveTimeInSec": 0, "NeutralTimeInSec": 8658, "NoImpactTimeInSec": 0, "TotalIdleTime": 0, "UserBreaksCount": 0, "EmployeeName": "Amlesh Singh", "UserProfileImage": null, "TimeZoneId": "C527B633-9FB6-4D9F-BE87-5172DBE87D18", "LunchBreakEndTime": null, "LunchBreakStartTime": null, "InTime": "2026-07-24T10:53:21.590509+05:30", "InTimeAbbreviation": null, "OutTimeAbbreviation": null, "LunchStartAbbreviation": null, "LunchEndAbbreviation": null, "InTimeTimeZone": null, "OutTimeTimeZone": null, "LunchStartTimeZone": null, "LunchEndTimeZone": null, "OutTime": "2026-07-24T20:00:14.794785+05:30", "PunchCardBased": false, "LatestInsertedTrackerDate": null, "LunchBreakDiff": null, "UsersBreakTime": null, "IsNextDay": 0, "SpentTimeDiff": 32813, "TotalOfflineTime": 0, "LunchTimeInSec": null, "UsersBreakTimeInSec": 0, "EmployeeNumber": "42452", "LoggedTime": null, "AttendanceStatus": "", "BranchName": "KGL-IT", "DesktopName": "XINNDNLEN0123", "TotalSpentTime": 101.11, "FullDayMinimumHours": 7.0, "HalfDayMinimumHours": 3.0, "AbsentDayMinimumHours": 3.0, "AttendanceAbsentTime": 546, "AttendanceHalfOrFullDayTime": 546, "IsAttendacneBasedOnPercentage": false, "TotalTimeInSec": 32813}, {"TimeSheetId": "8BEBFE70-C42E-490E-AFA0-121DC6386CD4", "UserId": "21AD8549-6102-4109-BB52-C88A03D7D570", "UserName": "Sanjeet.Kumar@kwglobal.com", "TeamName": "KGL", "IsNoImpactEnabled": false, "RoleName": " User", "ReportToEmployeeName": "Amlesh Singh", "ReportToEmployeeMail": "Amlesh.Singh@kwglobal.com", "Shift": "08:30 IST - 17:30 IST", "DepartmentName": "Support Function (IT)-System Admin", "MobileNo": null, "Date": "2026-07-24T00:00:00", "ActiveTimeInSec": 23070, "ProductiveTimeInSec": 13220, "UnProductiveTimeInSec": 0, "NeutralTimeInSec": 9850, "NoImpactTimeInSec": 0, "TotalIdleTime": 0, "UserBreaksCount": 0, "EmployeeName": "Sanjeet Kumar", "UserProfileImage": null, "TimeZoneId": "C527B633-9FB6-4D9F-BE87-5172DBE87D18", "LunchBreakEndTime": null, "LunchBreakStartTime": null, "InTime": "2026-07-24T11:30:32.895295+05:30", "InTimeAbbreviation": null, "OutTimeAbbreviation": null, "LunchStartAbbreviation": null, "LunchEndAbbreviation": null, "InTimeTimeZone": null, "OutTimeTimeZone": null, "LunchStartTimeZone": null, "LunchEndTimeZone": null, "OutTime": "2026-07-24T17:55:04.250286+05:30", "PunchCardBased": false, "LatestInsertedTrackerDate": null, "LunchBreakDiff": null, "UsersBreakTime": null, "IsNextDay": 0, "SpentTimeDiff": 23072, "TotalOfflineTime": 2, "LunchTimeInSec": null, "UsersBreakTimeInSec": 0, "EmployeeNumber": "47602", "LoggedTime": null, "AttendanceStatus": "", "BranchName": "KGL-IT", "DesktopName": "XINNDDELL0899", "TotalSpentTime": 71.11, "FullDayMinimumHours": 8.0, "HalfDayMinimumHours": 4.0, "AbsentDayMinimumHours": 4.0, "AttendanceAbsentTime": 384, "AttendanceHalfOrFullDayTime": 384, "IsAttendacneBasedOnPercentage": false, "TotalTimeInSec": 23072}], "soft_labels": {"SoftLabelConfigurationId": "85ACDD48-80CB-4FE0-90FD-29B06E7EE87A", "ProjectLabel": "Project", "GoalLabel": "Module", "EmployeeLabel": "Employee", "EmployeeCodeLabel": "Employee Code", "UserStoryLabel": "Task", "DeadlineLabel": "Deadline", "ProjectsLabel": "Projects", "GoalsLabel": "Modules", "EmployeesLabel": "Employees", "UserStoriesLabel": "Tasks", "DeadlinesLabel": "Deadlines", "ScenarioLabel": "Test suite", "ScenariosLabel": "Test suites", "RunLabel": "Test run", "RunsLabel": "Test runs", "VersionLabel": "Version", "VersionsLabel": "Versions", "TestReportLabel": "Test report", "TestReportsLabel": "Test reports", "EstimatedTimeLabel": "Estimated time", "EstimationLabel": "Estimation", "EstimationsLabel": "Estimations", "EstimateLabel": "Estimate", "EstimatesLabel": "Estimates", "AuditLabel": "Audit", "AuditsLabel": "Audits", "ConductLabel": "Conduct", "ConductsLabel": "Conducts", "ActionLabel": "Action", "ActionsLabel": "Actions", "TimelineLabel": "Timeline", "AuditActivityLabel": "Audit activity", "AuditReportLabel": "Audit report", "AuditReportsLabel": "Audit reports", "ReportLabel": "Report", "ReportsLabel": "Reports", "AuditAnalyticsLabel": "Audit analytics", "AuditQuestionLabel": "Question", "AuditQuestionsLabel": "Question", "ExtensionLabel": "Extension", "ExtensionsLabel": "Extensions", "StartTimeLabel": "Start Time", "EndTimeLabel": "End Time", "ProductiveHoursLabel": "Productive Hours", "ProductiveHoursPercentLabel": "Productive Hours %", "AvgProductiveHoursLabel": "Avg Productive Hours", "NonProductiveHoursLabel": "Non-Productive Hours", "NonProductiveHoursPercentLabel": "Non-Productive Hours %", "NeutralHoursLabel": "Neutral Hours", "NeutralHoursPercentLabel": "Neutral Hours %", "IdleHoursLabel": "Idle Hours", "IdleHoursPercentLabel": "Idle Hours %", "OfflineHoursLabel": "Offline Hours", "AwayHoursLabel": "Away Hours", "WorkingHoursLabel": "Working Hours", "WorkingHoursPercentLabel": "Working Hours %", "AvgWorkingHoursLabel": "Avg Working Hours", "ExpectedWorkingHoursLabel": "Expected Working Hours", "ActualWorkingHoursLabel": "Actual Working Hours", "TotalHoursLabel": "Total Hours", "TotalHoursPercentLabel": "Total Hours %", "AvgTotalHoursLabel": "Avg Total Hours", "OnlineHoursLabel": "Online Hours", "AvgOnlineHoursLabel": "Avg Online Hours", "LocationLabel": "Location", "ProductiveTOSLabel": "Productive(TOS)", "NonProductiveTOSLabel": "NonProductive(TOS)", "NeutralTOSLabel": "Neutral(TOS)", "TimeOnSystemTOSLabel": "TimeOnSystem(TOS)", "ProductiveTAFSLabel": "Productive(TAFS)", "NonProductiveTAFSLabel": "NonProductive(TAFS)", "NeutralTAFSLabel": "Neutral(TAFS)", "OfflineTAFSLabel": "Offline(TAFS)", "TimeAwayFromSystemTAFSLabel": "TimeAwayFromSystem(TAFS)", "SchedulesLabel": "Schedules", "ActualShiftLabel": "Actual Shift", "ScheduledVsActualsLabel": "Scheduled vs Actuals", "UserNameLabel": "Username", "TeamLabel": "Team", "TeamsLabel": "Teams", "TeamNameLabel": "Team Name", "WorkItemTypeLabel": "Task Type", "WorkItemTypesLabel": "Task Types", "ClaimedTimeLabel": "Claimed Time", "OpeningBalanceLabel": "Opening Balance", "NewWorkItemsLabel": "New Work Items", "CompletedWorkItemsLabel": "Completed Work Items", "OnHoldLabel": "On Hold", "TakenBackByClientLabel": "Taken Back by Client", "EndingBalanceLabel": "Ending Balance", "DescriptionLabel": "Description", "ProductiveLabel": "Productive", "NonProductiveLabel": "Non-productive", "NeutralLabel": "Neutral", "IdleLabel": "Idle", "OfflineLabel": "Offline", "NoImpactHoursLabel": "No Impact Hours", "NoImpactHoursPercentLabel": "No Impact Hours %", "NoImpactLabel": "No Impact", "NoImpactTAFSLabel": "NoImpact(TAFS)", "NoImpactTOSLabel": "NoImpact(TOS)", "CompanyId": "6E919CFE-74DD-4EBC-8665-3C0D44866649", "CreatedDateTime": "2026-03-28 14:50:11.710000", "TimeStamp": "b'\\x00\\x00\\x00\\x00\\x009K\\xf9'"}, "row_counts": {"associates": 1, "app_usage": 38, "web_usage": 16, "category_usage": 12, "timesheet": 2}}

Stage 3 — Rendered

Rendered 2026-07-25 02:31:34.739155 · 29258 bytes

Subject: Daily associates summary report - Jul 24, 2026

Attachments
[{"name": "ManagerDailyAssociateSummaryReport_2026-07-24.xlsx", "path": "runs/eef9ed32-977d-4da8-b9f6-7523a880bb0d-attachments/F4E91544-2B17-4462-ADB8-A6E77A859921-ManagerDailyAssociateSummaryReport_2026-07-24.xlsx", "sizeBytes": 10070, "contentType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "kind": "xlsx"}]
Body HTML (source)
<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
  <meta name="x-apple-disable-message-reformatting" />
  <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  <title>Account Password Reset</title>
  <style type="text/css">
    a {
      text-decoration: none;
      outline: none;
    }

    p {
      font-size: 14px;
      font-family: Roboto;
    }

    b {
      font-size: 14px;
      font-family: Roboto;
    }

    @media (max-width: 649px) {
      .o_col-full {
        max-width: 100% !important;
      }

      .o_col-half {
        max-width: 50% !important;
      }

      .o_hide-lg {
        display: inline-block !important;
        font-size: inherit !important;
        max-height: none !important;
        line-height: inherit !important;
        overflow: visible !important;
        width: auto !important;
        visibility: visible !important;
      }

      .o_hide-xs,
      .o_hide-xs.o_col_i {
        display: none !important;
        font-size: 0 !important;
        max-height: 0 !important;
        width: 0 !important;
        line-height: 0 !important;
        overflow: hidden !important;
        visibility: hidden !important;
        height: 0 !important;
      }

      .o_xs-center {
        text-align: center !important;
      }

      .o_xs-left {
        text-align: left !important;
      }

      .o_xs-right {
        text-align: left !important;
      }

      table.o_xs-left {
        margin-left: 0 !important;
        margin-right: auto !important;
        float: none !important;
      }

      table.o_xs-right {
        margin-left: auto !important;
        margin-right: 0 !important;
        float: none !important;
      }

      table.o_xs-center {
        margin-left: auto !important;
        margin-right: auto !important;
        float: none !important;
      }

      h1.o_heading {
        font-size: 32px !important;
        line-height: 41px !important;
      }

      h2.o_heading {
        font-size: 26px !important;
        line-height: 37px !important;
      }

      h3.o_heading {
        font-size: 20px !important;
        line-height: 30px !important;
      }

      .o_xs-py-md {
        padding-top: 24px !important;
        padding-bottom: 24px !important;
      }

      .o_xs-pt-xs {
        padding-top: 8px !important;
      }

      .o_xs-pb-xs {
        padding-bottom: 8px !important;
      }
    }

    @media screen {
      @font-face {
        font-family: Roboto;
        font-style: normal;
        font-weight: 400;
        src: local("Roboto"), local("Roboto-Regular"), url(https://fonts.gstatic.com/s/roboto/v18/KFOmCnqEu92Fr1Mu7GxKOzY.woff2) format("woff2");
        unicode-range: U+0100-024F, U+0259, U+1E00-1EFF, U+2020, U+20A0-20AB, U+20AD-20CF, U+2113, U+2C60-2C7F, U+A720-A7FF;
      }

      @font-face {
        font-family: Roboto;
        font-style: normal;
        font-weight: 400;
        src: local("Roboto"), local("Roboto-Regular"), url(https://fonts.gstatic.com/s/roboto/v18/KFOmCnqEu92Fr1Mu4mxK.woff2) format("woff2");
        unicode-range: U+0000-00FF, U+0131, U+0152-0153, U+02BB-02BC, U+02C6, U+02DA, U+02DC, U+2000-206F, U+2074, U+20AC, U+2122, U+2191, U+2193, U+2212, U+2215, U+FEFF, U+FFFD;
      }

      @font-face {
        font-family: Roboto;
        font-style: normal;
        font-weight: 700;
        src: local("Roboto Bold"), local("Roboto-Bold"), url(https://fonts.gstatic.com/s/roboto/v18/KFOlCnqEu92Fr1MmWUlfChc4EsA.woff2) format("woff2");
        unicode-range: U+0100-024F, U+0259, U+1E00-1EFF, U+2020, U+20A0-20AB, U+20AD-20CF, U+2113, U+2C60-2C7F, U+A720-A7FF;
      }

      @font-face {
        font-family: Roboto;
        font-style: normal;
        font-weight: 700;
        src: local("Roboto Bold"), local("Roboto-Bold"), url(https://fonts.gstatic.com/s/roboto/v18/KFOlCnqEu92Fr1MmWUlfBBc4.woff2) format("woff2");
        unicode-range: U+0000-00FF, U+0131, U+0152-0153, U+02BB-02BC, U+02C6, U+02DA, U+02DC, U+2000-206F, U+2074, U+20AC, U+2122, U+2191, U+2193, U+2212, U+2215, U+FEFF, U+FFFD;
      }

      .o_sans,
      .o_heading {
        font-family: "Roboto", sans-serif !important;
      }

      .o_heading,
      strong,
      b {
        font-weight: 700 !important;
      }

      a[x-apple-data-detectors] {
        color: inherit !important;
        text-decoration: none !important;
      }
    }
  </style>
  <!--[if mso]>              <style>                  table {                      border-collapse: collapse;                  }                  .o_col {                      float: left;                  }              </style>              <xml>                  <o:OfficeDocumentSettings> <o:PixelsPerInch>96</o:PixelsPerInch> </o:OfficeDocumentSettings>              </xml>          <![endif]-->
</head>

<body class="o_body o_bg-light"
  style="width: 100%; margin: 0px; padding: 0px; -webkit-text-size-adjust: 100%; -ms-text-size-adjust: 100%; background-color: #f9f8fa;">
  <!-- preview-text -->
  <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
    <tbody>
      <tr>
        <td class="o_hide" align="center"
          style="display: none; font-size: 0; max-height: 0; width: 0; line-height: 0; overflow: hidden; mso-hide: all; visibility: hidden;">
          Email Summary (Hidden)</td>
      </tr>
    </tbody>
  </table> <!-- header-white-link -->
  <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
  <tbody>
    <tr>
      <td class="o_bg-light o_px-xs" align="center"
        style="background-color: #f9f8fa; padding-left: 8px; padding-right: 8px;">
        <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
          style="max-width: 700px; margin: 0 auto;">
          <tbody>
            <tr>
              <td style="padding: 10px 0; text-align: left;">
               
              </td>
            </tr>
          </tbody>
        </table>
      </td>
    </tr>
  </tbody>
</table>

<table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" 
       style="background-color:#f9f8fa; margin:0; padding:0;">
  <tbody>
    <tr>
      <td align="center">
        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style=" max-width:700px;">
          <tbody>
            <tr>
              <td align="center" style="max-width:700px;">
                <div style=" text-align:center;  max-width:700px;">
                  <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
    <tbody>
      <tr>
        <td class="o_bg-light o_px-xs o_pt-lg o_xs-pt-xs" align="center"
          style="background-color: #f9f8fa;">
          <!--[if mso]><table width="632" cellspacing="0" cellpadding="0" border="0" role="presentation"><tbody><tr><td><![endif]-->
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="margin: 0 auto;">
            <tbody>
              <tr>
                <td class="o_re o_bg-white o_px o_pb-md o_br-t" align="center"
                  style="font-size: 0;vertical-align: top;background-color: #ecf9fb;border-radius: 4px 4px 0px 0px;padding-left: 16px;padding-right: 16px;padding-top: 7px;padding-bottom: 7px;">
                  <!--[if mso]><table cellspacing="0" cellpadding="0" border="0" role="presentation"><tbody><tr><td width="200" align="left" valign="top" style="padding:0px 8px;"><![endif]-->
                  <div class="o_col o_col-2"
                    style="display: inline-block;vertical-align: top;width: 100%;max-width: 200px;">
                    <div class="o_px-xs o_sans o_text o_left o_xs-center"
                      style="font-family: Helvetica, Arial, sans-serif;margin-top: 0px;margin-bottom: 0px;font-size: 16px;line-height: 24px;text-align: center;padding-left: 8px;padding-right: 8px;">
                      <p style="margin-top: 0px;margin-bottom: 0px;"><a class="o_text-primary"
                          style="text-decoration: none;outline: none;color: #126de5;"><img
                            src="https://timechampimages.blob.core.windows.net/icons/timechamp_logo.png" width="150" height="36"
                            style="max-width: 150px;-ms-interpolation-mode: bicubic;vertical-align: middle;border: 0;line-height: 100%;height: auto;outline: none;text-decoration: none;"></a>
                      </p>
                    </div>
                  </div>
                </td>
              </tr>
            </tbody>
          </table>
        </td>
      </tr>
    </tbody>
  </table>
                </div>
              </td>
            </tr>
          </tbody>
        </table>
      </td>
    </tr>
  </tbody>
</table>
  <!-- hero-icon-lines -->
  <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
    <tbody>
      <tr>
        <td class="o_bg-light o_px-xs" align="center"
          style="background-color: #f9f8fa; padding-left: 8px; padding-right: 8px;">
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="max-width: 700px; margin: 0 auto;">
            <tbody>
              <tr>
                <td class="o_bg-ultra_light o_px-md o_py-xl o_xs-py-md o_sans o_text-md o_text-light" align="center"
                  style="                                              font-family: Helvetica, Arial, sans-serif;                                              margin-top: 0px;                                              margin-bottom: 0px;                                              font-size: 19px;                                              line-height: 28px;                                              background-color: white;                                              color: #82899a;                                              padding-left: 24px;                                              padding-right: 24px;                                              padding-top: 10px;                                              padding-bottom: 10px;                                          ">
                  <p
                    style="font-size: 13pt; margin-top: 0px; margin-bottom: 10px; color: #363636; font-family: roboto; text-align: left;">
                    <span style="font-weight: 600;">Hi Amlesh Singh,</span><br /> Here is the summary report of your
                    associates for <span style="font-weight: 600;"> Jul 24, 2026</span>. </p>
                </td>
              </tr>
              <tr>
                <td style="text-align: center;"> <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"><tbody>  <tr>    <td class="o_bg-light o_px-xs" align="center" style="background-color: #f9f8fa; max-width: 700px;">      <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style="max-width: 700px; margin: 0 auto; background-color: white;">        <tbody>          <tr>            <td style="padding: 0px 25px; font-weight: 600; font-family: Helvetica, Arial, sans-serif;">              <p style="margin-top: 10px; margin-bottom: 0px; color: #363636; font-weight:600;font-size: 13pt; letter-spacing: .5px;">Sanjeet Kumar</p>            </td>          </tr>        </tbody>      </table><table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style="max-width: 700px; margin: 0 auto; background-color: #ffffff;">  <tbody>    <tr>      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td  style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;border-right: 1px solid #dbe5ea;">                  <span style="color: #363636;">Start Time<br></span>                  <span style="color: #51A6DF;font-size: 14pt;">11:30 AM</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>      <td  class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;" >        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td  style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;border-right: 1px solid #dbe5ea;">                  <span style="color: #363636;">Finish Time<br></span>                  <span style="color: #F27575;font-size: 14pt; ">05:55 PM</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td  style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;border-right: 1px solid #dbe5ea;">                  <span style="color: #363636;">Desk Time<br></span>                  <span style="color: #5861AA;font-size: 14pt;">6h 24m</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>              <td  class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">                <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">                  <tbody>                    <tr>                      <td>                        <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;">                          <span style="color: #363636;">Productive Hours<br></span>                          <span style="color: #4CC96D;font-size: 14pt; ">3h 40m</span>                        </p>                      </td>                    </tr>                  </tbody>                </table>              </td>          </tr>        </tbody>      </table><table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style="max-width: 700px; margin: 0 auto;">  <tbody>    <tr>      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top; ">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td   style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;border-right: 1px solid #dbe5ea;">                  <span style="color: #363636;">Non-Productive Hours<br></span>                  <span style="color: #F27575;font-size: 14pt; ">0h 0m</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>      <td  class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td  style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;border-right: 1px solid #dbe5ea;">                  <span style="color: #363636;">Neutral Time<br></span>                  <span style="color: #A4A9D0;font-size: 14pt; ">2h 44m</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center">                  <span style="color: #363636;">Idle Time<br></span>                  <span style="color: #D2BB45;font-size: 14pt; ">0h 0m</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"  style="display:none;">          <tbody>            <tr>              <td >                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center">                  <span style="color: #363636;">No Impact Time<br></span>                  <span style="color: #D2BB45;font-size: 14pt; ">0h 0m</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>    </tr>  </tbody></table><table width="100%" cellspacing="0"  style="max-width: 700px; margin: 0 auto;" cellpadding="0" border="0" role="presentation">  <tbody>    <tr style="border-bottom: 1px solid #dbe5ea;">      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="left" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 13pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-left: 24px; padding-right: 24px; padding-top: 16px; padding-bottom: 10px; vertical-align: top;">        <p style="margin-top: 10px; margin-bottom: 5px; color: #363636;font-weight:600;font-size:11pt">Most Used Applications & Websites : </p>        <div style="margin: 0px">           <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;"><span style = "color: #363636; margin: 0px;font-size: 35px; font-weight: bold;" >.</span> Idle (Meeting) </p>  <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;"><span style = "color: #363636; margin: 0px;font-size: 35px; font-weight: bold;" >.</span> sheridan.jira.com </p>  <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;"><span style = "color: #363636; margin: 0px;font-size: 35px; font-weight: bold;" >.</span> outlook.cloud.microsoft </p>  <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;"><span style = "color: #363636; margin: 0px;font-size: 35px; font-weight: bold;" >.</span> Idle (Meeting) </p>  <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;"><span style = "color: #363636; margin: 0px;font-size: 35px; font-weight: bold;" >.</span> Idle (Meeting) </p>         </div>      </td>    </tr>  </tbody></table><table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style="max-width: 632px; margin: 0 auto;">  <tbody>    <tr><td><table style="width: 100%; border-collapse: collapse; max-width: 632px; margin: 0 auto;">  <tbody><tr><td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="left" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 16px; line-height: 24px; background-color: #ffffff; color: #424651; border-top: 1px solid #d3dce0;"></td></tr>  </tbody></table></td>    </tr>  </tbody></table></td>            </tr>          </tbody>        </table> <!-- footer-white-2cols --> </td>
              </tr>
            </tbody>
          </table>
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="max-width: 700px; margin: 0 auto;">
            <tbody>
              <tr style="margin-bottom: 0px; background-color: white;">
                <td align="left"
                  style="background-color: white; align-items: center; flex-direction: row; padding-left: 24px; line-height: 30px; padding-right: 24px; padding-top: 10px; padding-bottom: 10px;">
                  <p> <b>Best Regards,</b><br /> <img src="https://i.stack.imgur.com/SRhpR.png" alt="signature"
                      style="margin-left: -1px; width: 100px;" /> </p>
                </td>
              </tr>
              <tr style="margin-bottom: 0px; background-color: white;">
                <td style="height: 10px;"></td>
              </tr>
            </tbody>
          </table>
        </td>
      </tr>
    </tbody>
  </table>
 <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" 
       style="background-color:#f9f8fa; margin:0; padding:0;">
  <tbody>
    <tr>
      <td align="center">
        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style=" max-width:700px;">
          <tbody>
            <tr>
              <td align="center" style="max-width:700px;">
                <div style="text-align:center; max-width:700px;">
                  <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
    <tbody>
      <tr>
        <td class="o_bg-light o_px-xs o_pb-lg o_xs-pb-xs" align="center"
          style="background-color: #f9f8fa;padding-bottom:32px;white-space: nowrap;">
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="margin:0 auto;">
            <tbody>
              <tr style="background-color: #ecf9fb;">
                <td class="o_re o_px o_pb-lg" style="font-size:0;padding-left:10px;">
                  <div class="small_font ccc"
                    style="display:inline-block;vertical-align:top;width:100%;max-width:200px">
                    <div class="o_px-xs o_sans o_text-xs o_text-dark_light o_left o_xs-center"
                      style="font-family:Helvetica,Arial,sans-serif;margin-bottom:0;font-size:14px;text-align:left;padding-left:8px;padding-right:8px;white-space: nowrap;">
                      <p style="margin-top:0;margin-bottom:0" class="small_font">For support <a class="small_font"
                          class="o_text-dark_light o_underline"
                          href="https://timechamp.freshdesk.com/support/solutions/articles/101000451716" target="_blank"
                          style="outline:0;color:#1e9999;text-decoration: none;">Contact us</a> </p>
                    </div>
                  </div>
                </td>
                <td style="height: 35px;white-space: nowrap;">
                  <div class="small_font ccc"
                    style="display:inline-block;vertical-align:top;width:100%;max-width:135px">
                    <div class="o_px-xs o_sans o_text-xs o_text-dark_light o_left o_xs-center"
                      style="font-family:Helvetica,Arial,sans-serif;margin-bottom:0;font-size:14px;text-align:Center;padding-left:8px;padding-right:8px;white-space: nowrap;">
                      <span><a class="small_font" href="https://timechamp.io/documents/TimeChampTermsAndConditions.pdf"
                          target="_blank" style="color: #1e9999;text-decoration: none;padding-left: 8px;">Terms &
                          Conditions</a> </span> </div>
                  </div>
                <td>
                  <div class="small_font"
                    style="display:inline-block;vertical-align:top;width:100%;max-width:200px;white-space: nowrap;">
                    <div class="o_px-xs o_sans o_text-xs o_text-dark_light o_right"
                      style="font-family:Helvetica,Arial,sans-serif;margin-top:0;margin-bottom:0;font-size:15px;line-height:21px;text-align:right;padding-left:8px;padding-right:8px;white-space: nowrap;">
                      <p style="margin-top:0;margin-bottom:0"> <a class="o_text-dark_light"
                          href="https://www.youtube.com/@timechamp_io" target="_blank"
                          style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/youtube_logo.png" width="19" height="19" alt="fb"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a><span>&nbsp;</span> <a class="o_text-dark_light" href="https://www.facebook.com/TimeChamp1/"
                          target="_blank" style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/facebook_logo.png" width="14" height="14" alt="fb"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a> <span>&nbsp;</span> <a class="o_text-dark_light" href="https://twitter.com/timechamp_io"
                          target="_blank" style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/twitter_logo.png" width="14" height="14" alt="tw"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a> <span>&nbsp;</span> <a class="o_text-dark_light"
                          href="https://www.linkedin.com/showcase/timechamp/" target="_blank"
                          style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/linkdin_logo.png" width="14" height="14" alt="ig"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a> <span>&nbsp;</span> <a class="o_text-dark_light"
                          href="https://www.instagram.com/timechamp.io/" target="_blank"
                          style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/instagram_logo.png" width="14" height="14" alt="ig"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a><span>&nbsp;&nbsp;&nbsp;</span> </p>
                    </div>
                  </div>
                </td>
              </tr>
            </tbody>
          </table>
          <div class="o_hide-xs" style="font-size:64px;line-height:64px;height:64px">&nbsp;</div>
        </td>
      </tr>
    </tbody>
  </table>
                </div>
              </td>
            </tr>
          </tbody>
        </table>
      </td>
    </tr>
  </tbody>
</table>
  
</body>

</html>
Rendered preview (sandboxed)

Stage 5 — Dispatched

Outcome
Inserted
SentMailId
EA8680C6-9ADA-448B-A014-A1C3A26CD186
Skip reason
Error
At
2026-07-25 02:31:35.029182

Events

AtStageLevelMessagemsWorker
2026-07-25 02:30:30.019004 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=Amlesh.Singh@kwglobal.com userId=F4E91544-2B17-4462-ADB8-A6E77A859921 thr-25972
2026-07-25 02:30:30.037011 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='F4E91544-2B17-4462-ADB8-A6E77A859921', @Date='2026-07-24') thr-25972
2026-07-25 02:30:31.637683 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 1 row(s) in 1583ms; cols=[UserId,CompanyId,UserName,UserEmail,TotalTime,TotalDeskTime,DeskTime,ProductiveTime,UnProductiveTime,NeutralTime,NoImpactTime,TotalIdleTime,MostUsedApps,Commits,WorkItemsActivity,LoggedWorkItems,IsAttendanceBasedOnTracking,IsUserHavingShift,StartTime,FinishTime,MessageEnum,IsNoImpactEnabled]; first_row={UserId=21AD8549-6102-4109-BB52-C88..., CompanyId=6E919CFE-74DD-4EBC-8665-3C0..., UserName=Sanjeet Kumar, UserEmail=Sanjeet.Kumar@kwglobal.com, TotalTime=6h 25m, TotalDeskTime=6h 24m, DeskTime=384, ProductiveTime=3h 40m} 1583 thr-25972
2026-07-25 02:30:31.651683 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-24', @IsApp=1, @IsForLineManager=1, @LineManagerId='F4E91544-2B17-4462-ADB8-A6E77A859921') thr-25972
2026-07-25 02:30:31.956362 DataFetch Info <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 38 row(s) in 288ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber]; first_row={ApplicationName=firefox, TotalDuration=03:24:08, Percentage=25.66, ProductivityRanking=Productive, UserName=Amlesh Singh, EmployeeNumber=42452} 288 thr-25972
2026-07-25 02:30:31.980367 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-24', @IsApp=0, @IsForLineManager=1, @LineManagerId='F4E91544-2B17-4462-ADB8-A6E77A859921') thr-25972
2026-07-25 02:30:32.023362 DataFetch Info <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 16 row(s) in 24ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber]; first_row={ApplicationName=sheridan.jira.com, TotalDuration=00:38:33, Percentage=22.86, ProductivityRanking=Productive, UserName=Amlesh Singh, EmployeeNumber=42452} 24 thr-25972
2026-07-25 02:30:32.033370 DataFetch Info >>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-24', @IsForLineManager=1, @LineManagerId='F4E91544-2B17-4462-ADB8-A6E77A859921') thr-25972
2026-07-25 02:30:32.630653 DataFetch Info <<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 12 row(s) in 590ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber]; first_row={ApplicationCategoryName=Office Apps, TotalDuration=05:03, Percentage=31.595, UserName=Amlesh Singh, EmployeeNumber=42452} 590 thr-25972
2026-07-25 02:30:32.647640 DataFetch Info >>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-07-24', @DateTo='2026-07-24', @OperationsPerformedBy='F4E91544-2B17-4462-ADB8-A6E77A859921', @EmployeeSearchText=NULL, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) thr-25972
2026-07-25 02:31:34.489434 DataFetch Info <<< USP_EmailComp_DownloadTimesheet returned 2 row(s) in 61832ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,Shift,DepartmentName,MobileNo,Date,ActiveTimeInSec,ProductiveTimeInSec,UnProductiveTimeInSec,NeutralTimeInSec,NoImpactTimeInSec,TotalIdleTime,UserBreaksCount,EmployeeName,UserProfileImage,TimeZoneId,LunchBreakEndTime,LunchBreakStartTime,InTime,InTimeAbbreviation,OutTimeAbbreviation,LunchStartAbbreviation,LunchEndAbbreviation,InTimeTimeZone,OutTimeTimeZone,LunchStartTimeZone,LunchEndTimeZone,OutTime,PunchCardBased,LatestInsertedTrackerDate,LunchBreakDiff,UsersBreakTime,IsNextDay,SpentTimeDiff,TotalOfflineTime,LunchTimeInSec,UsersBreakTimeInSec,EmployeeNumber,LoggedTime,AttendanceStatus,BranchName,DesktopName,TotalSpentTime,FullDayMinimumHours,HalfDayMinimumHours,AbsentDayMinimumHours,AttendanceAbsentTime,AttendanceHalfOrFullDayTime,IsAttendacneBasedOnPercentage,TotalTimeInSec]; first_row={TimeSheetId=8D27DB6A-C11D-4DE2-AB30-1C1..., UserId=F4E91544-2B17-4462-ADB8-A6E..., UserName=amlesh.singh@kwglobal.com, TeamName=KGL, IsNoImpactEnabled=False, RoleName= Manager, ReportToEmployeeName=Jaisingh Varma, Rep...} 61832 thr-25972
2026-07-25 02:31:34.494435 DataFetch Info Soft labels: batch-cache hit (105 keys) thr-25972
2026-07-25 02:31:34.505435 DataFetch Info AssociateSummary fetched — associates=1, app_usage=38, web_usage=16, category_usage=12, timesheet=2 thr-25972
2026-07-25 02:31:34.518435 DataFetch Info Wrote EmailComp_Job_Data (20098 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] 64481 thr-25972
2026-07-25 02:31:34.543440 Render Info --- Stage 3 begin --- template=AssociateSummary recipient=Amlesh.Singh@kwglobal.com thr-25972
2026-07-25 02:31:34.563438 Render Info dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) thr-25972
2026-07-25 02:31:34.763584 Render Info Rendered (29258 bytes, subject='Daily associates summary report - Jul 24, 2026', attachments=1) 223 thr-25972
2026-07-25 02:31:34.926177 QA Info QA passed (15 check(s)) 109 thr-25972
2026-07-25 02:31:34.937184 Dispatch Info >>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Amlesh.Singh@kwglobal.com', @Subject='Daily associates summary report - Jul 24, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='0ccf0ecd-f623-4b14-a81f-508f137aed17') thr-25972
2026-07-25 02:31:34.968178 Dispatch Info <<< USP_EmailComp_InsertMail returned MailId=ea8680c6-9ada-448b-a014-a1c3a26cd186 in 28ms (inserted) 28 thr-25972
2026-07-25 02:31:35.013184 Dispatch Info >>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=ea8680c6-9ada-448b-a014-a1c3a26cd186, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/a6351d871a384bca80369f9689f7eeb7_F4E91544-2B17-4462-ADB8-A6E77A859921-ManagerDailyAssociateSummaryReport_2026-07-24.xlsx') thr-25972
2026-07-25 02:31:35.017177 Dispatch Info <<< USP_EmailComp_InsertMailAttchment OK in 0ms 0 thr-25972
2026-07-25 02:31:35.024177 Dispatch Info Inserted into SentMail. MailId=ea8680c6-9ada-448b-a014-a1c3a26cd186 thr-25972