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 Endpoint Central (formerly Desktop Central) On-Premise Build Release Information
25 March 2024
Summary details of the current Build Release information for ManageEngine Endpoint Central. Note: Desktop Central changing its name to Endpoint Central will not affect the…
Read moreManageEngine ADManager Plus Build Release Information
22 March 2024
Summary details of the current build release information for ManageEngine ADManager Plus. Scroll the above to view more release details. Download the latest service packs…
Read moreManageEngine ServiceDesk Plus Cloud Build Release Information
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 OpManager Build Release Information
15 March 2024
Summary details of the current build release information for ManageEngine OpManager. Scroll the above to view more release details. Download the latest service packs here.…
Read moreManageEngine ServiceDesk Plus On-Premise Build Release Information
14 March 2024
Summary details of the current Build Release information for ManageEngine ServiceDesk Plus. To safely upgrade your current instance of ManageEngine ServiceDesk Plus please refer to…
Read more