Rubrik Automated IT Helpdesk Ticketing v1

存储架构 2018-03-07

Back when I last managed a virtual infrastructure one of my key responsibilities was managing VM backups. My first daily task was to verify backups from the previous night and resolve any failures. Some days this was easy, some days it was a pain, but the one constant was that the process always needed my attention which meant I had less time for fun innovative projects. I was carrying out manual processes just to keep my job and the business safe, and I only had a couple hundred VMs. Imagine the burden when you have thousands of VMs, SQL DBs, hosts? This is when you have whole teams for this task. Some organizations even have backup teams on night shifts!

That was 2011 and sadly, this daily ritual continues for many IT organizations. It’s now 2018, we have self-driving cars, strategic shifts in IT to automation and public cloud, yet we still manually click, click, click.

If you’re stuck in this rut then I have good news for you. There’s a better way! First, you need to switch to Rubrik and ditch those legacy backup technologies that have been around since the 90s, or still use a legacy architecture of proxies, management servers, catalog databases, non HTML5 interfaces, bolt-on APIs, single points of failure, bottlenecks, multiple silos of monolithic dedupe storage and generally just suck.

Next, leverage the Rubrik REST APIs and start consuming infrastructure as code to fully automate this once manual task. Yes, you can create pretty reports in the Rubrik GUI, but you still have to read them. So to help you get started I’m going to share with you a pre-written PowerShell script library that automates the following:

  1. Queries the status of each protected object (VM, DB, NAS, Physical host etc), applies your business SLA (I.E 24 hours), then determines whether the object is compliant by verifying a backup exists within the timeframe
  2. Automatically remediates the object by taking an on-demand backup (optional, disabled by default)
  3. Sends an email to your IT helpdesk to create a ticket for each group of objects not meeting the business SLA (I.E 1 ticket for all VMs not meeting SLA, 1 for DBs etc)
  4. Sends an HTML report to a different email showing all objects
  5. Outputs a CSV for logging the results

How cool is that? No more manually checking a report, creating a ticket, and fixing the backup. Whether you have 100 VMs or 5000, this is exactly what you should be automating in 2018 to increase the value of you and your business. It even tells you how long since the last backup, total backups, and lots of other useful info too. So where do you get this script library? Download it here:

Unzip the file to “C:RubrikAutoTicketingv1” so you don’t have to edit the file location variables. No modules are required for running the scripts as they leverage the REST APIs of Rubrik natively. In the folder you’ll find the following files:

  1. RubrikAutoTicketingv1-Auth.ps1
    – Run this first to securely store your Rubrik and SMTP credentials (cancel the SMTP prompt if creds are not required).
  2. RubrikAutoTicketingv1-Settings.ps1
    – Configure the variables in this script as per your environment, including Rubrik IP, email addresses, SMTP server, authorization, enabling/disabling email, CSV output, and auto on-demand snapshots.
  3. RubrikAutoTicketingV1-xxxx.ps1
    Configure the $ScriptDirectory variable at the start of each script (if you didn’t unzip to “C:RubrikAutoTicketingv1”) then schedule/run on the frequency required. Each script only reports on the object identified in the title, I.E VMwareVMs, NAS, SQL. If the Settings.ps1 file isn’t found the script cancels. If you want to override any setting from the global file then copy it to the individual script after the settings import section.

Here you can see a VM report: And a failure report on my physical host backups (due to the recent power outage in Boston where the host didn’t come back on): Let me know if you found this useful and if you haven’t switched to Rubrik yet; don’t backup, go forward.



Comparing high availability for Google Cloud SQL a... Cloud SQL is Google Cloud’s DBaaS platform that supports MySQL and now PostgreSQL in beta. RDS is AWS’s DBaaS. They both have “high availabili...
How do I learn #SQL for #data analysis? Step 1: This is a good starting point: SQL School Table of Contents OR, this: Learn SQL Both of th...
SQL Select percentage of total based on location I want to solve the following question: Give for each sports type the percentage of events in region 10 against the total number of events for that ...
Identify System Object Differences Between SQL Ser... By: Jeffrey Yao | | Related Tips:More > Upgrades and Migrations Trends in Database Administration - How Do You Compare - Click To Fin...
SQL Server – Detach/Attach Gotchas! One would think that detaching and attaching databases is one of the simplest things to do. It is. However, there are so many things that can break by...

责编内容来自:Virtually Sober (本文源链)
本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。