Last week I was working on private cloud solution that included around 50 runbooks. In the end of the development phase we needed to make sure all runbooks was following best\u00c2\u00a0practices, including naming convention and design standard. For example all links between activities that had a name including “IF” should be updated to orange color, and all runbooks named “Link” should be updated to green color. As we had a lot of runbooks I was thinking about a quick way to updated them all, instead of manually updating each link. We also wanted to update some activity names based on the configuration.<\/p>\n
The answer was a couple of SQL queries<\/p>\n
To update all non-deleted (Deleted = 0) runbooks that have black (default) color and named Link (default) to green link color<\/p>\n
Update LINKS SET Color=’65280′ WHERE Color = ‘0’ AND UniqueID IN (select uniqueID from OBJECTS WHERE ObjectType = ‘7A65BD17-9532-4D07-A6DA-E0F89FA0203E’ AND Name = ‘Link’ AND Deleted = ‘0’)<\/p><\/blockquote>\n
As you can see we set the color to 65280,<\/p>\n
\n
- Green is 65280<\/span><\/li>\n
- Black is 0<\/li>\n
- Red is 255<\/li>\n
- Orange is 4227327<\/li>\n<\/ul>\n
To updated all non-deleted links that have name that contains “warning” to red link color, run<\/p>\n
Update LINKS SET Color=’255′ WHERE Color = ‘0’ AND UniqueID IN (select uniqueID from OBJECTS WHERE ObjectType = ‘7A65BD17-9532-4D07-A6DA-E0F89FA0203E’ AND Name like ‘%Warning%’ AND Deleted = ‘0’)<\/p><\/blockquote>\n
If you want to update link width for all links named “Link” you can run the following query<\/p>\n
Update LINKS SET Width=’3′ WHERE UniqueID IN (select uniqueID from OBJECTS WHERE ObjectType = ‘7A65BD17-9532-4D07-A6DA-E0F89FA0203E’ AND Name = ‘Link’ AND Deleted = ‘0’)<\/p><\/blockquote>\n
If you want to update all Invoke Runbook activities with a name starting with “Invoke”, and set the name to the runbook it invoke you can run the following query<\/p>\n
UPDATE OBJECTS
\nSET objects.Name = TRIGGER_POLICY.PolicyPath
\nFROM OBJECTS, TRIGGER_POLICY
\nWHERE objects.UniqueID = TRIGGER_POLICY.UniqueID
\nAND objects.name LIKE ‘INVOKE%’ AND Deleted = ‘0’
\nGO<\/p><\/blockquote>\nYou\u00c2\u00a0don’t\u00c2\u00a0need to checkout your runbook to \u00c2\u00a0apply the modification, just refresh the console after the update.<\/p>\n
<\/p>\n
Please note that is\u00c2\u00a0unsupported<\/span> as we modify settings in the database direct.\u00c2\u00a0This is provided \u00e2\u20ac\u0153AS-IS\u00e2\u20ac\u009d with no warranties at all. This is not a solution for your production environment, just a idea and an example.<\/p>\n","protected":false},"excerpt":{"rendered":"
Last week I was working on private cloud solution that included around 50 runbooks. In the end of the development phase we needed to make sure all runbooks was following best\u00c2\u00a0practices, including naming convention and design standard. For example all links between activities that had a name including “IF” should be updated to orange color, … Continue reading