cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MrSaw
Engaged Sweeper
Is there anyway to get a report of computer that have had multiple users log into it? I need to somehow get a list of computer that have more then 1 user log into them and I'm not seeing anyway to do this.
2 REPLIES 2
dwinters
Engaged Sweeper II
Thanks for this. I was just searching for something like this here.
jprateragg
Champion Sweeper
This should hopefully point you in the right direction. It's something I whipped up to show you the asset and the number of unique users >= 2. This only reports back on the last month, but you could always lengthen that or remove it completely. I hope this helps.

Select Top 1000000 a.AssetID,
a.AssetName,
tsysIPLocations.IPLocation,
Count(a.Username) As CountUsername
From (Select Distinct tblCPlogoninfo.AssetID,
tblCPlogoninfo.Username
From tblCPlogoninfo
Where tblCPlogoninfo.logontime Between DateAdd(month, -1, GetDate())
And GetDate()) b
Left Join tblAssets a On b.AssetID = a.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID = a.LocationID
Group By a.AssetID,
a.AssetName,
tsysIPLocations.IPLocation
Having Count(a.Username) > 1
Order By tsysIPLocations.IPLocation,
a.AssetName