Compare AD group Computers and XD Computers

I wanted to check an managment AD group contained all the servers from my XD site.

Get AD Group members
get-adgroupmember "group name" | ft name,objectguid | out-file C:\temp\servers.csv

Get XD Server List
get-brokermachine | where-object {$_.desktopgroupname -eq "DGname"} | ft machinename | out-file c:\temp\XDservers.csv

Then some playing in excel to match the data.