Errors report

[harringg]

We have an issue with some XP machines and the firewall.

Is there a report that can show:
Only if it is an XP machine and has the following error: [Type] Ping Failed

That will tell me which machines need our script run to "fix" them.

[harringg]

Thanks. That'll work great for what I'm trying to do.

[Hemoco · Accepted solution]

The built-in error reports only list machines that have never been successfully scanned. You can run the report below to list Windows machines that generated an error in the last week.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblErrors.CFGname,
tsysasseterrortypes.ErrorMsg As Type,
tblErrors.ErrorText As Message,
tblErrors.Lastchanged
From tblAssets
Inner Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysasseterrortypes On tblErrors.ErrorType =
tsysasseterrortypes.Errortype
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblErrors.Lastchanged > GetDate() - 7 And tblAssetCustom.State = 1 And
tblAssets.Assettype = -1
Order By tblErrors.Lastchanged Desc,
tblAssets.AssetName

[Hemoco]

If a machine is never successfully scanned, Lansweeper cannot know what the OS is either.

[harringg]

Lansweeper wrote:
If a machine is never successfully scanned, Lansweeper cannot know what the OS is either.

They have been with manual scan.

Eitherway, is there a general Errors report? Regardless of OS?