Can we find the list of filenames associated with a DB using VDI ?

Hi all,
I want to find the list of filenames associated with the SQL server instance programmatically. As VDI is concerned with taking backup of SQL server. Can we find the list of filenames associated with a DB using VDI ? or Is there any other way to know filenames?

Thanks in Advance,
Ram

You can always execute sp_helpfile in a database to find the files for that database.

Or select * from sys.database_files

-Sue