As part of the EOL of “sum of query results” thresholds (coming on 30 June, 2022 and mentioned in this announcement and also in this more focused announcement), today we are releasing a bulk conversion tool for “sum of query results” conditions, to help convert them to Sliding Windows Aggregation alert conditions.
You will be able to find this tool using the following steps:
-
Go to Apps at the top-left of the main page, and click View all Apps
-
Click Go to New Relic I/O
-
Search for eol and you will find the tool (the full name is Sum of Query Results EOL Conversion Tool)
NOTE: Users without “Admin” or “Nerdpack Manager” permissions on the account will be unable to install the app. Users who do not have permission to edit alert conditions will not be able to run the app.
Once you’ve found it and started it running, although it is a simple tool to use, you may want to read through some documentation. I have posted the documentation below.
The “Sum of Query Results” EOL Conversion Tool is a New Relic One application that will list out all of your conditions using a “Sum of query results” threshold and allow you to access them one-at-a-time or convert them to conditions that use Sliding Windows Aggregation (SWA).
Pre-loading conditions
When you start the tool, it will pre-load all alert conditions using “Sum of query results” thresholds in all your account(s). This may take a few moments.
Filter by account
All accounts are selected by default. Use the account dropdown to deselect one or multiple accounts. This will filter the list to only show conditions from the selected account(s).
Filter by policy
All policies are selected by default. Use the policy dropdown to deselect one or more policies. This will filter the list to only show conditions from the selected policy or policies.
Filter by condition
Use the search field to type in a whole or partial condition name. The list will adjust to only show conditions that match the text you enter.
Click on any condition name to visit that condition
If you’d like to examine a specific condition, clicking on the condition name will open the edit screen for that condition.
Select conditions
Clicking on any checkbox will select or deselect a condition. If you click the top checkbox in the checkbox column (farthest to the left), you will select all displayed conditions.
Migrate the conditions
Once you have the conditions selected that you want to migrate to Sliding Windows Aggregation, click the “Migrate” button. Once your conditions have been migrated, a success message will appear, and you will be given the option to download a list in CSV format of all conditions that were converted.
If any conditions fail to migrate (this is unlikely †), we recommend manually migrating in the UI using the instructions from this post. If the issue is with aggregation method not being selected and evaluation offset being too large, use the Match Current Values option and adjust the problematic field, which will be highlighted in red.
† Failure modes (conversion will fail if any of these are not met):
- Original Window Duration must be greater than or equal to 1/120 original Threshold Duration
- Original values of Window Duration and Threshold Duration must have a common denominator greater than or equal to 30 seconds
- If Aggregation Method is not selected,
(Evaluation Offset * Window Duration)must be less than 3600 seconds
Secret NEW feature 
