How Fragmented are your database indexes

fragmentedindexes.sql

       SELECT
             [dbindexes].[object_id] as [Id],
             [dbtables].[name] as [Table],
             [dbindexes].[name] as [IndexName],
             [dbindexes].[type_desc] as [IndexType],
             [indexstats].[avg_fragmentation_in_percent] as [FragmentationPercent],
             [indexstats].[page_count] as [PageCount],
             CASE lob_data_space_id WHEN 0 THEN 0 ELSE 1 END AS [HasLobData]
       FROM [sys].[dm_db_index_physical_stats] (DB_ID(), NULL, NULL, NULL, NULL) AS [indexstats]
       INNER JOIN [sys].[tables] [dbtables] ON [dbtables].[object_id] = [indexstats].[object_id]
       INNER JOIN [sys].[indexes] [dbindexes] ON [dbindexes].[object_id] = [indexstats].[object_id] AND [indexstats].[index_id] = [dbindexes].[index_id]
       WHERE [indexstats].[database_id] = DB_ID() 
       AND [dbindexes].[name] IS NOT NULL