08-21-2012 02:29 PM
08-23-2012 04:11 PM
Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
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.Eventcode = YourCode
Order By tblComputers.ComputerUnique, tblntlogevent.TimeGenerated Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now