samp_country records in Software Asset Management<!-- /*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: ; } } .kb-wrapper { font-family: Lato, sans-serif; font-size: 12pt; color: #000000; line-height: 1.7; max-width: 100%; } .kb-wrapper p { margin: 0 0 12px 0; } .kb-wrapper h2 { font-size: 14pt; font-weight: 900; color: #032D42; border-bottom: 2px solid #e8fce4; padding-bottom: 6px; margin: 28px 0 14px 0; } .kb-wrapper h3 { font-size: 12pt; font-weight: 900; color: #032D42; border-bottom: 2px solid #e8fce4; padding-bottom: 4px; margin: 20px 0 10px 0; } .kb-wrapper ul { padding-left: 22px; margin: 0 0 14px 0; } .kb-wrapper ul li { margin-bottom: 8px; } .kb-wrapper ol.steps { list-style: none; padding-left: 0; counter-reset: step-counter; margin: 0 0 14px 0; } .kb-wrapper ol.steps > li { counter-increment: step-counter; position: relative; padding-left: 38px; margin-bottom: 14px; } .kb-wrapper ol.steps > li::before { content: counter(step-counter); position: absolute; left: 0; top: 2px; width: 26px; height: 26px; background: #032D42; color: #63DF4E; border-radius: 50%; font-size: 10pt; font-weight: 900; text-align: center; line-height: 26px; } .kb-wrapper ol.steps > li ul { margin-top: 8px; } .kb-wrapper .toc { background: #f5f8fa; border: 1px solid #d8e6ee; border-radius: 4px; padding: 14px 22px; margin-bottom: 8px; display: inline-block; min-width: 230px; } .kb-wrapper .toc-title { font-weight: 900; color: #032D42; font-size: 11pt; margin: 0 0 8px 0; } .kb-wrapper .toc ul { padding-left: 18px; margin: 0; } .kb-wrapper .toc ul li { margin-bottom: 4px; font-size: 11pt; } .kb-wrapper a { color: #52B8FF; text-decoration: none; } .kb-wrapper a:hover { text-decoration: underline; } .kb-wrapper .toc a { color: #032D42; } .kb-wrapper code { background: #e6f0f5; color: #032D42; border: 1px solid #b8cfd8; border-radius: 3px; padding: 1px 5px; font-family: 'Courier New', monospace; font-size: 10.5pt; } .kb-wrapper .related-links ul { list-style: none; padding-left: 0; } .kb-wrapper .related-links ul li { margin-bottom: 6px; } Overview The samp_country table stores country records used for grouping during Software Asset Management (SAM) Reconciliation. These records are created automatically when you select Country as a grouping option during the reconciliation process. How samp_country records are created When SAM Reconciliation runs with country grouping enabled, the system uses the sn_itam_samp.GroupingUtil script include to perform the following steps: Collect unique country values from the country field on the Location [cmn_location] table.Search for matching records in the samp_country table by comparing the name field.Return or create records based on the search results: If a matching samp_country record exists, the system returns the first matching record.If no matching record exists, the system creates a new samp_country record with the name field set to the country value from the Location [cmn_location] table. Important considerations Duplicate country records Because the process relies on exact matching of unique values from the country field in the Location [cmn_location] table, data inconsistencies can create multiple samp_country records representing the same country. Example: If your Location records contain different variations such as UK and United Kingdom, the system treats these as distinct values and creates a separate samp_country record for each variation. To prevent this, regularly review the country field in the Location [cmn_location] table for duplicate or inconsistent values before running reconciliation. Related Links Reconciliation of licenses across global entities