Incorrect Last user appearing

[lukee20]

Hi,

After some help, for some reason we have a incorrect last user showing up in the lansweeper reports. The user left over 3 months ago and the PC has also since been rebuilt! How does lansweeper determine last logged on user and how can I solve this issue?

[Hemoco]

Problem resolved through email. The new user had already been scanned.

[Hemoco]

Could you 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 YourComputer with the NetBIOS name of the problem machine.

Select Top 1000000 tblComputers.Computername, tblComputers.Domain,
tblComputers.Computer, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.Lasttried, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tsysASDomains.Servername, tsysASDomains.Domainname, tsysASDomains.Netbiosname,
tsysASDomains.Firsttime, tblComputers.LastLsPush, tblComputers.Scanserver,
Web40OSName.OSname, Web40OSName.SP, Web40OSName.OScode, tblerrors.CFGname,
tblerrors.ErrorText, tblerrors.Lastchanged, TsysDonotscan.Computername As
Excluded, tblComputers.Userdomain, tblComputers.Username,
tblCPlogoninfo.Domain As Domain1, tblCPlogoninfo.Username As Username1,
tblCPlogoninfo.ADsite, tblCPlogoninfo.Ipaddress, tblCPlogoninfo.logontime
From tblComputers Left Join
tsysASDomains On tsysASDomains.Netbiosname = tblComputers.Domain Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername Left Join
TsysDonotscan On TsysDonotscan.Computername = tblComputers.Computer Left Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Where tblComputers.Computer = 'YourComputer'
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.

[lukee20]

Lansweeper wrote:
Could you 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 YourComputer with the NetBIOS name of the problem machine.

Select Top 1000000 tblComputers.Computername, tblComputers.Domain,
tblComputers.Computer, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.Lasttried, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tsysASDomains.Servername, tsysASDomains.Domainname, tsysASDomains.Netbiosname,
tsysASDomains.Firsttime, tblComputers.LastLsPush, tblComputers.Scanserver,
Web40OSName.OSname, Web40OSName.SP, Web40OSName.OScode, tblerrors.CFGname,
tblerrors.ErrorText, tblerrors.Lastchanged, TsysDonotscan.Computername As
Excluded, tblComputers.Userdomain, tblComputers.Username,
tblCPlogoninfo.Domain As Domain1, tblCPlogoninfo.Username As Username1,
tblCPlogoninfo.ADsite, tblCPlogoninfo.Ipaddress, tblCPlogoninfo.logontime
From tblComputers Left Join
tsysASDomains On tsysASDomains.Netbiosname = tblComputers.Domain Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername Left Join
TsysDonotscan On TsysDonotscan.Computername = tblComputers.Computer Left Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Where tblComputers.Computer = 'YourComputer'
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.

Information has been sent: to email address