Greetings,
I am trying to put together a query to get the current disk space of our
servers and also their total size. I get as far as what is below then
get totally stuck. I don't know how to add the server names for the
objects in there. Is there an easy way to do this?

select
ObjectType.TypeID,
Object.RootMachineObjID,
ObjectType.Name,
Object.Status,
Object.String1,
Object.String2,
ObjectType.Header2
from
Object
left join ObjectType on Object.TypeID = ObjectType.TypeID
where
ObjectType.Name = 'NT_LogicalDiskObj'
And
Object.String2 is not null


--
abel5405
------------------------------------------------------------------------
abel5405's Profile: https://forums.netiq.com/member.php?userid=5035
View this thread: https://forums.netiq.com/showthread.php?t=55094