Here is a short script that has to be executed against MSCRM_Config db to add a new deployment administrator: Declare @DomainName Varchar(Max) Set @DomainName = ‘Put new deployment admin login here’–i.e. ‘ContosoAdministrator’ Declare @Id uniqueidentifier Select @Id = Id From mscrm_config..SystemUser Where Name = @DomainName if (@Id is null) Begin Set @Id = NEWID() INSERT …
Tag: T-SQL
CRM Usage Report
One of customer wanted to have the possibility to see who and when was working in CRM. I knew that MVP David Jennaway had created such solution based on IIS’s logs. No matter how I tried – I failed to implement it. Logs weren’t written to log database. Also this approach doesn’t work in IFD …