Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
isanchez
Engaged Sweeper
Dear Team

New Report :

We have to ask to the active directory for the following events.

528 Successful Logon
529 Logon Failure - Unknown user name or bad password
530 Logon Failure - Account logon time restriction violation
531 Logon Failure - Account currently disabled
532 Logon Failure - The specified user account has expired
533 Logon Failure - User not allowed to logon at this computer
534 Logon Failure - The user has not been granted the requested logon type at this
535 Logon Failure - The specified account's password has expired
536 Logon Failure - The NetLogon component is not active
537 Logon failure - The logon attempt failed for other reasons.
538 User Logoff
539 Logon Failure - Account locked out
540 Successful Network Logon
551 User initiated logoff
552 Logon attempt using explicit credentials

AD' has activated all events .

for lansweeper 5.x

Many Thanks

Ivan Sanchez
4 REPLIES 4
isanchez
Engaged Sweeper
Thanks
Hemoco
Lansweeper Alumni
Please refer to this forum thread for a sample report.
Lansweeper wrote:
Please refer to this forum thread for a sample report.



Please you me one example, because I cannot find it.

Hemoco
Lansweeper Alumni
isanchez wrote:
Lansweeper wrote:
Please refer to this forum thread for a sample report.



Please you me one example, because I cannot find it.


Do you mean you can't access the forum thread? The report it contains is the following:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname,
tblAssets.SP,
tblNtlog.Eventcode,
Case tblNtlog.Eventtype When 1 Then 'Error' When 2 Then 'Warning'
When 3 Then 'Information' When 4 Then 'Success Audit'
When 5 Then 'Failure Audit' End As Eventtype,
tblNtlogFile.Logfile,
tblNtlogMessage.Message,
tblNtlogSource.Sourcename,
tblNtlogUser.Loguser,
tblNtlog.TimeGenerated
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Inner Join tblNtlogFile On tblNtlogFile.LogfileID = tblNtlog.LogfileID
Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID
Inner Join tblNtlogSource On tblNtlogSource.SourcenameID =
tblNtlog.SourcenameID
Inner Join tblNtlogUser On tblNtlogUser.LoguserID = tblNtlog.LoguserID
Where tblNtlog.Eventcode = '55' And tblNtlogSource.Sourcename Like '%ntfs%' And
tblNtlog.TimeGenerated > GetDate() - 7
Order By tblNtlog.TimeGenerated Desc

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now