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.


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

        New to ADManager Plus?

          New to ADSelfService Plus?

            • Related Articles

            • 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 report to extract Active Technician Login and IP Address

              Go to Reports- New Query Report and execute this query. select DISTINCT ac.ACCOUNT_ID as "Login Account ID", au.FIRST_NAME as "Technician Name ( First Name )", count(acs.SESSION_ID) as "Number of Logins", LONGTODATE(max(acs.OPENTIME)) as "Last Login ...
            • Query to show KPI report based on technician

              Working on Builds: 14500 Database: MSSQL, PGSQL 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 ...
            • Report to get list of Requesters with Requester created time and created by

              Kindly execute the report under Report -> New Query Report.  SELECT AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName",  longtodate(aaauser.createdtime) "Created time",   AaaContactInfo.EMAILID "Email",  DepartmentDefinition.DEPTNAME ...
            • Query to find out who created Accounts (MSSQL & PGSQL)

              Tested in build PGSQL (14300) and MSSQL (14306) 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 ...