Running MP2xml.exe in NON-MOM management server

Someone in MOMcommunity.com asked us if we could run the MP2XML.exe outside the MOM Management server. So here is how you do it.

To run MP2xml.exe outside the MOM management servers do the following.

1) Copy the following DLL's to the MP2XML.exe folder.
2) Register the DLL's (some of the DLL's may not register)
3) Run the MP2XML.exe.

CMSupportCom.dll
EemConfigSnapIn.dll
EemConsoleSnapIn.dll
EEMEnginePS.dll
EemGuiCommon.dll
EemMonitorSnapIn.dll
EemRulesSnapIn.dll
MOMCommon.dll
MOMConfig.dll
MOMEngine.dll
MOMMPSupport.dll
MonitorGui.dll

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

How to query the list of servers currently monitored in NetIQ QDB database?

The below query will give all the currently monitored server names of both UNIX and WINDOWS server.

Execute the following query in the MSSQL query analyzer.
"Select name from object where typeid = '2' or typeid = '16'"