→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
laurentiun
Engaged Sweeper III
Hi,

Is possible to receive weekly or instant alert for monitor's changes between computers?

Thank you.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Build a report based on the tblMonitorHist database table and have this report mailed to you on a weekly basis by following the instructions on page 145 and beyond of our online documentation: http://www.lansweeper.com/documentation.pdf
A sample report that lists changes that occurred in the last 7 days can be seen below.

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

View solution in original post

4 REPLIES 4
mateussantos73
Engaged Sweeper III

Dear friends,

Could you help us with a report similar to the one above. Excuse my English, I'm from Brazil. I would like to know how to know if there was any hardware change such as changing memory in my machine.

King regards.

Hemoco
Lansweeper Alumni
There's nothing wrong with the report. If there are no results, there haven't been any monitor changes (on active computers) in the last 7 days. Make sure monitor history tracking is enabled in the Lansweeper web console under Configuration/Scanning Setup/Item Wait Time.
laurentiune
Engaged Sweeper
Hello,

This report has no results!
Hemoco
Lansweeper Alumni
Build a report based on the tblMonitorHist database table and have this report mailed to you on a weekly basis by following the instructions on page 145 and beyond of our online documentation: http://www.lansweeper.com/documentation.pdf
A sample report that lists changes that occurred in the last 7 days can be seen below.

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