Scheduled Reports
This report is used to get the complete list of all the scheduled reports with the owner name configured in the application.
SELECT CustomReport_Details.REPORT_NAME "Report Name", AaaUser.FIRST_NAME "Owner" FROM ReportScheduleTask LEFT JOIN CustomReport_Details ON ReportScheduleTask.REPORTID=CustomReport_Details.REPORTID LEFT JOIN SDUser ON ReportScheduleTask.OWNERID=SDUser.USERID LEFT JOIN AaaUser ON SDUser.USERID=AaaUser.USER_ID
New to ADSelfService Plus?
Related Articles
Scheduled Activities page does not load
Ticket id : https://support.servicedeskplus.com/support/meservicedesk/ShowHomePage.do#Cases/dv/72a75b3bf1b901d7235f1a5163370af88e843d302255113e Error : java.lang.NullPointerException Issue : Due to the null value present in the Execution_start_time ...Advanced Analytics - FAQ & Troubleshooting tips
Troubleshooting tips This document is listing of customer facing issues, Advanced analytics is common name for both Zoho reports and Analytics plus. First setup we have to get with customer that recreate issue and generate support log ...Query to fetch Task Worklog and related entity ID
DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 9400 SELECT taskdet.TASKID AS "Task ID", taskdet.TITLE AS "Title", taskowner.FIRST_NAME AS "Owner", taskdet.MODULE AS "Module", wotask.WORKORDERID AS "Request ID", taskprob.PROBLEMID ...Request Time Analysis Reports (Status, Group, Technician Fields changes and its timespent)
This report contains the time analysis for each status/group/technician changes in a request. For builds lower than 11122. Status Changes: SELECT wo.WORKORDERID AS "Request ID", sisd.STATUSNAME as "Changed From",sinsd.STATUSNAME as "Changed ...Query to Pull out Login and LogOut History and to Find User Status
Purpose To generate the report which contains Login and LogOut History of the users and to find out the user status currently. Query 1 Below query provides the users login and logout history of the users. SELECT au.first_name as ...