→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
harringg
Champion Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

4 REPLIES 4
harringg
Champion Sweeper
Thanks. That'll work great for what I'm trying to do.
Hemoco
Lansweeper Alumni
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
Lansweeper Alumni
If a machine is never successfully scanned, Lansweeper cannot know what the OS is either.
harringg
Champion Sweeper
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?

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now