lordmilko
commented
6 years ago Hi @mkardos1,
The first thing I did at my current job was write a script that reads a CSV and performs a bulk import of groups and devices, setting the location of each device!
The following provides a sample of how this can be done
Servers.csv
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"AddServers.ps1
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)"
# Add the device using a Host of <hostname>.<domain>
$device = $districtGroup | Add-Device $office.Name "$($office.Name).$env:userdnsdomain".ToLower()
# Set the location
$device | Set-ObjectProperty Location $office.Location
}
}
}
ProcessStates $statesNote how I don't specify -AutoDiscover when adding the device. You'll probably want to perform auto-discoveries by passing the created devices to Start-AutoDiscovery in stages later
while($true) { Get-Device | where TotalSensors -eq 0 | Select -First 5 | Start-Autodiscovery; Sleep 300 }
mkardos1
mbensaid23
Hello lordmilko,
Have you ever tried to make an import of devices into PRTG monitoring? I tried to use auto-discovery using a list of devices, but it adds reachable devices only. I'd like to add a list of devices, where both reachable and unreachable devs are added.
Thanks!