OK, seems to be a side effect of using 'GROUP BY id with rollup' When I drop the rollup all the objects are found. odd???

SET NOCOUNT ON

select id, cast(object_name(id) as varchar(50)) AS name, sum(CASE WHEN indid<2 THEN rows END) AS rows,

sum(reserved)*8 AS reserved, sum(dpages)*8 AS data, sum(used-dpages)*8 AS index_size, sum(reserved-used)*8 AS unused

from dbo.sysindexes with (nolock) where indid in(0,1,255) and id>100

GROUP BY id with rollup

ORDER BY sum(reserved)*8 desc