[cisco-voip] two informix DB questions - ARP & last executed sql queries

[Ryan Ratliff]

To expand on Tim's answer (which is correct) on the device page  
everything that is part of the "product specific configuration" is in  
an xml blob in the vendorConfig column.

Regarding the last db query I'm not 100% certain whether ccmadmin  
operations will show up there.

-Ryan

On Jun 4, 2009, at 6:41 AM, Tim Smith wrote:

Hi,

I havent done it in 6 yet, but I think it will probably be the same.
Look for a field called vendorConfig is this in the device table?
It should have an XML string in it which contains this setting.
Change it from the default to ensure it shows up.

It's a string in a field, so each different device can have a bunch  
of settings specific to that model.

Cheers,

Tim




On Thu, Jun 4, 2009 at 6:58 PM, <Thorsten.Mayr at barclayscapital.com>  
wrote:
Feels silly asking but I just can't find "Gratuitous ARP" in the DB.
Would have assumed that there is a reference under Device (!?)

If someone have stumbled across it in CUCM 6.X - don't want to bother
TAC/HTTS with silly questions like this.

- I checked the "Cisco Unified Communications Manager Data Dictionary"
for version 6.
- Looked at all fields of "device"

might be that I need glasses


Talking about the DB...

"Show tech dbstateinfo"

The output (showtechdbstateinfoXXXX.out) does contain the  " Last parsed
SQL statement :" ...
Thought I'd be clever.... changed a setting on a phone, hit save and ran
the command on a test cluster 2 seconds after...
Either my sight really has gone downhill or the insert/update query
really doesn't show up.
The lab cluster doesn't really have too much going on...

This leads me to the following questions:

a) are queries from users/admins are executed as "stduser" (I believe
they are)
b) should the output of show tech dbstateinfo it contain the last
executed query of admin's


Thx in advance
T

PS: in desperation I have tried:
run sql select tabname, colname, owner, coltype FROM syscolumns join
systables on syscolumns.tabid = systables.tabid where colname like
'%arp%'

&&

run sql select tabname, colname, owner, coltype FROM syscolumns join
systables on syscolumns.tabid = systables.tabid where colname like
'%grat%'

needless to say I didn't find it ;)

_______________________________________________

This e-mail may contain information that is confidential, privileged  
or otherwise protected from disclosure. If you are not an intended  
recipient of this e-mail, do not duplicate or redistribute it by any  
means. Please delete it and any attachments and notify the sender  
that you have received it in error. Unless specifically indicated,  
this e-mail is not an offer to buy or sell or a solicitation to buy  
or sell any securities, investment products or other financial  
product or service, an official confirmation of any transaction, or  
an official statement of Barclays. Any views or opinions presented  
are solely those of the author and do not necessarily represent those  
of Barclays. This e-mail is subject to terms available at the  
following link: www.barcap.com/emaildisclaimer. By messaging with  
Barclays you consent to the foregoing.  Barclays Capital is the  
investment banking division of Barclays Bank PLC, a company  
registered in England (number 1026167) with its registered offi!
  ce at 1 Churchill Place, London, E14 5HP.  This email may relate to  
or be sent from other members of the Barclays Group.
_______________________________________________
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip