Knowledge Base
ServiceDesk Plus
Full-stack ITSM suite with enterprise service management
AD SelfService Plus
Password self-service, endpoint multi-factor authentication, and enterprise single sign-on
ADAudit Plus
Active Directory auditing and reporting
ADManager Plus
Active Directory, Microsoft 365, and Exchange management and reporting
Analytics Plus
Advanced IT analytics
Applications Manager
Server and application performance monitoring
CloudSecurity Plus
Log management and monitoring for cloud platforms
Exchange Report Plus
Reporting, auditing, and monitoring for hybrid Exchange and Skype
Firewall Analyzer
Firewall rule, configuration, and log management
ServiceDesk Plus - MSP
Full-stack ITSM suite with enterprise service management for MSPs
Log360
Comprehensive SIEM with advanced threat mitigation and ML-driven UEBA
NetFlow Analyzer
Bandwidth monitoring and traffic analysis
OpManager
Integrated network, traffic, firewall, configuration, IP & switch port management
Password Manager Pro
Privileged account management
ServiceDesk Plus Cloud
Full-stack ITSM suite with enterprise service management from the cloud
SupportCenter Plus
Web-based customer support with Active Directory integration
OpManager MSP
Network performance monitoring for MSPs
OpUtils
IP address and switch port management
Recent Articles
Query to show total number of calls received and resolved per month
PGSQL & MSSQL: SELECT count(wo.workorderid) "Total Created", count(case when wo.completedtime >= <from_thismonth> AND wo.completedtime <= <to_thismonth> THEN 1 ELSE NULL END) "Closed" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON ...
Query to show Average response time for Category
PGSQL: SELECT accountdefinition.org_name "Account",cd.categoryname "Category", TO_CHAR(((avg(wo.respondedtime)-avg(wo.createdtime))/1000 || ' second')::interval, 'HH24:MI:SS') "Avg Response Time" FROM workorder wo LEFT JOIN workorderstates wos ON ...
Query to show total time spent for a ticket
PGSQL: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", wo.TITLE AS "Subject", rtdef.NAME AS "Request Type", ti.FIRST_NAME AS "Technician", sdo.NAME AS "Site", ...
Query to show who closed the request
PGSQL & MSSQL: select wo.workorderid "Request ID", aau.first_name "Request Closed By", cit.typename "Role", queuedefinition.queuename "Group" from WorkOrder wo LEFT JOIN WorkOrderHistory woh ON wo.WORKORDERID = woh.WORKORDERID LEFT JOIN ...
Query to show Request and associated task details
PGSQL & MSSQL: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", pd.PRIORITYNAME AS "Priority", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", icd.NAME AS "Item", ti.FIRST_NAME AS "Technician", ...