Never mind, I found it: fn_rbac_vSMS_DistributionDPStatus
Dont know why I didnt see it the first time i looked. Regards Mattias Benninge http://myitforum.com/myitforumwp/author/matbe/ On Mon, Sep 29, 2014 at 9:01 AM, Mattias Benninge <[email protected]> wrote: > Hi, > > I'm trying to create a report based on the view vSMS_DistributionDPStatus. > When i run the Query in the builder it works correctly but when trying to > launch it from the reporting server i get an error indicating permission > issues: > > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: > Query execution failed for dataset 'DataSet1'. ---> System.Data.SqlClient. > SqlException: The SELECT permission was denied on the object > 'vSMS_DistributionDPStatus', database 'CM_XXX', schema 'dbo'. > > Can this view not be used in SCCM 2012 R2? I tried to find a fn_rbac > equivalent but there seems to be none? > > Regards > Mattias Benninge > > > >
