Hi Antonio,
I had set up the DNS A record and rDNS on our server before installing the MacOS Server software and made sure that the Mac Mini's IP was static and the current IP is still the same on both the mac mini and the DNS record so I don't think that is an issue.
We are a single domain site.
We unfortunately do use .local in our domain and I am unable to change that at this time.
both the Server.App and Profile Manager show all the groups from Active Directory but they all show as having 0 members in them. E.G. the group 'All Staff' has every staff user in it when viewed on Windows Active Directory Users & Computers but shows no members when viewed on the Server.app or Profile Manager.
I did notice recently, and I am not sure what changed, that groups will show members if you right click on a group and go to Edit Group. The member list will populate after a few seconds but if you click ok it will ask for a username and password for that directory node. None of our AD administrator accounts work and neither does the Open Directory admin created with the mac server. The AD accounts bring up an error saying that the user is not an administrator on that directory node and the Open Directory admin will instead shake the popup as if the wrong password was entered. But it is not the wrong password because I am able to log in to the server using it.
Another thing I also found while testing some settings is that there is a primary group setting in Active Directory with the description "There is no need to change Primary group unless you have Macintosh clients or POSIX-compliant applications" I have set the primary group for a few staff accounts to 'All Staff' and a couple of accounts appeared in Profile Manager but others did not. I am not sure what is different between the accounts as all their properties settings are identical.
I have had a look at our groups in Directory Utility as you suggested and found that all our AD groups have users under the GroupMembership property. So I am able to see that users do appear in their groups but for some reason the MacOS Server software is not showing this. Could it be something to do with the authentication issue I mentioned above?
Thanks for taking the time to suggest a few things, I appreciate it.