{"id":416,"date":"2020-07-22T18:17:10","date_gmt":"2020-07-22T17:17:10","guid":{"rendered":"http:\/\/techsupportblog.co.uk\/?p=416"},"modified":"2021-12-11T20:31:09","modified_gmt":"2021-12-11T20:31:09","slug":"configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out","status":"publish","type":"post","link":"https:\/\/techtodd.co.uk\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/","title":{"rendered":"ConfigMgr &#8220;All instances of the objects that are related to the assigned security roles&#8221; Greyed Out"},"content":{"rendered":"\n<p>I came across an issue today where I couldn&#8217;t tick the box to automatically upgrade the ConfigMgr client on all devices after an SCCM upgrade. It turns out that to do so, you need to have the Assigned security scope setting of &#8220;All instances of the objects that are related to the assigned security roles&#8221;.<\/p>\n\n\n\n<p>When trying to apply this to my account I worked out that the person that installed ConfigMgr has to change this permission. In my case, that person had left the business and their AD account had been deleted.<\/p>\n\n\n\n<p><strong>NOTE: Before proceeding, please ensure you understand what you are changing and that you have a backup of your database. Making this change is likely to void Microsoft support, so do so at your own risk.<\/strong><\/p>\n\n\n\n<p>I came across a post on the Microsoft forums that allowed you to change this from SQL directly by swapping the user account used to set up ConfigMgr with your own. To do so, run <\/p>\n\n\n\n<p>SELECT * FROM dbo.RBAC_Admins<\/p>\n\n\n\n<p>You should be able to see your account and the one that was used to setup ConfigMgr. Using the ID in the first column, run the following SQL query, ensuring you change the 4 sections:<br>&#8220;new admin id&#8221;<br>&#8220;new logon name ie domain\\username&#8221;<br>&#8220;new display name&#8221;<br>&#8220;old admin id&#8221;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DECLARE @Y varbinary(85)\nSET @Y = (Select [AdminSID] from [dbo].[RBAC_Admins] WHERE [AdminID] = &lt;new admin id&gt;)\nUPDATE [dbo].[RBAC_Admins] \n   SET [AdminSID] = CONVERT(varbinary(85), @Y, 1),\n   [LogonName] = '&lt;new logon name ie domain\\username&gt;',\n   [DisplayName] = '&lt;new display name&gt;'\n WHERE [AdminID] = &lt;old admin id&gt;\nGO<\/pre>\n\n\n\n<p>It should look something like this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DECLARE @Y varbinary(85)\nSET @Y = (Select [AdminSID] from [dbo].[RBAC_Admins] WHERE [AdminID] = 1754545)\nUPDATE [dbo].[RBAC_Admins] \n   SET [AdminSID] = CONVERT(varbinary(85), @Y, 1),\n   [LogonName] = 'Domain\\John.Smith',\n   [DisplayName] = 'John Smith'\n WHERE [AdminID] = 175422\nGO<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>I came across an issue today where I couldn&#8217;t tick the box to automatically upgrade the ConfigMgr client on all devices after an SCCM upgrade. It turns out that to do so, you need to have the Assigned security scope setting of &#8220;All instances of the objects that are related to the assigned security roles&#8221;. [&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":[4],"tags":[],"class_list":["post-416","post","type-post","status-publish","format-standard","hentry","category-sccm"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ConfigMgr &quot;All instances of the objects that are related to the assigned security roles&quot; Greyed Out | Tech Todd<\/title>\n<meta name=\"description\" content=\"How to fix &quot;All instances of the objects that are related to the assigned security roles&quot; in Configuration Manager.\" \/>\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\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ConfigMgr &quot;All instances of the objects that are related to the assigned security roles&quot; Greyed Out | Tech Todd\" \/>\n<meta property=\"og:description\" content=\"How to fix &quot;All instances of the objects that are related to the assigned security roles&quot; in Configuration Manager.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/\" \/>\n<meta property=\"og:site_name\" content=\"Tech Todd\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-22T17:17:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-11T20:31:09+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\\\/2020\\\/07\\\/22\\\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2020\\\/07\\\/22\\\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\\\/\"},\"author\":{\"name\":\"TC\",\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/#\\\/schema\\\/person\\\/12f10ae88eec753067405d37c00f9103\"},\"headline\":\"ConfigMgr &#8220;All instances of the objects that are related to the assigned security roles&#8221; Greyed Out\",\"datePublished\":\"2020-07-22T17:17:10+00:00\",\"dateModified\":\"2021-12-11T20:31:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2020\\\/07\\\/22\\\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\\\/\"},\"wordCount\":241,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/#\\\/schema\\\/person\\\/12f10ae88eec753067405d37c00f9103\"},\"articleSection\":[\"SCCM\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2020\\\/07\\\/22\\\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2020\\\/07\\\/22\\\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\\\/\",\"url\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2020\\\/07\\\/22\\\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\\\/\",\"name\":\"ConfigMgr \\\"All instances of the objects that are related to the assigned security roles\\\" Greyed Out | Tech Todd\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/#website\"},\"datePublished\":\"2020-07-22T17:17:10+00:00\",\"dateModified\":\"2021-12-11T20:31:09+00:00\",\"description\":\"How to fix \\\"All instances of the objects that are related to the assigned security roles\\\" in Configuration Manager.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2020\\\/07\\\/22\\\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2020\\\/07\\\/22\\\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/index.php\\\/2020\\\/07\\\/22\\\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/project1-v4xcrw2sui.live-website.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ConfigMgr &#8220;All instances of the objects that are related to the assigned security roles&#8221; Greyed Out\"}]},{\"@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":"ConfigMgr \"All instances of the objects that are related to the assigned security roles\" Greyed Out | Tech Todd","description":"How to fix \"All instances of the objects that are related to the assigned security roles\" in Configuration Manager.","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\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/","og_locale":"en_GB","og_type":"article","og_title":"ConfigMgr \"All instances of the objects that are related to the assigned security roles\" Greyed Out | Tech Todd","og_description":"How to fix \"All instances of the objects that are related to the assigned security roles\" in Configuration Manager.","og_url":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/","og_site_name":"Tech Todd","article_published_time":"2020-07-22T17:17:10+00:00","article_modified_time":"2021-12-11T20:31:09+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\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/#article","isPartOf":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/"},"author":{"name":"TC","@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/#\/schema\/person\/12f10ae88eec753067405d37c00f9103"},"headline":"ConfigMgr &#8220;All instances of the objects that are related to the assigned security roles&#8221; Greyed Out","datePublished":"2020-07-22T17:17:10+00:00","dateModified":"2021-12-11T20:31:09+00:00","mainEntityOfPage":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/"},"wordCount":241,"commentCount":1,"publisher":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/#\/schema\/person\/12f10ae88eec753067405d37c00f9103"},"articleSection":["SCCM"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/","url":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/","name":"ConfigMgr \"All instances of the objects that are related to the assigned security roles\" Greyed Out | Tech Todd","isPartOf":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/#website"},"datePublished":"2020-07-22T17:17:10+00:00","dateModified":"2021-12-11T20:31:09+00:00","description":"How to fix \"All instances of the objects that are related to the assigned security roles\" in Configuration Manager.","breadcrumb":{"@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/project1-v4xcrw2sui.live-website.com\/index.php\/2020\/07\/22\/configmgr-all-instances-of-the-objects-that-are-related-to-the-assigned-security-roles-greyed-out\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/project1-v4xcrw2sui.live-website.com\/"},{"@type":"ListItem","position":2,"name":"ConfigMgr &#8220;All instances of the objects that are related to the assigned security roles&#8221; Greyed Out"}]},{"@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-6I","_links":{"self":[{"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/416","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=416"}],"version-history":[{"count":2,"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/416\/revisions"}],"predecessor-version":[{"id":418,"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/416\/revisions\/418"}],"wp:attachment":[{"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techtodd.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}