get the user logged in the agent

Question

• Version: OCS-NG_WINDOWS_AGENT_v2.10.1.0
• PHP Version: 7.4.3
• Database: Ubuntu 20.04 version 10.3.39-MariaDB-0ubuntu0.20.04.2
• Version OCSReports: 2.9.2

I have created multiple users because I need to distinguish where the data is coming from (by database query). 

However, it seems that the agent is not sending the data (username) with which it connects to ocs. Is there any way to get it? In which table I can find this information?

Answer 1

in old ocs-inventory Servers like 2.x it was stored in mysql in the hardware table under field userid

SELECT * FROM `hardware` WHERE userid like "testuser"

but the installed ocs-inventory agent does not send the user under which account the agent itself runs. It will report the logged on user i think.

The connected user information can change frequently, depending on who is using the machine at the time of inventory

In newer versions ocs-inventory ocs-inventory collects a connected user and a system user.

• The machine user is generally considered the primary or assigned user of the device, regardless of who is currently using it.
• The connected user reflects the account that was actively logged in when the OCS agent collected the inventory data.