<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=156465123-28122007><FONT face=Arial
size=2>Group,</FONT></SPAN></DIV>
<DIV><SPAN class=156465123-28122007><FONT face=Arial size=2>I need to get a
report that shows which BLFs are associated with device. Using a BAT phone
report tool this is not possible. </FONT></SPAN></DIV>
<DIV><SPAN class=156465123-28122007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156465123-28122007><FONT face=Arial size=2>Is there any sql
query that will list a device name and/or description in one field and in the
another, list of the BLFs that are assigned to the particular
device.</FONT></SPAN></DIV>
<DIV><SPAN class=156465123-28122007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156465123-28122007><FONT face=Arial size=2>CCM 5.1 has a
enhancement bug that cannot export BLF information through a
BAT.</FONT></SPAN></DIV>
<DIV><SPAN class=156465123-28122007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156465123-28122007><FONT face=Arial size=2>Any help is
appreciated.</FONT></SPAN></DIV>
<DIV><SPAN class=156465123-28122007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156465123-28122007><FONT face=Arial
size=2>Mladen</FONT></SPAN></DIV></BODY></HTML>