Administration XML Developer Forums

« Back to Administration XML Questions

Getting Unassigned DNs?

Combination View Flat View Tree View
Threads [ Previous | Next ]
Was hoping to get a list of unassigned DNs via AXL.

Noticed that there didn't seem to be a function.

Any ideas or alternate solutions?

Thanks!
-Alex

You will need to do something via <executeSQLQuery> for this.

Check the Data Dictionary for the tables and fields, but if 'Unassigned DNs' are DNs which do not appear on any device, something like this might work:

select dnorpattern from numplan where numplan.pkid not in (select fknumplan from devicenumplanmap)

Works GREAT!

Looks like it truncates due to char limits?
Is this true? Maybe it's my c buffer or something.
I'll look into it.

Thanks,
-Alex

Just so you know, it was my char array buffer size.

I also modified the sql query to only return the extensions starting with 5 or 3.

Might be useful to someone else, so here it is.
select dnorpattern from numplan where numplan.pkid not in (select fknumplan from devicenumplanmap) and (substring(dnorpattern FROM 1 FOR 1) = '5' or substring(dnorpattern FROM 1 FOR 1) = '3')

Thanks again!
-Alex