I am looking for a query that will show me all workstations with installed software where the software name  is "ManageEngine Endpoint Central" or "ManageEngine Desktop Central" and the last time that the workstation checked in.  I believe that is "Last Contact Time" in the Workstation Asset view.  I would also like to have the name of whom the Workstation is assigned to.

I can then build similar reports for all the software I am interested in monitoring.

I am running ServiceDesk Plus Build 14104 and the database is PostgreSQL

Thank you,

Steve