[cisco-voip] AXL query

Wes Sisk wsisk at cisco.com
Thu Oct 15 10:27:10 EDT 2009


how about just CLI command?

you can use the data dictionary to see all of the SQL table definitions:
http://www.cisco.com/en/US/partner/products/sw/voicesw/ps556/products_programming_reference_guides_list.html

admin:run sql select numplan.dnorpattern,voicemessagingprofile.name from 
numplan,voicemessagingprofile where 
numplan.fkvoicemessagingprofile=voicemessagingprofile.pkid
dnorpattern name         
=========== =============
5559101     NoVoiceMail  
5559102     NoVoiceMail  
5551002     vmp_privatevm
5551004     Unity7-22_VM 
5551006     Unity7-22_VM 
5551008     Unity7-22_VM 
5551010     Unity7-22_VM 
5551013     Unity7-22_VM 
5551011     Unity7-22_VM 
5551012     Unity7-22_VM 
5551015     Unity7-22_VM

/Wes


On Thursday, October 15, 2009 10:14:44 AM, Jeremy Rogers 
<Jeremy.Rogers at ip-soft.net> wrote:
>
> Thanks Wes,
>
> That's what I meant.  I don't know anything about AXL queries so 
> forgive me.  I am trying to find all lines with a specific VM profile 
> so I can delete old vm accounts from Unity Connection.
>
>  
>
>  
>
>  
>
> Jeremy Rogers
>
> Network Management
>
> IPsoft, Inc.
>
> Jeremy.Rogers at ip-soft.net <mailto:Jeremy.Rogers at ip-soft.net>
>
> Phone: 888.IPSOFT8
>
> http://www.ipsoft.com
>
>  
>
>  
>
> *From:* Wes Sisk [mailto:wsisk at cisco.com]
> *Sent:* Thursday, October 15, 2009 9:25 AM
> *To:* Jeremy Rogers
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] AXL query
>
>  
>
> vmprofiles are associated to lines, not users.
> you could join vmprofile table to numplan to get vmprofile to dn mapping.
> then you could possibly try another join based on (user assocaited to 
> device) or (user assocaited to line) to get a rough mapping of users.
>
> /wes
>
> On Thursday, October 15, 2009 8:44:08 AM, Jeremy Rogers 
> <Jeremy.Rogers at ip-soft.net> <mailto:Jeremy.Rogers at ip-soft.net> wrote:
>
> Is there any way to query AXL on Call Manager 6 to find all users with 
> a specific voicemail profile?
>
>  
>
> Jeremy Rogers
>
> Network Management
>
> IPsoft, Inc.
>
> Jeremy.Rogers at ip-soft.net <mailto:Jeremy.Rogers at ip-soft.net>
>
> Phone: 888.IPSOFT8
>
> http://www.ipsoft.com
>
>  
>
>  
>
>  
> ------------------------------------------------------------------------
>
>
>   
>  
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net <mailto: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/20091015/f582cf3d/attachment.html>


More information about the cisco-voip mailing list