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

Lansweeper "add cc user" doesn't show the correct listings
by  JLPingree   Go to last post Go to first unread
Last post: Yesterday at 8:12:44 PM(UTC)
Lansweeper Default User Date Format
by  RickW99456  
Go to last post Go to first unread
Last post: Yesterday at 5:00:51 PM(UTC)
Lansweeper Duplicate assets (Servers)
by  FrankSc   Go to last post Go to first unread
Last post: Yesterday at 3:20:28 PM(UTC)
Lansweeper Lansweeper load the disk subsystem
by  Alexey Gorbachev  
Go to last post Go to first unread
Last post: Yesterday at 3:13:17 PM(UTC)
Lansweeper Lost Configuration tab (Admin rights)
by  kspap   Go to last post Go to first unread
Last post: Yesterday at 10:30:12 AM(UTC)
Lansweeper Deployment with different user rights
by  Jupiter_IT  
Go to last post Go to first unread
Last post: Yesterday at 9:39:20 AM(UTC)
Lansweeper cisco fuji device not linking with connected devices
by  char   Go to last post Go to first unread
Last post: 7/5/2020 9:12:07 AM(UTC)
Lansweeper Microsoft CVE-2020-1425
by  Richard_B  
Go to last post Go to first unread
Last post: 7/3/2020 4:29:41 PM(UTC)