cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Need default Report SQL

Motaur
Engaged Sweeper

I had an administrator modify a default report several months ago. Can someone provide the SQL for the report Scan issues: RPC server unavailable.  They forgot to do a save as first. 

2 ACCEPTED SOLUTIONS

rader
Champion Sweeper

This is the my default one.

 

Select Top (1000000) tsysAssetTypes.AssetTypeIcon10 As icon,
  tblErrors.AssetID,
  tblAssets.AssetName,
  tsysasseterrortypes.ErrorMsg As Issue,
  tblErrors.ErrorText As [Issue Message],
  tblErrors.Lastchanged As [Last changed],
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As Type,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen As [Created at],
  tblAssets.Lastseen As [Last successful scan]
From tblErrors
  Inner Join tblAssets On tblErrors.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysasseterrortypes On
      tblErrors.ErrorType = tsysasseterrortypes.Errortype
  Left Outer Join tblOperatingsystem On
      tblAssets.AssetID = tblOperatingsystem.AssetID
  Left Outer Join tsysIPLocations On tsysIPLocations.LocationID =
      tblAssets.LocationID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblOperatingsystem.AssetID Is Null And tblAssetCustom.State = 1 And
  tblErrors.ErrorType = 2
Order By [Last changed] Desc

 

View solution in original post

Motaur
Engaged Sweeper

Thanks.  Much appreciated. 

View solution in original post

2 REPLIES 2

rader
Champion Sweeper

This is the my default one.

 

Select Top (1000000) tsysAssetTypes.AssetTypeIcon10 As icon,
  tblErrors.AssetID,
  tblAssets.AssetName,
  tsysasseterrortypes.ErrorMsg As Issue,
  tblErrors.ErrorText As [Issue Message],
  tblErrors.Lastchanged As [Last changed],
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As Type,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen As [Created at],
  tblAssets.Lastseen As [Last successful scan]
From tblErrors
  Inner Join tblAssets On tblErrors.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysasseterrortypes On
      tblErrors.ErrorType = tsysasseterrortypes.Errortype
  Left Outer Join tblOperatingsystem On
      tblAssets.AssetID = tblOperatingsystem.AssetID
  Left Outer Join tsysIPLocations On tsysIPLocations.LocationID =
      tblAssets.LocationID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblOperatingsystem.AssetID Is Null And tblAssetCustom.State = 1 And
  tblErrors.ErrorType = 2
Order By [Last changed] Desc

 

Motaur
Engaged Sweeper

Thanks.  Much appreciated.