http://3.86.49.49/ 2026-04-17T17:49:40+00:00 http://3.86.49.49/ http://3.86.49.49/lib/tpl/docnavwiki/images/favicon.ico text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:administration_-_manage_database_profiles&rev=1624612196&do=diff Administration - Manage Database Profiles Author: Colm Carew Always remember to be careful and take note of what datasource you are connecting to. In every report in the Reporting Manager that connects to the database, connects using a database profile. This is accomplished by the following line of code : text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:administration_-_manage_report_visibility&rev=1624612196&do=diff Administration - Manage Report Visibility Author: Colm Carew In Administration - Manage Roles and Permissions we discussed how to create and edit Roles and Permission. Report Visibilities are essentailly assigning a Role to a report so users with that corresponding role can see/run the report. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:administration_-_manage_roles_and_permissions&rev=1624612196&do=diff Administration - Manage Roles and Permissions Author: Colm Carew Each role should have a permission of 'gwt' and this should be a roles only permission in the Reporting Manager. Each role has a unique name and each user can have multiple roles. Roles are essentials names/tags assigned to users and reports to determine if a user can run/see a report. text/html 2023-03-31T16:18:43+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:administration_-_manage_scheduled_reports&rev=1680275923&do=diff Administration - Manage Scheduled Reports Author: Colm Carew Ensure to do this on the Errigal QA System (qalb1.err/ReportingManager) as we do not want to send emails to customers! Scheduled Reports are reports that are ran a certain time every day/week and the result of running these reports then gets emailed to whoever has the visibility that the report is ran for. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:administration_-_manage_users&rev=1624612196&do=diff Administration - Manage Users Author: Colm Carew The purpose of the manage user button is to create/edit users. Clicking the manage users will bring the list of users dialog and from here you can create a user or edit a user. To edit a user double click one of them. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:administration_-_reloading_report_files&rev=1624612196&do=diff Administration - Reloading report files Author: Colm Carew THIS IS A FEATURE THAT IS NOT TYPICALLY USED The files will be stored in .erpt format and are located in the appfiles/reports directory. Appfiles can be in : /usr/local/appfiles /export/home/scotty/apffiles text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:administration_-_report_checklist&rev=1624612196&do=diff Administration - Report Checklist Author: Colm Carew Each time a report is finished another member of staff should go through the report with you with the following checklist and ensure everything is in order <https://docs.google.com/document/d/1fzRQtcqlGCfCoXOaSA_CwZ3luE-kw0WYRH5qH3i1uho/edit> If you have not had any of your previous reports corrected, now may be a good time to get your mentor to correct a report using this checklist. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:administration_-_report_overviews&rev=1624612196&do=diff Administration - Report Overviews Author: Colm Carew Report Overviews help determine the purpose of the report and what tables are used in the report. They can be accessed in the Reporting Manager by right clicking on a report and clicking Show Report Overview text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:basic_sql_groovy_report_creation_and_existing_report_modification&rev=1624612196&do=diff Basic Report Creation And Report Modification Author: Colm Carew -- This assumes that you have some MySQL and Groovy/Java knowledge. Always remember to use Errigal QA first (qadb1.err) as the datasource and connect as a reader account. If you have any questions feel free to ask a team member. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:conventions_-_general_report_writing&rev=1624612196&do=diff Conventions - General Report Writing Author: Michelle McCausland ---------- Commenting * All reports must have a comment relating to the report creator/ who modified the report, the date modified and associated ticket number as per the report checklist. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:conventions_-_report_variables&rev=1624612196&do=diff Conventions - Report Variables Author: Michelle McCausland Guidelines for report variables * Where possible avoid hardcoding in values for things like network element names, region names, cluster names etc. as these fields can be subject to change at any time. In these cases it is preferable to query the database and return those results. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:creation_of_a_column_report&rev=1624612196&do=diff Creation of a column report Author: Colm Carew This assumes you have already created basic reports and line reports and know how to take reports from the Reporting Manager into the Report Builder project Go into an instance of the Reporting Manager and click new report. Select Column as the Type. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:creation_of_a_drilldrown_report&rev=1624612196&do=diff Drilldown Reports Author: Samuel Costa This assumes you have already created basic and column reports and know how to use variables on the reporting manager A drilldown report is a type of report that displays more detailed information from the data in another report. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:creation_of_a_line_report&rev=1624612196&do=diff Creation of a line report Author: Colm Carew Always remember to use Errigal QA first (qadb1.err) as the datasource and connect as a reader account. If you have any questions feel free to ask a team member. In our QA Reporting Manager click 'New Report' this will generate a window as follows : text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:creation_of_a_map_report&rev=1624612196&do=diff Creation of a map report Author: Colm Carew Map reports do not work in the local Report Builder so I suggest generating all SQL and numeric results you require in a table report first then adding the code to the report in the Reporting Manager. In order to create a map report create a new report in the Reporting Manager and click Map as the type. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:creation_of_a_pie_report&rev=1624612196&do=diff Creation of a pie report Author: Colm Carew This assumes you have already created basic reports and line reports and know how to take reports from the Reporting Manager into the Report Builder project Go into an instance of the Reporting Manager and click new report. Select Pie as the Type. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:creation_of_a_table_report&rev=1624612196&do=diff Creation of a table report Author: Colm Carew This assumes you have already created basic reports and line reports and know how to take reports from the Reporting Manager into the Report Builder project Go into an instance of the Reporting Manager and click new report. Select Table as the Type. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:log_files&rev=1624612196&do=diff Log Files Author: Colm Carew There are 2 log files to monitor for the Reporting Manager. The catalina.out and the ReportingManager.log. All println statements go to the catalina.out and all log.info statements go to the ReportingManager.log The catalina.out should always be located in /var/tomcat/ReportingManager/logs on every server. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:object_model_-_the_basics&rev=1624612196&do=diff Object model - the basics Author: Colm Carew Main Tables Script Report (script_report) - This is where the code for the reports is stored. It contains the report name. type (table,line, etc.) the date is was created, the report width and report height. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:review_user_guides&rev=1624612196&do=diff Reporting Manager User Guides Author: Michelle McCausland Please Note: The user guide process is currently being updated to include Errigal document templates, versioning etc. More to follow! Currently user guides are stored in the Errigal Dropbox account in: Errigal Shared Documents\User Guides text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:review_webex_introductory_video&rev=1624612196&do=diff Review webex introductory video Author: Colm Carew Updated: Oleksandr Kononov For a summary of what the Reporting Manager is and a demo of the overall features please go to <https://errigal.webex.com>, log in and find 'My Recorded Meetings'. The video is titled 'Reporting Manager Demo - Colm 13Jan2016'. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:searching_for_and_running_basic_reports&rev=1624612196&do=diff Searching for and running basic reports Author: Colm Carew Searching The search box in the reporting manager can be found in the bottom left hand corner of the page Simply type some text into this box and it will filter the reports, you do not need to press enter. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:start&rev=1624612196&do=diff Reporting Manager Introduction * Object model - the basics * Searching for and running basic reports * Log files Report Writing * Basic Report Creation And Report Modification * Conventions - General Report Writing * Conventions - Report Variables * Creation of a line report * Creation of a pie report * Creation of a column report * Creation of a table report * Creation of a drilldrown report * Creation of a map report * Use of report variables Administration * … text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:troubleshooting_-_getting_a_fail500_error_when_running_a_report&rev=1624612196&do=diff Troubleshooting - Getting a Fail500 error when running a report Author: Michelle McCausland Example Customer Request When trying to run this report, I get the following error: ---------- Solution More likely than not the issue is with the datasource being used by the report. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:troubleshooting_-_report_charts_not_working&rev=1624612196&do=diff Report Charts Not Working - Flash Author: Michelle McCausland Example Customer Request Support, I am getting the following message when running the Alarm Discrepancy Chart report: “You should see a chart here. Try resizing this window, if that does not work, try updating flash here” Please advise what the cause of this is and how to fix it. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:troubleshooting_-_report_error_tmp_sql&rev=1624612196&do=diff Troubleshooting - Report error /tmp/sql Author: Michelle McCausland Example Customer Request Support, I got a strange error that I have not seen before while running a report (Alarm History for...(Active Alarms))": ---------- Steps to find the solution text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:troubleshooting_-_report_export_to_excel_issue&rev=1624612196&do=diff Troubleshooting - Report Export to Excel Issue Example Customer Request I’m currently having issues exporting the Tickets Open Per Region to an Excel sheet. Please let me know if there’s something I need to do on my end, I typically pull this report a few times a day and have never had issues, thanks. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:troubleshooting_-_verifying_scheduled_reports_are_sending_as_expected&rev=1624612196&do=diff Troubleshooting - Verifying scheduled reports are sending as expected Author: Michelle McCausland Introduction This walkthrough assumes you already have knowledge of the reporting manager and that you have read through the reporting manager topics in the Errigal wiki. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=onboarding:reportingmanager:use_of_report_variables&rev=1624612196&do=diff Use of report variables Author: Colm Carew Secure Variables Secure variables are [“CUSTOMER”, “ROLE”, “CARRIER”,“CUSTOMERNAME”,“CARRIERNAME”]. If any of these variable names are used in your report then the user will need the associated permission such that if carrier is a variable and the user runs the report for ATT(Tickets) then the user must have the role of ATT(Tickets) to run the report!