derhally

rsprim, Sorry but looks EOC hasn't been updated to add support for some of the functions that you are using. Orion is a little a head in functionality than EOC's service. Specifically functions like Floor Ceiling are not part of the EOC grammar. At this time it isn't possible to run a query like the one you want.

You will have to change the entity names to the corresponding ones from EOC. e.g. EOC.Event and EOC.Node., Also will have to use the OrionID in the join statements to make sure the data lines up correctly. You should be able to test your query using SWQL Studio, just make sure you select "EOC" from the Server Type dropdown.

I'm not sure what's causing that error to happen. You can try shutting down the Job Engine Service and Job Engine Scheduler, and restart them in that same order. If that doesn't fix that, you may try deleting the Netflow server from EOC and re-adding it.

That's great. :)

 This is one difference between Orion and EOC. EOC uses a slightly different filtering language, but it is very similar to sql. You just need to qualify your property with the "Node.". You can get more information in the documentation. http://www.solarwinds.com/NetPerfMon/SolarWinds/EOCAdministratorGuide.4.37.htm I'll take…

Sorry, there isn't a workaround at this time.

There is a "releases" link in the middle of the bar area that is above the green button labeled "Clone or download"

Sorry about that, you can definitely find the samples in the the "Source.zip" on the same releases page.

Do you get the same error if you create the http operation manually? What do you see when you use the "sh ip sla statistics <operation number>" command? What IOS version are you using?

I apologize for not actually testing this out, but does this work for you if the subquery in the where clause is converted to inner join like SELECT pec.componentid, ( pec.avgioreadoperationspersec + pec.avgiowriteoperationspersec )AS avgiops, pec.timestamp, cst.componentprocessname, cst.componentprocessname + ' from ' +…

Please open a ticket with your use case for importing data into UDT and the team will look into, but as of now there is no way to do it.

By default, EOC will show a warning sign when any of the objects under a grouping have mixed status. To workaround this behaviour you can filter out nodes that are in an unmanaged state by changing your filter to be Node.Status <> 9 to hide any of those nodes. The different numeric values for status are Unknown = 0 Up = 1…

Are you using windows or orion built-in user credentials when logging in with Basic HTTP binding? Does the delay happen regardless of the account type?

You can go to the account manager in Orion. http://<orionserver>/Orion/Admin/AccountManager.aspx Select the account you are interested in and click the "Edit" button. Scroll down the page and you will see a "Report folder" setting. By default Orion accounts do not have reports assigned to them. You can assign the default…

Does SWQL Studio work for you if you try to use the HTTPS endpoint?

In our investigations with PRI modules, we've found that the cpmDS1DS0UsageTable is not really supported on 3800s or less. There is an open issue with Cisco, ticket # CSCee46303, that describes the issues with the ciscoPopMgmtMIBObjects MIB on those type of devices. From what we've been told, that MIB is not reliable…

I've entered your comments into our bug database. Thanks for the feedback.

Did you check the identity that is assigned to the application pool that is being used by EOC's website. By default we use the default app pool. You may just want to double check the account being used there to see if it hasn't changed. The account that you use to log into EOC is not the issue, it is the account that the…

In my test, I passed in the following AA:1 2013-12-06T16:26:00Z 2013-12-06T16:28:00Z false Note that my date values end with the letter Z indicating the time is in UTC. Otherwise it would be treated as a local date and converted to UTC giving you the wrong date range. To verify this you can run your script and then verify…

The REST endpoint would be more straightforward and easier to integrate with than the SOAP endpoint. The SWIS v2 endpoint is deprecated and likely to be removed in the future.

Take a look at the Orion VoIP Collector Services resource. It should have a column "Last Registered Time" That time should be close to current time. If it is more than 15 minutes old, then the there is an issue with your VoIP/IP SLA issue. If it is recent, then EOC is probably misinterpreting that value.

You can do it by editing the SwqlStudio.exe.config file that is located in the same directory as SWQLStudio. Look for the xml that looks like this <setting name="OperationTimeout" serializeAs="String"> <value>2</value> </setting> and change the text in the value element from "2" to the number minutes you think you need.

Is SNMP support enabled for Call Manager. I have't had a chance to configure 7.0, but in CUCM 6.1 you had to manually go an enable it.

Correct. If you use DPAPI, only the account that does the encryption can decrypt it. If you want to share encrypted data between accounts then you would need to use one of the other encryption techniques like using a certificate to encrypt the data.

Cirrus.Nodes represents a node that is being monitored by the NCM product.

The more nodes and interfaces the more data will be exchanged between Orion and EOC. Also the amount of Events, Syslog, and Traps may affect the data size. We are working on reducing the amount of data being transferred. I've been collecting statistics about how much data will be transferred based on the size of the Orion…

No offense taken. :) However it isn't a simple task. I'll make sure the PM of EOC is aware of your comments regarding this.

It may be a pain but can you try putting the date as a string literal instead of GETUTCDATE() For example, SELECT TOP 5 Flows.Application.Name, Flows.Application.PortName, SUM(TotalBytes) AS TotalBytes, SUM(TotalPackets) AS TotalPackets FROM Orion.Netflow.Flows WHERE Flows.ProtocolID IN (6, 17) AND…

Can you try with a more recent version of the sdk. You can find it here.

I just noticed your message has the "query" element as "c-gensym3". How are you generating the soap message?