You can use the sp_helpprimaryconn procedure to get a list of all unpublished objects in a primary database. Unpublished objects in a primary database are objects for which no primary articles exist.
To get information about all unpublished primary objects in a specific primary database, use sp_helpprimaryconn with the unpub keyword and specify a primary database connection:
sp_helpprimaryconn unpub, conn="conn_name"
where conn_name is the name of a primary database connection.