<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Scott,</div><div><br></div><div>To list the end users use this:</div><div><br></div><div><b>run sql select * from enduser</b></div><div><br></div><div>Personally I use the Informix DB scema information to 'discover' the data structure in UCM, for example:</div><div><br></div><div><b>run sql select tabname from systables where tabname like 'e%'</b></div><div><br></div><div>The IBM documentation gives more detail on discovering the database schema:</div><div><br></div><div><a href="http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/0305parker/0305parker.html">http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/0305parker/0305parker.html</a></div><div><br></div><div>Obviously you can just use the data dictionary, but the schema commands help when working with undocumented information, for example the CUPS database etc.</div><div><br></div><div><a href="http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html">http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html</a></div><div><br></div><div>Thanks</div><div><br></div><div>Stephen</div><div><br></div><br><div><div>On 26 Oct 2010, at 23:00, Scott Voll wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">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<div><br></div><div>Thanks</div><div><br></div><div>Scott</div>
_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>https://puck.nether.net/mailman/listinfo/cisco-voip<br></blockquote></div><br></body></html>