Than, if I use that I will leverage RBA for reports, if not I will not have access control to my custom reports. Just that, right?
Tnx a lot, 2013/9/18 Garth Jones <[email protected]> > The parameter @UserID is not blank, it collects the UserID of the person > running the report. It isn’t do much in CM12 but it will be used a ton in > CM12R2 to leverage RBA within SSRS. I’m working on a whole set of > blogs/videos that will give details on how it works and how to create > report for RBA in CM12R2. Look for them http://be.enhansoft.com/ all the > be release around RTM of CM12R2. **** > > ** ** > > ** ** > > ** ** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *JRIT > *Sent:* Wednesday, September 18, 2013 9:19 PM > > *To:* [email protected] > *Subject:* Re: [mssms] Default report query**** > > ** ** > > I got it, tnx. But its a little strange, did you see? this is BLANK > parameter.**** > > ** ** > > 2013/9/18 Daniel Ratliff <[email protected]>**** > > Also check the dataset properties. **** > > **** > > **** > > **** > > *Daniel Ratliff***** > > **** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Daniel Ratliff > *Sent:* Wednesday, September 18, 2013 9:08 PM > *To:* [email protected] > *Subject:* RE: [mssms] Default report query**** > > **** > > It should be under parameters. **** > > **** > > **** > > **** > > *Daniel Ratliff***** > > **** > > *From:* [email protected] > [mailto:[email protected]] *On Behalf Of *JRIT**** > > > *Sent:* Wednesday, September 18, 2013 9:02 PM > *To:* [email protected] > *Subject:* Re: [mssms] Default report query**** > > **** > > Thank you Daniel,**** > > I am analysing a report, this: Computers where physical memory has changed > > SELECT Distinct SYS.Name0, ROUND(NewMem.TotalPhysicalMemory0,-3) As > 'Current Physical Memory (MB)', > ROUND(OldMem.TotalPhysicalMemory0, -3) As 'Previous Physical > Memory (MB)' > From fn_rbac_R_System(@UserSIDs) SYS, > fn_rbac_GS_X86_PC_MEMORY(@UserSIDs) NewMem, > fn_rbac_HS_X86_PC_MEMORY(@UserSIDs) OldMem > Where SYS.ResourceID = NewMem.ResourceID AND SYS.ResourceID = > OldMem.ResourceID AND > ROUND(NewMem.TotalPhysicalMemory0,-3)<> > ROUND(OldMem.TotalPhysicalMemory0, -3) > Order by SYS.Name0**** > > But I cant find in Report Builder what is @UserIDs**** > > Can you help me? please.**** > > **** > > 2013/9/18 Daniel Ratliff <[email protected]>**** > > Open the report in report builder then view the dataset query. **** > > **** > > *Daniel Ratliff***** > > **** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *JRIT > *Sent:* Wednesday, September 18, 2013 8:09 PM > *To:* [email protected] > *Subject:* [mssms] Default report query**** > > **** > > How can I see/access the query for a Default report in SCCM 2012?**** > > Tnx**** > > **** > > > The information transmitted is intended only for the person or entity to > which it is addressed > and may contain CONFIDENTIAL material. If you receive this > material/information in error, > please contact the sender and delete or destroy the material/information.* > *** > > **** > > **** > > **** > > > The information transmitted is intended only for the person or entity to > which it is addressed > and may contain CONFIDENTIAL material. If you receive this > material/information in error, > please contact the sender and delete or destroy the material/information.* > *** > > **** > > > The information transmitted is intended only for the person or entity to > which it is addressed > and may contain CONFIDENTIAL material. If you receive this > material/information in error, > please contact the sender and delete or destroy the material/information.* > *** > > ** ** > > ** ** > > ** ** > >
<<image001.png>>
<<image002.png>>
