Configurations Management
Report on Organizational roles
DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 select r.orgrolename "orgrolename", r.description "Description", au.FIRST_NAME "Name", DepartmentDefinition.DEPTNAME "Department", SDOrganization.NAME "Site" from aaauser au ...
Report on Technician Leaves with date filter
DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 SELECT cre.FIRST_NAME "Created By", LONGTODATE(TechUnavailability.CREATEDDATE) "Created Date", avail.FIRST_NAME "Technician on Leave", back.FIRST_NAME "Backup Technician", ...
Additional field values
This report helps to find the picklist values in the additional fields. First you need to find the name of the table and the column holding the data, by executing the following SDP query report: SELECT Tablename, Columnname FROM ColumnAliases WHERE ...
Login frequency
This report is used to find the Technician and Requester Login frequency. SELECT AaaUser.FIRST_NAME "Technician", MAX(AaaLogin.NAME) "LoginName", MAX(AaaContactInfo.EMAILID) "Email", MAX(AaaAccSession.USER_HOST) "IP Address", ...
Requester details
This report is used to find the Requester complete details. SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...
Technician
This report is used to find the Technician complete details. SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...
SLA details
This report is used to get the complete list of SLA configured in the application. PGSQL SELECT sdo.name "Site Name" , sla.slaname "SLA", MAX(sla.duebydays) "SLA Days", MAX(sla.duebyhours) "SLA Hours", MAX(sla.duebyminutes) "SLA Minutes" , ...
Site details
This report is used to get the complete list of Site detail configured in the application. SELECT sd.name "SiteName", sd.Description "Description", regionDef.REGIONNAME "Region", timezonedefinition.displayname "Timezone", apa.DOOR_NO"Door Number", ...
Department head details
This report is used to get the complete list of Department and the department head configured in the application SELECT dept.deptid "Department ID", dept.deptname "Department Name", dept.phoneno "Phone No", dept.fax "Fax", sdorg.name "Site Name", ...
Technician Roles
This report is used to get the roles of the technicians. For version 10.5 and below SELECT au.FIRST_NAME "Technician", (ar.NAME) "Role" FROM HelpdeskCrew hdc LEFT JOIN SDUser sd ON hdc.TECHNICIANID=sd.USERID LEFT JOIN AaaLogin al ON ...
Technician group
This report is used to get the associated groups of the technicians. SELECT AaaUser.FIRST_NAME "FullName", (SDOrganization.NAME) "Site", (qd.queuename) "Group" FROM AaaUser LEFT JOIN UserDepartment ON AaaUser.USER_ID=UserDepartment.USERID LEFT JOIN ...
Service request approvers
This report helps to find the who all the service request approvers in the application. SELECT aaauser.first_name "Approver Name", dpt.deptname "Department", sdo.name "Site", sd.jobtitle "Job Title" FROM srapproverdetails LEFT JOIN aaauser ON ...
Template configuration
This report will give you the complete list of templates configured in the application. MSSQL SELECT serd.Name AS "Service Category", list.Templatename AS "Template Name", (SELECT STUFF( ( SELECT ',' + tgm.QUEUENAME FROM TemplateToGroupMapping tgm ...
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 ...
Preventive maintenance
This Report is used to export the list of Preventive maintenance configured in the application with the next schedule time. SELECT swo.WORKORDERID "Scheduled WOID", ti.SCHEDULE_TIME "Next Schedule Time", aau.FIRST_NAME "Requester", sdo.NAME "Site", ...
Support Groups
This Report is used to export the list of Support groups configured in the application with the complete details. MSSQL SELECT qd.QUEUENAME "Support group", ci.DESCRIPTION "Description", su.first_name "Owned By", STUFF( (SELECT ',' + au.first_name ...
Export Category,subcategory, item
This report is used to export the tree view. This report helps to import category,subcategory and item in other applications. Modify and import in the applications. SELECT CategoryDefinition.CATEGORYNAME "Category Name", SubCategoryDefinition.NAME ...