Users by Asset

[gsetech]

Is there a way to generate a report that would allow one to search by a username and generate a list of machines that person has logged into? This info is then used for me to login to their computer.

[Susan_A · Accepted solution]

User logon information is stored in the tblCPlogoninfo database table.

• Open the report builder under Reports\Create New Report. A default query will be generated.
  
• Double-click on tblCPlogoninfo in the table list on the right to add the table to your report.
  
• In the visual representation of the report in the upper section of the report builder, tick the Username and Domain fields in tblCPlogoninfo.
  
• Give your report a title and hit Save & Run.
  
• Filter the Username column within the report results to see logon events for that specific user.

If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, more information on which can be found here. The dictionary explains in great detail what each table and field stores.