3 weeks ago
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!
Solved! Go to Solution.
3 weeks ago
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
3 weeks ago
Thanks! That worked like a charm!
3 weeks ago
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now