Find last LSN applied on a database in SQL Server

Find the last LSN applied on the database in SQL Server

Query will give the LSN number which was applied recently on the database.

Select
redo_start_lsn from sys.master_files where database_id = db_id('SecondaryDatabaseName') and type = 0