[opennms-devel] Bug/new feature: Annotations

All, David H suggested I submit this as a bug/feature, I am not sure how
to do that so I figured this list would be the best place. The
functionality described is akin to what is in Open View if you are
familiar with it.

Annotations: 
        1) Database schema, I think this is straight forward and there
are two possible ways of doing this. One using a array data type (which
has to be pre sized.. I think) and the index as the indexed number of
the annotation. The annotations can be used as a audit trail of the
event so data integrity is an issue, so each event would have a indexed
set of annotations with time stamps and free form text. 

        schema could be
        eventid int 
        ano_index array
        ano_ts timestamp
        annotation text

      The other schema type could be 
        eventid int
        ano_index int
        ano_ts timestamp
        annotation text

Just some thoughts..  Im no dba ;-)


A few of the paths to an annotation could be the event creation ( this
would be excellent ), on the event view page "add annotation" ( super
great ) and a external program that auto corrective actions, alerting
software and anything else that would be able to add noteworthy data to
event during it's life( I think this is critical to fully make use of
annotations ).

Cheers,
Robert



        Its All About the Food  
        
Robert Reilly
Sr. UNIX Admin  Fresh Direct
23-30 Borden Ave
Long Island City, NY. 11101     
rreilly@xxxxxxxxxxxxxxx
IM: MSN rreilly@xxxxxxxxxxxxxxx         tel: 
mobile:         718.928.1172
347.306.2808    
        
Add me to your address book...   Want a signature like this?    


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/wiki/index.php?page=MailingListFaq

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this 
page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel