ORION 301: DATABASE & AUTOMATION Custom Reports & Orion SDK

Day 1

Orion Core
Database

Day 2

SQL Server
Reporting Services

Day 3

SQL Server Reporting Services (Continued)

Day 4

SolarWinds SDK

WHY PUBLIC TRAINING? The training is a comprehensive overview and detailed explanation of utilizing the database for custom reporting and alerts. Each class is led by a Certified SolarWinds Professional (SCP) with experience working on hundreds of unique Solarwinds® environments for companies of all sizes from small to large enterprises.

FEATURES & BENEFITS • Design/Implement custom reports & review Orion SDK
• Hands-on learning lab with customized equipment
• NPM, SQL Server Reporting Services (SSRS), Orion Software Development Kit (SDK)
• Breakfast and Lunch provided each training day
• Led by an SCP instructor with years of field experience

SolarWinds Training Course Modules Covered - NPM, SQL Server Reporting Services (SSRS), Orion Software Development Kit (SDK)

ORION 301: DATABASE & AUTOMATION Custom Reports & Orion SDK

The Orion 301: Database & Automation  class is geared towards students that have extensive experience with the SolarWinds platform, but want to do a deep dive into topics such as: NPM, SQL Server Reporting Services (SSRS), and the Orion Software Development Kit (SDK).

While our Orion 101, 201, or 202 classes are not a prerequisite, students will be more successful with an advanced understanding of the SolarWinds platform as this course will not cover installation and basic overviews. Students will also highly benefit from a basic understanding of the Transact-SQL and PowerShell languages, but neither is a requirement.

Download a PDF Copy of the Syllabus Here

Day 1: Orion Core Database

Installation of NPM

Orion Database Schema Review

  • Tables and Data Rollup

Orion Database Manager vs. SQL Server Management Studio (SSMS)

Best practices for Orion Database Management

  •  Creating Database Backups and Maintenance Plans

Day 2: SQL Server Reporting Services

Installation of SQL Server Reporting Services & Report Builder Authoring Environment

Introduction to Transact-SQL Language

Orion Database Schema Review continued…

  • Views, Stored Procedures, and Functions

Introduction to Report Builder Authoring Environment

Day 3: SQL Server Reporting Services (continued)

Creating Basic Reports with Report Builder

Creating Parameterized Reports with Report Builder

Embedding SSRS Reports into the Orion Website

Creating Advanced SQL Alerts with the Web Alert

Engine

Day 4: SolarWinds SDK

Installation of SolarWinds SDK

Introduction to SolarWinds Query Language (SWQL)

PowerShell and SolarWinds SDK

  • Connecting to SWIS
  • Querying SWIS
  • Updating SWIS

Let's Talk. Take the next steps in your SolarWinds Journey today!