Excess license usage shown for support reps in SCP 8.1
1. Go to reports - > New query report, and execute the below query.
select * from aaauser aaau join sduser sdu on aaau.user_id=sdu.userid inner join helpdeskcrew hd on sdu.userid=hd.technicianid inner join aaalogin aaal on hd.technicianid=aaal.user_id where sdu.STATUS='ACTIVE'
This will show the total number of support reps with active login.
2. Based on the above result, if any support rep that doesn't require a login is shown, the same can be edited and the login can be removed or the user shall be deleted.
3. Go to the contact module, and open any contact. In the URL, replace the userid with the support rep's user ID as per step 1's report output.
This will take you to the support rep details page. Edit and remove the login or delete the user based on your requirement.
New to ADSelfService Plus?
Related Articles
Query for Support Rep list in DB
Please run this query to find the list of Support Reps available with login in the system select * from aaauser aaau join sduser sdu on aaau.user_id=sdu.userid inner join helpdeskcrew hd on sdu.userid=hd.technicianid inner join aaalogin aaal on ...Workaround for Contacts tab not visible for support reps (post 11.0 version)
Post 11.0, the contacts tab will not be shown at the top for support reps. As a workaround follow these steps 1. Goto Admin -> ZOHO Creator apps 2. Click on Add Links -> Provide Link Name as Contacts -> URL as ...Database migration from MySQL to Postgres/MSSQL in SCP 8.1
We no longer support the use of MYSQL as database in SupportCenter Plus. Hence, we request our users to migrate to Postgres (which is in-built) or Microsoft SQL. Please follow the below steps to carry out the database migration: 1. Shutdown the ...SCP upgrade from 11.0 to 14.0 prerequisites
Before migration to scp version 14 below 2 points has to be done in scp 11027 1. Back up password should not be default i.e SCP123!, it should be updated 2. TLSv1, TLSv1.1 has to be added under the file /home/jre/lib/security/java.security file ( ...Script to Notify Support Reps when a new reply is received for Unassigned Requests
Please do follow the below steps to notify support reps when an unassigned request is updated or when a reply is received. 1. Download the configuration.json file, sendMail.py file, requestobj.json file from the below link: ...