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
New to ADSelfService Plus?
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 ...