Which BBIS pages face the public?

How to find which BBIS pages anyone can view.
Run the following SQL statement:

select 
    SP.* 
from 
    SITEPAGES SP
    inner join CMSEVERYONESECURITYPRIVS C on SP.GUID = C.SECUREDOBJECTGUID --everyone security table
where 
    SP.ISTEMPLATEPAGE = 0 
    and SP.INTRASHBIN = 0
    and SP.DELETED = 0
    and C.OBJECTTASKID = '1A68CB25-1A33-445D-8E2A-69839F959869' --view
    and C.VALUE = 1 --marked as true

Environment

 Blackbaud CRM
 4.0
 4.0
 4.0.166

Was this article helpful?