$getFragQuery = "SELECT dbschemas.[name] as 'Schema',
                dbtables.[name] as 'Table',
                dbindexes.[name] as 'Index',
                indexstats.avg_fragmentation_in_percent,
                indexstats.page_count
                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.schemas dbschemas on dbtables.[schema_id] = dbschemas.[schema_id]
                INNER JOIN sys.indexes AS dbindexes ON dbindexes.[object_id] = indexstats.[object_id]
                AND indexstats.index_id = dbindexes.index_id
                WHERE indexstats.database_id = DB_ID()"

$FragRate = Invoke-Sqlcmd -ConnectionString $ConnectionString -Query $getFragQuery

Schema                       : dbo
Table                        : LizenzHandling
Index                        : PK_LizenzHandling
avg_fragmentation_in_percent : 0
page_count                   : 0

Schema                       : dbo
Table                        : ServiceFelder
Index                        :
avg_fragmentation_in_percent : 83.3333333333333
page_count                   : 7