{"id":5769,"date":"2013-11-26T05:44:46","date_gmt":"2013-11-26T05:44:46","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=5769"},"modified":"2013-11-26T05:44:46","modified_gmt":"2013-11-26T05:44:46","slug":"identify-sage-crm-administrator-users","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/","title":{"rendered":"Identify Sage CRM Administrator users"},"content":{"rendered":"

Role of Sage CRM administrator is to perform various operations which includes Periodic Data Maintenance (Periodic Database Backup and its Recovery), Addition of new fields requested by users, Modifying Selection lookups, Data security by giving proper access privileges to users and teams etc.
\nGUMU Sage 100:<\/b><\/em><\/span> Follow GUMU Sage 100 – Sage CRM Integration Product Page on LinkedIn<\/a>
\nRecently there was a question in one of forum post that how can we identify a user who has System Administrator rights? \u00a0Hence I thought to document it for all of our blog readers and users who are not aware of this thing. There are below 2 ways to identify Sage CRM users who are Administrators.
\nA) From within Sage CRM System
\nB) From Sage CRM Database
\nA) From within Sage CRM System
\n<\/b>1) Login to Sage CRM.
\n2) Navigate to Administration | Users | Users.
\nNote: <\/b>Kindly note that Administration area is not accessible to all users. It is accessible based on the user rights configured from logged in user by Sage CRM Administrator.
\n3) Select System Admin option from the Administration field dropdown.
\n\"UserImg3\"<\/a>
\n4) Click on Find button.
\n5) That\u2019s it. You will get all the users who are Sage CRM Administrators.
\nB) From Sage CRM Database
\n<\/b>To identify the same from Sage CRM database, then you can easily do the same by executing below query on Sage CRM database.
\nselect User_Per_Admin,* from users (nolock)
\nwhere User_Per_Admin=3 and User_Deleted is null
\nNumber of users returned by the above query is the Sage CRM Administrators.
\n\"UserImg2\"<\/a>
\nIf you find this content useful, please drop us an email at crm@greytrix.com<\/a>
\nAlso Read:<\/span><\/strong>
\n 1) <\/span>How to identify and backup correct Sage CRM Database<\/a>
\n2) Identify Sage CRM version and its patches<\/a>
\n3) Assign Administrator Rights to System User of Sage CRM<\/a>
\n4) How to identify Merged Companies in Sage CRM<\/a>
\n5) Ways to Replace Sage CRM License Key<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Role of Sage CRM administrator is to perform various operations which includes Periodic Data Maintenance (Periodic Database Backup and its Recovery), Addition of new fields requested by users, Modifying Selection lookups, Data security by giving proper access privileges to users and teams etc. GUMU Sage 100: Follow GUMU Sage 100 – Sage CRM Integration Product\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,83,332,417],"tags":[],"class_list":["post-5769","post","type-post","status-publish","format-standard","hentry","category-administrator","category-crm72","category-sage-crm","category-user"],"yoast_head":"\nIdentify Sage CRM Administrator users - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Identify Sage CRM Administrator users - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Role of Sage CRM administrator is to perform various operations which includes Periodic Data Maintenance (Periodic Database Backup and its Recovery), Addition of new fields requested by users, Modifying Selection lookups, Data security by giving proper access privileges to users and teams etc. GUMU Sage 100: Follow GUMU Sage 100 – Sage CRM Integration Product\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-11-26T05:44:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/UserImg3.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/\",\"name\":\"Identify Sage CRM Administrator users - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/UserImg3.jpg\",\"datePublished\":\"2013-11-26T05:44:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/UserImg3.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/UserImg3.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Identify Sage CRM Administrator users\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Identify Sage CRM Administrator users - Sage CRM \u2013 Tips, Tricks and Components","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:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/","og_locale":"en_US","og_type":"article","og_title":"Identify Sage CRM Administrator users - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Role of Sage CRM administrator is to perform various operations which includes Periodic Data Maintenance (Periodic Database Backup and its Recovery), Addition of new fields requested by users, Modifying Selection lookups, Data security by giving proper access privileges to users and teams etc. GUMU Sage 100: Follow GUMU Sage 100 – Sage CRM Integration Product\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2013-11-26T05:44:46+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/UserImg3.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/","name":"Identify Sage CRM Administrator users - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/UserImg3.jpg","datePublished":"2013-11-26T05:44:46+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/UserImg3.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/UserImg3.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/26\/identify-sage-crm-administrator-users\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Identify Sage CRM Administrator users"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/5769","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=5769"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/5769\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=5769"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=5769"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=5769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}