Remedy Toolbox

This tool is an effort to bring all of my client/server utilities together under a single graphical interface. Long time users of my toolset will recognize many of the tools that exist in here, most of which were command line interface with text output. As I continue work on adding tools into this toolbox I will be retiring the legacy tool in favor of this one. The toolbox sports a handy in-line help feature in the form of a ? in the upper right corner of the tool. This will give you context appropriate assistance on the tab that you are currently looking at. There is a Readme.txt that is helpful in getting the tool launched the first time and batch files that once edited to your environment will help you launch the tool effectively. Enjoy

The tool starts with connections. The connections defined are stored within the tool and the passwords are stored encrypted. Once a connection is configured, you can use it throughout the tool (if required)

Tools

DB Size

This tool connects to your database through your Remedy server and provides you with information related to the number of records and size of the tables. Useful for helping diagnose bloat and answering the ever present question ‘Why is my database so big’

Escalation Timeline

This tool is a predictive tool. It connects to your Remedy server and tells you when escalations ‘should run’. Meaning that it takes a look at the timings of interval and time based escalations and based on that information will plot out each instance of when it should run within its pool. Allowing you to see where you have potential conflicts with other escalations within the same pool

Escalation Runtime

This tool looks not at theoretical future of escalations, but instead at an actual escalation log. It informs you of each escalation that happened in that log, how long it ran for, how many records it processed, and other useful information to help troubleshoot escalation performance issues

Object Finder

This tool will load up your complete system (All Objects) and allow you to search for objects filtering on Base/Overlaid/Custom allowing you to find workflow associated with fields and export anything you want to csv

Record Manager

This tool is designed to allow you to, as the name indicates, Manage Records. You should be able to Create, Modify, Delete, Import, and Export records. Create/Modify allow you to use normal API, or Merge API to do the work. Export can go to ARS or CSV, Import imports ARX only.

String Converter

This tool comes to the toolbox from another developer (with our own spin on it). This tool started life under the name of Login Converter. It has had a few tweaks made to it since it came to us, but functions much the same as it did before. This tool allows you to update one to many from/to values in text fields in any form/field on the system you want to. It is an extremely flexible and powerful tool to be able to change text in any field on any form on any number of records.

Version History

2.1.2 – Jan 30, 2023

  • BUG: In the 2.1 update I added an exclusion for field id 50-70 but messed up the logic and it was excluding all fields instead of just those in that range.
  • BUG: For some users, right clicking on a form in the DB Size form and telling it to refresh was causing an exception. Added some logic to try and prevent that error

2.1 – Dec 13, 2022

  • BUG: Remedy converged server introduced a new ‘Password’ field range of 50-70 which would throw an error if searched. Added this field range to the exclusion range for String Converter

2.0 – Sep 27, 2022

  • BUG: Fixed untold quantity of bugs in existing tools, sorry I didn’t keep track of all of them over the last year and change
  • CHANGE: Renamed Customization Finder to ‘Object Finder’ and enhanced it with search capabilities allowing you to do just a bit of what ARInside can do regarding finding fields and their related workflow
  • ENHANCEMENT: Added ‘Record Manager’ Tool. This tool is intended to be able to do virtually anything you can think of regarding records, from create/modify/delete/import/export in standard api or in Merge. This tool allows you to do Diary Editing (if your Remedy server is updated and hotfixed properly)
  • ENHANCEMENT:

1.1 – Apr 11, 2021

  • BUG: String Converter: Fixed a few minor RegEx issues
  • ENHANCEMENT: String Converter: Moved the Simulation button to the ‘Options’ section, and added a visual overlay to the running section to show you that it was in simulation mode
  • ENHANCEMENT: DB Size: Added the ability to refresh a single selected form to the right click context menu
  • ENHANCEMENT: DB Size: Added a note to the status bar letting you know the date/time and ‘what’ of the last refresh

1.0 – Mar 7, 2021

  • Initial Release