USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_DASHBOARDS_2

CREATE procedure dbo.USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_DASHBOARDS_2
(
  @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 
    DB.ID,
    DB.NAME,
    DB.SECURITYUIFOLDER,
    DB.DESCRIPTION,
    PERM.ID as PERMISSIONID,
    PERM.GRANTORDENY
  from
    dbo.V_INSTALLED_DASHBOARDCATALOG as DB
  left outer join 
    dbo.SYSTEMROLEPERM_DASHBOARD PERM on PERM.DASHBOARDCATALOGID = DB.ID and PERM.SYSTEMROLEID = @SYSTEMROLEID 
  where 
    (@ONLYASSIGNED = 0 or PERM.ID is not null)
  order by
    DB.SECURITYUIFOLDER, DB.NAME;