Permission for all technicians to view/associate billing contract names in tickets

Permission for all technicians to view/associate billing contract names in tickets

In certain cases, Contract association permission has been set only to SDAdmins due to which regular technicians does not have permission to associate contracts in tickets. 

This can be verified from the globalconfig table using the below query,

select * from globalconfig where category like '%AssociateContract%';



We can provide permission to all technicians via a DB query.

 It is highly recommended to take a backup / VM Snapshot before executing the queries. 

Kindly plan for a down time since it requires restart of the ME application.

1. Please take a trimmed backup/ VM Snapshot.

2. Kindly Connect to the database and execute the below queries one after the other,

update globalconfig set paramvalue='All technicians' where category like '%ContractAssociationPermission%';

update globalconfig set paramvalue='All technicians' where category like '%ViewAssociatedContractPermission%';

3. Restart the application windows service.

4. Check whether the regular technicians are able to view/associate contracts from tickets.

Note : The param values in the update queries are case sensitive, 
The value is All technicians and not  All Technicians



      New to M365 Manager Plus?
      New to M365 Manager Plus?
        New to RecoveryManager Plus?
        New to RecoveryManager Plus?
          New to Exchange Reporter Plus?
          New to Exchange Reporter Plus?
            New to SharePoint Manager Plus?
            New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                    • Related Articles

                    • Billing Date Errors

                      If the Start date and the billing date are set with the same date confusion occurs while creating a contract. Example: Here is a scenario were the Start date and the billing date are set as '1st' and it's set to quarterly billing. Logically the bill ...

                    • Query to show requests with contract billing, service plan and time spent details (MSSQL)

                      Working on : 14500 MSSQL: SELECT "wo"."WORKORDERID" AS "Request ID", "aau"."FIRST_NAME" AS "Requester", "wo"."TITLE" AS "Subject", "qd"."QUEUENAME" AS "Group", "ti"."FIRST_NAME" AS "Technician", "std"."STATUSNAME" AS "Request Status", ...

                    • Script to create worklog automatically based on technicians leave

                      You need to install Python to achieve the below. You can follow this link to install Python. (A) Create two incident additional fields with Date/time property as below: 1) Start Date  2) End Date Associate these additional fields in your Request ...

                    • Contract Details

                      SELECT mcdt.Contractid "Contract ID", mcdt.CONTRACTNAME "Contract Name", mcdt.comments "Description", contractcategory.Categoryname "Contract Type", LONGTODATE(mcdt.CREATEDDATE) "Created Time", LONGTODATE(mcdt.FROMDATE) "From Date", ...

                    • How to restrict automatic association of technicians to an account / sites ?

                      This article is applicable from 10600 builds. Scenario - At times the technicians will see extra Accounts / Sites in their login. Below is the reason and its solution : -> While creating an account, a common site will be automatically created by ...

                      Related Products