Report to show account permissions and limitations (does not include permissions for additional modules at the bottom of the page as seen below)
- ZackM
http://www.loop1systems.com
Looks good Zack.
One question:
CASE
WHEN (A.HOMEPAGEVIEWID = 0 OR A.HOMEPAGEVIEWID = 1 OR A.HOMEPAGEVIEWID IS NULL)
THEN CAST ('DELETED VIEW' AS NVARCHAR(100))
ELSE V1.VIEWTITLE
END AS 'HOME PAGE',
WHEN (A.SUMMARYVIEWID = 0 OR A.SUMMARYVIEWID = 1 OR A.SUMMARYVIEWID IS NULL)
ELSE V2.VIEWTITLE
END AS 'SUMMARY PAGE',
results in "Deleted View" on a default install. The default view (Orion Summary Home) is ViewID 1in the views table.
Other than that, great report
Great catch!!!
I had that in there to account for some NULL values in our lab. Thank you for bringing that to my attention. The report has been updated.
