Spotlight on SQL Server Enterprise uses Sql server store procedure below to return the results (pendingcmdcount and estimatedprocesstime)
sp_replmonitorsubscriptionpendingcmds @publisher='Prod-db', @publisher_db='Internal_apps', @publication='DornorToSearchRepl', @subscriber='prod-subcribe', @subscriber_db='Search', @subscription_type='0'
For the last parameter for example you have to set ‘0’ for the push subscription and ‘1’ for the pull subscription.
You can see detail of this stored procedure from Microsoft http://technet.microsoft.com/en-us/library/ms189452(v=sql.100).aspx
