We often get requirement to move articles/Knowledge from any platform to Salesforce but somehow we miss inline links to update. This script is just a quick way to find such affected articles:
String artIds = '';
for(Knowledge__kav k : [SELECT ArticleBody__c FROM Knowledge__kav WHERE Language='en_US' AND PublishStatus='Draft']){
if(k.Answer__c!= null && k.ArticleBody__c.containsIgnoreCase('help.company.com')){
//system.debug(k.Id);
artIds +=k.Id+',';
}
}
System.debug (artIds);