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.
- 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 ...