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 
<dkjones9...@gmail.com<mailto:dkjones9...@gmail.com>> wrote:

sorry that wasn't very helpful without this.

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

SELECT DISTINCT
      SYS.Netbios_Name0
     ,SYS.Is_Virtual_Machine0
     ,Processor.Name0
     ,COUNT(SYS.ResourceID)
     ,Processor.NumberOfCores0
     ,Processor.NumberOfLogicalProcessors0
FROM fn_rbac_R_System(@UserSIDs)  SYS
JOIN fn_rbac_GS_PROCESSOR(@UserSIDs)  Processor on 
SYS.ResourceID=Processor.ResourceID
JOIN v_FullCollectionMembership FCM on FCM.ResourceID=SYS.ResourceID
WHERE FCM.CollectionID = @variable
Group By 
SYS.Netbios_Name0,Processor.Name0,Processor.NumberOfCores0,Processor.NumberOfLogicalProcessors0,SYS.Is_Virtual_Machine0
ORDER BY SYS.Netbios_Name0

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

Cheers

Stuart Watret




<Processor with Cores by Collection.rdl.txt>


Reply via email to