Your WHERE-condition on LogonDate is not valid, 11/28/2013 is not a DATE, it's a numeric calculation resulting in an INTEGER 0.
from dbc.accesslog where UserName= 'abcd' and LogonDate=DATE '2013/11/28';
Thanks for the reply but when i used the below query
if this was an ANSI session it might be due to case sensitivity, but based on explain you seem to run in Teradata session mode.
Are you shure that Access Logging is switched on for that user/object combination?