SQL to check blocking session in Teradata

SEL USERNAME ,

SESSIONNO ,

HOSTID ,

IDENTIFYUSER(BLK1USERID) as BockedBy ,

BLK1SESSNO as BlockedBySessionNO

FROM TABLE

(SYSLIB.MONITORSESSION(-1,'*',0)) AS T1

WHERE (AMPSTATE='BLOCKED' OR PESTATE='BLOCKED')

AND

USERNAME <> IDENTIFYUSER(BLK1USERID)

ORDER BY 1,2;