I create the following select as a view in all databases that have partitions. This enables other DBA’s to quickly and easily gather information about partitioned indexes. You can group and filter on any of the columns to answers questions as needed.
Which partition is not on the expected file group?
SELECT TableName, IndexName, PARTITION_NUMBER
WHERE FileGroup <> 'MyFileGroup'
What is the total size of all indexes on each partition?
SELECT PARTITION_NUMBER, SUM(MB)
GROUP BY PARTITION_NUMBER