Shell Programming and Scripting

I'm primarily a "Windows" systems administrator whose been getting his toes in the Linux waters. I am new to programming and advanced scripting so please bear with me and my incomplete example below.

I have exported all entries from our DNS zones. I used sed to remove everything other than the fqdn from the files. We have a few hundred hosts across a few dozen zones. Some hosts are not in all zones though.

I would like to use something like awk to determine which hosts are (or are not) in the domains I specify. Bonus might also be to accept input from a file (with the various domain names) but the simpler the better.

the file looks something like this:

host1.domain1.com
host1.domain2.com
host1.domain3.com
host1.domain4.com
host2.domain1.com
host2.domain2.com
host2.domain3.com
host2.domain4.com

and so on. And again, some hosts are not in all zones.

I would like to do something like:

Code:

awk -F"." '($2 == "domain2" && $2 == "domain3") {print $1}' filename

to figure out which hosts are (or maybe, are not) in the zones specified.

Obviously this script is incomplete. I can't figure out how to find duplicates from $1 and then search $2 for domain2 and domain3.
I want all duplicate (or triplicate or so on) hosts from $1 that match a few possible domain inputs from $2 to return, and nothing else. Since I may have the same host returned per domain a few times, if the result could be truncated to just the host once, even better.

I am not necessarily looking to be spoon fed a few completed examples though I wouldn't object. If you have a few ideas for me, I'd appreciate being pointed closer in the right direction.

Something like this?

Code:

awk -F"." '$2 ~ "domain2|domain2" {a[$1]} END{for(i in a)print i}' input_file

#or

awk -F"." '$2 ~ "domain2|domain3" {print $1}' input_file | sort | uniq

--ahamed

Genius!
The second one did exactly what I was looking for as it sorted and summarized more cleanly. This was a lot simpler looking than I imagined. I appreciate your help and I will be able to modify this for use in other ways so I appreciate it very much!

---------- Post updated at 11:51 AM ---------- Previous update was at 11:25 AM ----------

Oh, one thing I also need to be able to do is use && for $2, not just |. So I would like to be able to filter by host1.temp.local host1.temp2.org etc etc.
That way if I get the request, which servers are in these four domains, I can use the &&, specify the domains, and get a list of the servers.
With the | I may get servers in some but not all of the specified domains. Thanks so far!

I didn't understand what your second requirement was.

btw, you can use awk ... | sort -u instead of awk ... | sort | uniq

--ahamed