SWQL Case statement used in EOCHas anyone successfully used case in SWQL in the EOC that is willing to share code snippet? My team has been struggling with this and I think this is the answer to one of my reporting problems. Thank you
Reporting - 12 hour and 24 hourOur organization is rated on availability of servers. We have SLAs that state we have to feed reports to them on whether a node is up, or down. We would need data from 2 solarwinds sites, both which are added into EOC...
Authentication - EOC 2.1Hey jblankjblank, In the old EOC there was an option under the Manage SolarWinds Servers to 'Import Active Directory Accounts from this SolarWinds Server into EOC'. Is that hidden somewhere in the EOC v2.1? H...
EOC Pass through AuthenticationSo when setting up a new user for EOC, there is a place to specify the account for Orion Instance 1 and Orion Instance 2. All of these user accounts are AD accounts. So these accounts will chan...
Thread multiple count statements in SWQL and columns
multiple count statements in SWQL and columnsIn SWQL Studio, both queries work fine. However when I try to make these to queries one table it fails I breviated column names in example below. I tried a lot of varaiations that is why I just broke it down to its ...
Database stress testBLUF: I'm looking for a way to test the database for latency without generating network traffic. I'm familiar with, but not proficient with databases, and I don't really know SQL. I've laways been a hardware/s...
EOC, SQL, SWQL for reportsWe have a report written in sql that use to reside on a MS Reporting server. The frame work is as follows in SQL ;with BaseQuery as ( select distinct n.Caption Node_Name, n.Description, p.Network_Zone, ...
SWQL, EOC and Select commandsSince we have the EOC2.2, we are trying to convert some custom reports that we did in MS Reporting server to SWQL. We learned a few things. Custom properties do not appear in the nodes view when using the swql ...
EOC 2.2 Compatible Modules???I'm looking to figure out exactly which modules and versions are supported by the new EOC 2.2 release. I can't seem to find a list in their documentation like I've seen in other module releases. Even a list of which m...
Differences in SWQL in EOC?I'm the most interested in EOC to do unified reporting across different Orion instances. I tend to fall back on the raw queries to get to the data I want and while the lack of inclusion of SQL along with SWQL is...
Network Atlas 1.90.0.285Does anyone know how to convert a map created in 1.11.0.167 to 1.90.0.285? It seems, Network Atlas 1.90.0.285 incompatible with previous version.
Filter node in EOC 2.1.1Is there any place where you can define node level filter? In EOC 1.6.3 , you can edit option under Global Node Status In EOC 2.1.1, you can edit Enterprise Nodes but there is no filter either SQL/SWQL fil...
Nodes are showing unknownHi , Has anyone faced the situation whereby the nodes suddenly turn grey / unknown in enterprise console? This has been happening frequently. I have also made changes to ensure that none of th...
Dynamic SWQL filter based on URL link?Hi, Is there a way to build a template view with a filter based on a URL variable? Today we have 70 sites in Europe. I would like to have a view per site. This view should show me the resources - Glo...
Thread EOC 2.0 report preview crashes all Orion instances
EOC 2.0 report preview crashes all Orion instancesCase#00042056. Latest and greatest version of all modules. Loading a report preview (not a fully fledged report... which never finishes anyway) for SAM metrics within EOC against 3 separate Orion environme...
SWQL Query working on Orion but not EOCCan anyone point me in the right direction why this boiled down bit of SWQL code would work fine from one of the Orion instances, but fail when trying to run from EOC against all those same Orion instances? se...
Thread Email Alert Not Received After Setting Alert Schedule Time
Email Alert Not Received After Setting Alert Schedule TimeHi I have setup an alert that emails me when a device is down. The alert works correctly. I have now edited the alert and have added a schedule to only trigger alerts between 9am - 5pm. The issue I have ...
SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website,
you consent to our use of cookies. For more information on cookies, see our cookie policy.