Job 550662D9-5C07-4043-A6AE-802471F57D7F

Dispatched Back to batch
Batch
CBF1D198-61AB-4D38-AB3E-1123DA50FD08
Template
AssociateSummary
Recipient
Ameya.Shinde@kwglobal.com (Ameya Shinde)
User id
056B4BBD-1E0B-4168-B754-BAD7044BE5E7
Status
Dispatched
Attempts
3
Claimed by
thr-9784 at 2026-07-30 02:31:26.051663
Created
2026-07-30 02:30:41.787650
Completed
2026-07-30 02:31:29.201233

Attachments — what the end user receives in the email

#FilenameSizeStatusAction
1 056B4BBD-1E0B-4168-B754-BAD7044BE5E7-ManagerDailyAssociateSummaryReport_2026-07-29.xlsx
runs/cbf1d198-61ab-4d38-ab3e-1123da50fd08-attachments/056B4BBD-1E0B-4168-B754-BAD7044BE5E7-ManagerDailyAssociateSummaryReport_2026-07-29.xlsx
- missing file missing

Stage 4 — QA gate

Pass
15 checks run · 15 pass · 0 warn · 0 fail/error · 311 ms · evaluated 2026-07-30 02:31:26.004662
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: Ameya.Shinde@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
31 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)
2 active reportee(s)
Total In Tree
3
Active Others
2
Inactive Others
0
63 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=27433 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=95
Section counts declared in the data
  • Associates: 2
  • App Usage: 42
  • Web Usage: 30
  • Category Usage: 18
  • Timesheet: 3
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 (39803 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 (39803 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\cbf1d198-61ab-4d38-ab3e-1123da50fd08-attachments\056B4BBD-1E0B-4168-B754-BAD7044BE5E7-ManagerDailyAssociateSummaryReport_2026-07-29.xlsx11345
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 2 people in this email are on this manager's team (2 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
46 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 95 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
TimeSheet33match
App_Usage_Daily_Report4242match
Web_Usage_Daily_Report3030match
App_Category_wise_Usage_Report1818match
16 ms

Stage 2 — Data

Fetched 2026-07-30 02:31:24.847825 · 27433 bytes

Associates 2 App Usage 42 Web Usage 30 Category Usage 18 Timesheet 3
Associates · 2 row(s) × 22 column(s)
UserIdCompanyIdUserNameUserEmailTotalTimeTotalDeskTimeDeskTimeProductiveTimeUnProductiveTimeNeutralTimeNoImpactTimeTotalIdleTimeMostUsedAppsCommitsWorkItemsActivityLoggedWorkItemsIsAttendanceBasedOnTrackingIsUserHavingShiftStartTimeFinishTimeMessageEnumIsNoImpactEnabled
11F5ECB4-134E-4168-8084-0C4E5011513C 6E919CFE-74DD-4EBC-8665-3C0D44866649 Gauravsingh Rana Gauravsingh.Rana@kwglobal.com 10h 26m 7h 59m 479 7h 49m 0h 0m 0h 9m 0h 0m 0h 24m <ApplicationReports><ApplicationReportModel><ApplicationName>devenv.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>ms-teams.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>ms-teams.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>mstsc.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>notepad++.exe</ApplicationName></ApplicationReportModel></ApplicationReports> True True 08:07 AM 06:33 PM 0 False
D44B9A04-35C0-4176-9CC9-2B7779AC2835 6E919CFE-74DD-4EBC-8665-3C0D44866649 Ramkrishna Maurya Ramkrishna.Maurya@kwglobal.com 10h 29m 8h 3m 483 7h 48m 0h 0m 0h 15m 0h 0m 0h 0m <ApplicationReports><ApplicationReportModel><ApplicationName>devenv.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>chatgpt.com</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>SSMS.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>ms-teams.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>sheridan.jira.com</ApplicationName></ApplicationReportModel></ApplicationReports> True True 11:41 AM 10:10 PM 0 False
App Usage · 42 row(s) × 6 column(s)
ApplicationNameTotalDurationPercentageProductivityRankingUserNameEmployeeNumber
Notepad 03:23:22 15.14 Productive Ameya Shinde 46850
ms-teams 02:55:43 13.08 Productive Ameya Shinde 46850
Idle (Meeting) 02:18:20 10.30 Neutral Ameya Shinde 46850
TimeChamp 00:47:57 3.57 Productive Ameya Shinde 46850
chrome 00:11:54 0.89 Productive Ameya Shinde 46850
explorer 00:09:46 0.73 Productive Ameya Shinde 46850
olk 00:05:43 0.43 Productive Ameya Shinde 46850
PickerHost 00:01:26 0.11 Productive Ameya Shinde 46850
SearchHost 00:00:10 0.01 Productive Ameya Shinde 46850
ShellHost 00:00:10 0.01 Productive Ameya Shinde 46850
devenv 04:33:05 20.32 Productive Gauravsingh Rana 47412
ms-teams 02:03:24 9.18 Productive Gauravsingh Rana 47412
mstsc 00:18:39 1.39 Productive Gauravsingh Rana 47412
notepad++ 00:14:30 1.08 Productive Gauravsingh Rana 47412
setup 00:08:58 0.67 Neutral Gauravsingh Rana 47412
msedge 00:07:42 0.57 Productive Gauravsingh Rana 47412
TimeChamp 00:01:17 0.10 Productive Gauravsingh Rana 47412
explorer 00:01:15 0.09 Productive Gauravsingh Rana 47412
GitHubDesktop 00:00:49 0.06 Neutral Gauravsingh Rana 47412
FortiClient 00:00:32 0.04 Productive Gauravsingh Rana 47412
SearchHost 00:00:28 0.03 Productive Gauravsingh Rana 47412
ShellExperienceHost 00:00:26 0.03 Productive Gauravsingh Rana 47412
CredentialUIBroker 00:00:24 0.03 Productive Gauravsingh Rana 47412
Ditto 00:00:07 0.01 Neutral Gauravsingh Rana 47412
FortiTray 00:00:05 0.01 Productive Gauravsingh Rana 47412
devenv 02:05:27 9.34 Productive Ramkrishna Maurya 47411
SSMS 01:07:36 5.03 Productive Ramkrishna Maurya 47411
ms-teams 00:49:59 3.72 Productive Ramkrishna Maurya 47411
notepad++ 00:16:57 1.26 Productive Ramkrishna Maurya 47411
GitHubDesktop 00:14:59 1.12 Neutral Ramkrishna Maurya 47411
TimeChamp 00:08:14 0.61 Productive Ramkrishna Maurya 47411
FortiClient 00:04:24 0.33 Productive Ramkrishna Maurya 47411
ShellExperienceHost 00:04:09 0.31 Productive Ramkrishna Maurya 47411
SnippingTool 00:01:37 0.12 Productive Ramkrishna Maurya 47411
explorer 00:01:24 0.10 Productive Ramkrishna Maurya 47411
Postman 00:00:59 0.07 Neutral Ramkrishna Maurya 47411
SearchHost 00:00:47 0.06 Productive Ramkrishna Maurya 47411
msedge 00:00:25 0.03 Productive Ramkrishna Maurya 47411
WindowsTerminal 00:00:20 0.02 Productive Ramkrishna Maurya 47411
chrome 00:00:05 0.01 Productive Ramkrishna Maurya 47411
StartMenuExperienceHost 00:00:02 0.00 Productive Ramkrishna Maurya 47411
Code 00:00:01 0.00 Productive Ramkrishna Maurya 47411
Web Usage · 30 row(s) × 6 column(s)
ApplicationNameTotalDurationPercentageProductivityRankingUserNameEmployeeNumber
youtube.com 00:54:58 17.41 UnProductive Ameya Shinde 46850
sheridan.jira.com 00:32:26 10.27 Productive Ameya Shinde 46850
bitbucket.org 00:09:52 3.12 Neutral Ameya Shinde 46850
google.com 00:03:06 0.98 Productive Ameya Shinde 46850
fast.com 00:02:38 0.83 Neutral Ameya Shinde 46850
sheridan.jira.com 00:07:08 2.26 Productive Gauravsingh Rana 47412
www.google.com 00:04:54 1.55 Productive Gauravsingh Rana 47412
smartreview-uat.kwglobal.com 00:04:09 1.31 Productive Gauravsingh Rana 47412
msdashboard.kwglobal.com 00:03:02 0.96 Productive Gauravsingh Rana 47412
github.com 00:02:05 0.66 Productive Gauravsingh Rana 47412
outlook.cloud.microsoft 00:01:32 0.49 Productive Gauravsingh Rana 47412
cjkgroupinc-my.sharepoint.com 00:01:21 0.43 Productive Gauravsingh Rana 47412
portal.azure.com 00:00:45 0.24 Productive Gauravsingh Rana 47412
smartreview.kwglobal.com 00:00:42 0.22 Productive Gauravsingh Rana 47412
app.powerbi.com 00:00:25 0.13 Productive Gauravsingh Rana 47412
teams.public.onecdn.static.microsoft 00:00:12 0.06 Productive Gauravsingh Rana 47412
learninghub.kwglobal.com 00:00:06 0.03 Productive Gauravsingh Rana 47412
chatgpt.com 02:02:27 38.78 Productive Ramkrishna Maurya 47411
sheridan.jira.com 00:24:11 7.66 Productive Ramkrishna Maurya 47411
smartreview-uat.kwglobal.com 00:15:40 4.96 Productive Ramkrishna Maurya 47411
learninghub.kwglobal.com 00:06:34 2.08 Productive Ramkrishna Maurya 47411
www.scimagojr.com 00:04:39 1.47 Productive Ramkrishna Maurya 47411
smartreview.kwglobal.com 00:03:50 1.21 Productive Ramkrishna Maurya 47411
cjkgroupinc-my.sharepoint.com 00:03:32 1.12 Productive Ramkrishna Maurya 47411
www.figma.com 00:03:15 1.03 Productive Ramkrishna Maurya 47411
github.com 00:01:08 0.36 Productive Ramkrishna Maurya 47411
outlook.cloud.microsoft 00:00:40 0.21 Productive Ramkrishna Maurya 47411
learn.microsoft.com 00:00:18 0.10 Productive Ramkrishna Maurya 47411
localhost 00:00:07 0.04 Productive Ramkrishna Maurya 47411
msdn.microsoft.com 00:00:05 0.03 Productive Ramkrishna Maurya 47411
Category Usage · 18 row(s) × 5 column(s)
ApplicationCategoryNameTotalDurationPercentageUserNameEmployeeNumber
PRINT ACCOUNT_IDC 03:24 12.356 Ameya Shinde 46850
Work Apps/URLs 03:23 12.296 Ameya Shinde 46850
Others 02:30 9.085 Ameya Shinde 46850
Personal URLs 00:54 3.271 Ameya Shinde 46850
Office Apps 00:48 2.907 Ameya Shinde 46850
Development 00:32 1.938 Ameya Shinde 46850
BackGround 00:03 0.182 Ameya Shinde 46850
Development 04:33 16.535 Gauravsingh Rana 47412
PRINT ACCOUNT_IDC 02:39 9.631 Gauravsingh Rana 47412
Work Apps/URLs 00:18 1.090 Gauravsingh Rana 47412
Office Apps 00:16 0.969 Gauravsingh Rana 47412
Others 00:09 0.545 Gauravsingh Rana 47412
HE and STM Apps 00:00 0.000 Gauravsingh Rana 47412
PRINT ACCOUNT_IDC 04:02 14.658 Ramkrishna Maurya 47411
Development 03:13 11.690 Ramkrishna Maurya 47411
Office Apps 00:26 1.575 Ramkrishna Maurya 47411
Others 00:15 0.909 Ramkrishna Maurya 47411
HE and STM Apps 00:06 0.363 Ramkrishna Maurya 47411
Timesheet · 3 row(s) × 56 column(s)
TimeSheetIdUserIdUserNameTeamNameIsNoImpactEnabledRoleNameReportToEmployeeNameReportToEmployeeMailShiftDepartmentNameMobileNoDateActiveTimeInSecProductiveTimeInSecUnProductiveTimeInSecNeutralTimeInSecNoImpactTimeInSecTotalIdleTimeUserBreaksCountEmployeeNameUserProfileImageTimeZoneIdLunchBreakEndTimeLunchBreakStartTimeInTimeInTimeAbbreviationOutTimeAbbreviationLunchStartAbbreviationLunchEndAbbreviationInTimeTimeZoneOutTimeTimeZoneLunchStartTimeZoneLunchEndTimeZoneOutTimePunchCardBasedLatestInsertedTrackerDateLunchBreakDiffUsersBreakTimeIsNextDaySpentTimeDiffTotalOfflineTimeLunchTimeInSecUsersBreakTimeInSecEmployeeNumberLoggedTimeAttendanceStatusBranchNameDesktopNameTotalSpentTimeFullDayMinimumHoursHalfDayMinimumHoursAbsentDayMinimumHoursAttendanceAbsentTimeAttendanceHalfOrFullDayTimeIsAttendacneBasedOnPercentageTotalTimeInSec
48100BB5-F51E-45FF-801D-3A7BDD7439BF 056B4BBD-1E0B-4168-B754-BAD7044BE5E7 Ameya.Shinde@kwglobal.com M-Sheridan False Manager Rajnarrayan Bose Rajnarrayan.Bose@kwglobal.com 07:00 IST - 06:55 IST Technology-Software Engineering 2026-07-29T00:00:00 41857 29508 3298 9051 0 5429 0 Ameya Shinde 2026-07-29T11:20:14.823281+05:30 2026-07-30T01:38:07.385177+05:30 False 1 51473 4187 0 46850 KGL-MUM XINMBDLNDQRT 129.07 8.0 4.0 4.0 697 697 False 51473
2596890C-DD09-4D5A-AFD5-740D904E1402 11F5ECB4-134E-4168-8084-0C4E5011513C Gauravsingh.Rana@kwglobal.com M-KGL Smart-Suite False User Ameya Shinde Ameya.Shinde@kwglobal.com 07:00 IST - 06:55 IST Technology-Software Engineering 2026-07-29T00:00:00 28759 28163 0 595 0 1448 0 Gauravsingh Rana 2026-07-29T08:07:34.546957+05:30 2026-07-29T18:33:16.113481+05:30 False 0 37542 7335 0 47412 KGL-MUM XINMBLVNSRQ7 88.7 8.0 4.0 4.0 479 479 False 37542
2F3505FB-704A-4825-8F68-2F0879F2CC1A D44B9A04-35C0-4176-9CC9-2B7779AC2835 Ramkrishna.Maurya@kwglobal.com M-KGL Smart-Suite False User Ameya Shinde Ameya.Shinde@kwglobal.com 07:00 IST - 06:55 IST Technology-Software Development 2026-07-29T00:00:00 29038 28080 0 958 0 0 0 Ramkrishna Maurya 2026-07-29T11:41:44.623587+05:30 2026-07-29T22:10:40.379420+05:30 False 0h 40m 0 37736 8698 2404 47411 KGL-MUM XINMBLVNLPW5 89.44 8.0 4.0 4.0 483 483 False 37736
Meta · non-tabular fields
{
  "row_counts": {
    "app_usage": 42,
    "associates": 2,
    "category_usage": 18,
    "timesheet": 3,
    "web_usage": 30
  },
  "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": "11F5ECB4-134E-4168-8084-0C4E5011513C", "CompanyId": "6E919CFE-74DD-4EBC-8665-3C0D44866649", "UserName": "Gauravsingh Rana", "UserEmail": "Gauravsingh.Rana@kwglobal.com", "TotalTime": "10h 26m", "TotalDeskTime": "7h 59m", "DeskTime": 479, "ProductiveTime": "7h 49m", "UnProductiveTime": "0h 0m", "NeutralTime": "0h 9m", "NoImpactTime": "0h 0m", "TotalIdleTime": "0h 24m", "MostUsedApps": "<ApplicationReports><ApplicationReportModel><ApplicationName>devenv.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>ms-teams.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>ms-teams.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>mstsc.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>notepad++.exe</ApplicationName></ApplicationReportModel></ApplicationReports>", "Commits": null, "WorkItemsActivity": null, "LoggedWorkItems": null, "IsAttendanceBasedOnTracking": true, "IsUserHavingShift": true, "StartTime": "08:07 AM", "FinishTime": "06:33 PM", "MessageEnum": 0, "IsNoImpactEnabled": false}, {"UserId": "D44B9A04-35C0-4176-9CC9-2B7779AC2835", "CompanyId": "6E919CFE-74DD-4EBC-8665-3C0D44866649", "UserName": "Ramkrishna Maurya", "UserEmail": "Ramkrishna.Maurya@kwglobal.com", "TotalTime": "10h 29m", "TotalDeskTime": "8h 3m", "DeskTime": 483, "ProductiveTime": "7h 48m", "UnProductiveTime": "0h 0m", "NeutralTime": "0h 15m", "NoImpactTime": "0h 0m", "TotalIdleTime": "0h 0m", "MostUsedApps": "<ApplicationReports><ApplicationReportModel><ApplicationName>devenv.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>chatgpt.com</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>SSMS.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>ms-teams.exe</ApplicationName></ApplicationReportModel><ApplicationReportModel><ApplicationName>sheridan.jira.com</ApplicationName></ApplicationReportModel></ApplicationReports>", "Commits": null, "WorkItemsActivity": null, "LoggedWorkItems": null, "IsAttendanceBasedOnTracking": true, "IsUserHavingShift": true, "StartTime": "11:41 AM", "FinishTime": "10:10 PM", "MessageEnum": 0, "IsNoImpactEnabled": false}], "app_usage": [{"ApplicationName": "Notepad", "TotalDuration": "03:23:22", "Percentage": "15.14", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "ms-teams", "TotalDuration": "02:55:43", "Percentage": "13.08", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "Idle (Meeting)", "TotalDuration": "02:18:20", "Percentage": "10.30", "ProductivityRanking": "Neutral", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "TimeChamp", "TotalDuration": "00:47:57", "Percentage": "3.57", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "chrome", "TotalDuration": "00:11:54", "Percentage": "0.89", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "explorer", "TotalDuration": "00:09:46", "Percentage": "0.73", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "olk", "TotalDuration": "00:05:43", "Percentage": "0.43", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "PickerHost", "TotalDuration": "00:01:26", "Percentage": "0.11", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "SearchHost", "TotalDuration": "00:00:10", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "ShellHost", "TotalDuration": "00:00:10", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "devenv", "TotalDuration": "04:33:05", "Percentage": "20.32", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "ms-teams", "TotalDuration": "02:03:24", "Percentage": "9.18", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "mstsc", "TotalDuration": "00:18:39", "Percentage": "1.39", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "notepad++", "TotalDuration": "00:14:30", "Percentage": "1.08", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "setup", "TotalDuration": "00:08:58", "Percentage": "0.67", "ProductivityRanking": "Neutral", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "msedge", "TotalDuration": "00:07:42", "Percentage": "0.57", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "TimeChamp", "TotalDuration": "00:01:17", "Percentage": "0.10", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "explorer", "TotalDuration": "00:01:15", "Percentage": "0.09", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "GitHubDesktop", "TotalDuration": "00:00:49", "Percentage": "0.06", "ProductivityRanking": "Neutral", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "FortiClient", "TotalDuration": "00:00:32", "Percentage": "0.04", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "SearchHost", "TotalDuration": "00:00:28", "Percentage": "0.03", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "ShellExperienceHost", "TotalDuration": "00:00:26", "Percentage": "0.03", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "CredentialUIBroker", "TotalDuration": "00:00:24", "Percentage": "0.03", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "Ditto", "TotalDuration": "00:00:07", "Percentage": "0.01", "ProductivityRanking": "Neutral", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "FortiTray", "TotalDuration": "00:00:05", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "devenv", "TotalDuration": "02:05:27", "Percentage": "9.34", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "SSMS", "TotalDuration": "01:07:36", "Percentage": "5.03", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "ms-teams", "TotalDuration": "00:49:59", "Percentage": "3.72", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "notepad++", "TotalDuration": "00:16:57", "Percentage": "1.26", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "GitHubDesktop", "TotalDuration": "00:14:59", "Percentage": "1.12", "ProductivityRanking": "Neutral", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "TimeChamp", "TotalDuration": "00:08:14", "Percentage": "0.61", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "FortiClient", "TotalDuration": "00:04:24", "Percentage": "0.33", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "ShellExperienceHost", "TotalDuration": "00:04:09", "Percentage": "0.31", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "SnippingTool", "TotalDuration": "00:01:37", "Percentage": "0.12", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "explorer", "TotalDuration": "00:01:24", "Percentage": "0.10", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "Postman", "TotalDuration": "00:00:59", "Percentage": "0.07", "ProductivityRanking": "Neutral", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "SearchHost", "TotalDuration": "00:00:47", "Percentage": "0.06", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "msedge", "TotalDuration": "00:00:25", "Percentage": "0.03", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "WindowsTerminal", "TotalDuration": "00:00:20", "Percentage": "0.02", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "chrome", "TotalDuration": "00:00:05", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "StartMenuExperienceHost", "TotalDuration": "00:00:02", "Percentage": "0.00", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "Code", "TotalDuration": "00:00:01", "Percentage": "0.00", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}], "web_usage": [{"ApplicationName": "youtube.com", "TotalDuration": "00:54:58", "Percentage": "17.41", "ProductivityRanking": "UnProductive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "sheridan.jira.com", "TotalDuration": "00:32:26", "Percentage": "10.27", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "bitbucket.org", "TotalDuration": "00:09:52", "Percentage": "3.12", "ProductivityRanking": "Neutral", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "google.com", "TotalDuration": "00:03:06", "Percentage": "0.98", "ProductivityRanking": "Productive", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "fast.com", "TotalDuration": "00:02:38", "Percentage": "0.83", "ProductivityRanking": "Neutral", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationName": "sheridan.jira.com", "TotalDuration": "00:07:08", "Percentage": "2.26", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "www.google.com", "TotalDuration": "00:04:54", "Percentage": "1.55", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "smartreview-uat.kwglobal.com", "TotalDuration": "00:04:09", "Percentage": "1.31", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "msdashboard.kwglobal.com", "TotalDuration": "00:03:02", "Percentage": "0.96", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "github.com", "TotalDuration": "00:02:05", "Percentage": "0.66", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "outlook.cloud.microsoft", "TotalDuration": "00:01:32", "Percentage": "0.49", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "cjkgroupinc-my.sharepoint.com", "TotalDuration": "00:01:21", "Percentage": "0.43", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "portal.azure.com", "TotalDuration": "00:00:45", "Percentage": "0.24", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "smartreview.kwglobal.com", "TotalDuration": "00:00:42", "Percentage": "0.22", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "app.powerbi.com", "TotalDuration": "00:00:25", "Percentage": "0.13", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "teams.public.onecdn.static.microsoft", "TotalDuration": "00:00:12", "Percentage": "0.06", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "learninghub.kwglobal.com", "TotalDuration": "00:00:06", "Percentage": "0.03", "ProductivityRanking": "Productive", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationName": "chatgpt.com", "TotalDuration": "02:02:27", "Percentage": "38.78", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "sheridan.jira.com", "TotalDuration": "00:24:11", "Percentage": "7.66", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "smartreview-uat.kwglobal.com", "TotalDuration": "00:15:40", "Percentage": "4.96", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "learninghub.kwglobal.com", "TotalDuration": "00:06:34", "Percentage": "2.08", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "www.scimagojr.com", "TotalDuration": "00:04:39", "Percentage": "1.47", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "smartreview.kwglobal.com", "TotalDuration": "00:03:50", "Percentage": "1.21", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "cjkgroupinc-my.sharepoint.com", "TotalDuration": "00:03:32", "Percentage": "1.12", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "www.figma.com", "TotalDuration": "00:03:15", "Percentage": "1.03", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "github.com", "TotalDuration": "00:01:08", "Percentage": "0.36", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "outlook.cloud.microsoft", "TotalDuration": "00:00:40", "Percentage": "0.21", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "learn.microsoft.com", "TotalDuration": "00:00:18", "Percentage": "0.10", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "localhost", "TotalDuration": "00:00:07", "Percentage": "0.04", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationName": "msdn.microsoft.com", "TotalDuration": "00:00:05", "Percentage": "0.03", "ProductivityRanking": "Productive", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}], "category_usage": [{"ApplicationCategoryName": "PRINT ACCOUNT_IDC", "TotalDuration": "03:24", "Percentage": "12.356", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationCategoryName": "Work Apps/URLs", "TotalDuration": "03:23", "Percentage": "12.296", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationCategoryName": "Others", "TotalDuration": "02:30", "Percentage": "9.085", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationCategoryName": "Personal URLs", "TotalDuration": "00:54", "Percentage": "3.271", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationCategoryName": "Office Apps", "TotalDuration": "00:48", "Percentage": "2.907", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationCategoryName": "Development", "TotalDuration": "00:32", "Percentage": "1.938", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationCategoryName": "BackGround", "TotalDuration": "00:03", "Percentage": "0.182", "UserName": "Ameya Shinde", "EmployeeNumber": "46850"}, {"ApplicationCategoryName": "Development", "TotalDuration": "04:33", "Percentage": "16.535", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationCategoryName": "PRINT ACCOUNT_IDC", "TotalDuration": "02:39", "Percentage": "9.631", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationCategoryName": "Work Apps/URLs", "TotalDuration": "00:18", "Percentage": "1.090", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationCategoryName": "Office Apps", "TotalDuration": "00:16", "Percentage": "0.969", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationCategoryName": "Others", "TotalDuration": "00:09", "Percentage": "0.545", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationCategoryName": "HE and STM Apps", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Gauravsingh Rana", "EmployeeNumber": "47412"}, {"ApplicationCategoryName": "PRINT ACCOUNT_IDC", "TotalDuration": "04:02", "Percentage": "14.658", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationCategoryName": "Development", "TotalDuration": "03:13", "Percentage": "11.690", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationCategoryName": "Office Apps", "TotalDuration": "00:26", "Percentage": "1.575", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationCategoryName": "Others", "TotalDuration": "00:15", "Percentage": "0.909", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}, {"ApplicationCategoryName": "HE and STM Apps", "TotalDuration": "00:06", "Percentage": "0.363", "UserName": "Ramkrishna Maurya", "EmployeeNumber": "47411"}], "timesheet": [{"TimeSheetId": "48100BB5-F51E-45FF-801D-3A7BDD7439BF", "UserId": "056B4BBD-1E0B-4168-B754-BAD7044BE5E7", "UserName": "Ameya.Shinde@kwglobal.com", "TeamName": "M-Sheridan", "IsNoImpactEnabled": false, "RoleName": " Manager", "ReportToEmployeeName": "Rajnarrayan Bose", "ReportToEmployeeMail": "Rajnarrayan.Bose@kwglobal.com", "Shift": "07:00 IST - 06:55 IST", "DepartmentName": "Technology-Software Engineering", "MobileNo": null, "Date": "2026-07-29T00:00:00", "ActiveTimeInSec": 41857, "ProductiveTimeInSec": 29508, "UnProductiveTimeInSec": 3298, "NeutralTimeInSec": 9051, "NoImpactTimeInSec": 0, "TotalIdleTime": 5429, "UserBreaksCount": 0, "EmployeeName": "Ameya Shinde", "UserProfileImage": null, "TimeZoneId": null, "LunchBreakEndTime": null, "LunchBreakStartTime": null, "InTime": "2026-07-29T11:20:14.823281+05:30", "InTimeAbbreviation": null, "OutTimeAbbreviation": null, "LunchStartAbbreviation": null, "LunchEndAbbreviation": null, "InTimeTimeZone": null, "OutTimeTimeZone": null, "LunchStartTimeZone": null, "LunchEndTimeZone": null, "OutTime": "2026-07-30T01:38:07.385177+05:30", "PunchCardBased": false, "LatestInsertedTrackerDate": null, "LunchBreakDiff": null, "UsersBreakTime": null, "IsNextDay": 1, "SpentTimeDiff": 51473, "TotalOfflineTime": 4187, "LunchTimeInSec": null, "UsersBreakTimeInSec": 0, "EmployeeNumber": "46850", "LoggedTime": null, "AttendanceStatus": "", "BranchName": "KGL-MUM", "DesktopName": "XINMBDLNDQRT", "TotalSpentTime": 129.07, "FullDayMinimumHours": 8.0, "HalfDayMinimumHours": 4.0, "AbsentDayMinimumHours": 4.0, "AttendanceAbsentTime": 697, "AttendanceHalfOrFullDayTime": 697, "IsAttendacneBasedOnPercentage": false, "TotalTimeInSec": 51473}, {"TimeSheetId": "2596890C-DD09-4D5A-AFD5-740D904E1402", "UserId": "11F5ECB4-134E-4168-8084-0C4E5011513C", "UserName": "Gauravsingh.Rana@kwglobal.com", "TeamName": "M-KGL Smart-Suite", "IsNoImpactEnabled": false, "RoleName": " User", "ReportToEmployeeName": "Ameya Shinde", "ReportToEmployeeMail": "Ameya.Shinde@kwglobal.com", "Shift": "07:00 IST - 06:55 IST", "DepartmentName": "Technology-Software Engineering", "MobileNo": null, "Date": "2026-07-29T00:00:00", "ActiveTimeInSec": 28759, "ProductiveTimeInSec": 28163, "UnProductiveTimeInSec": 0, "NeutralTimeInSec": 595, "NoImpactTimeInSec": 0, "TotalIdleTime": 1448, "UserBreaksCount": 0, "EmployeeName": "Gauravsingh Rana", "UserProfileImage": null, "TimeZoneId": null, "LunchBreakEndTime": null, "LunchBreakStartTime": null, "InTime": "2026-07-29T08:07:34.546957+05:30", "InTimeAbbreviation": null, "OutTimeAbbreviation": null, "LunchStartAbbreviation": null, "LunchEndAbbreviation": null, "InTimeTimeZone": null, "OutTimeTimeZone": null, "LunchStartTimeZone": null, "LunchEndTimeZone": null, "OutTime": "2026-07-29T18:33:16.113481+05:30", "PunchCardBased": false, "LatestInsertedTrackerDate": null, "LunchBreakDiff": null, "UsersBreakTime": null, "IsNextDay": 0, "SpentTimeDiff": 37542, "TotalOfflineTime": 7335, "LunchTimeInSec": null, "UsersBreakTimeInSec": 0, "EmployeeNumber": "47412", "LoggedTime": null, "AttendanceStatus": "", "BranchName": "KGL-MUM", "DesktopName": "XINMBLVNSRQ7", "TotalSpentTime": 88.7, "FullDayMinimumHours": 8.0, "HalfDayMinimumHours": 4.0, "AbsentDayMinimumHours": 4.0, "AttendanceAbsentTime": 479, "AttendanceHalfOrFullDayTime": 479, "IsAttendacneBasedOnPercentage": false, "TotalTimeInSec": 37542}, {"TimeSheetId": "2F3505FB-704A-4825-8F68-2F0879F2CC1A", "UserId": "D44B9A04-35C0-4176-9CC9-2B7779AC2835", "UserName": "Ramkrishna.Maurya@kwglobal.com", "TeamName": "M-KGL Smart-Suite", "IsNoImpactEnabled": false, "RoleName": " User", "ReportToEmployeeName": "Ameya Shinde", "ReportToEmployeeMail": "Ameya.Shinde@kwglobal.com", "Shift": "07:00 IST - 06:55 IST", "DepartmentName": "Technology-Software Development", "MobileNo": null, "Date": "2026-07-29T00:00:00", "ActiveTimeInSec": 29038, "ProductiveTimeInSec": 28080, "UnProductiveTimeInSec": 0, "NeutralTimeInSec": 958, "NoImpactTimeInSec": 0, "TotalIdleTime": 0, "UserBreaksCount": 0, "EmployeeName": "Ramkrishna Maurya", "UserProfileImage": null, "TimeZoneId": null, "LunchBreakEndTime": null, "LunchBreakStartTime": null, "InTime": "2026-07-29T11:41:44.623587+05:30", "InTimeAbbreviation": null, "OutTimeAbbreviation": null, "LunchStartAbbreviation": null, "LunchEndAbbreviation": null, "InTimeTimeZone": null, "OutTimeTimeZone": null, "LunchStartTimeZone": null, "LunchEndTimeZone": null, "OutTime": "2026-07-29T22:10:40.379420+05:30", "PunchCardBased": false, "LatestInsertedTrackerDate": null, "LunchBreakDiff": null, "UsersBreakTime": "0h 40m", "IsNextDay": 0, "SpentTimeDiff": 37736, "TotalOfflineTime": 8698, "LunchTimeInSec": null, "UsersBreakTimeInSec": 2404, "EmployeeNumber": "47411", "LoggedTime": null, "AttendanceStatus": "", "BranchName": "KGL-MUM", "DesktopName": "XINMBLVNLPW5", "TotalSpentTime": 89.44, "FullDayMinimumHours": 8.0, "HalfDayMinimumHours": 4.0, "AbsentDayMinimumHours": 4.0, "AttendanceAbsentTime": 483, "AttendanceHalfOrFullDayTime": 483, "IsAttendacneBasedOnPercentage": false, "TotalTimeInSec": 37736}], "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": 2, "app_usage": 42, "web_usage": 30, "category_usage": 18, "timesheet": 3}}

Stage 3 — Rendered

Rendered 2026-07-30 02:31:25.640705 · 39803 bytes

Subject: Daily associates summary report - Jul 29, 2026

Attachments
[{"name": "ManagerDailyAssociateSummaryReport_2026-07-29.xlsx", "path": "runs/cbf1d198-61ab-4d38-ab3e-1123da50fd08-attachments/056B4BBD-1E0B-4168-B754-BAD7044BE5E7-ManagerDailyAssociateSummaryReport_2026-07-29.xlsx", "sizeBytes": 11345, "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 Ameya Shinde,</span><br /> Here is the summary report of your
                    associates for <span style="font-weight: 600;"> Jul 29, 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;">Gauravsingh Rana</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;">08:07 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; ">06:33 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;">7h 59m</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; ">7h 49m</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; ">0h 9m</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 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"  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> devenv.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> 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> 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>  <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;"><span style = "color: #363636; margin: 0px;font-size: 35px; font-weight: bold;" >.</span> notepad++.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><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;">Ramkrishna Maurya</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:41 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; ">10:10 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 3m</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; ">7h 48m</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; ">0h 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 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> devenv.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> chatgpt.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> SSMS.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> 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> sheridan.jira.com </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
5DAAAEE2-538D-457C-92E8-420CEA8862C3
Skip reason
Error
At
2026-07-30 02:31:29.152233

Events

AtStageLevelMessagemsWorker
2026-07-30 02:30:41.986660 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=Ameya.Shinde@kwglobal.com userId=056B4BBD-1E0B-4168-B754-BAD7044BE5E7 thr-9784
2026-07-30 02:30:42.007660 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='056B4BBD-1E0B-4168-B754-BAD7044BE5E7', @Date='2026-07-29') thr-9784
2026-07-30 02:30:44.885023 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 2 row(s) in 2844ms; 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=11F5ECB4-134E-4168-8084-0C4..., CompanyId=6E919CFE-74DD-4EBC-8665-3C0..., UserName=Gauravsingh Rana, UserEmail=Gauravsingh.Rana@kwglobal.com, TotalTime=10h 26m, TotalDeskTime=7h 59m, DeskTime=479, ProductiveTim...} 2844 thr-9784
2026-07-30 02:30:44.925020 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-29', @IsApp=1, @IsForLineManager=1, @LineManagerId='056B4BBD-1E0B-4168-B754-BAD7044BE5E7') thr-9784
2026-07-30 02:30:45.196027 DataFetch Info <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 42 row(s) in 233ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber]; first_row={ApplicationName=Notepad, TotalDuration=03:23:22, Percentage=15.14, ProductivityRanking=Productive, UserName=Ameya Shinde, EmployeeNumber=46850} 233 thr-9784
2026-07-30 02:30:45.246024 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-29', @IsApp=0, @IsForLineManager=1, @LineManagerId='056B4BBD-1E0B-4168-B754-BAD7044BE5E7') thr-9784
2026-07-30 02:30:45.273027 DataFetch Info <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 30 row(s) in 12ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber]; first_row={ApplicationName=youtube.com, TotalDuration=00:54:58, Percentage=17.41, ProductivityRanking=UnProductive, UserName=Ameya Shinde, EmployeeNumber=46850} 12 thr-9784
2026-07-30 02:30:45.299024 DataFetch Info >>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-29', @IsForLineManager=1, @LineManagerId='056B4BBD-1E0B-4168-B754-BAD7044BE5E7') thr-9784
2026-07-30 02:30:45.700978 DataFetch Info <<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 18 row(s) in 386ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber]; first_row={ApplicationCategoryName=PRINT ACCOUNT_IDC, TotalDuration=03:24, Percentage=12.356, UserName=Ameya Shinde, EmployeeNumber=46850} 386 thr-9784
2026-07-30 02:30:45.710979 DataFetch Info >>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-07-29', @DateTo='2026-07-29', @OperationsPerformedBy='056B4BBD-1E0B-4168-B754-BAD7044BE5E7', @EmployeeSearchText=NULL, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) thr-9784
2026-07-30 02:31:24.750826 DataFetch Info <<< USP_EmailComp_DownloadTimesheet returned 3 row(s) in 39013ms; 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=48100BB5-F51E-45FF-801D-3A7..., UserId=056B4BBD-1E0B-4168-B754-BAD..., UserName=Ameya.Shinde@kwglobal.com, TeamName=M-Sheridan, IsNoImpactEnabled=False, RoleName= Manager, ReportToEmployeeName=Rajnarrayan ...} 39013 thr-9784
2026-07-30 02:31:24.786821 DataFetch Info Soft labels: batch-cache hit (105 keys) thr-9784
2026-07-30 02:31:24.819825 DataFetch Info AssociateSummary fetched — associates=2, app_usage=42, web_usage=30, category_usage=18, timesheet=3 thr-9784
2026-07-30 02:31:24.858823 DataFetch Info Wrote EmailComp_Job_Data (27433 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] 42840 thr-9784
2026-07-30 02:31:24.879824 Render Info --- Stage 3 begin --- template=AssociateSummary recipient=Ameya.Shinde@kwglobal.com thr-9784
2026-07-30 02:31:24.883825 Render Info dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) thr-9784
2026-07-30 02:31:25.653705 Render Info Rendered (39803 bytes, subject='Daily associates summary report - Jul 29, 2026', attachments=1) 773 thr-9784
2026-07-30 02:31:26.027664 QA Info QA passed (15 check(s)) 311 thr-9784
2026-07-30 02:31:26.076663 Dispatch Info >>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Ameya.Shinde@kwglobal.com', @Subject='Daily associates summary report - Jul 29, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='e245203c-4c6a-4c57-9909-df1121033c9e') thr-9784
2026-07-30 02:31:26.144664 Dispatch Info <<< USP_EmailComp_InsertMail returned MailId=5daaaee2-538d-457c-92e8-420cea8862c3 in 46ms (inserted) 46 thr-9784
2026-07-30 02:31:29.048231 Dispatch Info >>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=5daaaee2-538d-457c-92e8-420cea8862c3, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/8dd564c848a445198def2eb3313edbd7_056B4BBD-1E0B-4168-B754-BAD7044BE5E7-ManagerDailyAssociateSummaryReport_2026-07-29.xlsx') thr-9784
2026-07-30 02:31:29.063232 Dispatch Info <<< USP_EmailComp_InsertMailAttchment OK in 7ms 7 thr-9784
2026-07-30 02:31:29.090233 Dispatch Info Inserted into SentMail. MailId=5daaaee2-538d-457c-92e8-420cea8862c3 thr-9784