Query to list the custom and query reports and the technician created
The query displays the custom reports and query reports saved by technicians.
SELECT custrepdet.report_name "Report Name",
au.first_name"Created By" from customreportquery custrep
LEFT JOIN customreport_details custrepdet ON custrep.reportid=custrepdet.reportid
LEFT JOIN aaauser au on au.user_id=custrepdet.ownerid left join sduser sd on sd.userid=au.user_id
where au.first_name is not NULL
DB: MSSQL and Postgres
Steps to Change Report Owner
Kindly follow the below instruction to change the report owner. ( From Tech A to Tech B) Query to get Technician User ID: SELECT * FROM AAAUSER WHERE FIRST_NAME LIKE '%TECH NAME%'; You may replace the Tech A name and Tech B name to get the user ...
Query to show technician created time
PGSQL & MSSQL: SELECT AaaUser.FIRST_NAME "Technician Name", aci.emailid "Email ID", LONGTODATE(AaaUser.createdtime) "Technician Created Time", SDUSER.STATUS "Status(Active/Inactive)" FROM AaaUser left JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID ...
Query to show KPI report based on technician
This report is already available under Frequently asked reports under Reports->New Query Reports page. Below query can be used for date filter and filter by technicians name modifications. SELECT ti.FIRST_NAME "Technician", count(wo.WORKORDERID) ...
How to remove a Scheduled Report Created By Another Technician
Please note that you would not be able to edit the scheduled reports (private) created by other technicians. However, you can delete the unwanted scheduled reports you don't have access to, by connecting to the database. 1. In order to find the list ...
Query to find out who created Accounts
Execute the below queries under Reports->New Query Report. select org_id, org_name from accountdefinition ad where ad.org_name in('Requester Name', 'Palanivel Palras','Muhammad Nadeem Khan') Note down the Org_IDs of the above query from the result ...