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