Add user logged in to the Linux system

[rafaelduarte]

Hello good afternoon.

We have a report here at lansweeper where I can consult all laptops with a Linux operating system. This report contains: laptop model, cpu, memory, hostname, linux version, servicetag. I need to include the logged in user in the report, but I don't know how to do this. Below is the SQL code for the report:

Select Top 1000000 tblassets.AssetName,
tblLinuxSystem.OSRelease As OS,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblassets.Domain,
tblassets.AssetID,
tblassets.Memory,
tblassets.Username,
tblassetcustom.Model,
tblassetcustom.Serialnumber,
tblassets.IPAddress,
tblassets.Processor As CPU,
tblassets.Firstseen As [Created at],
tblassets.Lastseen As [Last Successful scan]
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tblLinuxSystem On tblassets.AssetID = tblLinuxSystem.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblassets.LocationID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblassets.Assettype
Inner Join tblState On tblState.State = tblassetcustom.State
Where (tblassetcustom.Manufacturer = 'Dell Inc.' And tblassetcustom.State = 1
And tsysAssetTypes.AssetTypename = 'Linux' And tblState.Statename =
'Active') Or
(tblassetcustom.Manufacturer = 'Lenovo')
Order By tblassets.Username

Can you give me some help?
Grateful.

[Mister_Nobody]

https://community.lansweeper.com/t5/reports-analytics/list-of-users-on-linux-servers/m-p/71644

[Mister_Nobody]

https://community.lansweeper.com/t5/general-discussions/linux-last-user-issues/td-p/73715