Eventlog search

[mdevylder]

I would like to write a query to get alll entries with the words 'Backup Exec' out of the database that was recorded from fileserver event logs.
Is there any information in what table this can be found?

Regards

Michel

[Hemoco · Accepted solution]

Event log information can be found in tblntlogevent. Example report:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblntlogevent.Eventcode, tblntlogevent.Eventtype,
tblntlogevent.Logfile, tblntlogevent.Message, tblntlogevent.Sourcename,
tblntlogevent.TimeGenerated, tblntlogevent.[User]
From tblComputers Inner Join
tblntlogevent On tblComputers.Computername = tblntlogevent.Computername
Where tblntlogevent.Message Like '%backup exec%'
Order By tblntlogevent.TimeGenerated Desc