Detect devices unplugged

[MWBrown]

Can I see in Lansweeper if a user has disconnected a monitor? I am trying to find a way to detect if a user takes a monitor from one computer and plugs it into another.

[Daniel_B · Accepted solution]

Another method which might be easier: Under Configuration\Item Wait Time enable history logging for MONITOR. Afterwards use a report like the following which lists any changes scanned for connected monitors:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Username,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Lastseen,
  Case tblMonitorHist.Action When 1 Then '+' When 2 Then '-'
  End As [Monitor +/-],
  tblMonitorHist.LastChanged,
  tblMonitorHist.MonitorModel,
  tblMonitorHist.SerialNumber
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblMonitorHist On tblAssets.AssetID = tblMonitorHist.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  tblMonitorHist.LastChanged Desc

[Daniel_B]

Lansweeper creates asset relations between monitors and computers and stores the date when an asset relation was first scanned (or manually created). You could generate a report which lists this information. Please find an example report below.

If this does not help you to get an overview, you might need to manually add asset user relations between users and computers as well as users and monitors (please find a KB article here about adding asset user relations). Afterwards you will be able to track if a monitor was connected to a computer which should be owned by another user.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tConnected.Lastseen,
  tsysAssetRelationTypes.Name As Relation,
  tConnected.AssetName As [connected to],
  tblAssetRelations.StartDate As since
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetRelations
    On tblAssets.AssetID = tblAssetRelations.ChildAssetID
  Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID =
    tblAssetRelations.Type
  Left Join tblAssets tConnected On tConnected.AssetID =
    tblAssetRelations.ParentAssetID
Where tsysAssetTypes.AssetTypename = 'monitor' And tblAssetCustom.State = 1
Order By tblAssets.AssetName