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

Solarwinds API for Group Availability report

I am currently working on Solarwinds to Sharepoint integration to update the monthly SLA for different group created in Solarwinds via an API call from share point.

Please let me know anybody know API query which can call from Sharepoint,

ServerIP:17774/.../Query.......

I have created manual report for the group availability, however I am trying to automated this.

Find more posts tagged with

Sharepoint Integration

Accepted answers

All comments

shahi-d

I would like to get a reply for the below query via API,

SELECT AVG(PercentAvailability) AS [Group Availability] FROM Orion.ContainerStatus OCS Where OCS.Container.Name Like '%Corp Network - US%' AND OCS.DateTime BETWEEN GETDATE() - 30 AND GETDATE()

Seashore

I would suggest you download SWQL-studio if you haven't already: https://github.com/solarwinds/OrionSDK/releases

In SWQL Studio, you can run your query normally but you can also go to menu "Edit" / "Copy Query AS" / "Curl..." to get the query in a format suitable for this usage.