Wednesday, March 19, 2008

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

No comments: