Magic Suite 3.26

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

ReportMagic

New Features

• Added the [HubSpot.Property:] macro. This allows you to obtain the properties (as a full JObject, or using the jsonPath parameter a subset of the JObject) of Accounts, Contacts and Deals, given the ID of an item.
• The [Hubspot.List:] macro now supports the 'associations' parameter to include relevant HubSpot 'associations' in the output jArray / jObjects.
• Added the [Object.Graph:] macro. This macro creates a graph from data in a jObject or the output from the [LogicMonitor.GraphSpecification:] macro. It only works in Normal Mode.
• Added the [LogicMonitor.GraphSpecification:] macro. This macro obtains graph data from LogicMonitor, and supports all the same parameters as the [LogicMonitor.Graph:] macro. Instead of outputting a graph, it outputs a JObject which represents the chart specification that would otherwise be sent to the chart generator. It runs in Normal Mode (you can specify mode=legacy but the output will be the same). The output of the macro can be manipulated (with other macros) and then sent to the [Object.Graph:] macro as input.
• The [HubSpot.List:] macro now provides the ability to request any HubSpot properties in the output objects. HubSpot entities may have custom properties on them, and this feature allows you to obtain them using the macro.
• The [Web.xxx:] macros now all by default set a User-Agent string, which may prevent failure for certain websites that mandate it must be present. Also added a 'userAgent' parameter, so that it can be set as required on the macros.
• The Report Job review status and message can be viewed in the Report Jobs table. The purpose of the review function is to allow failed report jobs (e.g. those with a macro error or system error, that caused the entire job to fail) to be reviewed (i.e. add a comment to say why), so that they can be safely ignored or followed up as needed
• The batch jobs table now shows the ReportMagic version in place when the batch job ran.

Improvements

• The Files preview panel now shows the file icon for completely empty (0 byte) files, for all file types, rather than just various specific file types.
• Added additional help examples for the [AlertMagic.MetricsGraph:] macro.
• Updated the help text for the 'xAxisHeightPercent' and 'yAxisWidthPercent' parameters for [xxx.Graph:] macros, to make it clearer what they actually do.
• The [LogicMonitor.ReportGroupList:] macro now supports the 'skip' and 'take' parameters.

Bug Fixes

• Various connections with JSON configuration have validation and helpful explanations if there is an issue.
• More Connection types now validate the configuration in the Connection edit / create dialog.
• Fixed an issue with PowerPoint input documents, where [ForEach:] and [Break:] macros may unexpectedly break out of a ForEach loop prematurely.
• Fixed an issue where any pages that used a 'splitter' panel, such as the files browser, would not allow the user to scroll (e.g. unable to scroll the list of files and folders in the Files page).
• Double clicking files now either downloads them or opens them in report studio. Double clicking folders now opens the folder.
• Fixed an issue where it was not possible to create a folder and then double-click / open it in the files browser, without refreshing the files view.
• Files and folders that start with a dot (.) are now shown in the file explorer, except .git folders for Git-specific file systems (as before).
• Files and folders that start with a dot (.) are now shown in the file explorer, except .git folders for Git-specific file systems (as before).
• When searching with shortcuts in ReportMagic the category field now auto updates to the shortcut being used.
• Updated nuget packages for DataMart / LogicMonitor API to fix an issue with the [LogicMonitor.CollectorList:] macro.
• The Agent now responds to requests concurrently. Capped at 4.
• On the Ops Dashboard, a - is now shown for AU AlertMagic Azure
• Fixed an issue where the Ops Dashboard would give a signing in error if not already logged in to the Production Magic Suite system.
• Fixed an issue with search / filter UI layout on the Progress Page in ReportMagic, which could be squashed when the count of report jobs, as indicated by the paging controls, was high, due to more text being shown in the UI.
• Fixed an issue where there was no pop-up indicating success or otherwise, when copying variable values from the pop-up that appears in the progress page, when clicking the expander icon in the variables panel.
• Fixed an issue where the Report Studio would crash when restoring recent content that was auto-saved in the code editor, when the user is in rich text mode.
• Fixed an issue where various [LogicMonitor.xxx:] macros might fail when used with multiple devices (e.g. the devices / deviceIds / deviceNames parameters).
• [List.GroupBy:] now does not error when using the aggregations Mean and All
• Various [LogicMonitor.xxx:] macros now do not system error.
• The jsonPath parameter now works as expected with the [HubSpot.Property:] macro.
• Fixed various issues with the [Meraki.NetworkEventList:] macro: 1) The properties parameter now behaves as expected. 2) The startAfter and endBefore properties now behave as expected. 3) Up to 10,000 Network Events can now be listed - increased from 1,000 events. 4) This macro now supports Normal Mode ONLY (not Legacy Mode). 5) Any errors now cause a macro error instead of system error, and errors will also show the actual reason why (e.g. a 404 unauthorised from Meraki).
• Fixed scrolling issues on various pages.
• Users who log into a Magic Suite app (such as ReportMagic) after being deleted now get shown the 'waiting on approval' message, rather than nothing or an incorrect page.
• Fixed an issue where the [Xlsx.Embed:] macro, when used in PowerPoint, would change the size of the embedded Excel icon, after opening and closing the embedded spreadsheet. For now, the 'IconText' parameter is no longer supported when used with PowerPoint only (but still works with Word input documents), and is now listed as optional in the help, but causes a macro warning if not used with Word.
• Fixed an issue where the 'pointWidth' parameter, as provided by [xxx.Graph:] macros, would have no effect on the chart output. Also made that parameter deprecated (but still works) in favour of 'pointWidthPercent', which more accurately reflects what the parameter does.
• [LogicMonitor.Dashboard:] now does not error when used
• Updated file explorer component to resolve an issue where the toolbar buttons may not always be shown.
• The [LogicMonitor.InstanceList:] macro now works as expected in Normal Mode, and respects the property selected in the 'property' parameter. Various "legacy" properties (on an instance) have been renamed to match the definition of the objects, i.e. deviceId becomes resourceId, etc (any property starting with 'device' now starts with 'resource'. See the macro help in ReportMagic or the Admin app for more details.
• Fixed an issue where the [LogicMonitor.DataPointList:] macro ignored the property parameter in Normal Mode and would always output a JArray of JObjects that contain ALL properties and values.
• Fixed an issue where the [LogicMonitor.Dashboard:] macro would attempt to set the wrong dashboard URL when used in conjunction with the insertHyperlink=true parameter.
• When using experimental ChartMagic to render, if there is an exception (which there likely will be), then there is now a macro error rather than a system error.
• Various irrelevant parameters were removed from the macro help parameter list for the [HubSpot.Property:] macro.
• The [Object.Graph:] macro examples have been updated.
• In ReportMagic4 the Drag and Drop file/folder highlight now: a) colours the whole Files pane rather than just half of it, and b) this highlight is now a better colour in dark mode.
• If the [InsertTableCellImage:] macro is used in anything except PowerPoint, a macro error is now generated, rather than a system error.
• Added an additional help example, and updated existing example so it can be run out-of-the-box, to the [Meraki.NetworkEventList:] macro.
• The [Jira.UserProperty:] macro help example can now be run without modification by any customer with a Jira Connection.
• Updated the [Jira.Table:] macro help example(s).
• Updated the help examples for the [Jira.LastImage:] macro.
• Updated the [Jira.IssueResponseTime:] macro help example.
• Updated the [Jira.IssueList:] macro help example.
• Updated the help example for the [Jira.IssueLastCommentProperty:] macro.
• Updated the help example for the [Jira.IssueAnalysis:] macro.
• Updated the help examples for the [LogicMonitor.SdtProperty:] macro.
• Updated the [LogicMonitor.RoleProperty:] macro help examples.
• Updated help example #2 for the [LogicMonitor.ReportProperty:] macro.
• The [LogicMonitor.ReportGroupProperty:] macro help examples have been updated.
• Updated help example 2 (the Normal Mode example) and removed superfluous example 3, which was combined with example 2.
• Updated the help examples for the [LogicMonitor.RecipientGroupProperty:] macro.
• Updated the help example for the [LogicMonitor.PropertySourceJson:] macro.
• Updated the help example for the [LogicMonitor.LogicModuleUpdateProperty:] macro.
• Updated the help example for the [LogicMonitor.EventSourceProperty:] macro.
• Updated the help example for the [LogicMonitor.DataSOurceProperty:] macro.
• Updated the help example for the [LogicMonitor.DataPointList:] macro.
• Updated the help example for the [LogicMonitor.ConfigSourceXml:] macro, so it can be run out-of-the-box.
• Updated the help example for the [LogicMonitor.ConfigSourceList:] macro.
• Updated the help example for the [LogicMonitor.ConfigSourceProperty:] macro.
• MS-20538 Updated the help example for the [LogicMonitor.ConfigCheckProperty:] macro.
• Updated the help example for the [LogicMonitor.ConfigCheckList:] macro. Changed the default mode from legacy mode to normal mode.
• MS-21562 RM 4 Library Schedules with forms do not now crash the UI.
• In the Library, if you have a template which uses a connection which you do not have set up you are now unable to run the template until you have the connection set up.
• In ReportMagic4 the Drag and Drop file/folder highlight now: a) colours the whole Files pane rather than just half of it, and b) this highlight is now a better colour in dark mode.
• When using ReportMagic4, the 'Home' button does not remain highlighted when naviagting around the app.
• In the Library, if there is a template which uses a connection which has not been set up you are now told which connections are needed to be set up.
• The Open Connections Page button in the ReportMagic 4 Report Library is now better coloured in dark and light modes.
• Fixed an issue in ReportMagic 4, where the padlock icon displayed on the access denied page was not displayed properly.

Admin

Improvements

• In ReportMagic and the Admin app's Connections table, the validity of each Connection's Configuration, is shown in the "Config" column. If invalid, the tooltip on the 'x' icon highlights the reason why.
• The configuration for Web Connections is now validated in the edit / create Connection form.
• The configuration for Toggl Connections is now validated in the edit / create Connection form.
• The configuration for Salesforce Connections is now validated in the edit / create Connection form.
• The configuration for Microsoft Azure Connections are now validated in the Connection edit / create form.
• The configuration for Cherwell Connections is now validated in the edit / create Connection form.
• MS-21255 The configuration for SMTP Connections is now validated in the Connection create / edit dialog.
• Fixed an issue where GitHub Connection validation was incorrect.

Bug Fixes

• Fixed an issue where Regular Users and Tenant Admin users would not see ANY toast pop-ups, e.g. when raising feedback.
• Fixed an issue where various missing CSS (loaded by JavaScript by the Blazor framework) could prevent a new Connection being added.
• In the connection create/edit/clone dialog the config field, now does not autofocus the cursor to the start of the config text whilst typing.
• The Status for DataMagic Sync executions now updates in real-time in the Admin app: DataMagic => Sync Executions.
• The connection edit/create/clone dialog resets/updates/clears the errors seen when you choose a different connection type.
• The Audit Logs pages (ReportMagic and Admin app) now limit the audit log CreatedDateTimeUtc range, and provide additional controls in the menu bar to choose the desired values. This results in a much faster page load time and avoids an issue where the page might take a long time to show the (very many) audit logs, by narrowing down the search options by default.
• Fixed an issue on the create / edit Connection dialog, where the URL for various Connection types would either be missing, or incorrectly have trailing forward-slashes (whether or not the default in the code should have one or not).
• Fixed an issue where the cancel dialog used on the create / edit / clone dialog on the Admin app's Connections page, when cancelling out of making changes, might sometimes not close and could not be exited, requiring a browser refresh to be able to use the page again.
• Fixed an issue where the create / edit / clone dialog on the Admin app's Connections page could take 1-2 seconds to appear.
• Updated the GitHub Connection help in the Docs app (in the Admin App section under Connections) and in ReportMagic.
• Fixed an issue where GitHub Connections would not function correctly, and show as invalid (as well as inability to collect Connection statistics), when using a Personal Access Token (PAT) to access private repositories.
• When creating a LogicMonitor Connection in the Admin App the Config field gives you helpful hints when you are trying to specify the hush property.
• Fixed an issue where SFTP Connection validation was incorrect.
• On the Admin, Connections page the Meraki Config field now gives a helpful error text when using the wrong values in the JsonMissingMemberAction property.
• The configuration for Meraki Connections now includes the missing properties RateLimitMaxCalls and RateLimitTimeSpanSeconds, as well as excludes incorrect property RateLimiter.
• Fixed broken form-select dropdown border colour style in dark mode.
• When editing a Connection, the "Cancel and lose these changes" popup no longer shows unless the values in it really have changed.
• When accessing the DataMagicSync Executions page in the Admin app, an error is no longer seen.
• Admin App > Branding: Logo and Background Image name fields are now emptied upon image removal/save of the page.
• In the Admin app the DataMagic Sync Executions page loads without erroring
• DataMagic Sync Executions message and status columns now update in real time
• Fixed an issue where SharePoint Connection validation message was incorrect.
• Fixed an issue where the ServiceNow Connection validation message was incorrect.
• Fixed an issue where SFTP Connection validation was incorrect.
• The username field in the connections dialog is now always the correct height.
• In the Connection edit / create form, when right-clicking in the Configuration field (a "Monaco" editor), the context menu that appears now correctly appears above other fields in the form, rather than being semi-hidden.
• Fixed an issue where Agent Connection validation was incorrectly mentioning the 'SqlMaxRetryCount' property. It is obsolete - use 'SqlMaxTryCount' instead.

AlertMagic

New Features

• The Webhooks sub-menu items (Azure, LogicMonitor, Meraki, or VCenter) are now only shown if there is an AMS setup, that uses the relevant type of Connection. VCenter is always shown however, because a VCenter Connection / AMS has not yet been developed.
• AlertMagic Metrics charts now show series totals underneath each chart.
• In AlertStudio > Configuration, the IncidentSpecMappings and ProblemSpecMappings can now be cloned.

Improvements

• Additional logging added to AlertMagic's AutoTaskIncidentManagementSystem IMS. These logs will appear in the AlertMagic UI's payloads page, for the payloads listed in the table.
• 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.

Bug Fixes

• Fixed issue where Information logs were not being sent from AlertMagic Azure to the Magic Suite API (and then to Elastic) for payload logs.
• Fixed broken logging template usage in AutoTaskIncidentManagementSystem.cs, which is logging errors in the payload logs for AutoTask ticket creation / update.
• AlertMagic now does not allow activation of a version, in Alert Studio, if the configuration is invalid.
• Fixed an AlertMagic issue where invalid Incident Spec Mappings and Problem Spec Mappings would not show as invalid in the UI (due to missing Condition), allowing activation when it should not be permitted.
• Fixed an issue where AlertMagic could not show any data / crash the UI.
• Fixed an issue in the Meraki Webhook config in AlertMagic, where when setting alerts on a network that is NOT the same type as the examplar network, e.g. from a multi-product network to a wireless only network, the network-wide alert settings would not be updated, and the UI would show an error.
• Fixed an issue where the AlertMagic IMS chart totals was actually showing the IMS read/write values.
• The AlertMagic Webhooks pages are now only accessible to Tenant Admins and above.
• Error is no longer reported expanding the Webhooks menu.
• Accessing Alert Studio by a url which includes IntegrationId and VersionNumber now works as expected.
• Fixed an issue where pressing the CTRL or SHIFT keys in the Payloads JSON editor, in Alert Studio, would indicate that there were changes to the version, when in fact there were no changes.
• In Alert Studio's Configuration section (tree nodes), adding new nodes (such as mappings), adds them to the end of the list of nodes, and scrolls into view.
• In AlertMagic's Alert Studio, if there is only one Integration, it is now automatically selected.
• In AlertMagic, various DateTime columns on the payloads page are now filterable.
• Fixed an issue where an error toast could show on the Metrics page for new Tenants that have no configuration.
• The AlertMagic > Webhooks > Azure menu item is now always shown to Tenant Admin users and above.
• The AlertMagic Webhooks > VCenter is now always shown to Tenant Admins and above.
• The AlertMagic Meraki Webhooks menu now auto-refreshes when adding / editing / created Meraki AMS systems. Also improved the Meraki Webhooks page to describe the pre-requisites (if not fulfilled) in order to proceed - e.g. must have a Meraki Connection, must have an integration, etc.
• Fixed an issue where invalid deep links would show the save / active (and other) controls that were not relevant, when asking you to choose an Integration and Version.
• Fixed an issue where a Toast did not pop up informing users that the new Integration button will remain greyed out until Deployment Targets, AMS or IMS exist in the tenant

DataMagic

New Features

• NetworkClientHistoryAggregations and NetworkClientHistory are now present on DataMagic and the Database.

Improvements

• On the Ports page there are new Appliance wan usage columns

Bug Fixes

• Fixed scrolling issues in DataMagic on various pages.
• Help/Documentation has been removed from DataMagic. It is now present in the Docs app.
• Super Admins and Uber Admins can now use the column selector dropdown as expected.
• Fixed layout / CSS issues on various pages in DataMagic.
• The Client History timeline is now the same size as the timelines on other pages.
• Tables inside the DataMagic help pages how show correctly in Dark Mode.

Docs

New Features

• In the Docs app, the Meraki Estate menu items are now ordered alphanumerically.

Improvements

• Fixed an issue in the docs app where the macro page would not show some incorrect 'empty' content before being fully loaded.
• Issues listed in the Release Notes page now highlight the Version text in blue, if the fix version of the issue matches the version of the Magic Suite build that is deployed.

Bug Fixes

• In the AlertMagic Integration section of the Connection to IMAP connection help, corrected incorrect help example which used "Url" instead of "Uri".
• The ConnectWise Manage Connection documentation has been updated and appears correctly in the Docs app and ReportMagic.
• Fixed an issue where certain bugs would be listed in the Release Notes even when not closed (e.g. they were ready for test, or in test). New features and improvements are still included, as before, even if they are not closed fixed, because they are still shown with the 'preview' icon in that case.
• The 'Connecting to ReportMagic' / 'MagicSuite Connections' page has been updated to correct some URLs on the page.
• [Object.Graph:] macro and various other graph-related macros can now correctly use the 'failureText' parameter. This parameter is used so that if a macro does fail, instead of a macro error it will generate a successful result but insert the failure text specified (which can be empty, e.g. failureText="") into the output document. This has always been supported but did not work as expected for a couple of macros.
• Fixed an issue in the [LogicMonitor.Graph:] macro where the parameter 'interLineAggregration' was mistakenly referred to as 'aggregation'.
• Fixed an issue where the Version shown in the release notes might be incorrect for issues that have more than one fix version.
• Changed the width of the treeview in the Docs app to be narrower.
• Updated the [LogicMonitor.GraphSpecification:] macro's help example.
• ReportMagic help pages now have missing Connection help.
• Connections page now shows hyperlinks to ConnectWise and Azure connection pages.
• Fixed an incorrect variable name as used in the examples for the dedicated [Object.Graph:] menu help page. You can view the page in the Docs app by going to ReportMagic > Writing Reports > Advanced [Object.Graph:] Macro
• Removed irrelevant 'properties' parameter from the [ServiceNow.Count:] macro's help example.
• When the 'iconText' parameter is used by the [Xlsx.Embed:] macro in PowerPoint templates, a macro warning is generated, as the parameter is now ignored (required as part of a fix to another bug) - except when used with Word.

MonitorMagic

Bug Fixes

• Fixed an issue where the spinner (loading circle) could be the wrong size on various pages.

NCalc 101

Improvements

• In ncalc101 the extend() function now supports adding a property with a null value.

ProMagic

New Features

• The Projects page in the ProMagic app now allows multi-select of the Projects in the table, stacking all the selected Projects on the chart.
• The ProMagic/Issues help page has now been expanded to include information about how to search for Status using specific Blazor library filters

Bug Fixes

• When there are no Projects selected in the Projects table in the ProMagic app, the chart is now not displayed, and the 'Select Projects' message is shown.

Shared

New Features

• Merlin chat is now present on all apps in a basic form, further improvements will be looked at separately.

Bug Fixes

• Various Monaco text fields now have line numbers and be 10 rows tall by default upon load
• The image attached to feedback toast now does not appear.