{"id":94,"date":"2017-09-26T14:04:26","date_gmt":"2017-09-26T13:04:26","guid":{"rendered":"http:\/\/techsupportblog.co.uk\/?p=94"},"modified":"2021-04-18T17:20:07","modified_gmt":"2021-04-18T16:20:07","slug":"scsm-notification-endpoint-missing-user-configuration-item","status":"publish","type":"post","link":"https:\/\/techtodd.co.uk\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/","title":{"rendered":"SCSM Notification Endpoint Missing From User Configuration Item"},"content":{"rendered":"<h3>Overview<\/h3>\n<p>I recently had an issue with SCSM whereby a customer had multiple user CIs that had an email address configured in Active Directory, however their Notification Endpoint (email address) field was not updating in the SCSM console. The end result was that the user wasn&#8217;t being sent workflow or subscription emails.<\/p>\n<p>After a lot of investigation and everything looking okay in terms of AD Connector settings I had to get Microsoft involved to investigate. Microsoft were able to provide a solution to this issue, however they were not able to provide the exact steps that they completed as it involved changes to the database. If completed yourself incorrectly this could effectively void any support that Microsoft could provide you with. <em>Therefore, my recommendation would be to call Microsoft rather than try and fix this yourself.<\/em><\/p>\n<h3>Fixing the issue<\/h3>\n<p><strong>The following were the steps required to resolve the issue, as above I DO NOT advise you complete this work yourself as the steps are not complete, this is just for information:<\/strong><\/p>\n<ol>\n<li>Take a backup of the SCSM Databases (as always)<\/li>\n<li>Open SCSM Powershell and import the <a href=\"https:\/\/smlets.codeplex.com\/\">SMLets module<\/a><\/li>\n<li>Remove ALL of the objects of System Notification Endpoint Class using the following command<code class=\"language-powershell\">Import-Module Smlets<br \/>\nGet-SCSMObject \u2013Class (Get-SCSMClass \u2013Name System.Notification.Endpoint$) | Remove-SCSMObject -Force<\/code><\/li>\n<li>Verify that the objects were marked for deletion in the ServiceManager DB using these queries\n<pre class=\"line-numbers\"><code class=\"language-sql\">select * from RelationshipType with (nolock) where RelationshipTypeName= 'System.UserHasPreference'\n \nselect * from Relationship with (nolock) where RelationshipTypeId = '649E37AB-BF89-8617-94F6-D4D041A05171'\n \nselect * from BaseManagedEntity where BaseManagedtypeId = 'C08E20E3-C0FE-66B8-8C12-BCC1F3F11D5D'\n \nselect * from TypedManagedEntity where ManagedTypeId = 'C08E20E3-C0FE-66B8-8C12-BCC1F3F11D5D'\n \nselect * from ManagedType where ManagedTypeId = 'C08E20E3-C0FE-66B8-8C12-BCC1F3F11D5D'<\/code><\/pre>\n<\/li>\n<li>Groom the objects manually once they are marked for deletion.\u00a0<strong><em>This is the part that Microsoft were not able to provide further information on as they said that this was tricky to complete.<\/em><\/strong><\/li>\n<li>Reset the Datasource Watermark and run the AD connector again to pull the Notification Endpoints back in\n<pre class=\"line-numbers\"><code class=\"language-sql\">-- Execute the following SQL Query to find the DataSourceID number for the AD Connector that is used to bring the users into SM\nUse ServiceManager\nSelect * from LFX.datasource\n \n-- Update the line below replacing # with the corresponding AD connector DataSourceID from above to reset the AD Watermark for that connector.\nexec [LFX].[ResetWatermarkForDataSource] #,'erroroutput'<\/code><\/pre>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Overview I recently had an issue with SCSM whereby a customer had multiple user CIs that had an email address configured in Active Directory, however their Notification Endpoint (email address) field was not updating in the SCSM console. The end result was that the user wasn&#8217;t being sent workflow or subscription emails. After a lot [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[25],"tags":[],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-service-manager"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SCSM Notification Endpoint Missing From User Configuration Item<\/title>\n<meta name=\"description\" content=\"I recently had an issue whereby the SCSM Notification Endpoint (email address) was missing from the user CI. These were the steps taken to resolve it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SCSM Notification Endpoint Missing From User Configuration Item\" \/>\n<meta property=\"og:description\" content=\"I recently had an issue whereby the SCSM Notification Endpoint (email address) was missing from the user CI. These were the steps taken to resolve it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/\" \/>\n<meta property=\"og:site_name\" content=\"Tech Todd\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-26T13:04:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-18T16:20:07+00:00\" \/>\n<meta name=\"author\" content=\"TC\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TC\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2017\\\/09\\\/26\\\/scsm-notification-endpoint-missing-user-configuration-item\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2017\\\/09\\\/26\\\/scsm-notification-endpoint-missing-user-configuration-item\\\/\"},\"author\":{\"name\":\"TC\",\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/#\\\/schema\\\/person\\\/12f10ae88eec753067405d37c00f9103\"},\"headline\":\"SCSM Notification Endpoint Missing From User Configuration Item\",\"datePublished\":\"2017-09-26T13:04:26+00:00\",\"dateModified\":\"2021-04-18T16:20:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2017\\\/09\\\/26\\\/scsm-notification-endpoint-missing-user-configuration-item\\\/\"},\"wordCount\":276,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/#\\\/schema\\\/person\\\/12f10ae88eec753067405d37c00f9103\"},\"articleSection\":[\"Service Manager\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2017\\\/09\\\/26\\\/scsm-notification-endpoint-missing-user-configuration-item\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2017\\\/09\\\/26\\\/scsm-notification-endpoint-missing-user-configuration-item\\\/\",\"url\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2017\\\/09\\\/26\\\/scsm-notification-endpoint-missing-user-configuration-item\\\/\",\"name\":\"SCSM Notification Endpoint Missing From User Configuration Item\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/#website\"},\"datePublished\":\"2017-09-26T13:04:26+00:00\",\"dateModified\":\"2021-04-18T16:20:07+00:00\",\"description\":\"I recently had an issue whereby the SCSM Notification Endpoint (email address) was missing from the user CI. These were the steps taken to resolve it.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2017\\\/09\\\/26\\\/scsm-notification-endpoint-missing-user-configuration-item\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2017\\\/09\\\/26\\\/scsm-notification-endpoint-missing-user-configuration-item\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2017\\\/09\\\/26\\\/scsm-notification-endpoint-missing-user-configuration-item\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SCSM Notification Endpoint Missing From User Configuration Item\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/#website\",\"url\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/\",\"name\":\"Tech Todd\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/#\\\/schema\\\/person\\\/12f10ae88eec753067405d37c00f9103\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/#\\\/schema\\\/person\\\/12f10ae88eec753067405d37c00f9103\",\"name\":\"TC\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b3a6951f4b1a2876b9cb71e98dda385477183f62e689405514ba93c705bf95d7?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b3a6951f4b1a2876b9cb71e98dda385477183f62e689405514ba93c705bf95d7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b3a6951f4b1a2876b9cb71e98dda385477183f62e689405514ba93c705bf95d7?s=96&d=mm&r=g\",\"caption\":\"TC\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b3a6951f4b1a2876b9cb71e98dda385477183f62e689405514ba93c705bf95d7?s=96&d=mm&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SCSM Notification Endpoint Missing From User Configuration Item","description":"I recently had an issue whereby the SCSM Notification Endpoint (email address) was missing from the user CI. These were the steps taken to resolve it.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/","og_locale":"en_GB","og_type":"article","og_title":"SCSM Notification Endpoint Missing From User Configuration Item","og_description":"I recently had an issue whereby the SCSM Notification Endpoint (email address) was missing from the user CI. These were the steps taken to resolve it.","og_url":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/","og_site_name":"Tech Todd","article_published_time":"2017-09-26T13:04:26+00:00","article_modified_time":"2021-04-18T16:20:07+00:00","author":"TC","twitter_card":"summary_large_image","twitter_misc":{"Written by":"TC","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/#article","isPartOf":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/"},"author":{"name":"TC","@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/#\/schema\/person\/12f10ae88eec753067405d37c00f9103"},"headline":"SCSM Notification Endpoint Missing From User Configuration Item","datePublished":"2017-09-26T13:04:26+00:00","dateModified":"2021-04-18T16:20:07+00:00","mainEntityOfPage":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/"},"wordCount":276,"commentCount":0,"publisher":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/#\/schema\/person\/12f10ae88eec753067405d37c00f9103"},"articleSection":["Service Manager"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/","url":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/","name":"SCSM Notification Endpoint Missing From User Configuration Item","isPartOf":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/#website"},"datePublished":"2017-09-26T13:04:26+00:00","dateModified":"2021-04-18T16:20:07+00:00","description":"I recently had an issue whereby the SCSM Notification Endpoint (email address) was missing from the user CI. These were the steps taken to resolve it.","breadcrumb":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2017\/09\/26\/scsm-notification-endpoint-missing-user-configuration-item\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/project1-v4xcrw2sui.live-website.com\/"},{"@type":"ListItem","position":2,"name":"SCSM Notification Endpoint Missing From User Configuration Item"}]},{"@type":"WebSite","@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/#website","url":"https:\/\/project1-v4xcrw2sui.live-website.com\/","name":"Tech Todd","description":"","publisher":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/#\/schema\/person\/12f10ae88eec753067405d37c00f9103"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/project1-v4xcrw2sui.live-website.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/#\/schema\/person\/12f10ae88eec753067405d37c00f9103","name":"TC","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/b3a6951f4b1a2876b9cb71e98dda385477183f62e689405514ba93c705bf95d7?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b3a6951f4b1a2876b9cb71e98dda385477183f62e689405514ba93c705bf95d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b3a6951f4b1a2876b9cb71e98dda385477183f62e689405514ba93c705bf95d7?s=96&d=mm&r=g","caption":"TC"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/b3a6951f4b1a2876b9cb71e98dda385477183f62e689405514ba93c705bf95d7?s=96&d=mm&r=g"}}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pfa3Hp-1w","_links":{"self":[{"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=94"}],"version-history":[{"count":6,"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"predecessor-version":[{"id":111,"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/94\/revisions\/111"}],"wp:attachment":[{"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}