List view: how to delete all rows on multiple pages

[dbullough]

We are cleaning up our CMDB and have 66,000 CI on 669 pages (100 CI's per page) with the Class: Next Hop Routing Rule.

We would like to select them all and delete them.   Is there a way to delete them all at once, or do we have to select all (100 at a time)?

The SNMP Routing Probe, has been disabled also so they shouldn't show up again.  

[Uncle Rob]

gs.sql with a truncate command.  
"didn't need that stuff anyway, m'i'right?"

[Chuck Tomasi]

(Chuck gets a chill up his spine thinking about gs.sql and the 'good old days')

[Uncle Rob]

Back when we could grant ourselves the maint role.

"Those were the daaaaays"

[dbullough]

Hi…

We have Eureka in the cloud and tested "delete all records" in the Test Portal.

Unfortunately it only runs for 300 seconds and times out and only deletes 2000 records at a time.

Perhaps the script is the way to go.

[Chuck Tomasi · Accepted solution]

Hi Dee,

If you are getting a timeout, then go with the script. Let me know how that works.