SELECT i.name, p.object_id, p.index_id, i.type_desc,
  COUNT(*) AS number_of_segments
FROM sys.column_store_segments AS s
  INNER JOIN sys.partitions AS p
ON s.hobt_id = p.hobt_id
  INNER JOIN sys.indexes AS i
ON p.object_id = i.object_id
WHERE i.type = 5 OR i.type = 6
GROUP BY i.name, p.object_id, p.index_id, i.type_desc;
GO