#! /bin/sh
# fxloggedofftelno - fix loggedoff UC telephone in Directory

# should be just the extension
(
runisql <<SQLCMD0
select directtemplate.extension, directtemplate.recordno
from directtemplate
where directtemplate.recordno in (
    select directcustom.recordno from directcustom
    where directcustom.subscriptiondesc = "Logged Off Phone"
)
SQLCMD0
) | awk '
{
	extn = $1
	recordno = $2
	if ( recordno == "" || extn == "" || extn == "extension" )
		next
	print "update directcustom set telephone = \"" extn "\" where recordno = " recordno ";"
}
' >fxloggedofftelno.sql