Thanks for the reply ,i will have to check if the number is shared although i doubt it ,as the numbers are provisioned to the CUCM via a frontend portal that provisions all devices the same and the norm is to put a "*" in front of the device directory number. It is CUCM 10.5.
Also i did not alter the SQL query ,i just didn`t copy all output here
WOW. When I see a post like this, I think it deserves solid ratings.
+5 to Bill for always going above and beyond.
If you have not done so, please rate helpful posts!