Enable New Reports UI

 
Author
Message
SysAid Technical Writer
1128
 

Analytics

Reports

Enable New Reports UI

SysAid is in the process of revamping its reports module with an enhanced user interface and functionality. While much of the new features are still in development, users running SysAid 15.2.05 and above, and an OS that is running the most recent service pack, can start using the new user interface right now.

 

To enable the new Reports UI

  1. Stop the SysAid server service
  2. In your file system, go to ..\SysAidServer\root\WEB-INF\accountConf.
  3. Open for edit the most recent “accountConf.xml” file – The accountConf file name should be “accountConf-<ACCOUNT_ID>-<DATE>.xml”.

  1. Add the tag “<isNewReports>true</isNewReports>“  to the end of the file before </accountConf> closing tag.
  2. Save the file.
  3. In the Windows menu, type "cmd" in the Search box.
  4. Right click the cmd.exe option that appears, and select Run as Administrator.
  5. In your command line, go to ..\SysAidServer\util.
  6. Run the following command “ReproduceAccountConf.exe <ACCOUNT_CONF_FILE_NAME> <ACCOUNT_ID>"
    For example: "ReproduceAccountConf.exe accountConf-cmdb-2015-05-18-15-33-24-233.xml  cmdb"

    The results should end with the text "cmdb ended successfully"

  1. In the command line interface, Run “UpgradeReports.bat ”
  2. When prompted enter the account id
  3. when prompted, enter the path to SysAid server.

  1. Wait for the Batch file to finish running.
  2. Start the “SysAid Server” service.
  3. Open SysAid and navigate to Analytics > Reports – the new reports UI appears.

 

For information about how to use the various elements in the new reports UI, see Reports.

Revert to the old Reports UI

You can revert your reports UI to the old module. To do this, you must have a DBClient tool such as DB Visualizer installed on your system.

 

To revert to the old Reports UI

  1. Stop "SysAid Server" Service.
  2. In your file system, go to ..\SysAidServer\root\WEB-INF\accountConf.
  3. Open for edit the most recent “accountConf.xml” file – The accountConf file name should be “accountConf-<ACCOUNT_ID>-<DATE>.xml”.
  4. Remove the tag “<isNewReports>true</isNewReports>“  that you entered at the end of the file before </accountConf> closing tag.
  5. Save the file.
  6. In the Windows menu, type "cmd" in the Search box.
  7. Right click the cmd.exe option that appears, and select Run as Administrator.
  8. In your command line, go to ..\SysAidServer\util.
  9. Run the following command “ReproduceAccountConf.exe <ACCOUNT_CONF_FILE_NAME> <ACCOUNT_ID>
    For example:
    ReproduceAccountConf.exe accountConf-cmdb-2015-05-18-15-33-24-233.xml  cmdb

    The results should end with the text "coded successfully"
  10. Open your DB Client tool.
  11. Connect to the Database.
  12. Run the following scripts:
    • INSERT INTO ui_menus (mi_id, mi_name, mi_parent, mi_action_type, mi_action, mi_enabled,mi_ui_class, mi_module_id,mi_order,mi_permission,mi_edition) VALUES (63, 'portal.submenu.myReports', 56, 'url', '#/MyReports.jsp', 'Y',null, 10,0,0,0);
    • INSERT INTO ui_menus (mi_id, mi_name, mi_parent, mi_action_type, mi_action, mi_enabled,mi_ui_class, mi_module_id,mi_order,mi_permission,mi_edition) VALUES (64, 'portal.submenu.recentReports', 56, 'url', '#/RecentReports.jsp', 'Y',null, 10,0,0,0);
    • INSERT INTO ui_menus (mi_id, mi_name, mi_parent, mi_action_type, mi_action, mi_enabled,mi_ui_class, mi_module_id,mi_order,mi_permission,mi_edition) VALUES (65, 'portal.menu.scheduler', 56, 'url', '#/SchedulerList.jsp', 'Y',null, 10,0,0,0);
    • update ui_menus set mi_action = '#/MnAnalyzer.jsp' where mi_name='portal.submenu.allReports';
    • update ui_menus set mi_action = '#/Analyzer.jsp' where mi_name='portal.submenu.Reports';
  13. Start the “SysAid Server” service.
  14. Open SysAid and navigate to Reports.

    The Old UI should be displayed.

Bug Fixes

Since this module has been released we have identified and fixed the following bugs.

 

Release 15.2.3:

  • 17790 - Resolved an issue that caused the action menu icon in the new Reports UI to be displayed even when the profile menu is opened on top of it.
  • 17764 - Resolved an issue that caused the action menu icon in the new Reports UI to be displayed even when the action menu for the report on the row above is opened on top of it.
  • 17708 - Fixed a bug that prevented schedules from being created in the new Reports UI.
  • 17964 - Fixed a bug that casued the Asset Details report results to be empty of content.

 

Release 15.3.3:

  • 17786 -Fixed a bug that prevented Report icons from being displayed in FireFox.

 

 

 

SysAider
2
 
Can we get an update?

Are these changes in Report UI available in SysAid ITSM MSP versions?

If so, how do we change the settings?

If not, when will they be available?

This message was edited 1 time. Last update was at Oct. 28, 2015 09:38 PM

SysAider
22
 
When will this be available for cloud customers?
SysAid Product Manager Community Manager
5260
 
Hey guys,

The new reporting module should be available in Cloud during November when 15.4 is released.

You can find more information about our roadmap here.

Cheers,
Danny
SysAider
8
 
Enabling the new reports UI deleted all my scheduled Reports.

Converting back to the old UI brought no changes. But the reason for reactivating the old UI was not the hope to find all deleted Reports. It was the matter, that i could not see any Informations in SysAid Settings -> Manager Portal -> Design Reports.

Will it be removed with SysAid 15.4 and all changes and designs must be done over Analytics -> Reports?

And will i have the same issue, that all scheduled Reports will be removed after Upgrading to 15.4? As i remember right, the Upgrade of SysAid 15.4 should be released this month, so i don't want to reschedule all those reports again after Upgrading to SysAid 15.4.
SysAid Product Manager Community Manager
5260
 
Hi roether,

The disappearance of reports is not something we have witnessed so far, but may be related to a bug #14543, the fix for which is under development. Generally, upon upgrade to 15.4, the scheduled reports should stay where they are.

As per your question, the new Reports UI will be entirely under Analytics > Reports.

Regarding the release date of 15.4, the open beta for the new version will be available Mid-November. We invite you to join our SysAid Pathfinders Program, and provide us with feedback so the system will function to your liking

Cheers,
Danny
SysAid Wiz
317
 
Hi,
I've tried to perform the upgrade, but I needed to manually launch the command inside the UpgradeReports.bat.

The string
gets an error due the Space char between "Program" and "Files" in the path.

Nothing serious, it's easy to correct

(by the way the new UI is awesome!)