• Very nice.
    I needed a minor alteration.
       LEFT JOIN sys.dm_db_index_operational_stats(NULL, NULL, NULL, NULL)IOS ON Indx.object_id=IOS.object_id AND Indx.index_id=IOS.index_id AND IUS.database_id=IOS.database_id
    WHERE(Obj.type_desc='USER_TABLE' OR Obj.type_desc='VIEW')
        AND ius.database_id = DB_ID()