SCCM 2012 SP1: Incorrect RBAC in Reports

System: SCCM 2012 SP1 CU2.

In the standart reports have parameter =SrsResources.UserIdentity.GetUserSIDs(User!UserID) for RBAC.

But this always returns value = 'disabled' and RBAC in reports does not work.

P.S. RBAC SQL function:
[dbo].[fn_rbac_R_System](@UserSIDs nvarchar(max)) RETURNS TABLE AS RETURN (SELECT V.* FROM [v_R_System] V WHERE V.ResourceID in (select cm.MachineID from  CollectionMembers cm 
inner join fn_rbac_GetSecuredObjects(@UserSIDs, 1, 1) objs on objs.Object = cm.SiteID) or @UserSIDs = 'disabled')

Alexey.

August 5th, 2013 6:36am

Hi,

RBAC for reports will be fully implemented in ConfigMgr 2012 R2 so this behaviour is a expected, some Changes were made in SP1 but it will not be fully implemented until R2.

Regards,
Jrgen 

Free Windows Admin Tool Kit Click here and download it now
August 5th, 2013 6:49am

Hi Jrgen,

I know about changes in R2, but i hope resolve the problem before release R2.
I have tried change SrsResources.dll in Report point from SCCM 2012 R2 preview distributive, but it is not help me.  

August 5th, 2013 7:30am

Not sure why you'd expect swapping a DLL would change anything. The feature is simply not implemented in SP1 and "hacking" it is not something anyone here can help you with.
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2013 11:01am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics