→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎09-22-2015 11:14 AM
Solved! Go to Solution.
‎09-23-2015 12:45 PM
‎09-30-2015 05:36 PM
‎09-28-2015 10:27 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tsysOS.OSname,
tsysOS.Image As icon,
tblNtlog.Eventcode,
tblNtlog.TimeGenerated,
tblNtlogFile.Logfile,
tblNtlogSource.Sourcename,
tblNtlogMessage.Message
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID
Inner Join tblNtlogSource On tblNtlogSource.SourcenameID =
tblNtlog.SourcenameID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblNtlogFile On tblNtlogFile.LogfileID = tblNtlog.LogfileID
Where tblNtlog.Eventcode In (4656, 4658, 4660, 4663, 4685, 4985) And
tblAssetCustom.State = 1
Order By tblNtlog.TimeGenerated Desc
‎09-24-2015 06:20 PM
‎09-23-2015 12:45 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now