Thanks David, am I missing it, i don’t see anything relating to a count of 
physical disks per machine?

Stuart Watret

On 1 Dec 2016, at 14:46, David Jones 
<<>> wrote:

sorry that wasn't very helpful without this.

On Thu, Dec 1, 2016 at 9:35 AM, David Jones 
<<>> wrote:
This is the SQL from a report I made this week.

FROM fn_rbac_R_System(@UserSIDs)  SYS
JOIN fn_rbac_GS_PROCESSOR(@UserSIDs)  Processor on 
JOIN v_FullCollectionMembership FCM on FCM.ResourceID=SYS.ResourceID
WHERE FCM.CollectionID = @variable
Group By 
ORDER BY SYS.Netbios_Name0

On Thu, Dec 1, 2016 at 6:55 AM, Stuart Watret 
<<>> wrote:
Anyone share a bit of query magic I can utilise to count disks in machines, 
that’s all I need.


Stuart Watret

<Processor with Cores by Collection.rdl.txt>

Reply via email to