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>>
