NetIQ Appmanager - Query to find the Stopped job ID’s and the Server names

Below is the SQL query to find the Stopped job ID’s and the Server names in NetIQ AppManager.

select a.Jobid, b.Name from job a, Object b where a.status&0xFF=4 And a.machineobjid = b.objid AND ParentJobID IS NOT NULL AND ParentJobID <> 0

I have customized a KS which event/alerts if there are any stopped jobs and restarts then optionally and it also gives you the server name on which the jobs are stopped. Please contact me if you need the KS.

NetIQ - SQL Query to find Grayed Out machine in NetIQ AppManager

Below is the query to find the list of servers which are currently grayed-out in NetIQ AppManager.

SELECT Name FROM Object WHERE (TypeID = 2 OR TypeID = 16) AND Status & 0x40 = 0x40 AND Status & 0x08000000 = 0