Are they custom groups? Those are manually listed via drag and drop and not a good idea for the reason you've just found. It's probably possible to find the remainder with a very complex SQL statement, but it's not enjoyable.
Best to use queries to set up all your groups based on OU or gateway address or something.
They are custom groups. My manager wants to send patches to 1/2 of a department, or floor at a time. So if a patch has a negative effect 1/2 of that department can still work.
I don't think it's possible with custom groups. I would do network gateway plus a regular expression on the system name until you get to 60/40 or so. http://www.droppedpackets.org/reports/use-regular-expressions-in-queries should help.
Have you organised your machine accounts in AD by department? If so, your query could look at the computer location. Otherwise you ned to find something else that can be used as an identifier.
Mark Star - http://www.marxtar.com
Home of Power State Notifier & Wake-On-WAN for LANDesk
You can use the following SQL query to find what machines are not in a custom group:
select devicename from computer where computer_idn not in
( select member_idn from CustomGroupComputer a left outer join Computer b on
a.member_idn <> b.computer_idn)
I do not understand. Can you walk me through the steps? I assume you are talking about making a new query in LANDesk.
Can this be done within the LANDesk console version 9.0? Is there a field that can be used in the Column Configuration?