Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

AXL: How to detect removed/inactive lines?

Hi,

is there a chance to detect a removed = inactive line via AXL/SQL-Query? (important to ignore these lines...)

Regards

Axel

4 REPLIES
Community Member

Re: AXL: How to detect removed/inactive lines?

i think so

You can find the query by analysing the source code on the route plan report when you search with criteria 'Unassigned DN"

Please Rate this post

Remy

Community Member

Re: AXL: How to detect removed/inactive lines?

Hi Remy,

you are right, but routeplan report - as far as I know - is not available via AXL...

Regards

Axel

Community Member

Re: AXL: How to detect removed/inactive lines?

Hi,

this is the url passed to the CCM to find unassigned DN

routeplanreportlist.asp?patternType=-1&findBy=name&match=begins&pattern=&rows=20&utilityList=

So patternType=-1 is one of the sql column you have to search

You can make SQL query with AXL and search patterntype=-1

Keep me inform if you find stg

Rate this post

Remy

Community Member

Re: AXL: How to detect removed/inactive lines?

You can use the status field of the device. If it is not Registered, then it is inactive device. It basically tells you about devices/phones as opposed to lines/number.

161
Views
0
Helpful
4
Replies
CreatePlease to create content