![Cron job schedule creator](https://loka.nahovitsyn.com/98.jpg)
![where does automize 9 backup where does automize 9 backup](https://s.pcformat.pl/g/x/a/2014/02/12/52fb8674ec63e0.22574929_800.jpg)
NOTE: A mail rule running a script is a LOCAL rule, and *only* runs on the particular machine it was created, while Outlook is open.Ĥ) The VBA script saves the message as a file called MSG.TXT file. This rule will moved backup status messages to a set sub-folder, and run a VBA script against it. We need our checks to be bullet-proof, and that starts here!ģ) A mail rule per customer within Outlook. This guarantees that each customer WILL have a backup check ticket created every day. It also allows me to easily run a report to see all backup checks for customers for any given period.Ģ) A scheduled script to create the backup check ticket. This allows me a quick and easy way to see if I have ANY backup check tickets that are open. The scheduled VBScript that creates the backup check ticket auto-sets that value to "To be checked". Within the database, Spiceworks names that field "c_backup_status". The default value is blank, with 3 other options to choose from: "To be checked", "Failed" and "OK". To achieve this, I had to create and schedule a script that e-mails the helpdeskġ) I created a custom field for Tickets, calling it "Backup Status". This is to ensure NO check slips through the cracks, or is forgotten about I needed to auto-create backup check tickets
![where does automize 9 backup where does automize 9 backup](https://www.spares.se/upload/A2/55050000771Q.png)
I achieved that with mail rules within Outlook, and running a VBA script from within a mail rule
WHERE DOES AUTOMIZE 9 BACKUP DRIVER
To read the Spiceworks DB directly, I needed an ODBC driver and a good, free one is available here:
![where does automize 9 backup where does automize 9 backup](https://cdn.down10.software/img/icons/antihero.jpg)
I needed to get data out of Spiceworks safely NEVER, NEVER and NEVER write directly to the database! Spiceworks natively supports this through e-mailing the helpdesk I needed a way to automatically insert data into Spiceworks safely I ALWAYS include the customer's name in the ticket, but where customers e-mail my helpdesk directly, the relate is done based on their e-mail address. I use "My Ticket Rules" to auto-relate a ticket to the relevant customer. In my Inventory view I can click on the icon for the "Customers" group to see all my customers, and at a glance I can see which customers have tickets related to them. This allowed me to relate tickets to customers. Each "customer device" I made a member of the custom group "customers" I overcame this by adding my customers as devices Spiceworks has no native support for multiple customers
![Cron job schedule creator](https://loka.nahovitsyn.com/98.jpg)