There is the ‘Top Knowledge Base Articles‘ report in Dynamics 365 CE on-prem.
Now we want a report of E-mail messages that contain certain knowledge base articles.
So we want all the outgoing e-mails where a Dynamics 365 CE user has attached Knowledge Article XYZ, and all the outgoing e-mails where a Dynamics 365 user has attached Knowledge Article ABC.
It doesn’t seem to be achievable in Advanced Find.
Can it be done with a SDK executable?
Or with a SQL join statement? If so, does anyone have it handy? This is on-prem so querying SQL Server tables/views is possible.