jbiggley ✭✭✭✭✭

Chris: Thanks for the reporting tips -- they worked well for what I was trying to do. A little more tweaking and I think I'll have it down pat. Just as an FYI, Excel 2007 takes the XML file, creates a schema and imports the data natively -- no converter required! I was really impressed with the default layout of the…

You can always keep an eye out for new features https://thwack.solarwinds.com/docs/DOC-176899#start=125 And NPM12 is in RC1

dreeves​ you'd be wise to heed the advice of jeff.stewart​. Latency to your DB with remote pollers is super important. I would target <200ms from your polling engines to your DB. I think the documentation says 250ms but I might be a bit paranoid

At adatole​ said, I now manage the monstrosity that he built along with zackm​ and the rest of our Merry Band o' Misfits. The unofficial, official number we've been working towards is 140K elements. However (and this is really important) you are going to need to metric ton of additional polling engines (we have 17 and only…

The network is actually at a client site, so installing trial software there is probably out of the question. Are there any SW clients that are known to have Motorola Canopy networks? I just want to get an idea of the depth of information available on those networks. Thanks

I echo mharvey in that infrastructure design is key. When the NPM Administrators guide (http://www.solarwinds.com/documentation/Orion/docs/OrionNPMAdministratorGuide.pdf) tells you not to use RAID 5 storage for your SQL DB, listen. When it says allocate XGB of RAM or X CPUs, do that too. It is OK to run this is a virtual…

Hey Lukas, I tried to get that custom SWQL macro to work but it would not render into a value. I ended up falling back to a SQL custom value for both the cluster and vCenter name. I did notice that the alerting engine only says 'Insert custom SQL' not 'SWQL' -- is that an NPM 12 feature?

Thanks Lukas. Do you need me to open a ticket for this or is it already added as a bug?

We did, but ran into exactly the problem you alluded to in your message -- SNMP service restart feigns as a server restart. Need something a little more complex, unfortunately. Josh

I don't, sorry. UCS gives me the heebee jeebees

Fortunately it only generates one line per cycle -- like updating a DB table -- but you could simply change the last 1 to last 2 or 3, etc. It's gets to be a little more tricky if the update is a variable number of lines.

That's the ticket! Between the comment from bsciencefiction.tv and changing to object type, this worked like a champ! Gold stars, all around.

Aww man -- my lack of SQL query showing for all to see! I might have to change that standard...

The idea was to group specific application monitors together (in this case for an HA cluster but looking forward I want to group our applications together into application services so that we know when a service is compromised not just an individual application). I had expected that a selected group in AppStack would show…

I opened case 706290 so that I could attach the files. Let me know if you need additional details.

Ahh, you type and screenshot faster than I do! Multi-tasking fail...

I wouldn't do this via SQL, do it via the SWIS API if you want to do it programmatically. Orion SDK 2.0 released on GitHub Why? Because the SWIS API ensures that you keep all of the things in order. If you make direct DB edits to things that are tied across multiple tables you will break things...badly. You can also use…

I'm heading off to a client to do the exact same install. Where did you find the WWN? It'd be great to be able to nip this one in the bud ahead of time. Thanks.

What sort of error are you getting? We run this in our environment without an issue. Can you run the component pieces of the script against a target computer from PowerShell on your primary polling engine? Do they work? You should be able to run Invoke-Command -ComputerName ${Node.DNS} –Credential ${CREDENTIAL}…

Interesting, although the Win32_PerfRawData_PerfProc_Process class is not available on this server and I suspect that it might be along the same lines as aLTeReGo posted about back in March 2010. I'll take a look and let you know.

Source IP, no. In our case it doesn't matter because the security groups allow all of our core subnets to AWS. We're lucky enough to have AWS as a LAN extension (VPN connected and via DirectConnect coming soon) so I don't have to worry about that pesky thing called the Internet Yes, we are definitely on a different subnet…

I find that more and more of my posts here start with some level of ominous overtone. It's like I've collected on the easy things, now its on to the things that make your brain hurt!

First, the level of awesomeness on this reply is beyond awesomesauce level. Now to the nitty-gritty details. Yes, I can Enter-PSSession -ComputerName fqdn -Credential (Get-Credential domain/user) and connect direct to the AWS instance from the polling engine. Yes, the polling engine is permitted in the TrustedHosts. (Found…

lbrowne‌ behold the mind of adatole‌! c25g_1xRtt_dBm 1.3.6.1.4.1.9.9.661.1.2.6.1.1.1 Current 1xRTT RSSI value. c3g_c2i_ratio 1.3.6.1.4.1.9.9.661.1.2.6.3.1.12 Carrier to interference ratio. Carrier-to-Interference ratio (C/I) is the ratio of power in an RF carrier to the interference power in the channel. c3g_EvDoRssi_dBm…

Chris, could you post the xpath query details? I have a sneaky suspicion that there might not be any hosts in our production environment that have this value set.

Interesting. I just dug into some of my hosts and I do not have queueDepth listed. Checked a bunch of hosts in the same cluster. Hosts are running 5.1. Any ideas?

OK, that corresponds with DQLEN via ESXTOP, but can you really dazzle me and show me the historical view of the %USD for the same LUN? I couldn't find in the API reference, but that doesn't mean that it wasn't hiding in there some place. I assume that AQLEN is not available? VMware KB: Checking the queue depth of the…

I sent support the link to this Thwack post -- hopefully they are reading along

One of my coworkers has a few exciting ideas that would leverage stored procedures and/or custom tables. When we finally develop a solution, we'll be sure to post it here.

Whoa -- I just tried this on another query for checking when SNMP stops responding and the CPU time jumped from 63ms to 3624ms. Did I do something wrong?!? SELECT Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name FROM Nodes/*SplitMarker*/left join (select CPULoad_Detail.NodeID, MAX(CPULoad_Detail.DateTime) as LastCPU from…