Followers report

Followers report

You can use the below query to get the Followers and the request details. Go to Reports --> New Query Report


select wo.workorderid "Request Id",wo.title "Subject",aaau.first_name "Followers",aaauc.emailid "Followers email" from workorder_cclist woc left join workorder wo on woc.workorderid=wo.workorderid left join aaauser aaau on aaau.user_id=woc.follower_id left join aaausercontactinfo aaauci on aaau.user_id=aaauci.user_id left join aaacontactinfo aaauc on aaauci.Contactinfo_id=aaauc.Contactinfo_id
      • Related Articles

      • Login Frequency Query Report

        The below report would help us find the last logged in time of the users in SCP 11.0 SELECT AaaUser.FIRST_NAME "Technician",        MAX(AaaLogin.NAME) "LoginName",        MAX(AaaContactInfo.EMAILID) "Email",        MAX(AaaAccSession.USER_HOST) "IP ...
      • Query report for Time Spent for First response in Version 11.0 (Postgres)

        SELECT slad.SLANAME AS "Request SLA", wo.WORKORDERID AS "Request ID", longtodate(wo.CREATEDTIME) AS "Created Time", slad.SLANAME AS "Request SLA", longtodate(wo.FR_DUETIME) AS "Request first response due time",round(wo.RESPONSE_TIMESPENT / 60000) AS ...
      • Changing the ownership of Report

        In order to change the ownership of the existing Reports, please follow the below steps, 1. connect to your database.  Incase, if your connecting database is postgresql, please refer the below link to connect to it. viz. ...
      • Issue running reports

        Cause : Report API running the background causes the issue. If the user mentions issue with running reports with the below error and trace as mentioned below. Error trace: ...
      • Analytics - SupportCenter Plus integration PKIX path building failed (for SCP 11.0)

        While syncing Analytics Reports, this error may appear where the self-signed certificate to sync both Analytics Reports and SCP will be missing. These traces (mentioned below) can be viewed in the file zrmeinteglog0.txt under the location  ...