{"id":2349,"date":"2015-06-24T18:13:54","date_gmt":"2015-06-24T22:13:54","guid":{"rendered":"http:\/\/batchpatch.com\/?p=2349"},"modified":"2019-10-29T22:55:27","modified_gmt":"2019-10-30T02:55:27","slug":"advanced-script-integration-with-batchpatch-part-2","status":"publish","type":"post","link":"https:\/\/batchpatch.com\/advanced-script-integration-with-batchpatch-part-2","title":{"rendered":"Advanced Script Integration with BatchPatch – Part 2"},"content":{"rendered":"

BatchPatch currently provides functionality for retrieving from target computers the list of services that are set to ‘automatic’ but currently in the ‘stopped’ state. The reason this is valuable\/convenient for most users is because after you reboot computers you frequently want to have a quick way to determine that all of the services that should be running are, in fact, running. <\/p>\n

If a service is set to ‘automatic’ it generally should be running after Windows boots. However, unfortunately there are actually some cases where a service might be set to ‘automatic’ but isn’t always running. In these cases we may or may not actually care about the particular service in question.<\/p>\n

For example, the following services on my computer are currently set to ‘automatic,’ but none of them are actually running at the moment:<\/p>\n\n

Microsoft .NET Framework NGEN v4.0.30319_X86\nMicrosoft .NET Framework NGEN v4.0.30319_X64\nGoogle Update Service (gupdate)\nMultimedia Class Scheduler\nSoftware Protection\nSkype Updater<\/pre><\/td><\/tr><\/table><\/div>\n\n
We have had some customers request the ability to create an exclusion list for the BatchPatch “Get stopped automatic services” action.  The idea here is that you would be able to create a list of services that you don’t really care about, so that when you execute “Get stopped automatic services” it only lists the services that are NOT contained in the exclusion list.  So if a really important ‘automatic’ service, like SQL Server, had not started after rebooting a computer, it would be easier to identify it if it weren’t buried in a list of other services that aren’t started, like the ‘Software Protection’ service, which is usually not started, even though it’s set to ‘automatic.’  We intend to provide this functionality in a future version of BatchPatch (EDIT: The feature was added 2015-07-22 and is available under ‘Tools > Settings > General > Exclusions list’)<\/strong>.  However, in the meantime while you are waiting for it, there is actually a very easy way to accomplish the same task in the current version of BatchPatch.<\/p>\n
Sample script:<\/h3>\n
Download StoppedAutoServices.vbs<\/a><\/p>\n\n
1\n2\n3\n4\n5\n6\n7\n8\n9\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n34\n35\n36\n37\n38\n39\n40\n<\/pre><\/td>
'Gets the list of services on a computer that are set to automatic and stopped but do not exist in the script's hardcoded list: arrayServiceExclusions.  Cocobolo Software, LLC June 2015\n<\/span>\n'usage: cscript.exe StoppedAutoServices.vbs COMPUTERNAME\n<\/span>\n'the first argument from the command line is assigned to strComputer\n<\/span>strComputer = WScript.Arguments(0)\n \n'create an array containing the list of service display names to exclude from the check for stopped automatic services.\n<\/span>arrayServiceExclusions = Array("Microsoft .NET Framework NGEN v4.0.30319_X86"<\/span>,"Microsoft .NET Framework NGEN v4.0.30319_X64"<\/span>,"Google Update Service (gupdate)"<\/span>,"Multimedia Class Scheduler"<\/span>,"Software Protection"<\/span>,"Skype Updater"<\/span>)\nstrStoppedAutoServicesList = ""<\/span>\nintCounter = 0\n \non<\/span> error<\/span> resume<\/span> next<\/span>\nErr.Clear\n \nSet<\/span> objWMIService = GetObject<\/span>("winmgmts:\\\\"<\/span> & strComputer & "\\root\\cimv2"<\/span>)\n \n'Get list of running services\n<\/span>Set<\/span> colService = objWMIService.ExecQuery("Select * from Win32_Service"<\/span>)\n\t\tFor<\/span> Each<\/span> objService in<\/span> colService\n\t\t\tIf<\/span> ((objService.StartMode = "Auto"<\/span>) And<\/span> (objService.State = "Stopped"<\/span>)) Then<\/span>\n\t\t\t\tboolIsServiceContainedInList = 0\n\t\t\t\t'loop through our hardcoded list and compare\n<\/span>\t\t\t\tFor<\/span> Each<\/span> strServiceName in<\/span> arrayServiceExclusions\n\t\t\t\t\tIf<\/span> objService.DisplayName = strServiceName Then<\/span>\n\t\t\t\t\t\tboolIsServiceContainedInList = 1\n\t\t\t\t\tEnd<\/span> If<\/span>\n\t\t\t\tNext<\/span>\n\t\t\t\t'if a service is set to automatic and in the stopped state and NOT contained in our hardcoded list, then add it to our final report and increment the counter\n<\/span>\t\t\t\tIf<\/span> boolIsServiceContainedInList = 0 Then<\/span>\n\t\t\t\t\tstrStoppedAutoServicesList = strStoppedAutoServicesList & vbLf & objService.DisplayName\n\t\t\t\t\tintCounter = intCounter + 1\n\t\t\t\tEnd<\/span> If<\/span>\n\t\t\tEnd<\/span> If<\/span>\n\t\tNext<\/span>\n \n'write the results list to the console\n<\/span>WScript.Echo strStoppedAutoServicesList\n'exit the script with the return value as the number of items in our list\n<\/span>Wscript.Quit(intCounter)<\/pre><\/td><\/tr><\/table><\/div>\n\n
To integrate the StoppedAutoServices.vbs script into BatchPatch:<\/h3>\n
    \n
  1. Create a ‘Local process\/command’ in BatchPatch.  Select Actions > Execute local process\/command > Create\/modify local commands<\/em><\/strong>.
    \n\"2015-04-27<\/a><\/li>\n
  2. Add the StoppedAutoService.vbs script to the grid.
    \n    \"2015-06-24<\/a>  Note, we use $computer<\/em><\/strong> as a parameter in the cscript.exe command.  This tells BatchPatch to send the host name from the row that executes the script.  This is what allows us to execute a script locally on the computer running BatchPatch to retrieve information from a remote computer.\n<\/li>\n
    <\/p>\n
  3. Now we’re ready to execute the script.  For the sake of this example, I have removed all but ‘Software Protection’ from the exclusion list hardcoded into the script as arrayServiceExclusions.  The reason for this is to demonstrate what the output looks like when some ‘automatic’ services are found in the ‘stopped’ state.  However, we will not see ‘Software Protection’ appear in our output since it remains in the arrayServiceExclusions.  Highlight the target computers in the grid and then select Actions > Execute local process\/command > Execute saved local commands > Get Stopped Automatic Services<\/em><\/strong>
    \n    \"ExecuteLocalCommandGetStoppedAutoServices\"<\/a>\n<\/li>\n
  4. When the script completes a couple of seconds later, we can see that the ‘Exit Code’ value in the ‘All Messages’ column is equal to the number of stopped automatic services that were found, excluding (of course) the items hardcoded into the script arrayServiceExclusions, which in this instance was only ‘Software Protection.’  In the screenshot below I have revealed the cell contents for the first row, and we can see the 4 services that were found.  If a machine is clear and no stopped automatic services are found, then the Exit Code will be 0, indicating that we do not need to further examine that computer.
    \n    \"ExecuteLocalCommandGetStoppedAutoServices_Result\"<\/a>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
    BatchPatch currently provides functionality for retrieving from target computers the list of services that are set to ‘automatic’ but currently in the ‘stopped’ state. The reason this is valuable\/convenient for most users is because after you reboot computers you frequently want to have a quick way to determine that all of the services that should […]<\/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":[32,128],"class_list":["post-2349","post","type-post","status-publish","format-standard","hentry","category-blog","category-general","category-tutorials","tag-automatic-services","tag-remote-script-execution"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts\/2349","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=2349"}],"version-history":[{"count":10,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts\/2349\/revisions"}],"predecessor-version":[{"id":4933,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts\/2349\/revisions\/4933"}],"wp:attachment":[{"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/media?parent=2349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/categories?post=2349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/tags?post=2349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}