![Corné Corné](https://community.lansweeper.com/html/assets/User_Avatar.png)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-09-2012 08:33 PM
Is it possible to see where and where a admin is logging in a system?
On a domain controller in eventviewer? or build a query in Lansweeper with this funktion?
On a domain controller in eventviewer? or build a query in Lansweeper with this funktion?
Labels:
- Labels:
-
Archive
1 REPLY 1
![Hemoco Hemoco](https://community.lansweeper.com/legacyfs/online/forums_avatars/9703.png)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-10-2012 02:23 PM
Login info is stored in tblCPlogoninfo. The example report below lists all admin logins that were scanned in the last 7 days.
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblUsersInGroup.Admingroup, tblCPlogoninfo.Domain As Domain1, tblCPlogoninfo.Username, tblCPlogoninfo.logontime From tblComputers Inner Join tblUsersInGroup On tblComputers.Computername = tblUsersInGroup.Computername Inner Join tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername Where tblUsersInGroup.Admingroup = '1' And tblCPlogoninfo.logontime > GetDate() - 7 Order By tblCPlogoninfo.logontime Desc
![](/skins/images/772330E1D508EE7C725F5596471AF035/responsive_peak/images/icon_anonymous_message.png)