Then scroll down to Orion.Nodes, where we will see the resource referenced in the hand-written SWQL statement I used previously. Let’s expand on the Orion item in the list: I just want to draw your attention to the fact that in this latest version of SWQL Studio (2.3.0.123), autocompletion is also possible.Ī lot of the power of SWQL Studio however, lies in the fact that the necessary data can be viewed graphically.
Sql studio how to#
We will talk more in the next post about how to write queries. In the below example, I typed out a simple query. You can click Query-> Execute in the menu.From here, you can type in SWQL, and execute the query to see the results. To the right of the object list you will see an editor screen. Note, the list of objects will vary depending on the modules installed and the versions of those modules. Once connected, you will see the server you connected to, as well the credentials you used, and if you expand on this connection icon, you will see the various data sources represented. Any changes to the database schema are abstracted from the user.Separate logins to the actual SQL database itself are not needed.By accessing via SWIS, instead of SWQL itself:
The connection itself is made to SWIS on the server (the same Information Service covered in the previous post). Once installed, connect it to your Orion server (of course, you will be working on your special dev server).
Sql studio install#
Just navigate to the “releases” area of the GitHub site ( ) and download and install “OrionSDK.msi” on your Windows workstation. SWQL Studio is a Windows -based utility, and is included with the Orion SDK.
Sql studio code#
And the site is also frequented by not just SolarWinds staff and THWACK MVPs, but other users who can also provide feedback and guidance on code that you may be working on. You can often find code samples that may address your use case by simply searching the forum. However, that does not mean you are alone. SolarWinds does not provide pre- or post-sales support on any customisations, including code using the Orion SDK. The other main resource is the Orion SDK forum here on THWACK. It’s also where issues are tracked, so if you do find a bug you can flag it as an issue there. The GitHub site is the main resource, where you can download the installer, browse code samples, and review the schema and wiki for the SDK itself. This free utility is simple to use, but can drastically lower the barrier to creating and editing SWQL queries.īefore we go any further, it’s worth highlighting two key resources for using the SDK. Today’s post will focus on first installing and then navigating through SWQL Studio. Greetings! And welcome to the second in our series of primers on customising the Orion Platform.
0 kommentar(er)
