[cisco-voip] What table field in CM?

[stephen.welsh at unifiedfx.com]

Scott,

To list the end users use this:

run sql select * from enduser

Personally I use the Informix DB scema information to 'discover' the data structure in UCM, for example:

run sql select tabname from systables where tabname like 'e%'

The IBM documentation gives more detail on discovering the database schema:

http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/0305parker/0305parker.html

Obviously you can just use the data dictionary, but the schema commands help when working with undocumented information, for example the CUPS database etc.

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html

Thanks

Stephen


On 26 Oct 2010, at 23:00, Scott Voll wrote:

> if I'm doing an SQL query on a CM 7.1.5 box what would the table / fields be for:  DN and Alerting name?  and/or User and telephone
> 
> Thanks
> 
> Scott
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20101026/b58e0f02/attachment.html>