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. > >
<<image002.png>>
<<image003.png>>
