Article ID: 129053, created on Jun 30, 2016, last review on Sep 30, 2016

Overview

The article describes solution to get list of sites in SiteBuilder 4.5 that have unpublished changed.

Resolution

  1. Login to the SiteBuilder node as user root.
  2. Execute command:

    mysql -D sitebuilder3 -e "select s.alias as \"Site\",  CONCAT(u.first_name, ' ' , u.last_name) as \"User Name\", u.email as \"Email\", COALESCE(FROM_UNIXTIME(sp.publication_time), 'Never') as \"Last time was published\" from user u join site s on u.id = s.user_id left join site_publication sp on s.id = sp.site_id where s.is_changed_since_last_publication=1"
    

The query lists unpublished sites with user information, for example:

+--------------------+----------------+-----------------------------+-------------------------+
| Site               | User Name      | Email                       | Last time was published |
+--------------------+----------------+-----------------------------+-------------------------+
| ringtonegetter.com | Gregorio White | GregorioMWhite@inbound.plus | 2016-07-04 10:58:51     |
| getthatlicense.com | Martin French  | MartinCFrench@teleworm.us   | Never                   |
+--------------------+----------------+-----------------------------+-------------------------+

Email subscription for changes to this article
Save as PDF