Add history for monitor connect to a machine

[leblanc_daniel_]

I wish if it possible to be able to see what monitor was connected to a machine and remove.
The reason is i have seen monitor that where added to a PC that was not suppose to added.
So if i have a user that had a 19inch HP and a month later has 2x 24 samsung, he says alway had 2 monitors of 24 inch and we have no documentation about this, if there was a history of the change from 19 inch to 24, added new monitor when?

Thank you
Daniel

[Hemoco]

The report we provided only lists monitor *changes*, not all monitors in your network. To list all monitors, you need to build a report based on tblMonitor, not tblMonitorHist (which only stores monitor changes).

[leblanc_daniel_]

Thank you, i have tried it and it only pop over 166 PC on around 1000 pc (166/1000), missing a few..loll

help

Dan

[Hemoco]

Please use the report below to list monitor changes. Note that monitor changes will only be tracked if the History checkbox of the Monitor item is ticked under Configuration/Scanning Setup/Item Wait Time.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tsysOS.Image As icon,
Case tblMonitorHist.Action When 1 Then '+' When 2 Then '-' End As Change,
tblMonitorHist.MonitorModel,
tblMonitorHist.SerialNumber,
tblMonitorHist.MonitorManufacturer,
tblMonitorHist.ManufacturedDate,
tblMonitorHist.LastChanged
From tblAssets
Inner Join tblMonitorHist On tblAssets.AssetID = tblMonitorHist.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblMonitorHist.LastChanged Desc