Showing results for 
Search instead for 
Did you mean: 
Create Post

Custom Property Mapper - A tool allow the mapping of CP values based on existing variables within the Orion DB

Custom Property Mapper - A tool allow the mapping of CP values based on existing variables within the Orion DB

Hey Thwacksters,

If you've seen some of my other content here on Thwack, you're probably aware that I'm a bit of a fan of Custom Properties in Orion, and extol their use far and wide (probably too noisily, sometimes!). I have an idea for a new page within Orion. Enter the 'Custom Property Mapper'!

In any given Orion instance I get involved with, I spend a lot of time honing the Custom Properties to the requirements of both the business and the Orion use case. One of the things I end up battling with is how the clients will keep on top of the CP assignments, when I'm no longer working with them. This led to my looking in to SQL update queries, and other methods, but none of them were intuitive to the average user, and certainly not something I could leave for people to carry on with when I'm out the door.

So, what is my idea all about? Well, it's pretty simple. I see it as a way of matching 'Custom Property/Value' with 'Other Orion Field', and have Orion set the relevant CP and value, each time it finds a match. An easy example would be:


Existing VariableValue to MatchCustom Property to AssignValue to assign
Machine TypeWindows 2008 R2 ServerDevice_TypeServer
Machine TypeWindows 7 WorkstationDevice_TypeWorkstation
Application Monitor AssignedAppInsight for ExchangeDevice_RoleExchange MB Server

The above simple example is an idea of what I'm hoping this FR could achieve. With suitable foresight, many common Custom Property assignments could be automated, going forward, minimising ongoing administration of Custom Properties

Whenever a node is added, or a new application template is assigned (for example), this new process could be interrogated, assigning the values as required.

This would not only ensure that alerts and other mechanics that rely on custom properties within you environment will work, for example, it will also mean that you no longer need fear automated Network Discoveries, since you've got your CP assignments mapped out

Level 13

I remember the old Crystal Reports which had tool allowing to link fields from different SQL tables and combine them into one set of data to process on. CPs are table colums so why not to make something like CP mapper

Level 13

This is a really good idea.  I'm hunting for a way to automate as much as possible and this would help tremendously!

Level 17

I currently do this via a SQL "Housekeeping" script...up-voted

Well, I reckon I need to go create 100 new accounts to up vote this some more...

I'd still love to see this some day. Maybe not a small UI fix, but still useful.