kfiresmith
ADSM.ORG Member
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
select NODE_NAME from NODES where COLLOCGROUP_NAME is null and DOMAIN_NAME='$1'
THANKS! Worked perfectly. I just had to figure out that it wants the domain exactly, it's case sensitive!
- Kodiak
I turned this into a script, if anyone else is interested in keeping on top of collocation membership in an automated way:
Put this directive into a script named something like: find-nocollocg
Then all you have to do is run the script, which takes the domain name as a variable afterward, ie:Code:select NODE_NAME from NODES where COLLOCGROUP_NAME is null and DOMAIN_NAME='$1'
run find-nocollocg WINDOWS
Anyone have any tricky bash scripting skills that can make this only echo results if there are matches?
select distinct collocgroup_name, count(node_name) AS NUMBER from collocgroup GROUP BY collocgroup_name ORDER BY NUMBER