Announcements
Configuration Management - view/export the list of preventive maintenance tasks with their next scheduled time
This report helps to view/export the list of preventive maintenance tasks with their next scheduled time configured in the application. SELECT swo.WORKORDERID "Scheduled WOID", ti.SCHEDULE_TIME "Next Schedule Time", aau.FIRST_NAME "Requester", sdo.NAME "Site", dpt.DEPTNAME "Department", cd.CATEGORYNAME "Category", scd.NAME "Subcategory", icd.NAME "Item", qd.QUEUENAME "Group", ati.FIRST_NAME "Technician", swo.TITLE "Subject",
Request Management - number of requests submitted per hour
Count of request inflow per hour - provides an insight on monthly opened incidents per hour. It provides you a quick determination on timeframe that received a large number of incidents. This information can then be used by an incident management administrator to determine if a particular department requires additional resources to efficiently manage the number of incidents. PGSQL: SELECT EXTRACT(YEAR FROM (to_timestamp(wo.createdtime/1000)::TIMESTAMP)) "created time", CASE WHEN EXTRACT(MONTH FROM
Change Management - report to generate details of change request
SELECT chdt.changeid "Change ID", chdt.title "Title", Longtodate(chdt.createdtime) "Created Time", Longtodate(chdt.scheduledstarttime) "Scheduled Start Time", Longtodate(chdt.scheduledendtime) "Scheduled End", Longtodate(chdt.completedtime) "Completed Time", orgaaa.first_name "Requested by", ownaaa.first_name "Technician", priodef1.priorityname "Priority", urgdef.NAME "Urgency", ctdef.NAME
Request Management - service template resource questions
Service templates resource questions. This report helps to find the resource questions and values chosen in the request. SELECT WO_Resources.WOID "RequestID",
CatalogResource.TITLE "Resource Question",
Questions.QUESTION "Question",
ResourcesQAMapping.ANSWER "Answer" FROM WO_Resources
LEFT JOIN ResourcesQAMapping ON WO_Resources.UID=ResourcesQAMapping.MAPPINGID
LEFT JOIN CatalogResource ON wo_resources.RESOURCEID=CatalogResource.UID
LEFT JOIN Questions ON Questions.QUESTIONID=ResourcesQAMapping.QUESTIONID
LEFT
Change Management - report on change approval details
SELECT chdt.changeid AS "Change ID", chdt.title AS "Title", orgaaa.first_name AS "Change Requester", qd.queuename AS "Group", ownaaa.first_name AS "Change Owner", catadef.categoryname AS "Category", priodef1.priorityname AS "Priority", Longtodate(chdt.createdtime) AS "Created