Thanks David, am I missing it, i don’t see anything relating to a count of
physical disks per machine?
On 1 Dec 2016, at 14:46, David Jones
sorry that wasn't very helpful without this.
On Thu, Dec 1, 2016 at 9:35 AM, David Jones
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
ORDER BY SYS.Netbios_Name0
On Thu, Dec 1, 2016 at 6:55 AM, Stuart Watret
Anyone share a bit of query magic I can utilise to count disks in machines,
that’s all I need.
<Processor with Cores by Collection.rdl.txt>