SELECT COUNT(*) FROM TL_USER tu WHERE tu.DEP_ID IS NULL OR tu.SECUR_CODE IS NULL
SELECT tu.TLNANME,tu.TLSUBBRID,tu.DEP_ID,tu.SECUR_CODE FROM TL_USER tu WHERE tu.DEP_ID IS NULL OR tu.SECUR_CODE IS NULL