Query to list the custom and query reports and the technician created

Query to list the custom and query reports and the technician created

Use case

The query displays the custom reports and query reports saved by technicians.

Query

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
Filter: None

Sample Report



          • Related Articles

          • 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 ...