How to send a backup of a Barracuda NG Firewall via email

How to create a backup of the firewall:

How to build an email with attachment with bash and openssl:

How to send an email via Netcat:

Rebuild indexes from SolarWinds Orion Server

SolarWinds sell a great solution for monitoring your network and your servers, but regarding the maintenance of the server itself or its database, there is a leak. After serveral months of intensive utilization, indexes from all tables become fragmented and the responsiveness from the SolarWinds Orion decrease a lot. At the beginning, in less than 10 seconds everything was finished but now, you can have a break and take a coffee and be back to see slowly the result.

I decided to build a script (Basic MS SQL) to select the most fragmented table (and the most heavy) and to build the “Rebuild script”.

It’s not perfect (it’s crappy, I know) but it solved my problem.