‎04-04-2024 10:09 AM
Hi All
I'm trying to create a report that shows a list of users who have more than 1 asset (Computer/Laptop) assigned to their ID in LanSweeper as users are only meant to be assigned one device (but some have managed t.
So far I have the below which is looking promising, but having done a spot check, it seems to be missing some users who have logged onto more than 1 device and I cant see the reason/pattern behind it!
Select Top 1000000 tblAssets.AssetID,
tblAssets.Username,
tblAssets.AssetName,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.State,
tblState.Statename
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblComputerSystem On tblComputerSystem.AssetID = tblAssets.AssetID
Inner Join (Select tblAssets.Userdomain,
tblAssets.Username,
Count(*) As UserCount
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputerSystem On tblComputerSystem.AssetID =
tblAssets.AssetID
Where tblAssets.Userdomain Is Not Null And tblAssets.Username Is Not Null
And tblAssetCustom.State = 1 And tblComputerSystem.DomainRole < 2
Group By tblAssets.Userdomain,
tblAssets.Username) As UserCount On UserCount.UserDomain =
tblAssets.UserDomain And UserCount.UserName = tblAssets.UserName
And UserCount.UserCount > 1
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblAssets.Username Not Like '%L_A%' And tblAssets.AssetName Not Like
'%vdi%' And tblComputerSystem.DomainRole < 2
Order By tblAssets.Userdomain,
tblAssets.Username,
tblAssets.AssetName
Any ideas?
‎07-18-2024 09:59 AM
We work with the lspush and it´s work fine for this
‎07-17-2024 07:19 PM
Hello @justanotherbod
This is a GREAT question. The challenge to answering this is first to understand that Lansweeper isn't a "monitoring tool". I say that because in order to fully know, real-time, who's using a computer, the asset must be scanned upon login -- via GPO's, login script, or local auto-runs, etc.
Therefore, to be 100% certain who's using which asset will require a few changes to the frequency and method of scanning that asset. You may want to consider some options.
LsPush is a comman line tool that is often recommended for this type of scanning upon login. Here's a KB that talks about LsPush: LsPush fallback scanning - Lansweeper Community. I'd also recommend searching our KB's for "LsPush".
Another work around can be found in ProTip #54. Jacob explains ways that you can use LsAgent to scan during login. To clarify, LsAgent is only designed to scan based off a schedule that's configured within the Web Console. But Jacob gives some ideas around manually making LsAgent run during login.
I don't think this answers your immediate question. But I hope it brings some clarity and work arounds to get the up-to-date and as real-time data as possible.
Let us know how it goes. Best wishes.
Tim
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now