Providing Admin Role
Login to pgsql database using command prompt
D:\>cd MEReports\AnalyticsPlus\pgsql\bin>
D:\MEReports\AnalyticsPlus\pgsql\bin>psql.exe -h localhost -p 33366 -U postgres
psql (9.5.1)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
postgres=#
Selecting accountsdb
postgres=# \c accountsdb
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
You are now connected to database "accountsdb" as user "postgres".
accountsdb=#
Execute the query
Get the user's Zuid (replace first_name with appropriate value)
select zuid,first_name from iamuser;
Make him Admin by replacing the text in red with the value
update iamuser set user_role=2 where zuid in ('zuid')
New to ADSelfService Plus?
Related Articles
Changing hostname in Servicedesk >Admin >Advanced Analytics settings
Lets assume analyticsplus.server.com:8443 as the FQDN that you wish to update in servicedesk>Admin>Advanced analytics settings page Launch Command prompt in servicedesk server as administrator Navigate to <ServicedeskPlus_home>\pgsql\bin >psql.exe -U ...Auto start Analytics Plus in Linux
Steps to auto start Analytics Plus in Linux environment: 1. Open "StartServer.sh" present in <AnalyticsPlus\bin> Add '#!/bin/sh' as the first line of the code. Add 'cd <location to Analytics/bin>' before the line 'sh run.sh' ex : ...Steps to perform Repopulation for sync issue
Symptoms: [SYSERR]|[INFO]|[61]: java.lang.NullPointerException| [SYSERR]|[INFO]|[61]: at com.manageengine.framework.sqlbuilder.AQBManager.updateColumnDetailCache(AQBManager.java:488)| Cause: The mismatch between ZRMEModules.xml and SDP UI. ...Steps to import approval date
We can fetch the approval date data from ServiceDesk Plus using the following workaround. Below are the steps to be followed to successfully import the data. Step 1: Click Import data within the ServiceDesk Plus database in Analytics Plus. Step 2: ...How to activate the personal edition of Analytics Plus
I have installed Analytics Plus and I don't see an option to activate Personal Edition. How do I get a personal Edition of Analytics Plus? Analytics Plus now has a download setup where you will be on the Professional Edition for the first 30 days. ...