SQL Server finds the file and filegroup implementation script based on the partition table name _mssql

SELECT Ps.name as Psname,  
 Dds.destination_idas partitionnumber, 
  fg.name as Filegroupname,fg.name,
  t.name ,
  f.name as FileName from
  (((sys.tables as T  
  INNER JOIN sys.indexes as I
      (t.object_id = i.object_id)) 
  inner join Sys.partition_schemes as PS on 
      (i.data_space_id = ps.data_space_id)) 
   INNER join Sys.destination_ Data_spacesas DDS on 
      (ps.data_space_id = dds.partition_scheme_id))
   INNER JOIN sys.filegroups as FG  
       ondds.data_space_id =fg.data_space_id
       innerjoin sys.database_files f on f.data_space_id = fg.data_space_id
      where T.name= ' SalesOrder '