Automated Change Control From Insight

[Andrew Downs]

Hi all,

i am wondering if you can help me. I have an insight object schema called Servers. 

Under Servers I have about 700 systems that I would like to automate patch changes for on a weekly / monthly basis. I would like to group these changes based on the following fields:

Business Unit

Patch Day

Patch Time

As an example:

SERVER A is assigned to Business Unit 1 with a patch day of Tuesday and a Patch Time of 8AM - 11:59PM (8AM - 11:59PM is a string value)

SERVER B is assigned to Business Unit 2 with a patch day of Thursday and a Patch Time of 8PM - 10PM (8AM - 10PM is a string value)

i am not sure how I can get this working. I am busy doing the following with powershell but not sure if is optimal:

1) Call the JIRA insight api and return all business units from the Business Unit Schema

2) Do a for each loop with results from business unit and do another API call to patch day schema

3) Do a for each loop on patch day schema and do yet another call to API call to Patch Time schema

4) Do another for each loop on Patch Time and build a iql query that would search objectType =“Servers” AND Status = “Active” AND “Business Unit” = “$($bu)” AND “Patch Day” = “$(“$patchDay”) AND “Patch Time” = “$(“$patchTime”)

5) from there I do yet another call to the JIRA API doing to IQL search. That is about how far I am, but it really does not seem optimal. 

once I get the results from the last query I am working on building to json I need to push to JIRA to get it to create the change control. Is this the correct approach? The servers do need to be linked to a custom field that is associated with the Change Control type. 

hope that all makes sense.