Very quick post as I’m out the door to find tables that have no clustered indexes.
Import-Module SqlServer Get-SqlDatabase -sqlserver 'ServerName' -dbname 'DBName' | %{ Get-SqlTable -Database $_ | where{$_.HasClusteredIndex -ne $true}| %{ $_.Name } }