Notification

Icon
Error

Number Of Application Hang Event ID 1002 Count , Null - I'm looking for How to count the Total number of Application Hang

Posted: Monday, November 25, 2019 6:18:15 PM(UTC)
HRS

HRS

Member Original PosterPosts: 2
0
Like
For Example server XXXXX01 Total Application hang Number= 4

Select Top 1000000 tblAssets.AssetName As AssetName1,
tblAssets.Domain,
tblAssets.AssetID,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblNtlog.Eventcode,
Case tblNtlog.Eventtype
When 1 Then 'Error'
When 2 Then 'Warning'
When 3 Then 'Information'
When 4 Then 'Security Audit Success'
When 5 Then 'Security Audit Failure'
End As EventType,
tblNtlog.TimeGenerated,
tblNtlogFile.Logfile
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblNtlog On tblNtlog.AssetID = tblAssets.AssetID
Inner Join tblNtlogFile On tblNtlogFile.LogfileID = tblNtlog.LogfileID
Where (tblAssets.AssetName = 'XXXXX01' Or tblAssets.AssetName =
'XXXXX02' Or tblAssets.AssetName = 'XXXXX03' Or
tblAssets.AssetName = 'XXXXX04') And tblNtlog.Eventcode = '1002' And
Case tblNtlog.Eventtype
When 1 Then 'Error'
When 2 Then 'Warning'
When 3 Then 'Information'
When 4 Then 'Security Audit Success'
When 5 Then 'Security Audit Failure'
End = 'Error' And tblNtlog.TimeGenerated > GetDate() - 7
Order By AssetName1,
tblAssets.Domain,
tblNtlog.TimeGenerated Desc
HRS
#1HRS Member Original PosterPosts: 2  
posted: 11/29/2019 9:42:49 PM(UTC)
Select Top 1000000 tblAssets.AssetName,
tblAssets.Domain,
tblAssets.AssetID,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Lastseen,
tblAssets.Lasttried,
case when count.count is null
then 0
else count.count end as [Number of 10016]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
left Join (select Eventcode, assetid, count(assetid) as Count from tblntlog where TimeGenerated > GetDate() - 7 and Eventcode = 10016 group by assetid,eventcode) Count on Count.assetid = tblassets.assetid
Where (tblAssets.AssetName in ('XXXXX01','XXXXX02','XXXXX03','XXXXX04'))
Order By AssetName,
tblAssets.Domain

Active Discussions

Installer Installer - Microsoft Office
by  Florian_Eigsi   Go to last post Go to first unread
Last post: 6/29/2020 3:33:20 PM(UTC)
Installer Firefox ESR 68.8.0 MSI Installer
by  PLSJohnJohn   Go to last post Go to first unread
Last post: 5/11/2020 4:33:50 PM(UTC)
Installer Update Chrome browser with GoogleUpdate.exe ?
by  Inna Ptushkina  
Go to last post Go to first unread
Last post: 5/4/2020 8:39:29 PM(UTC)
Installer Bios Update for Dell all in one
by  Florian_Eigsi   Go to last post Go to first unread
Last post: 4/2/2020 11:36:43 AM(UTC)
Installer Windows 10 Upgrade
by  Michael Kop  
Go to last post Go to first unread
Last post: 3/27/2020 4:47:52 PM(UTC)
Installer Uninstall - Adobe Acrobat 9x
by  palemmo   Go to last post Go to first unread
Last post: 3/25/2020 7:25:05 PM(UTC)
Installer OneDrive Silent Install
by  Steven.C  
Go to last post Go to first unread
Last post: 3/13/2020 2:55:19 PM(UTC)