I am looking to identify the expiration date for Data Labs on the system tables, but so far have not been able to find this information.
The reason we require this is for MI and monitoring purposes.
Not sure what you mean by "system tables" but Data Lab expirations are executed at the data labs level, not for individual tables. You can view a particular data lab expiration date within the "Data Labs" portlet by drilling down into the Lab Group and then the specific data lab. In the details display, there is an "Expries" listing that will have the expration date for this particular data lab.
is there any table in teradata so that we can find expiry date in there. Otherwise we have to go one by one lab to find the expiry date.
The data lab expirations are not stored anywhere in Teradata, however that doesn't mean you have to view them one by one for each data lab. Check the Data Lab 15.10 release article which shows that all data labs will be presented at the lab group level which can include the "Expires" column where you can view all the data lab expirations at one time. Refer to the link below and the screeen shot under the "The New Data Labs Portlet" header.