→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
iova
Engaged Sweeper
Hello,

I want to move/change the columns in the "Other scanning errors" report.

How can I do that??

Thanks!
1 ACCEPTED SOLUTION
Esben_D
Lansweeper Employee
Lansweeper Employee
I see. While it is indeed technically a report, it can't be customized. Only the reports in the reports tab can be edited.

The report I mentioned should include all of these errors as well.

View solution in original post

3 REPLIES 3
Esben_D
Lansweeper Employee
Lansweeper Employee
I see. While it is indeed technically a report, it can't be customized. Only the reports in the reports tab can be edited.

The report I mentioned should include all of these errors as well.

iova
Engaged Sweeper
Hello Charles,

If I go to Scanning --> Scanning Errors, there is a report there, among others, called "Other Scanning Errors".

I know how to move columns but it seems I cannot find this report in order to edit it.
Esben_D
Lansweeper Employee
Lansweeper Employee
Lansweeper does not have a built-in report called "Other scanning errors" so I'm not sure which report you are specifically referring to. However, I'll use the built-in report "Error: All scanning errors" as an example.

You can move the columns easily by using the report builder and dragging the rows of the fields in the correct order. The top row if the first column in the output.
You can move the rows by dragging and dropping them in the correct order by using the :: icon on the left side.

You can rename columns by giving them an Alias as seen below.

report builder

Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/Forum/yaf_postst9882_How-to-run-a-report.aspx#post38309

If you are interested in building or modifying reports, I 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: https://www.w3schools.com/sql/
Making use of the database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/Forum/yaf_postst9870_Lansweeper-database-dictionary.aspx#post38296