Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetName, tblAssetCustom.Printerstatus As Status, tblAssetCustom.Printedpages As [Printed Pages], tblAssets.Lastseen, tblAssets.AssetID, tblAssets.IPAddress, tblAssetCustom....
That list only shows the most recent ones.To get all the logins in the past month you will have to use a custom report.This report lists all logins during the past 31 days:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblCPlogoninfo.Us...
This report will show how many computers the user is currently logged into, This will be the best way to determine if the user has more than 1 pc.Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssetCustom.Model...
Found a field which contains this data so it is easier:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Username, tblAssets.IPAddress, tblAssetCustom.Manufacturer, tblOperatingsystem.Caption As Windows, TsysChassisTypes.Chas...