Where are Trace settings stored?

Version 1
    This document was generated from CDN thread

    Created by: David Roberts on 02-12-2008 07:25:34 PM
    hi,
    I've looked at the data dictionary for CM 6.1 and see a few tables where trace settings are stored. However, I'm unable to figure out where the specific Trace Filter settings are stored (checkbox items, especially under CallManager service).
    In the processnodeservice table, I see 'usercategories' which seems possibly like a mapping but it's an integer and I have no idea how the integer ID's would map to actual filter names (e.g. Enable Analog Trunk Trace , Enable Miscellaneous Trace , ...)

    Thanks

    Subject: Re: Where are Trace settings stored?
    Replied by: David Staudt on 02-12-2008 10:08:18 PM
    You can update trace settings via the updateProcessNodeService request, without a direct SQL update.

    The userCategories field is indeed where the 'Trace Fields' options are stored, packed into a bitmap. I'm making some inquiries to see if I can find a mapping document. You could try some trial-and-error if you're just interested in a few fields.

    Subject: Re: Where are Trace settings stored?
    Replied by: David Roberts on 02-12-2008 10:13:57 PM
    Thanks Dave,
    We're not looking to update the settings. So when you say it's stored as a bitmap, you mean that this single integer somehow has all the trace field settings encoded and there's some algorithm is needed to decode which specific settings are enabled?

    Subject: Re: Where are Trace settings stored?
    Replied by: David Staudt on 03-12-2008 11:47:59 PM
    I created a FAQ in the AXL wiki which covers this topic and provides a link to a file with all the bit mappings/definitions: http://developer.cisco.com/web/axl/wikidocs?src=/wiki/display/AXL/AXL_FAQ_updating+CM+Service+trace+settings

    Comments welcome.