I have been spending a lot of time converting reports to RBA style of SSRS report. I have converted about 50% of all of the Enhansoft reports to RBA style now. I'm getting really good at finding all the little things that need to be done to convert / create a RBA report. J
From: [email protected] [mailto:[email protected]] On Behalf Of Roland Janus Sent: Thursday, September 19, 2013 4:47 PM To: [email protected] Subject: RE: [mssms] Default report query Where you guys get all that time for that is a mystery to me. From: [email protected] [mailto:[email protected]] On Behalf Of Garth Jones Sent: Donnerstag, 19. September 2013 14:10 To: [email protected] Subject: RE: [mssms] Default report query RBA does not work in CM12 for SSRS, you need to wait for CM12R2 to use RBA for CM12 SSRS reports. There is more to it that just adding the @UserID to a report. What exactly are you trying to do? FYI, Currently I have 4 blogs and 1 video on the subject and are all in the final stages of being clean up getting ready to be posted, closer to RTM of CM12R2. I also have 3 additional blogs and 2 more videos that I'm hoping to get done for Oct 18th timeframe. From: [email protected] [mailto:[email protected]] On Behalf Of JRIT Sent: Wednesday, September 18, 2013 10:31 PM To: [email protected] Subject: Re: [mssms] Default report query 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>>
