cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
justanotherbod
Engaged Sweeper II

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?

2 REPLIES 2
RolandB
Engaged Sweeper III

We work with the lspush and it´s work fine for this

Tim_N
Lansweeper Employee
Lansweeper Employee

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

Tim N.
Lansweeper Employee

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now