It's now easier than ever to manage billing for all your 3rd party suppliers using our generic CSV import tool. Although most suppliers can offer you a CSV file out of the box, some might need a little extra help.
In this post we'll show you how to get usage information out of Veeam Backup & Replication console. In this example we're selling virtual machine backups and bill our customers based on the reserved storage quota (1) and the number of processed VMs (2), as reported by our Veeam Admin console.
We'll use a short PowerShell script to connect to our Veeam Backup & Replication admin console and export the data out of it.
Before you get started
Make sure you can install and run the PowerShell script in a user context that has direct network access to your Veeam Backup & Replication admin console.
Veeam only offers a PowerShell Snap-In at the time of writing. To use it you need to run Windows PowerShell 5.1, which is still the default version on Windows 10 and Windows Server 2019.
PowerShell Core 6 and up no longer support Snap-Ins. You can check your PowerShell version with the following command:
Get-Host | Select-Object Version
Install and run the script
Download our PowerShell script and save it on your server. Open up PowerShell and browse to the directory where you stored it, for example:
Run Get-Help to verify the script and see how it works:
Get-Help ./veeam-to-csv.ps1 -Detailed
Now we're ready to export our CSV file with only a single command:
This assumes that the Veeam console is running on the same machine and that the user has the required privileges to connect to it. If you need to specify a different server or user credentials, you can pass these using the script's arguments.
./veeam-to-csv.ps1 -Server 192.168.0.15 -User foo -Password bar
Refer to the output of the Get-Help command above to read about all the available parameters.
The script will show you the collected data and store a CSV file in your home directory by default. The last line of the output will contain the full path to the CSV file.
You can also choose a different target directory using the -OutputDirectory parameter:
./veeam-to-csv.ps1 -OutputDirectory "c:\scripts\goolash\output\"
Import your data in Goolash
Now you have all you need to start syncing with your Autotask contracts. Grab your newly minted CSV file and head over to the Goolash application.
Go to the Import tool, create a new Vendor called "Veeam Backup & Replication" and select your CSV file.
In the next step, we'll have to map each column from the CSV file to the right field:
- User ID maps to Customer ID
- User Name maps to Customer Name
- Units maps to License Count
- Product maps to both Product Name and Product SKU
Press the "Preview import" button to verify the data. If you're happy with the results, press the "Import Data" button.
You'll be redirected to your imported data:
Configure the synchronization
You're almost done. Map the Veeam products to your services in Autotask on the mapping page and link each customer to their respective Autotask account. That's it!
Goolash remembers your field mapping, so it 'll be even easier to update your records next month. Export your Veeam usage data, upload the file and we'll automatically update your contracts.
Share your thoughts
We'd love to hear your thoughts on working with Veeam Backup & Replication. There is more data available in the Veeam PowerShell Snap-In: take a look at their documentation if you'd like to get your hands dirty.
If you need help setting up this script or have ideas on how to extend it, don't hesitate to get in touch. We're always happy to help!