Servicedesk Plus System Log Report

Query that Reports System Logs in the Product - PgSQL

Hello,
Below is the query report that provides a breakdown of all transactions on the Servicedesk Plus product.

To run this report, you can run the query and document the results via the Reports --> New Report --> Query Report menu.

  1. SELECT err.message "System log message", err.errormodule "Module", err.suberrormodule "Sub Module", err.action "Action", err.type "Type", au.first_name "Performed by", longtodate(err.occurredtime) "Time of occurrence" FROM errorlog err LEFT JOIN aaauser au ON err.ownerid=au.user_id where au.first_name!='System'

    • Related Articles

    • Tracking Custom Event Log in OpManager

      Hello, In today's article, I will share information with you about tracking Custom Event Log in OpManager software. Although the Best Practice is to use the "EventLog Analyzer" product to perform many tracking such as this, we can also perform custom ...
    • Endpoint Central SIEM Integration

      There is no syslog forwarding feature for operations performed on the EPC. Instead, two different methods can be used. 1) Transferring logs via REST API. API Details : API Endpoint : /emsapi/server/auditLogs API Description: To fetch the event logs ...
    • ADAudit Plus – Alerts and Alert Profiles Guide

      What is ADAudit Plus? ADAudit Plus is a software used specifically for monitoring and securing Active Directory (AD) environments. This software monitors, audits, and reports on Active Directory and Windows Server-based systems. In short, ADAudit ...
    • Servicedesk Plus - Changing Local Account Password Using Script

      Reset Local Authentication Password You can follow the steps below to activate local authentication when logging into the SDP portal or to easily change the password of accounts used with local authentication. How can you change the password of your ...
    • ServiceDesk Plus - Request ID Reset and Start from a Specific Value Guide

      There may be some scenarios where, after testing Servicedesk Plus and then going live or in long-term SDP usage, the Request ID number is requested to start from 1 again while preserving the configurations. In these scenarios, it is possible to reset ...