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

    • SDP & Jira Integration Document: Technical Installation Guide

      SDP → Jira Cloud Integration Setup Guide Contents ? Overview 1. Overview & Architecture 2. Network / Firewall 3. Jira Preparation 3.1 API Token 3.2 Base64 String 3.3 Finding Field ID 3.4 Postman Test 4. Callback Function 4.1 Creation 4.2 Deluge ...

    • Password Manager Pro – Reporting of Manually Created Users and Last Login Dates

      ? Request Summary A list of users created manually (Add Manually) under the Users menu in Password Manager Pro (PMP) is needed. This list, in particular: Clearly distinguishes between manually generated users. Includes the user's last logon date. It ...

    • ServiceDesk Plus - Query for Service Catalog and Category Export

      This document is available on ManageEngine ServiceDesk Plus : Export Service Catalog Exporting the Category/Subcategory/Item structure It is designed for users who want to carry out their transactions. * The relevant queries are compatible with the ...

    • OAuth Mail Configuration

      Configuring ServiceDesk Plus OAuthentication Microsoft has announced that it will begin disabling Basic Auth for Outlook, EWS, POP, IMAP, EAS, and RPS protocols in Exchange Online starting October 1, 2022. As an alternative, we have prepared a guide ...