Workaround for Datto RMM Reports PDF Corruption

Workaround for Datto RMM Reports PDF Corruption



Alert
As of 10/24/24, this will be done automatically via PowerAutomate. There's no longer a need to manually fix the Datto RMM PDF corruption bug. 


Background: The PDF reports that come from Datto are created on the Datto end in such a way that they get corrupted in Think Automation or when opened within an IMAP web interface. Forwarding them from another email address does not fix the issue. We need to download the PDFs as a zip file from the Microsoft email to a computer desktop and then attach the zip file to a new email and resend them to Think Automation. 

This must be done before the 5th of the month when the AT reports go out. 

Notes
Preliminary steps are no longer necessary as of 7/16/24

Preliminary Steps. (Please ask Roberta if you need help with this.) 

1. First, log into ThinkAuto Server. Open the folder C:\Users\Administrator\Documents\Reports.

2. For each customer folder, delete the most recent sub-folder. It should be the folder named after today's date. 

3. Log off the Think Auto Server. 

Main Steps


Part 1

Using OWA (not the Outlook app) go to the info@nygeekgirls.com mailbox inbox, and to the subfolder called Reports\Datto RMM.


In the inbox subfolder, there will be roughly 32 emails that came in overnight from reports@aem.autotask.net. They will have the subject starting with "Scheduled RMM Report:" followed by the customer name. You will ONLY be working with the emails that came in on the first of the current month. 

For each email that meets the above criteria, save all PDFs that are attached to the email to desktop as a single zip archive. Do this by clicking the "Download all" link beneath the attachments for each email. (You are creating a separate ZIP archive for each email's attachments.):




You should now have a collection of zip archives on your computer, one for each email that came in. 

Part 2


Now, for each email in the reports subfolder, perform the following actions. You may perform these steps from the Outlook desktop app if you prefer. 

1. Click forward. DO NOT change the subject line. Leave the forward tag in the subject.

2. Set the "TO" field to request@thinkauto.geekgirlsit.com . 

2. Delete the (original) attachments from the email to be forwarded. 

4. Attach the corresponding ZIP file from the desktop to the email to be forwarded. (Make sure the customer name in the ZIP file name matches the customer name in the email subject.) 

5. After confirming the ZIP file has been attached and the old PDF files have been removed, send the email to request@thinkauto.geekgirlsit.com .

Alert
ThinkAutomation is buggy. It can choke if it receives too many emails at once. So it's best practice to send our one or two emails at a time, rather than sending many all at once. You can "save" each email and then hit "send" when ready. 



Repeat this process for each of the (roughly 32) emails. 

Part 3: Verification


7. Log into ThinkAuto Server. Open the folder C:\Users\Administrator\Documents\Reports. Sort the folders by date (newest on top) and refresh to confirm that there is a subfolder for each dated the 4th of the current month. For any customer subfolders that are missing, check your work. If you did everything correctly for those folders, do the following:

  1. Resend the ones that did not process 
  2. If this does not resolve the issue, ask Roberta for help as it may be a TA issue. 



    • Related Articles

    • Customer Reports Workflow

      Workflow On the first of the month we have scheduled all Datto RMM reports to send with "Scheduled RMM Report: " followed by Autotask/Datto Company Name in subject. Recipient: Info@nygeekgirls.com . A PowerAutomate rule (RMMREPORTFIX1) processes the ...

    • Creating Autotask Monthly Report for New Customer (for use with Datto RMM)

      1. In Autotask Live Reports Designer, copy one of the templates from Monthly Reports Sent to ThinkAutomation to be Appended to Datto RMM Reports. 2. Change filters Contract: Account and Contract: Contract Name to the correct client. 2B. Confirm the ...

    • Datto RMM Monitors

      Auto-Resolution Feature This info is incorrect. I have seen tickets self-close after more than the "after X minutes resolve the alert" auto-resolution time. -RP Based on the parameters you set up (1 minute, 5 minutes, etc.) if the monitor checks ...

    • Creating Report in Datto RMM for Customer Monthly Report

      In Datto RMM portal: Analytics>Reports> Create Report. Name Report: Scheduled Report for [customer name]. Under Type, choose Individual. Schedule: click on "click to change" button. Schedule monthly for the first of each month to run shortly after ...

    • Useful Links for Datto SaaS Protection licensing (in progress)

      This is useful info for managing licenses for managing licenses for Datto Backup for Microsoft 365 and Google Workspace. Datto SaaS Protection: Viewing the Licenses tab on the SaaS Protection Status page: ...