Support for Nagios products and services
https://support.nagios.com/forum/
Hey @gregbeyer
There may theoretically be a way to get this to work in the gui but it definitely isn't the most user friendly and intuitive. If you go to the scheduled downtime page there is the ability to set the amount viewed in page to no limit. That being said this needs to be improved on as it worked once and other times it gave an endless buffering icon. You can give it a try and see if it will load for you and if it does click the checkbox to select all in the top and endlessly scroll to the bottom for the option to select remove in the with selected option. Not perfect but worth giving a shot.gregbeyer wrote: ↑Wed Jul 24, 2024 9:01 am This is a one-off downtime. However, as we have thousands of hosts, and 4-6 checks per host, the downtime scheduler created 60K downtime records. No way to (reasonably) delete those using the check and delete method. So if there's not a UI method, the only hope is an SQL query to do so.
I think some way to mass delete needs prioritization for development. It's only been a known need since 2014.
Code: Select all
##NAGIOSXI GENERIC API CALL
def nagiosxiGenericAPI(resource,endpoint,modifier,method,myurl,mykey):
#AND THEN A MIRICAL HAPPENS
# ~tobtieker
url = ("https://{turl}/nagiosxi/api/v1/{resource}/{endpoint}?{modifier}&apikey={akey}".format(turl=myurl,akey=mykey,resource=resource,endpoint=endpoint,modifier=modifier))
#GET
if method == "get":
try:
r = requests.get(url=url,verify=False)
except Exception as e:
print.error("%s",e)
r = False
elif method == "post":
try:
r = requests.post(url=url,verify=False)
except Exception as e:
print.error("%s",e)
r = False
elif method == "put":
try:
r = requests.put(url=url,verify=False)
except Exception as e:
print.error("%s",e)
r = False
elif method == "delete":
try:
r = requests.delete(url=url,verify=False)
except Exception as e:
print.error("%s",e)
r = False
else:
print.error("%s","NO METHOD PROVIDED")
r = False
return r
Code: Select all
#COUNT IT
ic = 0
#API RESULTS
items = r.json()
#MAKE A CSV
mycsv = open('yourfile.csv','w',newline='',encoding='utf-8')
csv_writer = csv.writer(mycsv)
#WRITE OUR DOWNTIME RESULTS INTO THE CSV
for i in item['scheduleddowntime']:
if ic == 0:
header = i.keys()
csv_writer.writerow(header)
ic+=1
else:
line = i.values()
csv_writer.writerow(line)
ic+=1
Code: Select all
#Using the nagiosXIGenericAPI function
resource = system
endpoint = scheduleddowntime
method = delete
modifier = <your internal_id>
myurl
mykey
d = nagiosXIGenericAPI(resource,endpoint,modifier,myurl,mykey)
print(d)
Yep, I, too, repeatedly tried viewing "No limit" but got the endless buffer spinner. Let it run all weekendsgardil wrote: ↑Wed Jul 24, 2024 9:24 am it worked once and other times it gave an endless buffering icon. You can give it a try and see if it will load for you and if it does click the checkbox to select all in the top and endlessly scroll to the bottom for the option to select remove in the with selected option. Not perfect but worth giving a shot.
The most I can do at a time is 500. But 60K / 500 means doing it 120 times . . . NOT! LOL (or I'd cry).