...
If not using realms, you will need to remove or comment out the SQL for the left outer join to the realm table and the WHERE condition filtering to realm by GUID. If you are using realms, replace the GUID in the WHERE clause with the realm you want to display in this portal/report/homepage.
...