21st of November, 2022
Service
New Features
Excel Export and Import
We have added the ability to export and import results. You can export the results of a rule, edit this rule’s data in Excel and then import it back into the rule.
This is useful in a variety of scenarios such as populating a new Glossary or Reference rule, or annotating a large number of metadata fields for an Alert.
Spreadsheets exported from a Loome Monitor rule have protection around which columns may be edited and what values you can insert into them. You can also insert and remove rows for manual rules such as a Glossary or Reference.
When exporting you can also choose to export all rows, or only the rows matching your current filters in the results.
You can also add new columns for metadata, or data in a manual Glossary or Reference.
We also have server-side validation when you import a spreadsheet back into a rule. If you have invalid data or columns, you will be provided a list of issues to rectify before importing again.
You can choose to turn import and export on or off for each rule.
New Custom Field Types
Decimal
We have added a new custom field type, ‘Decimal’. You can add this to your Loome Monitor rules where you need to specify scale and precision for values such as money or percentage.
Boolean
We have added a Boolean custom field type for metadata columns. You can add this custom field to your rule to choose between ‘True’ and ‘False’ for each row in your results.
Notifications
We have introduced a new notification system. It can send email notifications as well as in-app notifications.
You will notice a notification hub in the top right corner. In-app notifications will be sent to this hub. You can have a maximum of 50 notifications per user before trailing notifications will be removed.
Currently you can view agent status notifications and import and export notifications.
The agent status notification replaces the agent status bar. When an agent goes offline or comes online, you will now receive notifications via email and in-app. This provides a clearer picture of what is happening with your agents.
You also have the ability to opt out of notifications. Emails will have a link to opt out, however in-app notifications for the agent status are mandatory.
Please let us know if you would like other event notifications, and we can expand these notifications in the future.
Agent Installation and Lifecycle
We have made several improvements to agent installation and lifecycle.
- We have replaced the Azure RM PowerShell commands with Azure CLI and Azure Az PowerShell commands to keep up with current Microsoft tools.
- We have also added an option to the installation command line for Windows and Linux to perform a silent installation.
- We have also removed the PowerShell remoting requirement for Windows agents and added Sudo as a prefix to the Linux installation to avoid installation permission issues.
Improvements
- We have improved the list view of projects and have added more information about each rule, as well as filtering and sorting.
- We updated the rule results layout by rearranging in-built columns and selecting default columns (some non-priority columns are now initially hidden), so that your data columns are more prominent.
- We modified the rule results view to show the source data columns before the custom field columns. You will need to update your agent and re-run your rule to update this.
- We added support for datetime offset and precision and scale filtering in the Loome Monitor results page.
- We have improved the results page, so you do not need to scroll the page to get to the bottom of the results table.
- The results page will conform to multiple screen sizes.
- We have moved the rule metrics to a slide out in the results table to improve the page layout.
- Results grid filters will be preserved when loading more records on a results view.
- The default order of records in the results view now prioritizes default statuses.
- You can now clone a manual record to copy it with a new key column value in a manual or source and manual rule.
- ‘Created By’ and ‘Created Date’ are hidden by default on the Project rules list. You can choose to display it using the column filters.
- We have added improvements to the sign out process.
- We also added an Excel enabled flag to the rules list to indicate if Import and Export is enabled.
Fixes
- We have fixed an issue where the ‘New Record’ column is being returned as an integer to the results page, and not filterable as a Boolean.
- We fixed an issue where the clickable URL on a Loome Monitor rule, when copied and shared would be incorrect.
- The Reconciliation rule type was previously adding ‘Alert’ as the rule type in the LM__MAPPING table.
- You could previously not use a datetime column as a key column in a manual Glossary or Reference.
- We fixed an issue where a Reconciliation rule was not populating both sides (base and comparison) of data into the communications table.
- The ‘Assigned to’ column had an issue where empty values were generating new rows into the metadata table on every run.
- We have fixed an issue where the Consumer application role could see all rows in a rule when using a specific filter.
- Fixed an issue with Synapse rules where a custom list value could not be selected on a row.
- We fixed a bug where certain numeric types were being treated as Varbinary.
- We have fixed an issue that occurred when key columns had large string values of over 50 characters.
- Fixed a bug that prevented spaces in metadata column names.
- You can no longer edit a key on a manual record in a Source and Manual rule.
- Fixed an issue where a new manual record is not marked as new in the ‘New Record’ column in the results.
- We prevent users from adding a new manual record without key column values.
- Fixed an issue with the licensing service that was causing some users to encounter a licensing error when opening a tenant.
- Resolved an issue where silent renewal of login could prompt an expired login message.
- Resolved issues with licensing service occasionally failing to validate a tenant.
Agent
This update requires agent version - 2022.11.21.1
Please download a new install script and update your agent to use new features, improvements, and fixes.
This version of the agent requires you to download a new install script for the agent from your tenant’s ‘Agent’ page.
New Features
- We have added Excel Export and Import. To use Import and Export you will need to update your agent. Read more above.
- We have added Decimal and Boolean Custom Fields. To use these custom fields, you will need to update your agent. You can learn more about each custom field above.
Improvements
- The default order of records in the results view now prioritizes default statuses.
- We modified the rule results view to show the source data columns before the custom field columns. You will need to re-run your rule to update this.
Fixes
- We have fixed an issue where the ‘New Record’ column is being returned as an integer to the results page, and not filterable as a Boolean.
- The Reconciliation rule type was previously adding ‘Alert’ as the rule type in the LM__MAPPING table.
- You could previously not use a datetime column as a key column in a manual Glossary or Reference.
- We fixed an issue where a Reconciliation rule was not populating both sides (LHS/RHS) of data into the communications table.
- The ‘Assigned to’ column had an issue where empty values were generating new rows into the metadata table on every run.
- Fixed an issue with Synapse rules where a custom list value could not be selected on a row.
- We fixed a bug where certain numeric types were being treated as Varbinary.
- We have fixed an issue that occurred when key columns had large string values of over 50 characters.
- We fixed a bug that prevented spaces in metadata column names.
- Fixed an issue where a new manual record is not marked as new in the ‘New Record’ column in the results. New records will be updated when the rule is run.