Search

Login Converted – Updated

Hi Everyone,

Version 2.7 of the Login Converter utility has been released.  This is a significantly faster version then the previously published one.  I highly recommend if you are using this utility to update to this latest version to take advantage of the improved speed as well as capability related to forms selection/import and correctness.

You can grab this version here:  

Cheers,

Entry Inspector 2.5 Released!

Hi Everyone,

Version 2.5 of the Entry Inspector has been released.  This is a huge update over the last published version as I have been working on updates / fixes on and off for over a year with some key beta testers.  I am happy with this version finally and decided to release it to a greater audience.

You can grab this version here:  

As always, if you are interested in a full version that removes the 20 record limit on actions, please click on the buy link below or email me at support@soleauthority.net to arrange alternate payment.

Click below to Purchase

(Will re-directed to a PayPal storefront):


Upon check-out, you will receive your key via email in 1-2 business days. If you have any questions at all pre/post purchase you can reach me at support@soleauthority.net

Cheers,

Published updated version of AIFGenerator tool

A few people had been reporting issues with the AIFGenerator tool that allows you to quickly clone an existing SRM AIF (based on template or your own custom AIF).  I’ve refreshed the utilities dependencies, upped the JRE requirements to 1.8 to take advantage of some newer Java language features and fixed up a few corner case issues that could have been the cause of some of the issues reported.

If you have tried the utility in the past and it hasn’t worked for you, assuming you still have a need for quick AIFs, give this new version a try and let me know if there are any issues:

AIFGenerator

Still here…

Hi Everyone,

Things have been quiet from me for quite some time as I have been transitioning into a new organization but I hope to get back to providing updates and utilities here in the coming weeks.

I currently have a new version of Entry Inspector that is being readied that will have the following capabilities / fixes:

  • BugFix – Search Type – Display Name / Advanced Search Format – Will now accept view contexts and field display names in any all supported/installed locales, previously only English (the default) would function in this search mode, any other non-english view field labels in the query box would throw errors about not being valid fields.
  • Enhancement – Columns headers for results table to allow toggling between DB Names (current behavior) and Display Names based on the view context selected.
  • Enhancement – Ability to save & retrieve search queries by form/server
  • Enhancement – Ability to disable form load counts – In a couple of very large enterprises that use Entry Inspector, pointing to tables with millions of rows slows down entry inspector tremendously as every-time a form is selected it would wait while a count is returned to show the total number of entries in the form.  While in general, it is nice to see this information, for these clients it makes using tool cumbersome so I’m adding an opt-out option for this functionality, hopefully one day BMC adds a proper count stat into the solution that is self managed that could be leveraged to not have to do a SQL count to get this information accurately.
  • Maintenance – Updated all dependent libraries to the latest available and bundle the latest BMC Java API (9.1)

I am also exploring the possibility of having a ‘light-mode’ version that could leverage the new RESTful API rather then the Java API.  This might be useful if port access to the AR Server is blocked but RESTful/MidTier traffic is still allowed (possible use-case would be Remedy OnDemand instances…), wouldn’t have near all the capabilities available as using the Java API but for basic data access it might prove useful.  This will probably come in a different release then the items listed above though.

Wishing everybody a happy new year 🙂

 

Entry Inspector 2.1 Released!

Hi Everyone,

Version 2.1 of the Entry Inspector has been released.  This is mostly a stability release rather then full of enhancements but there are a few nice ones that made the cut.

Here is a summary of the changes introduced in this version:

  • Added ability to do Create and Service actions against Display-Only Forms
  • Changed the field selection drop-downs to support auto-completion
  • Managing columns pop-up will allow for multiple actions now
  • Replaced existing login managers backend with an embedded database

That last item is an important first step towards other capabilities I’ll be including in future versions as this new settings database will eventually allow for persisting additional types of settings like saved search queries, commonly used SQL queries, results list column defaults per form, etc.

Because of this change to the new login backend, if you had previously installed Entry Inspector v2.0, your existing profiles.xml file will be automatically removed and replaced with a settings.mv.db.  You will need to re-add all your profiles manually though.

You can grab this version here:  

As always, if you are interested in a full version that removes the 20 record limit on actions, please click on the buy link below or email me at support@soleauthority.net to arrange alternate payment.

 

Click below to Purchase

(Will re-directed to a PayPal storefront):




Upon check-out, you will receive your key via email in 1-2 business days. If you have any questions at all pre/post purchase you can reach me at support@soleauthority.net

Cheers,

Entry Inspector 2.0 Released!

Hi Everyone,

Version 2.0 of the Entry Inspector has been released.  Many new features and a brand new installer to go with it to ease installation and sharing of the utility.

Here is a summary of the major changes introduced in this version:

  • Packaged with new installer (if you require non-windows version, please let me know and I will provide one)
  • Added selected row counter to allow for knowing how many you have selected without having to drill into a specific function for a count
  • Added SERVICE as an action type in the Modify/ModifyALL functions that will trigger Service workflow
  • Changed Display, Modify & ModifyAll function windows from jDialog to JPanel so that they can be maximized/resized as needed
  • Fixed Replace function not being used when Action Type MERGE was selected (it was appending instead)
  • Added new Create entry capabilities, you can do a standard create or a merge create against any data form
  • Added Copy To New capability, you can do a standard create or a merge create based upon the selected entry that will pre-populate
  • Added support for properly expanding Keywords (e.g. $USER$) for modify/modifyAll/create operations
  • Added ability to set specific Merge options rather then always using defaults
  • Increased performance of ARX/CSV exports by roughly ~30-40% and lowered memory consumption by about 50% during exports
  • Added ability to ‘append’ ARX data rather than just overwriting every-time
  • Added a new Utility section on main interface and include an Execute SQL utility
  • Added a new Utility section on main interface and include an Execute Process utility
  • Added a new Utility section on main interface and include a Manage Attachments utility
  • Added a new Utility section on main interface and include a Manage Diaries utility

You can grab this version here:  

As always, if you are interested in a full version that removes the 20 record limit on actions, please click on the buy link below or email me at support@soleauthority.net to arrange payment.

 

Click below to Purchase

(Will re-directed to a PayPal storefront):


Upon check-out, you will receive your key via email in 1-2 business days.  If you have any questions at all pre/post purchase you can reach me at support@soleauthority.net

Cheers,

Login Converter – Utility for mass updating Login IDs

Updating a Remedy system when a Login ID has to changed can be a long and slow process if you want to keep the integrity of the data after changing the Login ID.  BMC provides the Data Wizard tool to do this however it has many limitations such as:

  • Only being able to update one LoginID at a time
  • Requires customization to target custom forms/fields
  • Is generally slow and doesn’t search within all fields (only target fields important to ITSM workings)

There are also other third party tools developed for the same goal such as the RRR|LoginConv (https://rrr.se/cgi/tools/main?tool=rrrLoginConv) build which utilize arsPerl and since arsPerl has fallen a bit behind from a support perspective, an more up-to-date alternative is something that has been asked for on the ARSList.

Building upon some previous work I’ve done, I’ve put together a utility based upon the Java API that will perform the following tasks:

  • High performance updates from an old LoginID to a new LoginID utilizing merge action that bypasses workflow
    • Updates all Character Fields (regardless of size)
      • Match exact
      • (optional) Match surrounded by single/double quotes
      • (optional) Match surrounded by separators such as white-space, comma, period, pipe, semi-colon or colon
    • (optional) Updates all Status History entries
    • (optional) Updates all Diary Field entries

Here is a peak at what it looks like running through a multiple Login ID update:


LoginConverter_Small

Some key features of this utility include:

  • Ability to load in list of conversions from file when doing multiple updates per run
  • Pre-loaded list of all data forms from your connected AR System into the Specific Form field (with auto-fill capabilities)
  • Ability to specify a list of specific forms to update or all forms
  • Ability to specify a semi-colon delimited list of specific fields to update or all matching character/diary/status history fields
  • Two progress bars show displaying progress by the currently processing form and the overall end to end process.
  • Ability to control the speed by way of a delay slider that will slow down or speed up the processing dynamically
  • Ability to pause / resume the processing
  • Ability to cancel in-flight updates (doesn’t not roll back, just stops wherever it happens to be)
  • Ability to toggle on/off the scope/matching capabilities
  • Ability to specify all forms to be checked or a specific form only
  • Ability to ‘simulate’ the run without actually make any changes
  • Detailed output provided on forms processed and matches found

Recommend you test this in a non-production environment and gauge the results prior to running this against a production system.  I also recommend using JRE 1.7 (64-bit) while directly on the AR System server you are connecting to to execute this program for optimum performance.  It will run just fine from any host that can connect to the AR System via API but due to the type of work being done, running this utility on the server itself will increase the throughput considerably and take the network layer out of the equation.

NOTICE:  If you have a very large system (10s or 100s of millions of rows), the initial time to get the entry totals may take awhile before you see the program start to process forms.

NOTICE:  If you begin to see too much performance degradation on your AR System and want to lessen the impact, simply move up the slider bar to introduce delay between processing which will elongate the processing but reduce the load on the system greatly.  You can even pause it during prime business hours to resume it later when there are less users on the system.

If any issues arise, please let me know and I will make adjustments.   You can download the program below

Cheers,

Version 1.1 Released – October 28

  • Added ability to pre-load list of Login IDs to update via file import

Version 1.2 Released – October 28

  • Fixed some visual anomalies
  • Added more detailed output to found matches, you’ll now see all the fields that matched and will be updated

Version 2.0 Released – October 28

  • Reworked the UI to be more efficient and consistent
  • Changed specific form field into menu with pre-loaded remedy forms with auto-fill support
  • Improved how detailed output is generated and provided more consistent information on how many updates per form and what field specifically are update

Version 2.1 Released – October 30

  • Added ability to specify multiple specific forms rather then just one or all
  • Added ability to specify multiple field IDs in a semi-colon (;) delimited list instead of always running against all character/diary/status history fields
  • Added ability to show/collapse Options section while job is running in order to give more real-estate to the detailed output window when needed.
  • Added additional error checking for bad input from user in various sections
  • Small re-factoring and UI fixes

Version 2.2 Released – Nov 18

  • Switched to H2 database for login profiles and lay groundwork for eventual capability of saving configuration profiles for repeatable updates
  • Don’t stop when a form throws an error in the pre-processing phase

Version 2.5

  • Returned to SQLite DB
  • Added ability to specify forms via import file
  • Added debugging capabilities with the -debug option flag
  • Updated User Interface and Libraries

Version 2.6 (yanked – do not use)

  • Faster processing
  • Attempt to fix a bug with some versions of AR System / Customer environment terminating after the first match

Version 2.7

  • Reduced number of API calls to the system considerably for better speed-ups compared to v2.6
  • FIx some outputting errors / ommissions in the display panel
  • Fix corner case where status history was not being updated correctly

 

 

Find String in Fields – Utility

I was recently tasked with how to find all occurrence of a specific string that could exist in any field in any form on a Remedy system.  This poses an interesting challenge and my first gut check for this type of request would be to go-to the database so after some searching, I had found the following which gave me most of the information I was looking for:

http://stackoverflow.com/questions/9185871/how-to-search-sql-server-database-for-string

The above would provide output that would list the T tables and C columns where a match was found which got me part of the way there, would still need to then go search on that form/field to find the entries in question.

So after see this in action, I decided to see what the difference in performance would be to do something similar but using only the Remedy API and came up with the attached program.  It actually ran in about the same amount of time and I can get a bit more detail then the SQL proc gave me.

You can download the program at the bottom of this post and run the program like this:

java -jar FindStringInFields.jar -x <servername> -u <username> -p <password> -t <port> -s <string to search for in doublequotes> -o <name of output file, defaults to output.csv if not set here>

While the program is running, you will be kept up to date on the progress via a progress bar and when completed will tell you how many matches have been found.  After completion, the results will be provided in a CSV style file with formName, fieldName, fieldID and entryID for all found occurrences.

Here is a screenshot of it in action where I search my own local system for server name references:

FindStringInField

Hope this is useful.

Remedy Image Browser – Simple tool for browsing Image Objects

Inspired by an Idea on the BMC Communities by Jason Miller (https://communities.bmc.com/ideas/7609), I put together a very simple Java app that will allow you to log into a target AR System, grab all the Image objects and display them (with image preview in-line) in a table.  Upon selecting an image, it is rendered in full scale to the right of the table.

Here is a screenshot of it in action:

RemedyImageBrowser_small

For those interested, you can download it below

New version of Entry Inspector released – v1.4

Hi Everyone,

Version 1.4 of the Entry Inspector has been released.  Lots of polishing and stabilization on systems with limited memory with a couple of new features worth mentioning which include:

  • Manageable profiles from the login screen
  • Replace capability for Modify/ModifyAll in addition to Overwrite & Append functions

You can grab the latest version always here:  Entry Inspector

As always, if you are interested in a full version that removes the 20 record limit on actions, please click on the buy link below or email me at support@soleauthority.net to arrange payment.

 

Click below to Purchase

(Will re-directed to a PayPal storefront):




Upon check-out, you will receive your key via email in 1-2 business days.  If you have any questions at all pre/post purchase you can reach me at support@soleauthority.net

Cheers,