Hi LockeAG,
I just trawl this forum and the mu core files for example code then hack bits together like:
$blogs = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs WHERE blog_id!='1' AND last_updated!='0000-00-00 00:00:00' ORDER BY last_updated DESC LIMIT 50");
foreach ($blogs as $blog) :
// we need _posts and _options tables for this to work
$blogOptionsTable = "wp_".$blog."_options";
$blogPostsTable = "wp_".$blog."_posts";
$site = $wpdb->get_col("SELECT option_value FROM $blogOptionsTable WHERE option_name='siteurl'");
$name = $wpdb->get_col("SELECT option_value FROM $blogOptionsTable WHERE option_name='blogname'");
// we fetch the posttitle for the latest post
$posttitle = $wpdb->get_col("SELECT post_title FROM $blogPostsTable WHERE post_status = 'publish' AND post_type='post' ORDER BY id DESC LIMIT 0,1");
// untitled posts get a title
if ($posttitle[0] == '') { $posttitle[0] = 'Untitled';}
// we fetch the link for the latest post
$posturl = $wpdb->get_col("SELECT guid FROM $blogPostsTable WHERE post_status = 'publish' AND post_type='post' ORDER BY id DESC LIMIT 0,1");
// and now we build the table of latest blog posts
if ($posttitle[0] == 'Hello world!') { /*ignore Hello world!*/
} else {
print "<tr><td><a href='$site[0]' title='$name[0]' target='_blank'>".ucfirst($name[0])."</a></td>n";
print "<td><a href='$posturl[0]' title='$posturl[0]' target='_blank'>$posttitle[0]</a></td>n";
print "<td><a href='$site[0]feed' title='$name[0] RSS Feed'><img src='$site[0]wp-content/themes/home/images/feed-icon16x16.png' align='right' alt='$name[0] RSS Feed' /></a></td></tr>n";
}
endforeach;
It's a hack though, more just me finding out how stuff works and seeing what's possible. Use at you own risk as there's no guarantee it won't hose whatever install of the everchanging mu you might have.
You can also do quite a lot with itdamager's sitewide feed or the "list all posts" plugin, just search around and see what's what.