josh

percent fragmentation is got from dmv

other columns are got from sysindexes, filegroups

Only To get percent detail i need to go to physical stats dmv. I need result which has objject name, index name, index id, filegroup percent fragmentation.

Your query gives db, table, percent fragmentation - If i am not wrong, index physical stats dmv gives the same information.