Rob Huffman Tue, 12/05/2006 - 13:26
User Badges:
  • Super Red, 40000 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hi Jacob,


Transaction History Reports


The Transaction History report shows the details of BBSM transactions. For auditing purposes, these transactions are never deleted from the BBSM database. If you want to export this data or truncate part of it, use standard SQL commands. For the database schema, refer to the Cisco BBSM 5.2 SDK Developer Guide.


From this good doc;


http://www.cisco.com/en/US/products/sw/netmgtsw/ps533/products_user_guide_chapter09186a0080192294.html#1039049


Cisco BBSM 5.2 SDK Developer Guide


http://www.cisco.com/en/US/products/sw/netmgtsw/ps533/products_user_guide_book09186a008019e125.html


Here is a great post from Stephen @ Cisco that outlines how to deal with this;


http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Wireless%20-%20Mobility&topic=Security%20and%20Network%20Management&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.1dd96995/0#selected_message


Hope this helps!

Rob


stschmidt Thu, 12/07/2006 - 11:12
User Badges:
  • Bronze, 100 points or more

Purge both the transaction history and debugging tables. This can be

done via SQL commands. MSDE has a 2GB limit per database. If you want to save this data in a test file, use the following:


Bcp "use atdial select * from transaction_history" queryout

-T -c


The above will export the table to a tab delimited text file. It will be

very large and notepad will not be able to open this file. You will need

to use excel, access or some other text editor that can handle large

files.


The next step is to purge the two tables. These will be the largest

tables especially if you have been using debug. Transaction_history is

written to constantly and needs to be purged on occasion.


From the command prompt


OSQL -d atdial -E

> delete transaction_history

> delete debugging

> go

jmrobfogel Thu, 12/07/2006 - 22:26
User Badges:

Thank you for this . I just want to confirm if this will require a reboot of the system after done, or if there are any other issues I should consider before doing this. Will service be interrupted? Also, do I need to make a back up the logs if we do not need them? Any particular reason to do this? Finally, about how often should we do this as a regular maitenance procedure. Thanks so much

Actions

This Discussion

 

 

Trending Topics - Security & Network