Add groups and devices using a CSV file

Hi HenkHill,

For reference, you can currently do this fairly easily in PowerShell with PrtgAPI

For example, given the file Servers.csv with the following contents

Name,State,District,Location
NY-NEWYORK,New York,NY1,"23 Fleet Street, New York, New York, USA"
NY-QUEENS,New York,NY1,"48 Queen Street, Queens, New York, USA"
NY-BRONX,New York,NY2,"35 West Street, The Bronx, New York, USA"
IL-CHICAGO,Illinois,IL1,"42 South Street, Chicago, Illinois, USA"

where

• You have separate probes for "New York" and "Illinois"
• "NY1", "NY2" and "IL1" districts you wish to create groups for, and
• "NY-NEWYORK", "NY-QUEENS", "NY-BRONX" and "IL-CHICAGO" are devices within each district

you can import this hierarchy by creating a file AddServers.ps1 containing the following code

if(!(Get-PrtgClient))
{
    Connect-PrtgServer prtg.contoso.local
}

# Import the CSV
$csv = Import-Csv $PSScriptRoot\Servers.csv

# Group each record by its State
$states = $csv | group State

function ProcessStates($states) {

    foreach($state in $states)
    {
        Write-Host "Processing state $($state.Name)"

        # Get this state's PRTG Probe
        $probe = Get-Probe $state.Name

        if(!$probe)
        {
            throw "Could not find probe '$($state.Name)'"
        }

        # Group each record in this state by its District
        $districts = $state.Group | group District

        ProcessDistricts $probe $districts
    }
}

function ProcessDistricts($probe, $districts) {

    foreach($district in $districts)
    {
        Write-Host "   Processing district $($district.Name)"

        # Get this district's PRTG Group
        $districtGroup = $probe | Get-Group $district.Name

        if(!$districtGroup)
        {
            # If no such group exists, create one
            $districtGroup = $probe | Add-Group $district.Name
        }

        ProcessOffices $district $districtGroup
    }
}

function ProcessOffices($district, $districtGroup) {

    foreach($office in $district.Group)
    {
        # Get this office's server
        $device = $districtGroup | Get-Device $office.Name

        if(!$device)
        {
            Write-Host "      Adding device $($office.Name)"

            $fqdn = "$($office.Name).$env:userdnsdomain".ToLower()

            # Add the device using a Host of <hostname>.<domain>
            $device = $districtGroup | Add-Device $office.Name $fqdn

            # Set the location
            $device | Set-ObjectProperty Location $office.Location
        }
    }
}

ProcessStates $states

This can then be used as the basis for developing your own scripts (for example, retrieving existing objects by ID, deciding whether to specify -AutoDiscover to the Add-Device cmdlet, or perhaps later on perform a detailed or template based auto-discovery using the Start-AutoDiscovery cmdlet

For more information on using PrtgAPI please see the wiki

Regards,

lordmilko