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.
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 TechniciansNew to ADSelfService Plus?
Related Articles
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", ...Query to get Asset contract and its details (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) SELECT mcdt.Contractid "URL Contract ID", mcdt.customcontractid "Custom contractid in details page", mcdt.CONTRACTNAME "Contract Name", aao.NAME "Maintenance Vendor Name", LONGTODATE(mcdt.FROMDATE) ...Query to show tickets older than 30 days ( MSSQL )
Tested in build MSSQL (14306) MSSQL: SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",std.STATUSNAME "Request Status",wo.TITLE "Subject",aau.FIRST_NAME AS "Requester Name", pd.PRIORITYNAME as "Priority", adef.ORG_NAME as "Account", ...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 ...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 ...