SAM- How manual usage CSV upload (Copilot, Visio, Project Online) works and where data mapsSummary<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } 1. How the process starts Customer exports usage CSVs for Project, Visio, and Copilot from the Microsoft 365 admin portal. These CSVs are manually attached to the Microsoft 365 Integration Profile (samp_sw_subscription_profile). 2. Scheduled job execution The scheduled job SAM – Collect Microsoft 365 Usage runs daily and performs these key actions: 1captureManualReportUsageActivity(profile)Reads and parses CSV attachments from the integration profile.2updateLastActivity(profile)Updates the "Last activity" field for subscriptions if the product mapping matches usage data.3deleteAttachmentsForProfile(profile)Deletes the uploaded attachments after processing. 3. File identification and handling The job identifies which attachment belongs to which product (Project, Visio, or Copilot) by checking the filename pattern. It extracts a timestamp from the filename to determine the most recent report. If multiple CSVs are uploaded for the same product, only the newest one is processed. If a previous import already contains newer data, older files are skipped. 4. Data processing and storage The script reads each valid CSV file and, for every user row, captures the Last Activity Date and User Principal Name. These details are recorded as usage activity within the Microsoft 365 usage logic managed by ServiceNow SAM. After the data import completes, attachments are deleted automatically from the Integration Profile. 5. Verification After the job runs, imported activity data can be validated by confirming that user usage and activity details appear under Software Usage / Last Activity for corresponding users. Attachments will no longer be visible — this confirms ingestion was successful. Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Xanadu and later Instructions<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Upload Microsoft 365 usage CSVs for Copilot, Visio, and Project directly to your Microsoft 365 Integration Profile. Allow the job “SAM – Collect Microsoft 365 Usage” to process them (or trigger it manually). The system will: Read and import the CSVs into usage activity data. Update subscription last activity (if mapped products match). Delete the attachments automatically after processing. Recommendations Ensure filenames remain in Microsoft’s default format (e.g., ProjectActivityUserDetail...csv, VisioActivityUserDetail...csv). Avoid renaming files, as filename patterns are used for product mapping. Do not re-upload older files; only the most recent CSV per product is processed. Expect the attachments to be deleted automatically once processed — this is normal and confirms the import was successful.