Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Does anyone know where we can find an ERD for the ORION DB (Primarily SAM) Application/Group Members/Nodes, etc?

dcottle

Find more posts tagged with

sql

Database

For the Novice

Comments

KMSigma.SWI

You won't find it. It's something that changes version to version. This is why we suggest people use the [mention:611dcbeac4a744629d169bd937026c93:393e7426ce8b492199490c0b60cb1f1e] if they need to query the data sets.

kjamil

Never too late..... Unfortunately no ER diagram or data dictionary, however SolarWinds do provide SWQL by mean to manipulate data, see below there is a very useful namespace and take a note of summary column.

head hear for more information https://github.com/solarwinds/OrionSDK/wiki

vabguagas

@ backrooms Check the official documentation provided by the developers of the ORION DB or SAM application. This is often the best source for accurate and detailed information. Engage with community forums or developer groups related to ORION DB or SAM. Members might have shared ERDs or similar diagrams in the past.

Quick Links

Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Cisco ASA SSL Tunnels
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches