‎02-28-2015 06:26 PM
Solved! Go to Solution.
‎03-02-2015 12:01 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblState.Statename As State,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblErrors.ErrorText,
tsyserrortype.Errorname
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblState On tblAssetCustom.State = tblState.State
Left Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
Left Join tsyserrortype On tblErrors.ErrorType = tsyserrortype.ErrorType
Where tsysAssetTypes.AssetTypename Like 'switch' And tblAssets.Lastseen <
GetDate() - 1 And tblAssetCustom.State = 1
‎03-03-2015 10:04 AM
‎03-02-2015 12:01 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblState.Statename As State,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblErrors.ErrorText,
tsyserrortype.Errorname
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblState On tblAssetCustom.State = tblState.State
Left Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
Left Join tsyserrortype On tblErrors.ErrorType = tsyserrortype.ErrorType
Where tsysAssetTypes.AssetTypename Like 'switch' And tblAssets.Lastseen <
GetDate() - 1 And tblAssetCustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now