→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mdevylder
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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