[cisco-voip] any sql gurus?

[John Franklin]

Here you go...

select d.name from devicexml4k dxml inner join device d on dxml.fkdevice = d.pkid where dxml.xml like '%<autoSelectLineEnable>0</autoSelectLineEnable>%' and xml like '%<autoCallSelect>1</autoCallSelect>%'

John

From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Wellnitz, Erick A.
Sent: Wednesday, October 26, 2011 8:11 AM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] any sql gurus?

I need to develop a CLI sql query for a specific task.  What I need to do is determine which phones have ‘auto line select’ and ‘auto call select’ disabled.

What I need is: name and description from the device table based on <autoSelectLineEnable>0</autoSelectLineEnable> and <autoCallSelect>1</autoCallSelect> from the devicexml4k table.



Any ideas?

ERICK A. WELLNITZ
Network Engineer
Katten Muchin Rosenman LLP
525 W. Monroe Street / Chicago, IL 60661-3693
p / (312) 577-8041
erick.wellnitz at kattenlaw.com<mailto:erick.wellnitz at kattenlaw.com> / www.kattenlaw.com<http://www.kattenlaw.com/>


===========================================================

CIRCULAR 230 DISCLOSURE: Pursuant to Regulations Governing Practice Before the Internal Revenue

Service, any tax advice contained herein is not intended or written to be used and cannot be used

by a taxpayer for the purpose of avoiding tax penalties that may be imposed on the taxpayer.

===========================================================

CONFIDENTIALITY NOTICE:

This electronic mail message and any attached files contain information intended for the exclusive

use of the individual or entity to whom it is addressed and may contain information that is

proprietary, privileged, confidential and/or exempt from disclosure under applicable law.  If you

are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or

distribution of this information may be subject to legal restriction or sanction.  Please notify

the sender, by electronic mail or telephone, of any unintended recipients and delete the original

message without making any copies.

===========================================================

NOTIFICATION:  Katten Muchin Rosenman LLP is an Illinois limited liability partnership that has

elected to be governed by the Illinois Uniform Partnership Act (1997).

===========================================================


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