USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_DASHBOARDS

                CREATE procedure [dbo].[USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_DASHBOARDS]
                    @SYSTEMROLEID uniqueidentifier,
                    @ONLYASSIGNED bit = 0
                    /* Used by the SecurityGetRoleFeaturePermTreeRequest web service */
                as
                    set nocount on;

                    if @SYSTEMROLEID is null begin
                        raiserror('@SYSTEMROLEID is required',16,10);
                        return 7;
                    end;

                    select 
                        CAT.ID,
                        CAT.NAME,
                        CAT.SECURITYUIFOLDER,
                        PERM.GRANTORDENY,
                        CAT.DESCRIPTION,
                        PERM.ID as PERMISSIONID,
                        CAT.SPECXML
                    from
                        dbo.DASHBOARDCATALOG as CAT
                    left outer join 
                        dbo.SYSTEMROLEPERM_DASHBOARD PERM on PERM.SYSTEMROLEID=@SYSTEMROLEID and PERM.DASHBOARDCATALOGID=CAT.ID
                    where 
                        (PERM.ID IS NOT NULL) OR (@ONLYASSIGNED=0)
                    order by
                        CAT.SECURITYUIFOLDER, CAT.NAME;