...

Alle Emails aus antony und dem Dateisystem löschen (über Navicat und Powershell)

1. Pfade im Dateisystem aus Datenbank holen und das Ergebniss in einem administrativen Powershell-Fenster ausführen

   Code Block
   language sql
   select CONCAT("Remove-item \'", SUBSTRING(guid, 1, 2), "/", SUBSTRING(guid, 3, 2) , "/", REPLACE( SUBSTRING(guid, 5), "-", "/"), "/\' -Recurse -Force") FROM instance_properties_attachments WHERE addin_id=3

2. Daten aus Datenbank löschen

   Code Block
   language sql
   DELETE FROM email_messages; DELETE FROM email_addresses; DELETE FROM `email_message-email_account`; DELETE FROM instance_properties WHERE instance_id=3; DELETE FROM tlstatus WHERE instance_id=3; DELETE FROM instance_properties_attachments where addin_id=3

Alle Termine aus antony löschen (über Navicat)

...

UPDATE
	tlstatus
		INNER JOIN instance_properties ON 
			instance_properties.instance_id = tlstatus.instance_id and 
			tlstatus.instance_id=3  AND 
			instance_properties.object_id = tlstatus.object_id AND 
			instance_properties.direction = 2 AND
			tlstatus.is_resubmission=0 AND -- nicht wiedervorlegt
			tlstatus.resubmission_date is null AND -- keine wiedervorlage eingerichtet
			tlstatus.is_globalize=0 AND  -- nicht geteilt
			instance_properties.chatsession_id=0 -- nicht geteilt
 
SET tlstatus.resubmission_sort_date = instance_properties.object_date
WHERE tlstatus.resubmission_sort_date is NULL