Thanks for your information.

as per your script i have executed in our server.

see the below resilts:

Actual log size: 369409.0

Used_log_size_mb :128.0

potential_log_size :368000.0

actual_VLF's :2890

used Vlf's:1

Potential_VLFs :736

growth_iteration :46

Log_initial_size:8000.0

File_auto_growth_mb:1024.0

Please advise me how can i take action here to reduce the log