List of Shared computers

[MrSaw]

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.

[dwinters]

Thanks for this. I was just searching for something like this here.

[jprateragg]

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