Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Untag as favorite
Users that logon locally
Options
Previous Topic Next Topic
ejensen
#1 Posted : Wednesday, January 11, 2012 5:31:17 PM

Rank: Premium user

Groups: Premium Users, Member
Posts: 45
Location: Ohio, USA
Is it possible to generate a report of computers and/or users that are logging in locally instead of the domain?

I recently found that some of the computers have local computer accounts on them and I suspect that some of the users might be logging on with them to bypass proxies, etc.

thanks,
Eric
Back to top
Lansweeper
#2 Posted : Thursday, January 12, 2012 3:12:48 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,379
The example report below shows a list of recent local user logins.
Quote:
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblCPlogoninfo.Username, tblCPlogoninfo.Ipaddress, tblCPlogoninfo.logontime
From tblComputers Inner Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Where tblComputers.Computer = tblCPlogoninfo.Domain
Order By tblCPlogoninfo.logontime Desc
Back to top
ejensen
#3 Posted : Thursday, January 12, 2012 4:17:07 PM

Rank: Premium user

Groups: Premium Users, Member
Posts: 45
Location: Ohio, USA
Thank you. That works except it is such a big list that it kills my browser.
Is there anyway to page the report so it only shows like 100 at a time?
Or is there a way I can exclude a list of users? (e.g. tblCPlogoninfo.Username Not In "user1,user2,user3")
Back to top
Lansweeper
#4 Posted : Thursday, January 12, 2012 7:41:01 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,379
If you're not after login times specifically, you could also use the report below for a simple list of detected local users.
Quote:
Select Distinct tblComputers.Computername, tblComputers.ComputerUnique,
tblCPlogoninfo.Username
From tblComputers Inner Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Where tblComputers.Computer = tblCPlogoninfo.Domain
Order By tblComputers.ComputerUnique
Back to top
ejensen
#5 Posted : Monday, January 16, 2012 3:36:05 PM

Rank: Premium user

Groups: Premium Users, Member
Posts: 45
Location: Ohio, USA
that is much faster, thank you.
Back to top
Users browsing this topic
Guest
Untag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba