Excess license usage shown for support reps in SCP 8.1

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

                    • SCP, SDP and MSP Differences

                      Though ManageEngine has multiple HelpDesk applications, they are developed and targeted for Different markets. Here are few cases to understand the difference between them. HelpDesk Applications in ManageEngine (ME) are as follows :  1. SupportCenter ...
                    • 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 ...
                    • 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 ...
                    • How to apply renewed license when the existing one expires

                      The steps have to be carried out from ServiceDesk installed server, Go to Services.msc and stop the ManageEngine ServiceDesk Plus Service, after which open the command prompt with Admin privileges (Run it as Administrator) and point to the bin ...
                    • Support Groups configuration

                      1) The support groups that we are configuring in a template is always based on the sites. When we have more than one account assigned in the template, only the support groups added under “Default Settings” will get displayed in the template. Refer ...