SELECT      
 CAST(OBJECT_NAME(sysind.id) AS CHAR(20)) AS TableName
 , CAST(sysind.name AS CHAR(30)) AS IdxName
 , CAST(sysfg.groupname AS CHAR(10)) AS GroupName
FROM 
 sysindexes  sysind    
INNER JOIN 
 sysfilegroups sysfg
ON 
 sysind.groupid = sysfg.groupid
 INNER JOIN 
  sysobjects sysobj
 ON 
  sysind.id = sysobj.id
WHERE 
 sysobj.xtype <> 'S' 
AND 
 sysind.name NOT LIKE '_WA%' 
ORDER BY
 TableName