How can I delete events from my cell with the mquery command ?<\/p>\n
mquery<\/strong> can be used with -s DELETE<\/strong> option to delete events\/data from your impact manager.<\/p>\n (Replace CELLNAME with the name of your cell)<\/p>\n For example if you want to delete all CLOSED PATROL_EV type events from your cell with the msg slot = test you can run the following:<\/p>\n [Here Patrol_EV = the required CLASS] In gen, you can use any class using the -a switch.<\/p>\n To delete all events from your cell for a specific date range(18th Sep 06 -> 20th Sep 06) you could use:<\/p>\n You can specify any slots and values to narrow down your criteria.. e.g.<\/p>\n If you want to delete entries from a dynamic data table you would have to use the -d option additionally<\/p>\n This would delete all the data from the table BEM_MATCH_TABLE<\/em>.<\/p>\n As the mquery should not be used for amounts of more than 1000 entries\/events you should use the -i.e. startup option of mcell to delete ALL events from your cell.<\/p>\n To check the amount of events\/entries that will be deleted simply replace the DELETE by COUNT in your mquery:<\/p>\n <\/p>\n Example:<\/strong><\/p>\n For more info on the mquery binary, type a mquery -h<\/strong> from the command prompt. This will show you all available slots\/class options that you can use with mquery<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" How can I delete events from my cell with the mquery command ? mquery can be used with -s DELETE option to delete events\/data from your impact manager. (Replace CELLNAME with the name of your cell) For example if you […]<\/p>\nmquery -n CELLNAME -a PATROL_EV -w 'status: == CLOSED, msg: == test ' -s DELETE<\/pre>\n
mquery -n CELLNAME -a EVENT -s DELETE -w \"date: between ['20060918', '20060920']\"<\/pre>\n
mquery -n CELLNAME -a PATROL_EV -s DELETE -w \"status: == CLOSED, severity: == OK, <\/pre>\n
mc_origin: == testcell, mc_host: =='losborn.bmc.com', event_handle: == 7086\"<\/pre>\n
mquery -n CELLNAME -a BEM_MATCH_TABLE -d -s DELETE<\/pre>\n
mquery -n CELLNAME -w 'status: == CLOSED, msg: == test ' -s COUNT<\/pre>\n
General Command:<\/strong><\/h3>\n
mquery -n YourCellName -a EventClass -w \"event_handle: ==<Internal ID>\" -s DELETE<\/pre>\n
mquery -n pncell_SDCZFMSWVPBMC03 -a CORE_EVENT -w \"event_handle: == 131253\" -s DELETE<\/pre>\n