Query report on Maintenance module (MSSQL & PGSQL)
SELECT ad.ORG_NAME "Customer", 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", ...