subject:"\[mssms\] Count physical disks"

Re: [mssms] Count physical disks

2016-12-01 Thread Stuart Watret

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,

Re: [mssms] Count physical disks

2016-12-01 Thread David Jones

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

[mssms] Count physical disks

2016-12-01 Thread Stuart Watret

Anyone share a bit of query magic I can utilise to count disks in machines, that’s all I need. Cheers Stuart Watret