Nagios Support Forum

Code: Select all

mysql -u <username> -p<password> (no space between -p and password)

Code: Select all

use nagiosql;

Code: Select all

SELECT * FROM tbl_lnkHostToHostgroup;

Code: Select all

SELECT * FROM tbl_lnkHostToHostgroup WHERE idMaster=<host_id>;

Code: Select all

python3 hostgroup_click.py -n drs -H "localhost,u2204ncpa"

localhost was found in 1 of 6 total hostgroups. [linux-servers]
u2204ncpa was found in 3 of 6 total hostgroups. [linux-servers,linux-columbia-mo,linux-servers]

Code: Select all

python.exe hostgroup_click.py -n drs -H "u2204ncpa,localhost" -o

u2204ncpa was found in 2 of 6 total hostgroups. [linux-columbia-mo,linux-servers] Membership for 1 groups is assigned via the u2204ncpa host object config. [dev-linux-web]

localhost was found in 1 of 6 total hostgroups. [linux-servers]

Code: Select all

localhost: total_groups=1;  Membership for 1 group/s is assigned via hostgroup object config/s. [linux-servers]

u2204ncpa: total_groups=3;  Membership for 2 group/s is assigned via hostgroup object config/s. [linux-columbia-mo,linux-servers] Membership for 1 group/s is assigned via host object config/s. [dev-linux-web]

Code: Select all

# First get a list of all the hosts contained in the .cfg files
$NagiosHosts=@()
$FileCnt=(Get-ChildItem .\CNCAAD\Configs\nagios\etc\hosts\).Count
$cnt=1
ForEach ($tmpFile in (Get-ChildItem .\CNCAAD\Configs\nagios\etc\hosts\))
{
    Write-Progress -Activity "Processing Nagios Hosts Files..." -CurrentOperation "$($tmpFile)" -PercentComplete (($cnt / $FileCnt*100))
    $tmpHost=New-Object PSObject -Property @{HostName=$(Get-Content $tmpFile.FullName | FindStr host_name | Where-Object {$_ -notlike "#*"} | Where-Object {($_.SubString($_.IndexOf("host_name"))).TrimStart("host_name").Trim().Split(" ")[0]});
                                             HostGroups=""}
    $NagiosHosts = $NagiosHosts + $tmpHost
    $cnt = $cnt +1
}
Write-Progress -Activity "Complete" -Completed   # This clears the progress bar

# Now search for every host in the hostgroups.cfg to be able to report any hosts not in a group.
$HostCnt=$($NagiosHosts.Count)
$cnt=1
ForEach ($tmpHost in $NagiosHosts)
{
    Write-Progress -Activity "Processing Nagios Hosts..." -CurrentOperation "$($tmpHost.HostName)" -PercentComplete (($cnt / $HostCnt*100))
    $tmpHost.HostGroups=$(Get-Content ".\CNCAAD\Configs\nagios\etc\hostgroups.cfg" | Select-String -Pattern $tmpHost.HostName -Context 2 | FindStr.exe hostgroup_name | ForEach-Object {($_ -split '\s+')[2]}) -join ", "
    $cnt = $cnt +1
}
Write-Progress -Activity "Completed" -Completed   #This clears the progress bar

# Now compare/list any hosts not a member of the "*site*" group.
$MissingSiteGroup = @($NagiosHosts | Where-Object {$_.HostGroups -notlike "*site*"})
[code]

From there you can compare whatever you need based on your group memberships/requirements. I also do a check for OS group membership but your organization is probably different.