The reason for this was due to the fact that scheduled reports are currently only visible to the technician that creates them in ManageEngine ServiceDesk Plus. In this case the scheduled reports the client was looking for had been created under a different technician account.
select rst.reportid”Report ID”,crd.report_name”Report Name”,au.first_name”Technician Name”,rst.ownerid”Technician ID”,sd.status”Active/Resigned” from reportscheduletask rst left join customreport_details crd on crd.reportid=rst.reportid left join aaauser au on au.user_id=rst.ownerid left join sduser sd on sd.userid=au.user_id;
-
Go to [ServiceDesk Plus – Home] pgsqlbin in the command prompt.
C:> cd ManageEngineServiceDeskPluspgsqlbin
-
Enter the command: psql.exe -U postgres -h 127.0.0.1 -p 65432 servicedesk
C:> cd ManageEngineServiceDeskPluspgsqlbin> psql.exe -U postgres -h 127.0.0.1 -p 65432 servicedesk
This article is relevant to:
AnalyticsService DeskOther recent articles in the same category
You may be interested in these other recent articles
ManageEngine ServiceDesk Plus Cloud Build Release Information
25 July 2024
Summary details of the current Build Release information for ManageEngine ServiceDesk Plus Cloud Edition. All upgrades are performed by the Zoho Cloud team. Should you…
Read moreManageEngine Analytics Plus Build Release Information
23 July 2024
Summary details of the current build release information for ManageEngine Analytics Plus. Scroll the above to view more release details. Download the latest service packs…
Read moreManageEngine ADSelfService Plus Build Release Information
12 July 2024
The current build release information for ManageEngine ADSelfService Plus is summarised below. Scroll down for more information. You can download the latest service packs here.…
Read moreManageEngine Password Manager Pro Build Release Information
21 June 2024
The current build release information for ManageEngine Password Manager Pro is summarised below. Scroll down for more information. You can download the latest service packs…
Read moreSecurity Advisory – Important Security Fix Released For ManageEngine Solutions
17 June 2024
Product Name Affected Version(s) Fixed Version Fixed on Password Manager Pro 12430 and below 12431 14/06/2024 PAM360 7000 and below 7001 14/06/2024 DetailsAn SQL injection…
Read more