How can I find which user is Deployment Administrator?

There’s always the interesting step when you get to handle an on premise CRM that someone else set up. The system was almost always set up a long time ago, which in this case means more than three years, and no one remembers or knows which account that was used to set up the system.

 

What you need to do very often requires you to be deployment administrator, a term which no one knows what it is in the IT department of the customer. That is the normal case.

So, how do you find out which account it is that has the deployment administrator right? The answer is the following query against the MSCRM_CONFIG database:

SELECT * FROM SystemUser WHERE Name IS NOT NULL

It seems that the “Name” column is populated with the account name of the account that is deployment administrator. I’ve had a look at a couple of systems available to me and it has been correct in all of them.

Rickard Norström
Developer at CRM-Konsulterna
www.crmkonsulterna.se