cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
wcb
Engaged Sweeper III
While following up on some of the recent talk regarding login info, I went to the Config page of one of my computers and in looking at the User Info I saw entries for 2 different users logging into the same PC at the same time.

I checked in the tblCPlogoninfo table and found the records related to the time involved and found that there are 2 entries (username changed to protect the innocent):


ID Computername logontime Domain Username ADsite Ipaddress
14466 45 2012-04-17 10:09:19.980 WPBPS user1 NULL 10.132.50.96
14465 45 2012-04-17 10:09:19.790 WPBPS user2 NULL 10.132.50.96


I tried the eventlog on the pc in question and on the domain controllers but could not find matching entries. Where is this logon information pulled from? Anything else you need to know from me to offer up suggestions on why this happened? There are more entries like this for this computer, this is just one I pulled up as an example. I have not looked to see if there are other similar entries for other computers.
1 REPLY 1
Hemoco
Lansweeper Alumni
Please contact us at support@lansweeper.com and provide us with the following:
- Screenshot of your web console landing page. You can access your landing page by clicking on the Lansweeper logo in the top left corner of the web console. Please show us the whole page.
- Output of the report below, preferably in Excel format. Replace "YourPC" with the name of the machine returning unusual logon info.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblCPlogoninfo.logontime, tblCPlogoninfo.Domain
As Domain1, tblCPlogoninfo.Username, tblCPlogoninfo.ADsite,
tblCPlogoninfo.Ipaddress
From tblComputers Inner Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Where tblComputers.ComputerUnique Like '%YourPC%'
Order By tblComputers.ComputerUnique, tblCPlogoninfo.logontime Desc


To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.