→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
07-17-2012 02:33 AM
Solved! Go to Solution.
03-27-2014 03:13 PM
joyboy11111 wrote:
I have been trying to use the AD report lock out code from above and it is saying unkown object name: "tblntlogevent". I am using version 5.1.0.31. Would any of the tables tblntlog, tblntlogfile, tblntlogmessage, tblntlogsource, or tblntloguser be able to pull the needed information in place of "tblntlogevent'?
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblNtlog.Eventcode,
Case tblNtlog.Eventtype When 1 Then 'Error' When 2 Then 'Warning'
When 3 Then 'Information' When 4 Then 'Success Audit'
When 5 Then 'Failure Audit' End As Eventtype,
tblNtlogFile.Logfile,
tblNtlogMessage.Message,
tblNtlogSource.Sourcename,
tblNtlogUser.Loguser,
tblNtlog.TimeGenerated
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Inner Join tblNtlogFile On tblNtlogFile.LogfileID = tblNtlog.LogfileID
Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID
Inner Join tblNtlogSource On tblNtlogSource.SourcenameID =
tblNtlog.SourcenameID
Inner Join tblNtlogUser On tblNtlogUser.LoguserID = tblNtlog.LoguserID
Where tblNtlog.Eventcode = 531 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblNtlog.TimeGenerated Desc
07-20-2014 05:16 PM
07-25-2014 07:03 PM
ohadbadihi wrote:
I have the same problem i looking for this reports, we have windows2008r2 active directory , and he didnt fount any result .
do i need to put values ?
best regard ohad
03-24-2014 03:23 PM
03-27-2014 03:13 PM
joyboy11111 wrote:
I have been trying to use the AD report lock out code from above and it is saying unkown object name: "tblntlogevent". I am using version 5.1.0.31. Would any of the tables tblntlog, tblntlogfile, tblntlogmessage, tblntlogsource, or tblntloguser be able to pull the needed information in place of "tblntlogevent'?
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblNtlog.Eventcode,
Case tblNtlog.Eventtype When 1 Then 'Error' When 2 Then 'Warning'
When 3 Then 'Information' When 4 Then 'Success Audit'
When 5 Then 'Failure Audit' End As Eventtype,
tblNtlogFile.Logfile,
tblNtlogMessage.Message,
tblNtlogSource.Sourcename,
tblNtlogUser.Loguser,
tblNtlog.TimeGenerated
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Inner Join tblNtlogFile On tblNtlogFile.LogfileID = tblNtlog.LogfileID
Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID
Inner Join tblNtlogSource On tblNtlogSource.SourcenameID =
tblNtlog.SourcenameID
Inner Join tblNtlogUser On tblNtlogUser.LoguserID = tblNtlog.LoguserID
Where tblNtlog.Eventcode = 531 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblNtlog.TimeGenerated Desc
11-29-2012 11:57 AM
11-29-2012 03:49 PM
dr.sah wrote:
in which group they are, create date
Select Top 1000000 tblADusers.Username, tblADusers.Userdomain, tblADusers.Firstname, tblADusers.Lastname, tblADusers.Name, tblADusers.Displayname, tblADusers.Description, tblADusers.Office, tblADusers.Telephone, tblADusers.Fax, tblADusers.Mobile, tblADusers.Street, tblADusers.City, tblADusers.C, tblADusers.Zip, tblADusers.Country, tblADusers.Countrycode, tblADusers.UPN, tblADusers.Title, tblADusers.Department, tblADusers.Company, tblADusers.email, tblADusers.OU, tblADusers.Lastchanged, Max(tblCPlogoninfo.logontime) As lastlogon From tblADusers Left Join tblCPlogoninfo On tblCPlogoninfo.Username = tblADusers.Username And tblCPlogoninfo.Domain = tblADusers.Userdomain Group By tblADusers.Username, tblADusers.Userdomain, tblADusers.Firstname, tblADusers.Lastname, tblADusers.Name, tblADusers.Displayname, tblADusers.Description, tblADusers.Office, tblADusers.Telephone, tblADusers.Fax, tblADusers.Mobile, tblADusers.Street, tblADusers.City, tblADusers.C, tblADusers.Zip, tblADusers.Country, tblADusers.Countrycode, tblADusers.UPN, tblADusers.Title, tblADusers.Department, tblADusers.Company, tblADusers.email, tblADusers.OU, tblADusers.Lastchanged Order By tblADusers.Userdomain, tblADusers.Username
07-19-2012 03:09 AM
07-19-2012 02:41 AM
07-17-2012 03:34 PM
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.Eventcode = 531
Order By tblComputers.ComputerUnique, tblntlogevent.TimeGenerated Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now