User Tools

Site Tools


menu:reports:view_reports
LDAP: couldn't connect to LDAP server

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
menu:reports:view_reports [2021/10/22 06:02] – ↷ Page moved from menu:operate:reports:view_reports to menu:reports:view_reports pgelsmenu:reports:view_reports [2021/10/22 06:23] (current) – ↷ Links adapted because of a move operation pgels
Line 1: Line 1:
 +{{indexmenu_n>2}}
 +
 +====== View reports ======
 +
 +The 'View custom reports' tool allows the user to view and download any created custom report. The tool is available for "Browser" users (user level 1) and higher.
 +
 +The tool opens with a list of all currently available report results in alphabetical order along with its creation timestamp and number of data rows.
 +
 +A the front of the row is a radio button to select the (one) report to view and at the end a checkbox to include the report in the 'delete' action.
 +
 +{{ menu:reports:view_custom_reports.png?nolink |}}
 +
 +When "View report" is clicked the report results are retrieved from the database and converted to a table format. For very large reports the results are truncated at 5000 rows to prevent overloading the browser and prevent long upload times. A message is included at the bottom should the view have been truncated.
 +
 +{{menu:reports:large_custom_report.png?nolink&600|}}
 +
 +:::
 +
 +{{menu:reports:truncated_report_view.png?nolink&380|}}
 +
 +The link following the report allows the user to download the full results in CSV (comma-separated-values) format. The default separator is a comma. This downloaded csv file will not be truncated and uses the report name with the extension ".csv" as filename.
 +
 +===== Download using URL =====
 +
 +Created reports can be downloaded using the link at the top of the report view, but also using a web-address. By pointing the browser to this URL the report can be fetched directly from the server:
 +
 +<code>
 +http(s)://<server-fqdn>/report/<report-name>
 +</code>
 + 
 +The csv download files are by default created using Unix newlines. To retrieve the csv file using the Dos carriage-return/newline append ''&type=dos'' to the url.
 +
 +The report name in the URL is not case sensitive and any extension provided will be ignored. If spaces are used in the report name, make sure those are substituted with ''%20''.
 +
 +To retrieve 'dated' report results, include the desired date in the report name as is shown in the reports overview. However, if the date part of the name is omitted, and the report name without the date suffix does not exist, the LATEST of the dated reports of that name is returned. The filename will include the selected date suffix.
 +
 +Some examples:
 +<code>
 +-- fetch the 'Domains' report
 +https://genesis.netyce.org/report/Domains
 +-- same thing
 +https://genesis.netyce.org/report/domains.csv
 +
 +-- a dated report requested in Dos format
 +https://genesis.netyce.org/report/Action_logs_by_date-20191226&type=dos
 +
 +-- will return the latest dated result report of 'Action_logs_by_date' (in dos)
 +https://genesis.netyce.org/report/Action_logs_by_date&type=dos
 +
 +-- spaces must be replaced
 +https://genesis.netyce.org/report/Report%20with%20Spaces
 +</code>
 +
 +
 +===== Download using API =====
 +
 +Generated reports can also be retrieved using the NetYCE XCH API. Two API calls are available: ''**fetch_report**'' and ''**run_report**''. Both retrieve the requested report name in XML format but where the first retrieves an earlier retrieved report, the latte will first generate it before returning its results.
 +
 +Details on these API calls can be found in [[guides:reference:api:exchange_gateway_and_api#reports|YCE Exchange gateway and API]]
 +
 +
 +
 +
 +