Checks to create new reclamation candidates for MS CopilotIssue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } 1. After attaching MS usage data exported from MS admin to the integration profile2. executed two jobs successully- SAM - Collect Microsoft 365 Usage- SAM - Create New Reclamation Candidates for Office 365 Integration3. New software usage data have been updated: /samp_sw_usage_list.do?sysparm_query=norm_product.prod_nameLIKEplanner%5EORnorm_product.prod_nameLIKEvisio%5EORnorm_product.prod_nameLIKEcopilot&sysparm_first_row=1&sysparm_view=4. The xml from integration profile shows the sync dates below: {"ConnectionAliasId":"SYSID","validate_connection":"success","error_message":"","warning_message":"","Office365ActiveUserDetailReportRefreshDate":"2026-06-06","Office365ActiveUserDetailSyncDate":"2026-06-08 08:43:33","M365AppUserDetailReportRefreshDate":"2026-06-05","M365AppUserDetailSyncDate":"2026-06-08 09:17:21","OneDriveStorageUsageReportRefreshDate":"2026-06-06","OneDriveStorageUsageSyncDate":"2026-06-08 09:29:12","MailBoxStorageUsageReportRefreshDate":"2026-06-06","MailBoxStorageUsageSyncDate":"2026-06-08 09:32:48","activationReportRefreshDate":"2026-06-06","activationSyncDate":"2026-06-08 09:36:59","powerBIAPIStatus":"success","VisioReportRefreshDate":"6/1/2026","VisioSyncDate":"2026-06-04 14:43:34","CopilotReportRefreshDate":"6/1/2026","CopilotSyncDate":"2026-06-04 14:47:25","ProjectReportRefreshDate":"6/2/2026","ProjectSyncDate":"2026-06-04 14:45:39"}5 . But there's no new reclamation candidate were created for Copilot product Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } All Releases Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Copilot follows a different code path than standard products like Exchange Online or Teams. This product must pass a 7-day sync freshness check before the code will evaluate them for reclamation.Once the Copilot sync runs successfully and CopilotSyncDate is within 7 days of the reclamation job execution, the code will proceed to evaluate Copilot subscriptions for reclamation.Additionally once the latest copilot usage data is synced successfully, below are the additional checks we run before creating reclamation candidatesCheck 1 :The code checks whether external_created field (or sys_created_on if null) on the samp_sw_subscription record is older than last_activity_threshold ( example - 90 days for reclamation rule). If the subscription is newer than 90 days, stale stays false and no candidate is created.Check 2 :If the Check 1 passes , then the code evaluates staleness. If last_activity is populated on the subscription record, it must be older than the threshold (90 days). If last_activity is null, the outcome depends on include_no_activity defined on the reclamation rule — currently it is set to false, meaning null activity = not stale = no candidate.So if the subscription record has last_activity greater than 90 days, then we will create the reclamation candidate for this assuming it has passed Check 1 listed aboveIf the subscription record has last_activity set to empty, then we have set the include_no_activity to true on the reclamation rule to consider the subscription as a reclamation candidateCheck 3 :Before creating a candidate, the code checks to verify no active reclamation candidate with a low_usage justification already exists for this subscription (either as a user_subscription / subscription_to_retain on the Reclamation. Candidate header, or as an entry in the samp_sw_rc_m2m_subscription table). If a duplicate exists, creation is skipped.So if all the above 3 checks pass, only then the reclamation candidate is created.