Basically i am trying to retrieve event log for Login Failure, Login Success, Module Created and User Role Created for our DNN Portal. Unfortunately, i noticed that there are so many entries that the DNN did not record. Only few records were captured. 

May i ask how does this event log capture and in what scenario this event log wont capture the required information?

I have tried execute the following SQL query directly to our database and still the same. Or is is being stored somewhere else?

LOGIN FAILURE REPORT:

SELECT [LogTypeKey]
      ,[LogUserName]
      ,[LogCreateDate]
      ,[LogServerName]
  FROM [dbo].[EventLog]

  WHERE LogConfigID = '97'

LOGIN SUCCESS REPORT:

SELECT [LogTypeKey]
      ,[LogUserName]
      ,[LogCreateDate]
      ,[LogServerName]
  FROM [dbo].[EventLog]

  WHERE LogConfigID = '98'

MODULE CREATED: 

SELECT [LogTypeKey]
      ,[LogUserName]
      ,[LogCreateDate]
      ,[LogServerName]

  FROM [dbo].[EventLog] 

  WHERE LogConfigID = '70'

USER ROLE CREATED:

SELECT [LogTypeKey]
      ,[LogUserName]
      ,[LogCreateDate]
      ,[LogServerName]

  FROM [dbo].[EventLog] 

  WHERE LogConfigID = '34'

We do have older records. My problem is that logs are not recorded. When i test using several test accounts to login, it was not recorded. Check on the event viewer and i cannot see it is being recorded. Even checking directly in database also shows no records. 

Oddly, sometimes is does records, and sometimes it does not.

Anyone had similar issues as this or is there some settings that defined by time/date when to record only or etc?