Select Top (1000000) tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetName,
tblAssets.AssetID,
tblErrors.CFGname,
tsysasseterrortypes.ErrorMsg As Issue,
tblErrors.ErrorText As [Issue Message],
tblassets.LastseenCredentials as [Last Successful Credentail],
tblassets.LasttriedCredentials as [Last Tried Credential],
tblassets.LasttriggeredCredentials as [Last Manually Triggered Tried Credential],
tblAssets.Firstseen As [Created at],
tblAssets.Lastseen As [Last successful scan],
tblAssets.Lasttried,
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 Outer Join tsysIPLocations On tblAssets.LocationID =
tsysIPLocations.LocationID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1 And Coalesce(tblAssets.OScode, '') = ''
Order By tblErrors.Lastchanged Desc,
tblAssets.AssetName