cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
552
Views
0
Helpful
4
Replies

AXL: How to detect removed/inactive lines?

schemberg
Level 1
Level 1

Hi,

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

Regards

Axel

4 Replies 4

cronier.remy
Level 1
Level 1

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

Hi Remy,

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

Regards

Axel

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

msabir
Level 4
Level 4

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.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: