cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Michael_V
Champion Sweeper III
This report shows the items and computers that took the most time to scan.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
TsysWaittime.CFGname,
TsysLastscan.Scantime,
TsysLastscan.Lasttime
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
Where tblAssetCustom.State = 1
Order By TsysLastscan.Scantime Desc
3 REPLIES 3
MDGraves
Engaged Sweeper III
thx for code and reply.
Michael_V
Champion Sweeper III
Scantime is in seconds.
MDGraves
Engaged Sweeper III
Is that in milliseconds?