Another one… Use this for daily SSRS subscriptions because I’m too lazy to log into the server to check. Plus there’s no aggregation available on the product..

SELECT convert(date,CreatedOn, 1), CM_NAME as 'Triggered Email Name', COUNT(cm_triggeredemailid) as 'Total Triggered'
FROM [xxx_MSCRM].[dbo].[cm_triggeredemailBase]
WHERE CreatedOn >= getDate() - 1
group by CM_NAME, convert(date,CreatedOn, 1)
order by 1 desc

December 15, 2015

SilverPop (CoreMotives) – Dynamics CRM 2013 SQL -Triggered Emails Count

Another one… Use this for daily SSRS subscriptions because I’m too lazy to log into the server to check. Plus there’s no aggregation available on the […]
December 15, 2015

SilverPop (CoreMotives) – Dynamics CRM 2013 SQL – Submitted Data Extract Query

Ran into a limit using the CoreMotives web form result export button from our on-prem CRM (2013) deployment so I wrote a little SQL script to […]
March 3, 2015

CRM Email Router strikes again

Spent a day and a half trying to figure out why our CRM Email Router hasn’t been playing with others. Managed to find out why today. […]
March 3, 2015

iTrent / People Manager – Site not Responding.

Rare for me to blog something not Dynamics/SQL-y based, but this one is more of a note to self. Had an issue where 2 departments were […]
March 2, 2015

Dynamics CRM 2013 – Anonymous SMTP

Run this on SQL: Update DeploymentProperties set BitColumn = 1 where columnname = 'AllowCredentialsEntryViaInsecureChannels' Update DeploymentProperties set BitColumn = 1 where columnname = 'ECAllowNonSSLEmail' Do this […]
March 2, 2015

If it doesn’t restart without wanting to install updates…

CTRL+R -> CMD -> shutdown /r /t 0 God bless command prompt. God not-bless windows updates downloading without permission. God bless me not having to manage […]
December 11, 2014

CRM 2013 / SSRS – The SELECT permission was denied on the object ”, database ”, schema ‘dbo’.

Ran into this issue yesterday whilst doing something I consider a cardinal sin (Writing CRM reports in SQL). No errors appeared whilst running the report in […]
December 2, 2014

500 internal server error – Interesting one

Have been deploying an upgrade to an application, had a few issues with SQL report performance (Which our DBA kindly fixed) – Not the overall issue. […]
November 28, 2014

CRM 2013 – The attribute “” cannot be found for entity “”. Specify a valid query, and try again.

Working in a multi-tenant environment with CRM 2013 and have come across this error when trying to build reports. This issue was probably never an issue […]
October 22, 2014

Dynamics CRM 2013 – DisableSSLCheckForEncryption

Got a non-SSL enabled CRM deployment (Development server) with databases coming from an organisation/deployment with SSL enabled and encryption keys active. Try activating encryption without SSL […]