Job 4B18B49F-6F3F-476B-9787-90A43BB932C1

Dispatched Back to batch
Batch
8178A5B6-225C-4EE2-9656-96868CFC741B
Template
AssociateSummary
Recipient
Amlesh.Singh@kwglobal.com (Amlesh Singh)
User id
F4E91544-2B17-4462-ADB8-A6E77A859921
Status
Dispatched
Attempts
3
Claimed by
thr-17600 at 2026-07-31 02:31:49.163365
Created
2026-07-31 02:30:27.291083
Completed
2026-07-31 02:31:49.787843

Attachments — what the end user receives in the email

#FilenameSizeStatusAction
1 F4E91544-2B17-4462-ADB8-A6E77A859921-ManagerDailyAssociateSummaryReport_2026-07-30.xlsx
runs/8178a5b6-225c-4ee2-9656-96868cfc741b-attachments/F4E91544-2B17-4462-ADB8-A6E77A859921-ManagerDailyAssociateSummaryReport_2026-07-30.xlsx
- missing file missing

Stage 4 — QA gate

Pass
15 checks run · 15 pass · 0 warn · 0 fail/error · 1188 ms · evaluated 2026-07-31 02:31:49.053771
VerdictRuleExpected GotTime
Pass R1_RECIPIENT_EMAIL
Recipient's email address looks valid
severity: Block
A real email address (with @, no commas/semicolons/angle-brackets, max 320 characters)
valid: Amlesh.Singh@kwglobal.com
0 ms
Pass R2_RECIPIENT_ACTIVE
Recipient is an active employee in this company
severity: Block
Recipient is a current, active employee of this company
OK
46 ms
Pass R3_ACCESSIBLE_USERS
Recipient is a manager (has at least one team member)
severity: Block
Recipient is a manager who has at least one team member to report on (skipped for UrgentAttention -- those recipients are HR-scoped, not line-manager-scoped)
1 active reportee(s)
Total In Tree
2
Active Others
1
Inactive Others
0
110 ms
Pass R4_SUBJECT_NONEMPTY
Email has a clean, non-empty subject line
severity: Block
Email has a subject line that's filled in (no leftover {{name}} markers, max 500 characters)
len=46
0 ms
Pass R5_PAYLOAD_PRESENT
Stage 2 saved data for this recipient
severity: Block
Stage 2 saved data for this recipient
size=19038 bytes
0 ms
Pass R6_PAYLOAD_NONEMPTY
The email actually has content (not empty)
severity: Block
The data has at least some rows in it (not empty)
total rows=63
Section counts declared in the data
  • Associates: 1
  • App Usage: 36
  • Web Usage: 12
  • Category Usage: 12
  • Timesheet: 2
0 ms
Pass R7_BODY_NO_PLACEHOLDERS
Email body has no unfilled placeholders like {{ManagerName}}
severity: Block
Email body has no unfilled placeholders like {{ManagerName}} or ${date}
body OK (29248 bytes)
0 ms
Pass R8_BODY_COMPLETE
Email body is complete (not cut off)
severity: Warn
Email body is complete (at least 200 characters and ends with a closing tag, not cut off)
body looks complete (29248 bytes)
0 ms
Pass R9_ATTACHMENTS_EXIST
All attachment files are saved correctly
severity: Block
Every attachment file the email references actually exists on disk
1 attachment(s) present
Files attached
pathsize
runs\8178a5b6-225c-4ee2-9656-96868cfc741b-attachments\F4E91544-2B17-4462-ADB8-A6E77A859921-ManagerDailyAssociateSummaryReport_2026-07-30.xlsx9867
0 ms
Pass R10_ATTACHMENT_SIZE
Attachments are not too large to be emailed
severity: Warn
Each attachment is 25 MB or less (so the email can actually be sent)
OK
0 ms
Pass R11_PAYLOAD_USERS_ACCESSIBLE
Email shows exactly this manager's team members
severity: Warn
Every person shown in the email is accessible to this recipient (no leakage). For AssociateSummary / TeamSummary the accessible set is the recipient's line-manager reportee tree. For UrgentAttention the accessible set is the recipient's HR scope (the users returned by USP_*_GetUrgentNotificationUserDetails for their HrUserId), which is broader than the reportee tree. For InsufficientHours the reportee tree is used but the 'missing reportees' half is skipped (the report only lists users who triggered the threshold).
All 1 people in this email are on this manager's team (1 team member(s) total)
0 ms
Pass R12_ROW_COUNTS_CONSISTENT
The counts shown match the actual number of rows
severity: Warn
The 'count' numbers shown at the top of the data match how many rows are actually there
all 5 row_counts consistent
0 ms
Pass R13_ATTACHMENT_SHEETS
Excel attachment has all the expected sheets
severity: Block
The Excel attachment contains exactly the sheets it should - no missing, no extras
all 4 expected sheet(s) present, no extras
Sheets actually in the attachment
  • App_Category_wise_Usage_Report
  • App_Usage_Daily_Report
  • TimeSheet
  • Web_Usage_Daily_Report
93 ms
Pass R14_METRICS_RANGE
Time and percentage values look reasonable
severity: Warn
Time values (productive/unproductive/neutral/no-impact/idle/total) are within realistic bounds and percentages are 0-100
all metrics in 63 row(s) within bounds (5 field(s) checked)
0 ms
Pass R15_ATTACHMENT_MATCHES_DASHBOARD
Attachment sheets match the proc data the email was built from
severity: Warn
Every sheet in the .xlsx attachment has the same number of rows as the proc result the email was built from (no rows dropped or duplicated during rendering).
every sheet in the xlsx attachment matches the proc data saved at Stage 2
Sections
sheetpayload_rowsxlsx_rowsstatus
TimeSheet22match
App_Usage_Daily_Report3636match
Web_Usage_Daily_Report1212match
App_Category_wise_Usage_Report1212match
0 ms

Stage 2 — Data

Fetched 2026-07-31 02:31:47.322308 · 19038 bytes

Associates 1 App Usage 36 Web Usage 12 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 8h 15m 8h 15m 495 3h 55m 0h 0m 4h 19m 0h 0m 0h 0m <ApplicationReports><ApplicationReportModel><ApplicationName>Idle (Meeting)</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>Idle (Meeting)</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>outlook.cloud.microsoft</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>ms-teams.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>mstsc.exe</ApplicationName></ApplicationReportModel></ApplicationReports> True True 09:15 AM 05:30 PM 0 False
App Usage · 36 row(s) × 6 column(s)
ApplicationNameTotalDurationPercentageProductivityRankingUserNameEmployeeNumber
Idle (Meeting) 05:07:54 26.79 Neutral Amlesh Singh 42452
EXCEL 04:43:59 24.71 Productive Amlesh Singh 42452
mstsc 00:58:11 5.06 Productive Amlesh Singh 42452
firefox 00:28:23 2.47 Productive Amlesh Singh 42452
ms-teams 00:24:21 2.12 Productive Amlesh Singh 42452
OUTLOOK 00:21:55 1.91 Productive Amlesh Singh 42452
iPSMonitor 00:19:03 1.66 Neutral Amlesh Singh 42452
explorer 00:13:15 1.15 Productive Amlesh Singh 42452
TimeChamp 00:10:36 0.92 Productive Amlesh Singh 42452
java 00:02:26 0.21 Neutral Amlesh Singh 42452
chrome 00:01:37 0.14 Productive Amlesh Singh 42452
FoxitPDFEditor 00:01:17 0.11 Productive Amlesh Singh 42452
SnippingTool 00:01:15 0.11 Productive Amlesh Singh 42452
ShellExperienceHost 00:01:10 0.10 Productive Amlesh Singh 42452
WindowsTerminal 00:00:58 0.08 Productive Amlesh Singh 42452
ApplicationFrameHost 00:00:51 0.07 Productive Amlesh Singh 42452
tvnviewer 00:00:48 0.07 Productive Amlesh Singh 42452
filezilla 00:00:21 0.03 Productive Amlesh Singh 42452
SearchHost 00:00:19 0.03 Productive Amlesh Singh 42452
CredentialUIBroker 00:00:18 0.03 Productive Amlesh Singh 42452
OneDrive 00:00:11 0.02 Productive Amlesh Singh 42452
msedge 00:00:01 0.00 Productive Amlesh Singh 42452
Idle (Meeting) 03:59:56 20.87 Neutral Sanjeet Kumar 47602
ms-teams 00:51:15 4.46 Productive Sanjeet Kumar 47602
mstsc 00:42:24 3.69 Productive Sanjeet Kumar 47602
QuickAssist 00:19:11 1.67 Neutral Sanjeet Kumar 47602
explorer 00:06:50 0.59 Productive Sanjeet Kumar 47602
POWERPNT 00:03:49 0.33 Productive Sanjeet Kumar 47602
msedge 00:03:13 0.28 Productive Sanjeet Kumar 47602
EXCEL 00:01:38 0.14 Productive Sanjeet Kumar 47602
CredentialUIBroker 00:00:51 0.07 Productive Sanjeet Kumar 47602
SnippingTool 00:00:34 0.05 Productive Sanjeet Kumar 47602
SearchHost 00:00:32 0.05 Productive Sanjeet Kumar 47602
StartMenuExperienceHost 00:00:02 0.00 Productive Sanjeet Kumar 47602
LockApp 00:00:01 0.00 Productive Sanjeet Kumar 47602
TimeChamp 00:00:00 0.00 Productive Sanjeet Kumar 47602
Web Usage · 12 row(s) × 6 column(s)
ApplicationNameTotalDurationPercentageProductivityRankingUserNameEmployeeNumber
sheridan.jira.com 00:24:18 15.84 Productive Amlesh Singh 42452
cjkgroupinc-my.sharepoint.com 00:04:34 2.98 Productive Amlesh Singh 42452
outlook.cloud.microsoft 01:01:28 40.06 Productive Sanjeet Kumar 47602
sheridan.jira.com 00:33:42 21.96 Productive Sanjeet Kumar 47602
www.youtube.com 00:18:50 12.27 Productive Sanjeet Kumar 47602
www.dell.com 00:03:48 2.48 Productive Sanjeet Kumar 47602
enquiry.indianrail.gov.in 00:02:34 1.67 Productive Sanjeet Kumar 47602
www.msn.com 00:01:23 0.90 Productive Sanjeet Kumar 47602
www.bing.com 00:01:22 0.89 Productive Sanjeet Kumar 47602
mail.google.com 00:00:45 0.49 Productive Sanjeet Kumar 47602
msedge 00:00:41 0.45 Productive Sanjeet Kumar 47602
www.atlassian.com 00:00:02 0.02 Productive Sanjeet Kumar 47602
Category Usage · 12 row(s) × 5 column(s)
ApplicationCategoryNameTotalDurationPercentageUserNameEmployeeNumber
PRINT ACCOUNT_IDC 05:30 25.404 Amlesh Singh 42452
Others 05:29 25.327 Amlesh Singh 42452
Office Apps 01:05 5.004 Amlesh Singh 42452
Work Apps/URLs 00:58 4.465 Amlesh Singh 42452
Development 00:22 1.694 Amlesh Singh 42452
HE and STM Apps 00:02 0.154 Amlesh Singh 42452
Email 00:00 0.000 Amlesh Singh 42452
Others 04:19 19.938 Sanjeet Kumar 47602
PRINT ACCOUNT_IDC 03:12 14.781 Sanjeet Kumar 47602
Work Apps/URLs 00:42 3.233 Sanjeet Kumar 47602
Office Apps 00:00 0.000 Sanjeet Kumar 47602
HE and STM Apps 00:00 0.000 Sanjeet Kumar 47602
Timesheet · 2 row(s) × 56 column(s)
TimeSheetIdUserIdUserNameTeamNameIsNoImpactEnabledRoleNameReportToEmployeeNameReportToEmployeeMailShiftDepartmentNameMobileNoDateActiveTimeInSecProductiveTimeInSecUnProductiveTimeInSecNeutralTimeInSecNoImpactTimeInSecTotalIdleTimeUserBreaksCountEmployeeNameUserProfileImageTimeZoneIdLunchBreakEndTimeLunchBreakStartTimeInTimeInTimeAbbreviationOutTimeAbbreviationLunchStartAbbreviationLunchEndAbbreviationInTimeTimeZoneOutTimeTimeZoneLunchStartTimeZoneLunchEndTimeZoneOutTimePunchCardBasedLatestInsertedTrackerDateLunchBreakDiffUsersBreakTimeIsNextDaySpentTimeDiffTotalOfflineTimeLunchTimeInSecUsersBreakTimeInSecEmployeeNumberLoggedTimeAttendanceStatusBranchNameDesktopNameTotalSpentTimeFullDayMinimumHoursHalfDayMinimumHoursAbsentDayMinimumHoursAttendanceAbsentTimeAttendanceHalfOrFullDayTimeIsAttendacneBasedOnPercentageTotalTimeInSec
3B8306F6-3A82-4CE4-9CB4-F65FE8431A18 F4E91544-2B17-4462-ADB8-A6E77A859921 amlesh.singh@kwglobal.com KGL False Manager Jaisingh Varma Jaisingh.Varma@kwglobal.com 07:00 IST - 06:55 IST Support Function (IT)-System Admin 2026-07-30T00:00:00 48493 28729 0 19764 0 0 0 Amlesh Singh C527B633-9FB6-4D9F-BE87-5172DBE87D18 2026-07-30T11:19:19.093242+05:30 2026-07-31T00:47:33.254332+05:30 False 1 48494 1 0 42452 KGL-IT XINNDNLEN0123 149.63 7.0 3.0 3.0 808 808 False 48494
F6598439-3917-4FB9-8FF3-6D859CC1581B 21AD8549-6102-4109-BB52-C88A03D7D570 Sanjeet.Kumar@kwglobal.com KGL False User Amlesh Singh Amlesh.Singh@kwglobal.com 07:00 IST - 06:55 IST Support Function (IT)-System Admin 2026-07-30T00:00:00 29702 14153 0 15548 0 0 0 Sanjeet Kumar C527B633-9FB6-4D9F-BE87-5172DBE87D18 2026-07-30T09:15:50.035874+05:30 2026-07-30T17:30:52.635742+05:30 False 0 29702 0 0 47602 KGL-IT XINNDDELL0899 91.67 8.0 4.0 4.0 495 495 False 29702
Meta · non-tabular fields
{
  "row_counts": {
    "app_usage": 36,
    "associates": 1,
    "category_usage": 12,
    "timesheet": 2,
    "web_usage": 12
  },
  "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": "8h 15m", "TotalDeskTime": "8h 15m", "DeskTime": 495, "ProductiveTime": "3h 55m", "UnProductiveTime": "0h 0m", "NeutralTime": "4h 19m", "NoImpactTime": "0h 0m", "TotalIdleTime": "0h 0m", "MostUsedApps": "<ApplicationReports><ApplicationReportModel><ApplicationName>Idle (Meeting)</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>Idle (Meeting)</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>outlook.cloud.microsoft</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>ms-teams.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>mstsc.exe</ApplicationName></ApplicationReportModel></ApplicationReports>", "Commits": null, "WorkItemsActivity": null, "LoggedWorkItems": null, "IsAttendanceBasedOnTracking": true, "IsUserHavingShift": true, "StartTime": "09:15 AM", "FinishTime": "05:30 PM", "MessageEnum": 0, "IsNoImpactEnabled": false}], "app_usage": [{"ApplicationName": "Idle (Meeting)", "TotalDuration": "05:07:54", "Percentage": "26.79", "ProductivityRanking": "Neutral", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "EXCEL", "TotalDuration": "04:43:59", "Percentage": "24.71", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "mstsc", "TotalDuration": "00:58:11", "Percentage": "5.06", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "firefox", "TotalDuration": "00:28:23", "Percentage": "2.47", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "ms-teams", "TotalDuration": "00:24:21", "Percentage": "2.12", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "OUTLOOK", "TotalDuration": "00:21:55", "Percentage": "1.91", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "iPSMonitor", "TotalDuration": "00:19:03", "Percentage": "1.66", "ProductivityRanking": "Neutral", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "explorer", "TotalDuration": "00:13:15", "Percentage": "1.15", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "TimeChamp", "TotalDuration": "00:10:36", "Percentage": "0.92", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "java", "TotalDuration": "00:02:26", "Percentage": "0.21", "ProductivityRanking": "Neutral", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "chrome", "TotalDuration": "00:01:37", "Percentage": "0.14", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "FoxitPDFEditor", "TotalDuration": "00:01:17", "Percentage": "0.11", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "SnippingTool", "TotalDuration": "00:01:15", "Percentage": "0.11", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "ShellExperienceHost", "TotalDuration": "00:01:10", "Percentage": "0.10", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "WindowsTerminal", "TotalDuration": "00:00:58", "Percentage": "0.08", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "ApplicationFrameHost", "TotalDuration": "00:00:51", "Percentage": "0.07", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "tvnviewer", "TotalDuration": "00:00:48", "Percentage": "0.07", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "filezilla", "TotalDuration": "00:00:21", "Percentage": "0.03", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "SearchHost", "TotalDuration": "00:00:19", "Percentage": "0.03", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "CredentialUIBroker", "TotalDuration": "00:00:18", "Percentage": "0.03", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "OneDrive", "TotalDuration": "00:00:11", "Percentage": "0.02", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "msedge", "TotalDuration": "00:00:01", "Percentage": "0.00", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "Idle (Meeting)", "TotalDuration": "03:59:56", "Percentage": "20.87", "ProductivityRanking": "Neutral", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "ms-teams", "TotalDuration": "00:51:15", "Percentage": "4.46", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "mstsc", "TotalDuration": "00:42:24", "Percentage": "3.69", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "QuickAssist", "TotalDuration": "00:19:11", "Percentage": "1.67", "ProductivityRanking": "Neutral", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "explorer", "TotalDuration": "00:06:50", "Percentage": "0.59", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "POWERPNT", "TotalDuration": "00:03:49", "Percentage": "0.33", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "msedge", "TotalDuration": "00:03:13", "Percentage": "0.28", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "EXCEL", "TotalDuration": "00:01:38", "Percentage": "0.14", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "CredentialUIBroker", "TotalDuration": "00:00:51", "Percentage": "0.07", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "SnippingTool", "TotalDuration": "00:00:34", "Percentage": "0.05", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "SearchHost", "TotalDuration": "00:00:32", "Percentage": "0.05", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "StartMenuExperienceHost", "TotalDuration": "00:00:02", "Percentage": "0.00", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "LockApp", "TotalDuration": "00:00:01", "Percentage": "0.00", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "TimeChamp", "TotalDuration": "00:00:00", "Percentage": "0.00", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}], "web_usage": [{"ApplicationName": "sheridan.jira.com", "TotalDuration": "00:24:18", "Percentage": "15.84", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "cjkgroupinc-my.sharepoint.com", "TotalDuration": "00:04:34", "Percentage": "2.98", "ProductivityRanking": "Productive", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationName": "outlook.cloud.microsoft", "TotalDuration": "01:01:28", "Percentage": "40.06", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "sheridan.jira.com", "TotalDuration": "00:33:42", "Percentage": "21.96", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "www.youtube.com", "TotalDuration": "00:18:50", "Percentage": "12.27", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "www.dell.com", "TotalDuration": "00:03:48", "Percentage": "2.48", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "enquiry.indianrail.gov.in", "TotalDuration": "00:02:34", "Percentage": "1.67", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "www.msn.com", "TotalDuration": "00:01:23", "Percentage": "0.90", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "www.bing.com", "TotalDuration": "00:01:22", "Percentage": "0.89", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "mail.google.com", "TotalDuration": "00:00:45", "Percentage": "0.49", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "msedge", "TotalDuration": "00:00:41", "Percentage": "0.45", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationName": "www.atlassian.com", "TotalDuration": "00:00:02", "Percentage": "0.02", "ProductivityRanking": "Productive", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}], "category_usage": [{"ApplicationCategoryName": "PRINT ACCOUNT_IDC", "TotalDuration": "05:30", "Percentage": "25.404", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "Others", "TotalDuration": "05:29", "Percentage": "25.327", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "Office Apps", "TotalDuration": "01:05", "Percentage": "5.004", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "Work Apps/URLs", "TotalDuration": "00:58", "Percentage": "4.465", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "Development", "TotalDuration": "00:22", "Percentage": "1.694", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "HE and STM Apps", "TotalDuration": "00:02", "Percentage": "0.154", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "Email", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Amlesh Singh", "EmployeeNumber": "42452"}, {"ApplicationCategoryName": "Others", "TotalDuration": "04:19", "Percentage": "19.938", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationCategoryName": "PRINT ACCOUNT_IDC", "TotalDuration": "03:12", "Percentage": "14.781", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationCategoryName": "Work Apps/URLs", "TotalDuration": "00:42", "Percentage": "3.233", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationCategoryName": "Office Apps", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}, {"ApplicationCategoryName": "HE and STM Apps", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Sanjeet Kumar", "EmployeeNumber": "47602"}], "timesheet": [{"TimeSheetId": "3B8306F6-3A82-4CE4-9CB4-F65FE8431A18", "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": "07:00 IST - 06:55 IST", "DepartmentName": "Support Function (IT)-System Admin", "MobileNo": null, "Date": "2026-07-30T00:00:00", "ActiveTimeInSec": 48493, "ProductiveTimeInSec": 28729, "UnProductiveTimeInSec": 0, "NeutralTimeInSec": 19764, "NoImpactTimeInSec": 0, "TotalIdleTime": 0, "UserBreaksCount": 0, "EmployeeName": "Amlesh Singh", "UserProfileImage": null, "TimeZoneId": "C527B633-9FB6-4D9F-BE87-5172DBE87D18", "LunchBreakEndTime": null, "LunchBreakStartTime": null, "InTime": "2026-07-30T11:19:19.093242+05:30", "InTimeAbbreviation": null, "OutTimeAbbreviation": null, "LunchStartAbbreviation": null, "LunchEndAbbreviation": null, "InTimeTimeZone": null, "OutTimeTimeZone": null, "LunchStartTimeZone": null, "LunchEndTimeZone": null, "OutTime": "2026-07-31T00:47:33.254332+05:30", "PunchCardBased": false, "LatestInsertedTrackerDate": null, "LunchBreakDiff": null, "UsersBreakTime": null, "IsNextDay": 1, "SpentTimeDiff": 48494, "TotalOfflineTime": 1, "LunchTimeInSec": null, "UsersBreakTimeInSec": 0, "EmployeeNumber": "42452", "LoggedTime": null, "AttendanceStatus": "", "BranchName": "KGL-IT", "DesktopName": "XINNDNLEN0123", "TotalSpentTime": 149.63, "FullDayMinimumHours": 7.0, "HalfDayMinimumHours": 3.0, "AbsentDayMinimumHours": 3.0, "AttendanceAbsentTime": 808, "AttendanceHalfOrFullDayTime": 808, "IsAttendacneBasedOnPercentage": false, "TotalTimeInSec": 48494}, {"TimeSheetId": "F6598439-3917-4FB9-8FF3-6D859CC1581B", "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": "07:00 IST - 06:55 IST", "DepartmentName": "Support Function (IT)-System Admin", "MobileNo": null, "Date": "2026-07-30T00:00:00", "ActiveTimeInSec": 29702, "ProductiveTimeInSec": 14153, "UnProductiveTimeInSec": 0, "NeutralTimeInSec": 15548, "NoImpactTimeInSec": 0, "TotalIdleTime": 0, "UserBreaksCount": 0, "EmployeeName": "Sanjeet Kumar", "UserProfileImage": null, "TimeZoneId": "C527B633-9FB6-4D9F-BE87-5172DBE87D18", "LunchBreakEndTime": null, "LunchBreakStartTime": null, "InTime": "2026-07-30T09:15:50.035874+05:30", "InTimeAbbreviation": null, "OutTimeAbbreviation": null, "LunchStartAbbreviation": null, "LunchEndAbbreviation": null, "InTimeTimeZone": null, "OutTimeTimeZone": null, "LunchStartTimeZone": null, "LunchEndTimeZone": null, "OutTime": "2026-07-30T17:30:52.635742+05:30", "PunchCardBased": false, "LatestInsertedTrackerDate": null, "LunchBreakDiff": null, "UsersBreakTime": null, "IsNextDay": 0, "SpentTimeDiff": 29702, "TotalOfflineTime": 0, "LunchTimeInSec": null, "UsersBreakTimeInSec": 0, "EmployeeNumber": "47602", "LoggedTime": null, "AttendanceStatus": "", "BranchName": "KGL-IT", "DesktopName": "XINNDDELL0899", "TotalSpentTime": 91.67, "FullDayMinimumHours": 8.0, "HalfDayMinimumHours": 4.0, "AbsentDayMinimumHours": 4.0, "AttendanceAbsentTime": 495, "AttendanceHalfOrFullDayTime": 495, "IsAttendacneBasedOnPercentage": false, "TotalTimeInSec": 29702}], "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": 36, "web_usage": 12, "category_usage": 12, "timesheet": 2}}

Stage 3 — Rendered

Rendered 2026-07-31 02:31:47.760894 · 29248 bytes

Subject: Daily associates summary report - Jul 30, 2026

Attachments
[{"name": "ManagerDailyAssociateSummaryReport_2026-07-30.xlsx", "path": "runs/8178a5b6-225c-4ee2-9656-96868cfc741b-attachments/F4E91544-2B17-4462-ADB8-A6E77A859921-ManagerDailyAssociateSummaryReport_2026-07-30.xlsx", "sizeBytes": 9867, "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 30, 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;">09:15 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:30 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;">8h 15m</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 55m</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; ">4h 19m</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> 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> 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> ms-teams.exe </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> mstsc.exe </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
F4FF4372-8F89-41F3-A9FA-14967BA74BA7
Skip reason
Error
At
2026-07-31 02:31:49.743847

Events

AtStageLevelMessagemsWorker
2026-07-31 02:30:27.524912 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=Amlesh.Singh@kwglobal.com userId=F4E91544-2B17-4462-ADB8-A6E77A859921 thr-17600
2026-07-31 02:30:27.537913 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='F4E91544-2B17-4462-ADB8-A6E77A859921', @Date='2026-07-30') thr-17600
2026-07-31 02:30:32.086953 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 1 row(s) in 4525ms; 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=8h 15m, TotalDeskTime=8h 15m, DeskTime=495, ProductiveTime=3h 55m} 4525 thr-17600
2026-07-31 02:30:32.095952 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-30', @IsApp=1, @IsForLineManager=1, @LineManagerId='F4E91544-2B17-4462-ADB8-A6E77A859921') thr-17600
2026-07-31 02:30:32.122951 DataFetch Info <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 36 row(s) in 14ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber]; first_row={ApplicationName=Idle (Meeting), TotalDuration=05:07:54, Percentage=26.79, ProductivityRanking=Neutral, UserName=Amlesh Singh, EmployeeNumber=42452} 14 thr-17600
2026-07-31 02:30:32.142954 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-30', @IsApp=0, @IsForLineManager=1, @LineManagerId='F4E91544-2B17-4462-ADB8-A6E77A859921') thr-17600
2026-07-31 02:30:32.157955 DataFetch Info <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 12 row(s) in 8ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber]; first_row={ApplicationName=sheridan.jira.com, TotalDuration=00:24:18, Percentage=15.84, ProductivityRanking=Productive, UserName=Amlesh Singh, EmployeeNumber=42452} 8 thr-17600
2026-07-31 02:30:32.170952 DataFetch Info >>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-30', @IsForLineManager=1, @LineManagerId='F4E91544-2B17-4462-ADB8-A6E77A859921') thr-17600
2026-07-31 02:30:32.874985 DataFetch Info <<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 12 row(s) in 694ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber]; first_row={ApplicationCategoryName=PRINT ACCOUNT_IDC, TotalDuration=05:30, Percentage=25.404, UserName=Amlesh Singh, EmployeeNumber=42452} 694 thr-17600
2026-07-31 02:30:32.878966 DataFetch Info >>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-07-30', @DateTo='2026-07-30', @OperationsPerformedBy='F4E91544-2B17-4462-ADB8-A6E77A859921', @EmployeeSearchText=NULL, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) thr-17600
2026-07-31 02:31:47.203307 DataFetch Info <<< USP_EmailComp_DownloadTimesheet returned 2 row(s) in 74313ms; 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=3B8306F6-3A82-4CE4-9CB4-F65..., UserId=F4E91544-2B17-4462-ADB8-A6E..., UserName=amlesh.singh@kwglobal.com, TeamName=KGL, IsNoImpactEnabled=False, RoleName= Manager, ReportToEmployeeName=Jaisingh Varma, Rep...} 74313 thr-17600
2026-07-31 02:31:47.228309 DataFetch Info Soft labels: batch-cache hit (105 keys) thr-17600
2026-07-31 02:31:47.273308 DataFetch Info AssociateSummary fetched — associates=1, app_usage=36, web_usage=12, category_usage=12, timesheet=2 thr-17600
2026-07-31 02:31:47.355307 DataFetch Info Wrote EmailComp_Job_Data (19038 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] 79790 thr-17600
2026-07-31 02:31:47.496309 Render Info --- Stage 3 begin --- template=AssociateSummary recipient=Amlesh.Singh@kwglobal.com thr-17600
2026-07-31 02:31:47.525309 Render Info dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) thr-17600
2026-07-31 02:31:47.793894 Render Info Rendered (29248 bytes, subject='Daily associates summary report - Jul 30, 2026', attachments=1) 294 thr-17600
2026-07-31 02:31:49.082365 QA Info QA passed (15 check(s)) 1188 thr-17600
2026-07-31 02:31:49.336398 Dispatch Info >>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Amlesh.Singh@kwglobal.com', @Subject='Daily associates summary report - Jul 30, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='8d3b77be-96fb-408d-a77a-0e29b5d33014') thr-17600
2026-07-31 02:31:49.468369 Dispatch Info <<< USP_EmailComp_InsertMail returned MailId=f4ff4372-8f89-41f3-a9fa-14967ba74ba7 in 82ms (inserted) 82 thr-17600
2026-07-31 02:31:49.546370 Dispatch Info >>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=f4ff4372-8f89-41f3-a9fa-14967ba74ba7, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/aa3cab7a866948fabc1ac922732a1e65_F4E91544-2B17-4462-ADB8-A6E77A859921-ManagerDailyAssociateSummaryReport_2026-07-30.xlsx') thr-17600
2026-07-31 02:31:49.605842 Dispatch Info <<< USP_EmailComp_InsertMailAttchment OK in 41ms 41 thr-17600
2026-07-31 02:31:49.672844 Dispatch Info Inserted into SentMail. MailId=f4ff4372-8f89-41f3-a9fa-14967ba74ba7 thr-17600