cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
gsetech
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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.

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
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.