Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper II

Dear Concern,

We are having a requirement of adding an additional column to User ID, who is the Last login into a machine. So, how can add the column in the server. can you please suggest on this. For further clarification please see the attachment. Kindly awaiting for your reply.

Thanks & Regards,
Lansweeper Alumni
The page you are referring to appears to be linked from the IP Location Overview. The IP Location Overview and the pages it links to are automatically generated. Changing the behavior of automatically generated pages would require you to make additional manual changes to your installation, which we do not support. Such changes may cause problems during upgrades.

What you can do instead is use a custom report. A sample report can be seen below. Replace YourLocation with the name of the IP location you would like to report on.

Select Top 1000000 DERIVEDTBL.icon, DERIVEDTBL.Name As Sysname, DERIVEDTBL.IP, DERIVEDTBL.IPLocation, DERIVEDTBL.Type, DERIVEDTBL.Domain, DERIVEDTBL.computername, DERIVEDTBL.Userdomain, DERIVEDTBL.Username, DERIVEDTBL.Lastseen From (Select Web40OSName.Compimage As icon, tblComputers.LastknownIP As IP, web40AllIPLocations.IPLocation As IPLocation, tblComputers.Computer As Name, Web40OSName.OSname As Type, tblComputers.Lastseen, tblComputers.IPNumeric, Cast(tblComputers.Computername As varchar) As computername, tblComputers.Domain, tblComputers.Userdomain, tblComputers.Username From tblComputers Inner Join web40AllIPLocations On tblComputers.Computername = web40AllIPLocations.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On tblComputers.Computername = Web40OSName.Computername Union Select tsysDevicetypes.ItemTypeIcon10 As icon, tblCustDevices.Ipaddress As IP, web40AllIPLocationsDev.IPLocation As IPLocation, tblCustDevices.Displayname As Name, tsysDevicetypes.ItemTypename As Type, tblCustDevices.LastSeen, tblCustDevices.IPNumeric, tblCustDevices.DeviceKey As computername, '' As domain, '' As Userdomain, '' As Username From tsysDevicetypes Inner Join tblCustDevices On tsysDevicetypes.ItemType = tblCustDevices.Devicetype Inner Join web40AllIPLocationsDev On tblCustDevices.DeviceKey = web40AllIPLocationsDev.DeviceKey Where tblCustDevices.State = 1) DERIVEDTBL Where DERIVEDTBL.IPLocation = 'YourLocation' Order By DERIVEDTBL.IPNumeric

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.