‎12-29-2011 05:03 PM
‎12-30-2011 10:37 AM
Select Top 1000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Lastseen, tblComputers.Domain, tblntlogevent.Eventcode, tblntlogevent.Eventtype, tblntlogevent.Logfile, tblntlogevent.Sourcename, tblntlogevent.TimeGenerated From tblComputers Inner Join tblADComputers On tblComputers.Computername = tblADComputers.Computername Inner Join tblntlogevent On tblComputers.Computername = tblntlogevent.Computername Where tblADComputers.OU Like '%domain controller%' Order By tblntlogevent.TimeGenerated Desc
‎12-29-2011 08:38 PM
‎12-29-2011 07:07 PM
‎12-29-2011 06:53 PM
‎12-29-2011 05:10 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblntlogevent.Eventcode, tblntlogevent.Eventtype,
tblntlogevent.Logfile, tblntlogevent.Sourcename, tblntlogevent.TimeGenerated
From tblComputers Inner Join
tblADComputers On tblComputers.Computername = tblADComputers.Computername
Inner Join
tblntlogevent On tblComputers.Computername = tblntlogevent.Computername
Where tblADComputers.OU Like '%domain controller%'
Order By tblntlogevent.TimeGenerated Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now