Josh,
If this is your Query:
USE [MSCRM_CONFIG]
SELECT ID FROM Organization
THEN
You need to change it to look at the correct Database. The query should be:
USE [OrgName_MSCRM]
Select SqlAccessGroupName, PrivReportingGroupName from OrganizationBase
This will fetch 2 names for you.
Example: Domain\SqlAccessGroup {GUID} and Domain\PrivReportingGroup {GUID}
Now with those names you can look the other Security Groups up. The {GUID} remains constant the prefix changes.
PrivReportingGroup {GUID}
PrivUserGroup {GUID}
ReportingGroup {GUID}
SqlAccessGroup {GUID}
UserGroup {GUID}
So now if you run
USE [MSCRM_CONFIG]
SELECT DefaultOrganizationId FROM Deployment
You will find the GUID which is being used in the AD after the Security group names.
I hope this information helps you. :-)
