Anonymous_User Absent Member.
Absent Member.
939 views

Maintenance Mode on Linux not detected, only Windows


Running NetIQ AM with agents at the same level. I have an issue with
Maintenance Mode on Linux not being detected by a SQL query I run
against the database. The Linux agent has the cloud icon on it which
clearly shows that it is in MM, but my SQL query only picks up whatever
Windows AM agents I have in MM, but not the Linux server (which runs
CentOS 7). Here is my SQL query syntax:

Select 'Line Break' = '<BR>', Name
from dbo.Object with (nolock)
where TypeID in (2)
and Status &0x00004000 = 0x00004000
order by Name asc


--
toddheron
------------------------------------------------------------------------
toddheron's Profile: https://forums.netiq.com/member.php?userid=11298
View this thread: https://forums.netiq.com/showthread.php?t=55804

0 Likes
2 Replies
andy_doran Absent Member.
Absent Member.

Re: Maintenance Mode on Linux not detected, only Windows

TypeID = 2 means explicitly "NT Servers", so that is why you see no Unix servers. Use this:-

Select 'Line Break' = '<BR>', O.Name
from dbo.Object O with (nolock)
inner join dbo.fnListAllMachineType(1) T
on T.TypeID = O.TypeID
where O.Status &0x00004000 = 0x00004000
order by O.Name asc
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Maintenance Mode on Linux not detected, only Windows


Andy - the solution worked perfectly!!!! Thanks!!!! 😄


--
toddheron
------------------------------------------------------------------------
toddheron's Profile: https://forums.netiq.com/member.php?userid=11298
View this thread: https://forums.netiq.com/showthread.php?t=55804

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.