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
mailto:dkjones9...@gmail.com>> wrote:
sorry that wasn't very helpful without this.
On Thu, Dec 1, 2016 at 9:35 AM, David Jones
mailto:dkjo
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.
>
> SELECT DISTINCT
> SYS.Netbios_Name0
> ,SYS.Is_Virtual_Machine0
> ,Processor.Name0
> ,COUNT(SYS.ResourceID)
> ,Processor.
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_PR
Anyone share a bit of query magic I can utilise to count disks in machines,
that’s all I need.
Cheers
Stuart Watret
4 matches
Mail list logo