Password Manager Pro Manual User Last Logon Report | KB

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:

  1. Clearly distinguishes between manually generated users.
  2. Includes the user's last logon date.
It has been requested.

🎯 Method of Fulfilling the Request

The request was fulfilled using the Password Manager Pro Query Reports feature.
The custom SQL query report filters users created using the "Add Manually" method on PMP and presents their Last Logon information in the report output.

This allows manual users to:
  1. Whether or not he/she actively uses the system
  2. Identifying accounts that haven't logged in for a long time.
It can be done easily.

🛠️ Implemented Solution – Creating a Query Report

Steps

  1. Password Manager Pro interface is accessed with a user who has Admin privileges.
  2. Go to the Reports tab.
  3. The Query Reports menu is selected.
  4. The "Create New Query Report" option is clicked.
  5. A custom SQL query, prepared to meet the request, is added to the relevant field.
  6. Report information can be defined as desired.
    Example:
    Report Name: Manually Created Users – Last Logon Report
    Description: This report lists the last login dates of users created manually (Add Manually) on PMP.
    Report Category: User
  7. The report is generated by selecting Run / Generate Report.

🔍 SQL Query
  1. SELECT AAALOGIN.NAME AS "Username", PTRX_LANGUAGEMAPPING.TRANSLATEDLANGUAGE AS "Role", AAACONTACTINFO.EMAILID AS "MailId", AAACONTACTINFO.LANDLINE AS "Landline No", t1.status AS "TwoFactorStatus", CASE WHEN AaaAccSession.last_opentime IS NULL THEN NULL ELSE TO_TIMESTAMP(AaaAccSession.last_opentime / 1000) END AS "LastLoginTime" FROM((SELECT t.userid, 'Disabled' AS status FROM(SELECT AaaLogin.USER_ID AS userid, Ptrx_TwoFactorAuth.AUTHENTICATORSTATUS AS status FROM AaaLogin LEFT JOIN Ptrx_UsersTwoFactorAuth ON AaaLogin.USER_ID = Ptrx_UsersTwoFactorAuth.USER_ID LEFT JOIN Ptrx_TwoFactorAuth ON Ptrx_UsersTwoFactorAuth.TWOFACTORID = Ptrx_TwoFactorAuth.TWOFACTORID) t WHERE t.status IS NULL) UNION (SELECT) Ptrx_UsersTwoFactorAuth.USER_ID, 'Enabled' AS status FROM Ptrx_UsersTwoFactorAuth INNER JOIN Ptrx_TwoFactorAuth ON Ptrx_UsersTwoFactorAuth.TWOFACTORID = Ptrx_TwoFactorAuth.TWOFACTORID WHERE Ptrx_TwoFactorAuth.AUTHENTICATORSTATUS = true)) t1 INNER JOIN AaaLogin ON AaaLogin.USER_ID = t1.userid INNER JOIN AaaAccount ON AaaAccount.LOGIN_ID = AaaLogin.LOGIN_ID INNER JOIN AaaUser ON AaaLogin.USER_ID = AaaUser.USER_ID INNER JOIN AaaAuthorizedRole ON AaaAccount.ACCOUNT_ID = AaaAuthorizedRole.ACCOUNT_ID INNER JOIN AaaRole ON AaaAuthorizedRole.ROLE_ID = AaaRole.ROLE_ID INNER JOIN PTRX_LANGUAGEMAPPING ON AAAROLE.NAME = PTRX_LANGUAGEMAPPING.BASELANGUAGE INNER JOIN PTRX_USERDETAILS ON AAAUSER.USER_ID = PTRX_USERDETAILS.USERID INNER JOIN AAAUSERCONTACTINFO ON AAAUSERCONTACTINFO.USER_ID = AAAUSER.USER_ID INNER JOIN AAACONTACTINFO ON AAAUSERCONTACTINFO.CONTACTINFO_ID = AAACONTACTINFO.CONTACTINFO_ID LEFT JOIN (SELECT ACCOUNT_ID, MAX(opentime) AS last_opentime FROM AaaAccSession GROUP BY ACCOUNT_ID) as AaaAccSession ON AaaAccSession.ACCOUNT_ID = AaaAccount.ACCOUNT_ID WHERE PTRX_LANGUAGEMAPPING.LANGUAGEID = 1 AND PTRX_USERDETAILS.ISIMPORTEDUSER = 0 ORDER BY AAALOGIN.NAME;


📊 Report Contents

The generated report includes the following information:
  1. Username – Username
  2. Role – The user's role in Password Manager Pro
  3. Mail ID – The email address assigned to a user.
  4. Last Logon Time – The date and time the user last logged into the system.

    • Related Articles

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

    • ADSelfService Plus – Automatic Password Reset and SMS Sending of Expired Passwords

      ? The goal The purpose of this document is to describe the configuration steps required to automatically reset expired user passwords and send a new password to the user via SMS on ManageEngine ADSelfService Plus. ⚙️ Prerequisites ADSelfService Plus ...

    • PAM360 HTTPS Gateway Server User Guide

      This document was prepared to explain what the HTTPS Gateway Server component in the ManageEngine PAM360 product does, how it is configured, and in which scenarios it can be used. The goal is to comprehensively convey how to enable this feature to ...

    • Password Manager Pro Time Zone Setup

      Hello, In this article, I will explain how you can change the time of the PMP application. This problem can be easily understood by comparing the time written in the report with the time of the machine when drawing a report. It can also be a solution ...

    • Chippers Settings in TLS 1.2v in Password Manager Pro

      Hello, In this article, we will configure the PMP product to work only for TLSv1.2. First, stop the PMP service and take a folder backup of the server or a snapshot of the server. Changes will be made to 3 different files; server.xml , gateway.conf ...