{"id":3961,"date":"2018-02-16T17:52:35","date_gmt":"2018-02-16T22:52:35","guid":{"rendered":"http:\/\/batchpatch.com\/?p=3961"},"modified":"2018-02-16T17:52:55","modified_gmt":"2018-02-16T22:52:55","slug":"advanced-multi-row-queue-sequence-contingent-operations-with-custom-scripts","status":"publish","type":"post","link":"https:\/\/batchpatch.com\/advanced-multi-row-queue-sequence-contingent-operations-with-custom-scripts","title":{"rendered":"Advanced Multi-Row Queue Sequence – Contingent Operations with Custom Scripts"},"content":{"rendered":"

Today the goal is to tie together some concepts that I’ve written about in the past in order to demonstrate how you can use the Advanced Multi-Row Queue Sequence to execute certain actions on some hosts with a contingency that something must be true on another host before the additional hosts begin operations. <\/p>\n

The Plan<\/a><\/h2>\n

Here is the overall picture of what we’re going to do:<\/p>\n

Host1:<\/strong>
\n1. Check if there is enough disk space. If the available disk space is less than a desired threshold, then stop executing the multi-row queue sequence. If there is enough disk space available, then go on to the next step.<\/p>\n

2. Stop a specific service. If this action fails, stop executing the multi-row queue sequence. If it completes, then move on to the next step.<\/p>\n

3. Set the service to manual. If this action fails, stop executing the multi-row queue sequence. If it completes, then move on to the next step.<\/p>\n

4. Install Windows Updates and reboot.<\/p>\n

5. Start the stopped service. If this action fails, stop executing the multi-row queue sequence. If it completes, then move on to the next step.<\/p>\n

6. Set the service back to automatic. If this action fails, stop executing the multi-row queue sequence. If it completes, then move on to the next step.<\/p>\n

7. Only after all previous actions are complete should the next two hosts begin their operations.<\/p>\n

Host2:<\/strong>
\n1. Check if there is enough disk space. If the available disk space is less than a desired threshold, terminate the queue for this host only, but still proceed with the rest of the multi-row queue sequence for Host3.<\/p>\n

2. Deploy Firefox<\/p>\n

Host3:<\/strong>
\n1. Run a custom script<\/p>\n

<\/p>\n

\n

<\/p>\n

Scripts<\/h2>\n

In all cases with these scripts we return 0 for success and a non-zero integer (1) for failure. This enables us to use the job queue special items for ‘Terminate queue if previous actions fails\/errors’ and ‘Abort advanced multi-row sequence if previous action fails\/errors’. If the script returns 1, then those special items will consider it failed and will abort\/terminate. If the script returns 0, those items will consider it successful and move on to the next step in the queue.<\/p>\n

GetCDriveSpace.vbs<\/strong><\/p>\n\n

'Gets the free space on C drive.  If free space is less than specified threshold return 1. Else return 0.  \n<\/span>'Cocobolo Software LLC April 2017.\n<\/span> \non<\/span> error<\/span> resume<\/span> next<\/span>\nErr.Clear\n \nDim<\/span> freeMB\nConst MBCONVERSION = 1048576\n \nSet<\/span> objWMIService = GetObject<\/span>("winmgmts:\\\\localhost\\root\\cimv2"<\/span>)\n \n'Get C drive space\n<\/span>Set<\/span> colLogicalDisk = objWMIService.ExecQuery("Select * from Win32_LogicalDisk"<\/span>)\n\t\tFor<\/span> Each<\/span> objLogicalDisk in<\/span> colLogicalDisk\n\t\t\tIf<\/span> objLogicalDisk.DeviceId = "C:"<\/span> Then<\/span>\t\t\t\t\t\n\t\t\t\tfreeMB = objLogicalDisk.freespace\/MBCONVERSION\n\t\t\tEnd<\/span> If<\/span>\n\t\tNext<\/span>\n \nIf<\/span> freeMB < 500 Then<\/span>\n\twscript.quit(1)\nElse<\/span>\n\twscript.quit(0)\nEnd<\/span> If<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n
\nStopService.vbs<\/strong><\/p>\n\n
'Stops the specified service and returns 0 if successful else returns non-0\n<\/span>'Cocobolo Software LLC February 2018.\n<\/span>\n'Usage: cscript.exe "C:\\Your Script Repository\\StopService.vbs" "Your service display name goes here"\n<\/span>\n'The first argument from the command line is assigned to strServiceDisplayName\n<\/span>strServiceDisplayName = WScript.Arguments(0)\n \non<\/span> error<\/span> resume<\/span> next<\/span>\nErr.Clear\n \nSet<\/span> objWMIService = GetObject<\/span>("winmgmts:\\\\localhost\\root\\cimv2"<\/span>)\n \nSet<\/span> colServices = objWMIService.ExecQuery("Select * from Win32_Service where DisplayName='"<\/span> & strServiceDisplayName & "'"<\/span>)\n\tFor<\/span> Each<\/span> objService in<\/span> colServices\n\t\tReturnValue = objService.StopService()\n\t\t\twscript.quit(ReturnValue)\t\t\t\n\tNext<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n
\nStartService.vbs<\/strong><\/p>\n\n
'Starts the specified service and returns 0 if successful else returns non-0\n<\/span>'Cocobolo Software LLC February 2018.\n<\/span>\n'Usage: cscript.exe "C:\\Your Script Repository\\StartService.vbs" "Your service display name goes here"\n<\/span>\n'The first argument from the command line is assigned to strServiceDisplayName\n<\/span>strServiceDisplayName = WScript.Arguments(0)\n \non<\/span> error<\/span> resume<\/span> next<\/span>\nErr.Clear\n \nSet<\/span> objWMIService = GetObject<\/span>("winmgmts:\\\\localhost\\root\\cimv2"<\/span>)\n \nSet<\/span> colServices = objWMIService.ExecQuery("Select * from Win32_Service where DisplayName='"<\/span> & strServiceDisplayName & "'"<\/span>)\n\tFor<\/span> Each<\/span> objService in<\/span> colServices\n\t\tReturnValue = objService.StartService()\n\t\t\twscript.quit(ReturnValue)\t\t\t\n\tNext<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n
\nSetServiceToManual.vbs<\/strong><\/p>\n\n
'Sets the specified service to manual and returns 0 if successful else returns non-0\n<\/span>'Cocobolo Software LLC February 2018.\n<\/span>\n'Usage: cscript.exe "C:\\Your Script Repository\\SetServiceToManual.vbs" "Your service display name goes here"\n<\/span>\n'The first argument from the command line is assigned to strServiceDisplayName\n<\/span>strServiceDisplayName = WScript.Arguments(0)\n \non<\/span> error<\/span> resume<\/span> next<\/span>\nErr.Clear\n \nSet<\/span> objWMIService = GetObject<\/span>("winmgmts:\\\\localhost\\root\\cimv2"<\/span>)\n \nSet<\/span> colServices = objWMIService.ExecQuery("Select * from Win32_Service where DisplayName='"<\/span> & strServiceDisplayName & "'"<\/span>)\n\tFor<\/span> Each<\/span> objService in<\/span> colServices\n\t\tReturnValue = objService.ChangeStartMode("manual"<\/span>)\n\t\t\twscript.quit(ReturnValue)\t\t\t\n\tNext<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n
\nSetServiceToAutomatic.vbs<\/strong><\/p>\n\n
'Sets the specified service to automatic and returns 0 if successful else returns non-0\n<\/span>'Cocobolo Software LLC February 2018.\n<\/span>\n'Usage: cscript.exe "C:\\Your Script Repository\\SetServiceToAutomatic.vbs" "Your service display name goes here"\n<\/span>\n'The first argument from the command line is assigned to strServiceDisplayName\n<\/span>strServiceDisplayName = WScript.Arguments(0)\n \non<\/span> error<\/span> resume<\/span> next<\/span>\nErr.Clear\n \nSet<\/span> objWMIService = GetObject<\/span>("winmgmts:\\\\localhost\\root\\cimv2"<\/span>)\n \nSet<\/span> colServices = objWMIService.ExecQuery("Select * from Win32_Service where DisplayName='"<\/span> & strServiceDisplayName & "'"<\/span>)\n\tFor<\/span> Each<\/span> objService in<\/span> colServices\n\t\tReturnValue = objService.ChangeStartMode("automatic"<\/span>)\n\t\t\twscript.quit(ReturnValue)\t\t\t\n\tNext<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n
<\/p>\n
Create Custom Script Deployments<\/h2>\n
For each script file we need to create a deployment in BatchPatch.  I have all of my scripts in a single folder on my BatchPatch computer.<\/p>\n
\"\"<\/a><\/p>\n
Select ‘Actions > Deploy > Create\/modify’<\/em>, and then for each script create a deployment that looks like the following screenshots, and save those deployments using the double-right-arrow button.  Note, the DiskCheck.vbs deployment has no parameters, but each of the other deployments has the desired service name as its only parameter:<\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
Create Job Queue For Each Host<\/h2>\n
Before we create the Advanced Multi-Row Queue Sequence we have to create a job queue for each host.  The job queue will be the step by step list of operations that we want each host to execute inside of the advanced multi-row queue sequence.  <\/p>\n
Select ‘Actions > Job Queue > Create \/ modify’<\/em> and then create the following job queues for each host.  You can ‘apply queue’ to each host\/row accordingly:<\/p>\n
Host1<\/strong>
\n\"\"<\/a><\/p>\n
Host2<\/strong>
\n\"\"<\/a><\/p>\n
Host3<\/strong>
\n\"\"<\/a><\/p>\n
Note, for the places where we want to abort the entire multi-row queue sequence if the previous action fails\/errors, we always add that special item right before the ‘terminate queue if previous action fails\/errors’ because if we terminated the queue first, then the queu would not be running and could therefore not execute the command to abort the entire multi row queue sequence.  However, in the case of Host2, we want to *only* terminate the queue if the previous action fails\/errors, but we do not want to abort the entire multi-row queue sequence.<\/p>\n
Assembling the Advanced Multi-Row Queue Sequence<\/h2>\n
Finally we will create our sequence.  I’ve gone ahead and added a new row to the grid called ‘SequenceExecutionRow’ which is essentially a dummy row that is used just for the multi-row queue sequence.<\/p>\n
\"\"<\/a><\/p>\n
    \n
  1. \nWith that special row selected, choose ‘Actions > Job Queue > Create \/ modify advanced multi-row queue sequence’<\/em><\/li>\n
  2. In the window that appears enter a Sequence Name and select the radio button for ‘Create Sequence Execution Row’, and apply it to the SequenceExecutionRow
    \n    \"\"<\/a>\n<\/li>\n
  3. Next highlight Host1 and choose the radio button ‘Set Sequence Position Number’ with a value of 1.
    \n    \"\"<\/a>\n<\/li>\n
  4. Do the same with Host2 and Host3.
    \n    \"\"<\/a>\n<\/li>\n
  5. Finally we are ready to execute the sequence.  Highlight the SequenceExecutionRow and select ‘Actions > Job Queue > Execute advanced multi-row queue sequence.
    \n    \"\"<\/a>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
    Today the goal is to tie together some concepts that I’ve written about in the past in order to demonstrate how you can use the Advanced Multi-Row Queue Sequence to execute certain actions on some hosts with a contingency that something must be true on another host before the additional hosts begin operations. The Plan […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1,17,3],"tags":[293,238,294,129,99,100],"class_list":["post-3961","post","type-post","status-publish","format-standard","hentry","category-blog","category-general","category-tutorials","tag-advanced-multi-row-queue-sequence","tag-advanced-scripting","tag-contingent-operations","tag-custom-scripting","tag-job-queue","tag-multi-step-execution"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts\/3961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/comments?post=3961"}],"version-history":[{"count":6,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts\/3961\/revisions"}],"predecessor-version":[{"id":3982,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts\/3961\/revisions\/3982"}],"wp:attachment":[{"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/media?parent=3961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/categories?post=3961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/tags?post=3961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}