Clear down notes

[Sam Green]

Hi all,

We currently have a script which posts our alerts to our ticketing system, then our ticketing system responds with a ticket reference and attaches the ticket reference to the alert in the form of a note.

My issue is that these notes build up very quickly over time (currently 200000) and I'm looking for an automated way to keep these numbers down.

Does anyone know how I can go about this?

Cheers,

------------------------------
CA - UIM administrator
------------------------------

[David Michel]

one option is if it can be done via command line or script then nexec and be scheduled to run it periodically. 
http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/nexec-command-execution.html

------------------------------
Support Engineer
Broadcom
------------------------------

[Sam Green]

Yeah, I thought I could tie a command into Nexec.

Just checked the nas white paper and it looks like there's a callback for it:

./pu -u administrator -p PASSWORD /PATH/TO/PRIMARY/nas note_delete *note_id*

I'm not sure if a wildcard would be accepted in the command, rather than specifying a particular note ID.  I'll need to get onto my test environment to confirm it.

I cant test this in live as it kills my transactionlog replication when I delete more than 5000 notes at once :)

------------------------------
CA - UIM administrator
------------------------------

[Stephen Danseglio]

Hi Sam,

Unfortunately, you have to use a single integer per command execution.

Steve

------------------------------
Support Engineer
Broadcom
US
------------------------------