Also check the dataset properties. [cid:[email protected]]
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. [cid:[email protected]] Daniel Ratliff From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of JRIT Sent: Wednesday, September 18, 2013 9:02 PM To: [email protected]<mailto:[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]<mailto:[email protected]>> Open the report in report builder then view the dataset query. Daniel Ratliff From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of JRIT Sent: Wednesday, September 18, 2013 8:09 PM To: [email protected]<mailto:[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.
<<inline: image002.png>>
<<inline: image003.png>>
