‎05-15-2012 08:31 PM
‎05-18-2012 04:13 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.Lasttried, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tblComputers.LastLsPush, tblComputers.OScode, tblComputers.SP,
tblComputers.Description, tblComputers.Scanserver, 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 = 529
Order By tblntlogevent.TimeGenerated Desc
‎05-17-2012 08:19 PM
‎05-16-2012 03:11 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now