Magic Suite 3.27

Magic Suite 3.27 has been released with the following changes across all products.

ReportMagic

New Features

• In the Library there are now Schemas present for LogicMonitor DataMagic, Meraki DataMagic, and Magic Suite.
• The [HubSpot.List:] and [HubSpot.Property:] macros now support Owner as a valid value for the 'type' parameter, e.g. can be used as follows to list all the Owners in your HubSpot account: [HubSpot.List: type=Owner]
• The [Table.Save:] macro now does not error (but generates a warning) if the 'excludeColumns' and 'emptyTableText' parameters are used and the columns do not exist.
• On the Progress Page (for Schedules / Report Studio), the variables table can now be downloaded into an Excel (.xlsx) file.
• The Batch Jobs page has been added to RM4
• ReportMagic 4 now has Report Studio.
• The Schedules page and associated UI (Progress page, Batch Jobs, Report Jobs, Macro Results) are now all present in the ReportMagic4 app. Pages are also appropriately controlled by RBAC.
• Traces are now available for all systems in the Kibana logs.

Improvements

• The maximum number of concurrent requests that a Magic Suite Agent can handle can now be configured. It will be capped at the value set (or default to 5) but can never exceed the number of (virtual / real) cores on the CPU. The default value of 5 can be overridden by adding the following property to the Agent configuration in the appsettings.json file and setting the desired value (denoted by n). An Agent service restart is required for this configuration change to take effect. "MaxConcurrentRequests": n
• MS-19652 Added the [MagicSuite.ConnectionList:] macro and deprecated the [ReportMagic.ConnectionList:] macro.
• 'Network Group Function' and 'Network Allow Function' can be added to an organization within DataMagic

Bug Fixes

• In ReportMagic4 the text colour when renaming files/folders is now black rather than white
• Fixed an issue with the file explorer in ReportMagic where folders that are not permitted to be renamed (such as the Library folder and My Files folder) could still be ATTEMPTED to be renamed (though would fail after trying) by using the slow double-click method. This edit control should not even appear to the user in the first place.
• Fixed an issue where using the column selector on tables in the various apps would results in a browser console error, and a possible UI crash.
• When opening the search box, focus (of the user's cursor) always appears in the Search Term text input.
• Ops Dashboard now updates in real time without a page refresh being required.
• The schedule progress page on RM4 refreshes the batch job status whilst processing without needing to manually refresh the page
• Fixed an issue where empty strings in the [List.GroupBy:] macro were NOT being counted (but they should).
• API errors are no longer reported when loading a macro's full variable details in Report Studio.
• Fixed an issue where blank report control variables would not be created properly from input XLSX files, if the Excel actually omitted the cell XML (a common Excel optimization for empty strings, if the cell has no other formatting, such as borders, font style, etc.).
• Fixed an issue where using late evaluation of text-based variables, in macros that require Dates / Times or Colors would not work as expected and the value would not be correctly used, leading to potentially wrong data in graphs and other macros.
• Fixed an issue where the [LogicMonitor.AlertAnalysis:] macro did not use the correct start and end date (instead it was using the last calendar month).
• Fixed an issue in normal mode where the [Jira.IssueLastCommentProperty:] macro would show visible newline characters (\r and \n) in the document output.
• Fixed an issue where the file upload click to browse files button did not work in the files browser.
• Fixed an issue where the [Jira.InsertMarkup:] macro would not always insert images into the output document at the correct size.
• Fixed help example #3 in the [AutoTask.TicketProperty:] macro by adding new property support for "AllAsJObect".
• Fixed an issue where NCalc orderBy would not work with a list of integers mixed with doubles.
• Resolved a transient issue that resulted in the poor display of the ReportMagic web UI.
• Fixed an issue where reports that send notifications (emails) as a result of a Schedule's "stop on" settings (e.g. stop on system error) would always decrement the deferred macro count on the report job, as shown in the UI, which could incorrectly result in a count of -1 for deferred macros.
• Fixed intermittent SharePoint file-system move / copy errors.
• The Batch Jobs page renames the Duration column to Generation, and adds the previously-unavailable additional columns (hidden by default, but can be shown with the columns chooser button in the toolbar) called: Preparation, Input File Transfer, Output File Transfer, and Cleanup. This was to avoid an issue where it appeared that the sort on Duration was incorrect, whereas in fact the column actually sorted on Generation (previously called Duration) and just displayed the sum of all the aforementioned duration properties.
• An invalid AutoTask Connection now gives a macro error rather than a system error when used by a macro.
• Updated the PanoramicData.Blazor nuget to fix an issue where it was not possible to drag and drop files / folders into a folder in the file explorer.
• "Failed to load image: Not Found" toast now not seen when accessiing ReportMagic4
• Fixed an issue in ReportMagic 4 where the Run button on the Schedules page resulted in an error, and the Schedule would not run.
• On ReportMagic4 now only users who have permission to see the Report Studio page can see the page.
• On the Schedules page in ReportMagic4, the Search is now not performed on every keypress and will wait until paused typing so keystrokes are now not missed.
• On the Schedules page in ReportMagic4, the Search is now not performed on every keypress and will wait until paused typing so the screen does not flash
• On the Schedules page in ReportMagic4, the Search is now not performed on every keypress and will wait until paused typing so the screen does not flash.
• On the Schedules page in ReportMagic4, the Search is now not performed on every keypress and will wait until paused typing so keystrokes are now not missed.
• Fixed an issue where running a Schedule with a new form (e.g. when already on the Progress Page) would not then take the user to the newly-running Schedule's Progress Page.
• Schedules now do not generate more than one Batch Job.
• Autosave now works in Report Studio in ReportMagic 4.
• The "Send Feedback" button in the Report Studio help dialog now opens and populates the feedback form when clicked.
• The "Send Feedback" button on the macro details in the Progress Page now opens and populates the feedback form when clicked.
• Can now insert examples in Report Studio on ReportMagic4
• Fixed an issue where the Review Report Job pop-up on the Progress Page was too small.
• When cloning a Schedule in ReportMagic 4, the name of the cloned Schedule in the pop-up includes the suffix " - Clone".
• In ReportMagic 4, when opening the Run Schedule form e.g. in the Report Library, the values are reset each time it is opened.
• Removed spurious / unnecessary 'x' (close) button on the Chains visualization pop-up on the Schedules page.

Admin

New Features

• The Connection create / edit dialog in the Admin app (not in ReportMagic 3) now allows an expiry date (UTC) to be set for a Connection's credentials. The values are also shown in the table, with appropriate colours.

Bug Fixes

• Fixed an issue where the Role Permissions in the Admin app could not be created as expected in some circumstances.
• The Tenant GUID id is now accessible to view in the Super Admin Tenants page
• Added additional validation into the Audit Logs time range controls.
• The Admin => Audit Logs are now sorted by default on Created DateTime UTC (because those users don't see the ID column), and the Super Admin => Audit Logs are still sorted by the ID column (as before).
• Removed unnecessary red boxes around feedback forms in various apps.

AlertMagic

New Features

• The Payloads page in AlertMagic now has additional columns in the table: "Problem Signature" and "Incident ID".
• In AlertMagic's Payloads table, the Incident Number column (shown as "Incident No." has now been added (which joins previously-added Incident ID, and Problem Signature columns).
• In Alert Studio, it is now possible to clone Incident Spec Comments and Problem Spec Comments.

Improvements

• AlertMagic Azure now logs lookup attempts which should appear in the payload logs in the AlertMagic app.
• Added additional logging for Microsoft Dynamics IMS systems in AlertMagic, so that more information comes through to the Payloads logs screen. Updated the logging so that informational logs are now included. Previous warning logs are now reverted back to information logs.
• AlertMagic's Alert Studio page now has a new tab called "Notes". This is a text area input where you can enter any notes regarding the current version. When saving an existing version as a new version (i.e. Save (New Version) button) or importing from a previously-exported version, the Notes field is set back to empty.
• The logs shown in AlertMagic's Payloads page can now be filtered by log level, via a drop-down (e.g. All, Information, Warning, Error, Critical).

Bug Fixes

• Fixed broken AlertMagic ServiceNow payload processing.
• When on any page in Magic Suite apps (such as AlertMagic and DataMagic), if you then select the help button you are now taken to the correct page in the Docs app.
• Fixed an issue where the search box filter on the AlertMagic Payloads page did not work as expected.
• The Cancel button in the AlertMagic Meraki Webhooks page now cancels immediately without waiting for actions to complete.
• Fixed an issue in Alert Studio's Test Overrides where the Name drop-down would show a validation error when there is only one item in the drop-down, and so could not be saved.
• In AlertMagic's Add Test screen, the Test Overrides toolbar is now above the table, not below. Also fixed minor padding / spacing issues with the toolbar.
• In Alert Studio, tables shown as a result of clicking nodes in the Configuration tree (e.g. Mappings, Incident Specs) are now ordered correctly. You can order an Incident Spec by Name, Comment, Condition, etc.

DataMagic

New Features

• It is now possible to reset TimeSeriesDataAggregations for DataMagic syncs by specifying "AggregationReset" : true in the LogicMonitor Connection's configuration.
• All pages in DataMagic now show 100 results by default

Improvements

• On DataMagic, the page you are on in the left hand pane now remains highlighted so that you easily know where you are
• In DataMagic, Edit buttons (which are the default on all/most pages in DataMagic) are now coloured blue (not grey), and Create buttons are now green (not blue) to match the colour scheme used on the other apps.

Bug Fixes

• Various network metadata is now updated if changed inbetween each round robin
• Users can now access all pages in DataMagic
• The items selected in the estate tree now remain selected when navigating through pages or refreshing the page etc.
• The table on the Client History page is now filled correctly using the date range selected in the timeline
• Fixed an issue in DataMagic where it was not possible to add Organizations.
• The items selected in the estate tree now remain selected when navigating through pages or refreshing the page etc.
• Fixed an issue that was preventing network tags from being updated.
• Deep links work for logged out users in DataMagic
• The Network Event deeplink now includes note to the Organization/Network selected in the estate tree so that the URL can be followed easily to get to the exact same place needed
• The DataMagic feedback form now opens and submits as expected
• Fixed an issue where the column selector on tables would cause a UI issue / error.
• The ports page: a. now appears correctly when selecting a device or a switch, and b. filters correctly when on the ports page and using the estate tree to filter by Org/Assigned status/Network/Device etc
• On DataMagic, the page you are on in the left hand pane now remains highlighted so that you easily know where you are
• You can now access the Estate>Organisations page even when you had an organization selected in the estate pane
• Various pages now select the appropriate level above your current selected Network/Device/Port in the estate tree to allow users to have a seemless browsing experience.
• DataMagic now has a favicon
• The org/network/assigned selected in the estate tree now remains selected when accessing the Network Events page
• The org/network/assigned selected in the estate tree now remains selected when accessing the Client History page
• The paging on the Mac Vendor page now works as expected
• The left hand navigation pane can be scrolled on if there is too many options to see on your screen
• GET console errors are no longer seen on the Floor Plans page in DataMagic
• On the Ports page on DataMagic you can now re-order all columns without a reload error
• The pages in the Estate Menu in DataMagic are now ordered alphabetically.
• The Menu in DataMagic is now listed in alphabetical order
• Fixed problems with filtering on PerfScore and Upstream Packet Loss, on the Device page.
• Navigating the estate organization dropdown with up and own arrows now works as expected without giving a reload error.
• The Sensor Data page is now accessible when you have a device or port selected in the estate tree.
• The deep link is now updated with the page size and which page selected.
• In DataMagic, the feedback form now does not have a box around the submit/cancel buttons.
• Fixed incorrect fonts in DataMagic, which made dialogs, menus and other UI elements use inconsistent fonts compared with other Magic Suite apps.

Docs

New Features

• In the Advanced Topic section of the docs app, there is now a page about the various MagicSuite Schemas and how to access them.

Improvements

• The ConnectWise Manage Connections help has been updated to describe the additional / optional Configuration properties that can be specified.
• Added a Normal Mode help example for the [CloudHealth.OrganisationList:] macro.
• Various properties in the Meraki Connection Configuration are now excluded from validation (or the list of properties), or used as expected.

Bug Fixes

• Updated help example 3 for the DataMagic Organizations help.
• Updated help example 6 for the [LogicMonitor.Graph:] macro to use the correct 'interLineAggregation' parameter, rather than 'aggregation'.
• Updated the help examples for the [AutoTask.FieldProperty:] macro.
• Moved the DataMagic help topics in DocMagic from the "Meraki Estate" sub-menu, to the top-level in the tree, just below the "Support" menu item.
• Fixed an issue in the Docs app's Release Notes page where, when there are no release notes for a particular version, the table of release notes shown on the right may not be empty as expected, but show release notes for another version (if you have previously clicked on a version that does have release notes).
• Fixed a typo on the "Connecting to External Systems" in the Docs app, in the ReportMagic > Connections and Agents section.
• Updated the help examples for the [AutoTask.TicketProperty:] macro.
• Updated the help example for the [AutoTask.TicketList:] macro.
• Updated the help examples for the [AutoTask.Property:] macro.
• Updated the help examples for the [AutoTask.List:] macro.
• Updated the help examples for the [AutoTask.AccountProperty:] macro.
• Updated the help example for the [AutoTask.AccountList:] macro.
• Updated the help example for the [CloudHealth.CustomerDetails:] macro.
• Updated the help example for the [CloudHealth.AwsACcountDetails:] macro.
• Updated the help example for the [CloudHealth.AwsAccountsList:] macro.
• Updated the help examples for the [CloudHealth.AvailableReportDimensions:] macro.
• Updated the help example for the [CloudHealth.AvailableReportOptions:] macro.
• Updated the help example for the [CloudHealth.AvailableReportsList:] macro.
• Updated the help example for the [CloudHealth.AssetDetails:] macro.
• Updated the help example for the [CloudHealth.AssetList:] macro.
• Updated the help example for the [CloudHealth.OrganisationAccountsList:] macro.
• Removed single colon character as description for [CloudHealth.AvailableReportDimensions:] macro examples.

NCalc 101

Bug Fixes

• Fixed an issue where the ItemAtIndex function would not accept an Int64 index parameter. An Int64 now can be used (so long as the value is between 0 and Int.MaxValue / 2147483647) or an exception / error will occur explaining the valid range.
• Fixed an issue where the timeSpan ncalc function (e.g. us used in many macros such as the [Calculate:] macro) did not behave as expected when not using the standard time format string specifier.

Shared

Bug Fixes

• For logged out users, the feedback dialog does not now show the User field.
• Fixed intermittent SharePoint file-system move / copy errors.
• Added logging to download once controller.