Dell Server Administrator Report

[Jsarosy]

Hello,

Looking for failed hard drives in Dell Servers. Doesn't seem to come up under the builtin SMART Hard drive reports. Was wondering if it is possible to create a custom report from the server event logs.  The event is recorded in Lansweeper. 

For example, under Event Log under the server, there is an entry -

Server Administrator - Event 2048 System - Time xxx

Severity: Critical, Category: Storage, MessageID: STOR0212, Message: The Physical Disk 0:1:6 on Controller 0 at Connector 0 has failed.

Could a report be created that could run against all the servers in the domain? 

Thanks!

[Jsarosy]

Thanks! That worked like a charm! 

[Mister_Nobody · Accepted solution]

Select Top 10000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Username,
  tblNtlogSource.Sourcename,
  tblNtlog.Eventcode,
  tblNtlog.TimeGenerated,
  tblNtlogMessage.Message,
  tblAssets.OScode
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
  Inner Join tblNtlogSource On tblNtlogSource.SourcenameID =
      tblNtlog.SourcenameID
  Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID
Where tblNtlogSource.Sourcename = 'server administrator' And
  tblNtlog.Eventcode = '2048' And
  tblAssetCustom.State = 1
Order By tblNtlog.TimeGenerated Desc