Disconnected Devices Cleanup Using the Console or PowerShell or Python

#    [-------------------------------------DISCLAIMER-------------------------------------]
#    This script is provided as-is with no implicit
#     warranty or support. It's always considered a best practice
#     to test scripts in a DEV/TEST environment, before running them
#     in production.
#     Please proceed with caution.
#     Do not distribute your API Key to any untrusted 3rd party.
#    [-------------------------------------DISCLAIMER-------------------------------------]

#     The SETUP section gets your API return and is not specific to any particular use-case.
#     The OPERATIONAL section is specific to one scenario and can be overhauled for your specific uses.

############################# SETUP Section #############################

#modify log path as desired
$logPath = 'C:\temp\'

#Easier to maintain, especially if multiple organizations, or for repurposing for different API Tables
$apiInstance = 'https://console.automox.com/api/'
$apiTable = 'servers'

#replace the two variables below with your Org ID and your API key
$orgID = 'YOUR_ORG_ID'
$apiKey = 'YOUR_API_KEY'
$orgAndKey = "?o=$orgID&api_key=$apiKey"

#Number of days disconnected before deleting - adjust to your desired range
$maxDays = 120
#optional query to filter, if the whole server list is too long, you could add the date filter here
$query = ''

#initialize empty arrays to store server IDs to be deleted
$toDelete = @()
$failDelete = @()
$successDelete = @()

#put components together
$getURI = $apiInstance + $apiTable + $orgAndKey + $query

#Get the json body of the Web Request
$jsonReturn = (Invoke-WebRequest -UseBasicParsing -Method Get -Uri $getURI).Content

#Convert to object with manipulatable properties/values
$servers = $jsonReturn | ConvertFrom-Json

#Export to C

############################# END Setup Section #############################


############################# OPERATIONAL Section #############################

#Check each server for checkin time, conditionally take action
foreach ($server in $servers) {
    #pull out wanted details
    $serverID = $server.id
    $serverName = $server.name

    #check to make sure last_disconnect_time isn't null, which it will be for currently connected devices, in which case the lastcheckin variable will be set to today's date
    $lastCheckin = Get-Date
    if ($server.last_disconnect_time) {
        $lastCheckin = [datetime]$server.last_disconnect_time
        }

    #Calculate time since last checking to now
    $span = New-TimeSpan -Start $lastCheckin

    #uncomment line below if you want to see all the servers with their last disconnect time and number of days disconnected for troubleshooting
    #echo "device: $serverName `t last disconnected date: $lastCheckin `t days disconnected: $span.Days"

    if ($span.Days -ge $maxDays) {
        #Delete or data collection code here

        #Delete method takes serverID only

        #Hardcoded would look like this $delURI = https://console.automox.com/api/servers/$serverID?o=YOUR_ORG_ID&api_key=YOUR_API_KEY

        $toDelete += @{"ServerName"=$serverName;"ServerID"=$serverID;"last_disconnect_time"=$lastCheckin}
        $delURI = $apiInstance + $apiTable + '/' + $serverID + $orgAndKey

        #Attempt to delete and track failures
        try {
            $delResponse = Invoke-WebRequest -UseBasicParsing -Method Delete -Uri $delURI
            Write-Output "Successfully Deleted Server: $serverName"
            $successDelete += @{"ServerName"=$serverName;"ServerID"=$serverID;"last_disconnectn_time"=$lastCheckin}
        }
        catch {
            $failDelete += @{"ServerName"=$serverName;"ServerID"=$serverID;"last_disconnect_time"=$lastCheckin}
            Write-Output "Failed to Delete Server: $serverName"
        }
    }
    #Output logging into json files for later review/manipulation
    $toDelete | ConvertTo-Json | Out-File $logPath\ToBeDeleted.json
    $successDelete | ConvertTo-Json | Out-File $logPath\Delete_Success.json
    $failDelete | ConvertTo-Json | Out-File $logPath\Delete_Failed.json
}

#    [-------------------------------------DISCLAIMER-------------------------------------]
#    This script is provided as-is with no implicit
#     warranty or support. It's always considered a best practice
#     to test scripts in a DEV/TEST environment, before running them
#     in production.
#     Please proceed with caution.
#     Do not distribute your API Key to any untrusted 3rd party.
#    [-------------------------------------DISCLAIMER-------------------------------------]
#
import requests
from datetime import datetime, timedelta

url = 'https://console.automox.com/api/servers'

# START Configurable Items
# User enters API key
api_key = input("Please enter your Automox API key: ")

# User enters org ID
while True:
    try:
        org_id = int(input("Please enter the org ID: "))
    # Cycle repeats until an integer value is entered for org ID
    except ValueError:
        print("The value you have entered is not an integer. Please enter an integer for org ID.")
    else:
        break

# User enters max_days
while True:
    try:
        max_days = int(input("Please enter the maximum number of days disconnected before deleting: "))
    # Cycle repeats until an integer value is entered for max_days
    except ValueError:
        print("The value entered is not an integer. Please enter an integer for max days.")
    else:
        break
# END Configurable Items

# Calculate Cutoff Date
cutoff_date = datetime.now() - timedelta(days=max_days)

# Prepare the query
query = {
    "o": org_id,
    "limit": 500,
    "page": 0,
}

headers = {
    "Content-Type": "application/json",
    "Authorization": "Bearer " + api_key
}

# Submit the query
get_response = requests.get(url, headers=headers, params=query)

# Get user input
while True:
    try:
        dry_run = bool(input('Dry run? True/False: '))

    except ValueError:
        # The cycle repeats until the user enters True or False
        print("Error! You have not entered a Boolean value. Please try again.")

    else:
        break

# Do a dry run, display list of devices to be deleted without actually deleting them
if dry_run is True:
    # Iterate through devices
    for device in get_response.json():
        # Filter out connected devices
        if device['last_disconnect_time'] is not None:
            # Reformat the last disconnected date
            last_disconnect_date = datetime.strptime(device['last_disconnect_time'].split("+")[0], "%Y-%m-%dT%H:%M:%S")
            # If device has been disconnected before the cutoff date, include it in the list
            if datetime.date(last_disconnect_date) < datetime.date(cutoff_date):
                print("Device " + str(device['name']) + " with Device ID " + str(device['id']) + " will be deleted.")
                del_url = url + "/" + str(device['id'])
                query = {
                    "o": org_id
                }

# Live run - displays list of devices to be deleted, and then actually deletes those devices
if dry_run is False:
    # Iterate through devices
    for device in get_response.json():
        # Filter out connected devices
        if device['last_disconnect_time'] is not None:
            # Reformat the last disconnected date
            last_disconnect_date = datetime.strptime(device['last_disconnect_time'].split("+")[0], "%Y-%m-%dT%H:%M:%S")
            # If device has been disconnected before the cutoff date, include it in the list and delete it
            if datetime.date(last_disconnect_date) < datetime.date(cutoff_date):
                print("Device " + str(device['name']) + " with Device ID " + str(device['id']) + " will be deleted.")
                del_url = url + "/" + str(device['id'])
                query = {
                    "o": org_id
                }
                print("Deleting devices...")
                del_response = requests.delete(del_url, headers=headers, params=query)