mrxinu

llinteau12​ - what's UP?! What about this?

Which report is this? Can you provide the entire original query and then what you changed it to?

Does it need to be a graph? Would a report suffice?

This would involve a custom report using the Report Writer. If you have a DBA, point him at the syslog table and then show him your reports. He'll know what to do at that point.

Maybe I need more information about your current alerting, but I would think you'd already have a blanket "Volume Overutilized" alert whose email action you could modify to repeat every 3 hours until it resets. Do you have more complicated alerting place where this change is less practical? -- Steven W. Klassen Programmer…

Orion only knows what it gets from the HOST-RESOURCES information that it gets back via SNMP. Could you run an snmpwalk against the server and see if you're getting the same information? I know that the handful of AIX hosts that I've worked with needed an entirely different SNMP daemon installed on an alternate port to get…

You'll want to make sure that you can get to those devices from the server where SolarWinds is installed because ultimately that's all that matters, right? You can download a copy of SolarWinds' Engineer Toolset and use its MIB Walk utility to try and query the device via SNMP and/or you could use the built-in wbemtest…

Hi there, What you're looking for is the out-of-the-box group & dependency function of SolarWinds. To do what you're describing you'd want to create a group that contains all the devices (dependents) and then create a dependency where the core switch is the parent and that newly-created group is the dependent. Once that's…

If you have inventories running you should be able to pull that right out of the database with a report. Try the query below in a report (or Custom Query resource) of type SWQL: SELECT EntityID, VLANID, VLANName, VLANMTU, VLANType, VLANState, NodeID, LastDiscovery, FirstDiscovery, MissingFROM NCM.VLANs To get a count of…

There's a program called 'whatamask' that does this kind of conversion. I would suggest extracting the information from the database, processing it with the program below and then using that in a report. The alternative is to read the section of code that's doing the magic below and then cobble it together with MS SQL…

Have you seen this? Product Upgrade Advisor | SolarWinds Customer Portal

This sounds like something that could be sorted out with a little PowerShell scripting. If you know what the names of the folders are going to be, they could be searched out with Get-ChildItem and the -Recurse option. Once the targets were found, the tests could be done and then reported back to SAM. One template that's…

See my reply at Is it possible to set high bandwidth alert for a node on specific interface ?

Do you have Server & Application Monitor (SAM) or just Network Performance Monitor (NPM)? If you have the former, you can use a WMI query against Win32_PageFileUsage. If not, you should still be able to get it via SNMP. The article here goes through the OIDs involved: Windows memory usage monitoring

May be unrelated, but you're re-using "Message.ProcessName" twice. Should the latter be "Statistic.ProcessName"? I wonder if the odd error goes away once the error below is fixed. Write-Host "Message.ProcessName: Process Name"Write-Host "Message.Processname:" $PN2 -- Steven W. Klassen Programmer Analyst @ Loop1 Systems…

You could get this from a PowerShell script pointed at your devices in your environment, but I'm not coming up with a way to integrate that kind of survey with SAM. Maybe someone else will jump in here. -- Steven W. Klassen Programmer Analyst @ Loop1 Systems http://www.loop1systems.com/ http://www.linkedin.com/in/mrxinu

Hi there sja​, I think your JOIN was off just a little bit. I've fixed it and moved the Owner bit down to the WHERE clause. Give this a try: SELECT Caption ,InterfaceDescription ,InterfaceAliasFROM ( SELECT ND.Caption ,NCMI.InterfaceAlias ,NCMI.OperStatus ,NCMI.InterfaceDescription ,NodesCustomProperties.Owner…

Your understanding of an interface's status going to 'Unknown' when the node where it resides goes down is consistent with what I know. This bit from the 10.3 release notes seems to speak to that, though. Maybe someone from SWI can chime in. "Defined dependencies are now properly respected in the event that a dependent…

Is it a specific component complaining or all of them?

Yes, the integration between NPM and NCM has nothing to do with your license as far as I know. You're just allowing your NPM web console users access to the details on the NCM side where the inventories overlap.

Hi there fpdell​ - you'd want to start by having a node custom property (Settings > Custom Properties > Add Custom Property > Choose Node > Type: String) and then once you've done that set it for all the nodes in your environment. From there, you can take one of the existing availability reports and tweak it to group by…

I totally understand your frustration. There are actually a few different locations for credentials depending on where they're going to be used. Off the top of my head I can think of three: the node credentials, the SAM credentials, and the VMware credentials (and the UCS credentials - make that four). The credentials you…

Unfortunately the advanced alert manager doesn't have any structure for specifying time periods so this would be a good candidate for a 'Custom SQL' alert. If you take a screenshot of your working alert I can give you the query to do what you need. The port number makes no difference, though. NPM isn't looking any closer…

Your options are to use Network Sonar Discovery and paste in the IP addresses or to use a scripting language and the SolarWinds API to add the nodes and the interfaces. If you decide to do the latter there are examples of doing both included in the SDK's samples folder.

See the reply over here: You Can Display Mailbox Database Size And Space Use For All My Mailbox Servers

When you say 'system admin' do you mean the admin user in SolarWinds or the local administrator on the server? I've had problems in the past authenticating with AD users. Try creating a user with the privileges for what you're need called 'apiuser' and use that instead.

Prevailing wisdom was that you didn't want to go any deeper than 3 or 4 levels deep. I don't know if that's because the map files were being parsed from the file system only when they were needed or if it was truly that complicated to get a bubble-up status on the nodes. Since 9.5 the map data is in the database, so I'm…

I should also mention that you can get the same effect by using a standard web report (I just spend too much time writing queries). If you create a report that includes all your Citrix hosts as a data source, and then you include the average CPU load field which will already have its data aggregation set to average like…

Absolutely! Use a little SWQL. You'll want to limit the query to your Citrix servers somehow (by vendor or maybe a custom property if the vendor varies). Here I'm limiting to nodes where the vendor is Cisco. SELECT AVG(CPULoad) AS AVG_CPULoadFROM Orion.NodesWHERE Vendor = 'Cisco' -- Steven W. Klassen Programmer Analyst @…

If we ignored the fact they're very different versions, merging the two data sets would run into issues with duplicate keys. There is no easy way to do this without doing a lot of massaging of the data (e.g., shifting the unique identifiers from one table by a lot to avoid overlap). Short answer: you really don't want to…