Table where user assigned to asset is stored in PostgreSQL?
I am wondering if anyone here might know where the user name that is
assigned to an asset (workstation) is stored in the postgres database? I have written a program to make microsoft's Remote Assistance easier to use for us.
It queries the ServiceDesk Plus DB to find the computer name based on user name entry, so I don't have to remember the names of all computers, just type the name of the user that called me and I can connect. I am currently using the last logged on user name (only one I could find), but it breaks down if they log into another computer for some reason. I can't for the life of me figure out where it is in these 1400+ tables.
The two tables I am using now are systeminfo and usersaccountinfo. System info to get the last logged user, then joining to usersaccountinfo to get their full name. Does anyone know where I might get that 'assigned to asset' user name?