Anonymous_User Absent Member.
Absent Member.
811 views

# of CPUs per NetIQ AM agent?

Looking for a SQL query to determine the number of CPUs on each NetIQ
AppManager agent host. Running NetIQ AM 7.0.1. Some of the agents run on
Windows physical servers, while others run on Windows VMs (about a 50/50
split).


0 Likes
2 Replies
Anonymous_User Absent Member.
Absent Member.

Re: # of CPUs per NetIQ AM agent?


There isn;t reaslly a way to distinguish whether or not an agent is a VM
or not - there are various things to look for (like the name of a NIC)
which can give about 90% accuracy. So the queries below are not going to
tell you whether an agent is a VM or not, just how many CPUs...

For Windows agents:-

select 'Agent' = P.Name, 'TotalCPU' = count(1)
from Object C with (nolock)
inner join ObjectType T with (nolock) on T.TypeID = C.TypeID
inner join Object P with (nolock) on P.ObjID = C.RootMachineObjID
where T.Name = 'NT_CpuNumber'
and C.Status &0x08000000 = 0
and P.Status &0x08000000 = 0
group by P.Name
order by P.Name asc

for UNIX agents:-

select 'Agent' = P.Name, 'TotalCPU' = count(1)
from Object C with (nolock)
inner join ObjectType T with (nolock) on T.TypeID = C.TypeID
inner join Object P with (nolock) on P.ObjID = C.RootMachineObjID
where T.Name = 'UNIX_CpuObj'
and C.Status &0x08000000 = 0
and P.Status &0x08000000 = 0
group by P.Name
order by P.Name asc


--
Andy Doran
Software Engineer Consultant (NetIQ)
------------------------------------------------------------------------
andy_doran's Profile: https://forums.netiq.com/member.php?userid=3937
View this thread: https://forums.netiq.com/showthread.php?t=47006

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: # of CPUs per NetIQ AM agent?

You're the man Andy, that worked.

"andy doran" <andy_doran@no-mx.forums.netiq.com> wrote in message
news:andy_doran.5rrulb@no-mx.forums.netiq.com...
>
> There isn;t reaslly a way to distinguish whether or not an agent is a VM
> or not - there are various things to look for (like the name of a NIC)
> which can give about 90% accuracy. So the queries below are not going to
> tell you whether an agent is a VM or not, just how many CPUs...
>
> For Windows agents:-
>
> select 'Agent' = P.Name, 'TotalCPU' = count(1)
> from Object C with (nolock)
> inner join ObjectType T with (nolock) on T.TypeID = C.TypeID
> inner join Object P with (nolock) on P.ObjID = C.RootMachineObjID
> where T.Name = 'NT_CpuNumber'
> and C.Status &0x08000000 = 0
> and P.Status &0x08000000 = 0
> group by P.Name
> order by P.Name asc
>
> for UNIX agents:-
>
> select 'Agent' = P.Name, 'TotalCPU' = count(1)
> from Object C with (nolock)
> inner join ObjectType T with (nolock) on T.TypeID = C.TypeID
> inner join Object P with (nolock) on P.ObjID = C.RootMachineObjID
> where T.Name = 'UNIX_CpuObj'
> and C.Status &0x08000000 = 0
> and P.Status &0x08000000 = 0
> group by P.Name
> order by P.Name asc
>
>
> --
> Andy Doran
> Software Engineer Consultant (NetIQ)
> ------------------------------------------------------------------------
> andy_doran's Profile: https://forums.netiq.com/member.php?userid=3937
> View this thread: https://forums.netiq.com/showthread.php?t=47006
>



0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.