Skip to main content
Solved

Worklet to pull device patching logs stopped working with error

  • April 19, 2022
  • 1 reply
  • 238 views

Forum|alt.badge.img

Hello!
I have a worklet that has been running weekly for months with no issue, the worklet essentially grabs patching logs from each device in Automox and exports them all to a CSV. I noticed on around January 18th of 2022 that the script started reporting nothing so I ran the code locally and am getting an error:
 

Invoke-RestMethod : The request was aborted: Could not create SSL/TLS secure channel.
At line:11 char:13
+ $response = Invoke-RestMethod $apiUrl -Method 'GET' -Headers $headers ...
+             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebExc
   eption
    + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand

I know Automox has the limitation of no more than 500 results when pulling from the API, but I am well under half that. Here is the full script for context:

#Set Execution policy to allow for 3rd party modules
Set-ExecutionPolicy Unrestricted -Force

#Define API Key and URL to get initial Machine list
$apiKey = "APIKEY"
$apiUrl = "https://console.automox.com/api/servers/"
$headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$headers.Add("Authorization", "Bearer $apiKey")
#$headers.Add("Cookie", "ax_session=CENSORED")

$response = Invoke-RestMethod $apiUrl -Method 'GET' -Headers $headers -Body $body
$response | ConvertTo-Json

$time = (Get-Date).ToString("yyyy-MM-dd-HH")
Export-Csv "C:\Automox_Patch_Exports\Patch_Export_$((Get-Date).ToString("yyyy-MM-dd-HH")).csv" -NoTypeInformation

$name = $server.name;

#For each machine get the patch info according to machine ID and Org.
foreach($server in $response){
    #Define Server ID, Org ID, and Group ID.
    $id = $server.id
    $organization_id = $server.organization_id
    $server_group_id = $server.server_group_id

    $apiUrl = "https://console.automox.com/api/servers/$($id)/packages?o=$($organization_id)"
    $response = Invoke-RestMethod $apiUrl -Method 'GET' -Headers $headers -Body $body
    #Define which objects you want to be included in the CSV. See (Under "Response") for full list:	https://docs.automox.com/api/endpoints/list-software-packages-for-a-device
    $DesiredProperties = $response | Select-Object $server.name, installed, create_time, display_name, package_id, software_id, cve_score
    #Add the information to the CSV.
    $DesiredProperties | ConvertTo-Csv -NoTypeInformation | Add-Content -Path "C:\Automox_Patch_Exports\Patch_Export_$time.csv"
}

Tried researching the specific error, but was not able to come up with much so wanted to check with Automox while I kept troubleshooting on my own.

Thanks in advance for any tips :)
 

Best answer by JHagstrom

Solved the issue. Was something firewall related.
 

View original
How helpful was this post to you?

1 reply

Forum|alt.badge.img
  • Author
  • Pro
  • 27 replies
  • Answer
  • April 20, 2022

Solved the issue. Was something firewall related.
 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings