Mass Delete?

[Blazer]

I had a situation where my camera moved (loose mount), and the position it moved to had constant random motion, so several thousand events were recorded. Is there an easy way to delete ALL current events, or at least most of them?

I know I can go to the event viewer and hit "all" and get 25 or so events at a time...but its tedious to click "check all", and then scroll to the bottom and click "delete", wait for page to refresh, and repeat many times. Any suggestions on how to handle this?

I thought about just nuking everything in /events, but that would still leave data in mysql...I suppose I could delete those using phpmyadmin, but just wondering if there is already a functional way to do it in Zm that I am unaware of.

I noticed that I could go into the settings and change the "ZM_WEB_EVENTS_PER_PAGE" value, so I could probably set this to 1000 and turn off the thumbnails option, then I could select and delete 1000 events at a time. Is this the recommended way?

[jameswilson]

id recommend using an auto filter to remove all relevant data.

Set your filter to select all events from monitor 2 then save then check auto delete all matches. let it run then delete it rather than wait.

Personally im against deleting anything as given time they will go automatically. So set yoir auto dlete when full sit back and have a coffe

James

[Blazer]

Set your filter to select all events from monitor 2 then save then check auto delete all matches. let it run then delete it rather than wait.

Cool...I assume when a filter is used to delete it deletes the event both from mysql and the filesystem (~/events)?

Personally im against deleting anything as given time they will go automatically. So set yoir auto dlete when full sit back and have a coffee

Is auto delete turned on by default? Heh I guess I should know that, I should check my settings. *lurk*

Okay now that I did that, I have a question:

I see a filter called "PurgeWhenFull". when I go to "Show Filter Window", and I understand it's definition. But, I don't see anything that indicates that this filter is automatically called, or perhaps rather where it is called from.

[zoneminder]

To avoid having to do a 'check all' on several different pages you can always click on 'view all' first and then 'check all' though that might take a while if you have thousands. Delting from the Events table will also work as zmaudit will come along and gradually tidy up any inconsistencies.

The PurgeWhenFull filter is run automatically every minute or so if you have saved it to run automatically. To check, load the filter from the drop-down and click on 'save'. You will then get a series of checkboxes with options of things to do automaitally. If none of these are checked, as they won't be by default, then your filter won't run by itself.

Phil

[jameswilson]

ok select purge when full and modify as needed

click save
a new window will pop up asking what you want to do with it, eg auto delete all matching
turn this on click save again and your away.

No its not on by default

im not sure about the filter deleting fs as well i assume it deletes the db and zmaudit deletes the fs but youll need someone who knows more than me to confirm that one

James

[zoneminder]

The filters should respect the FAST_DELETE option to will only delete exactly the same as the interactive deletes.

Phil

[cordel]

The best thing to get what you are after is to creat a filter where:
archive status Unarchived only
monitorid = <your camera>
and
date is greater than equal to <date it moved>
and
date less than equal to<date fixed>

on the results page click view all
then click check all and delete

You do not need to save this filter since this is just a one time thing.
Or you could save it and check the delete all matching box and let zm do everything on it's own.

Regards,
Cordel

[Blazer]

Thanks for great replies, exactly the info I was looking for