I wanted to show what the two queries that I put up show you about a SQL Merge Publication.     We've incorporated them into a couple of web-pages that provide a single repository for all of the cab files that constitute a mobile LOB application,  see below.

This web page lets us manage the version of the software currently running on the device,   if the version number changes a new version of the application is pulled down the next time it synchronises with the SQL publication.   In addition it lets me upload securely any updates that I need to deploy.

Clicking a given publication, takes you into the detail.

Note that it shows record-counts applying the filter specified.   In addition we can substitute the Host_Name() function in any of the filter criteria with the contents of the publication filter criteria textbox. .    This is a massive time saver as we can see exactly what would be sent down to the mobile device ahead of any coding.

+ it's just based on two simple bits of SQL that I posted previously.