8clover

In agreement with all, awesome job Danielle! Welcome to the bunch Maria!

This has been a bit of an issue depending upon where you use the query. If it is going through the information service and sticking to straight SWQL, you will need to reference the tables using Orion.Nodes, Orion.AlertStatus, and so on. The problem with this is that you may not be able to access all of the tables in the…

While you can't add items to the Node Details resource, you can add a resource for Custom Properties. I have included a screen shot below to show you what it could look like. Would this work for what you? If so, you will need to add the Custom Properties for Nodes resource to the view node details view. Once you have the…

Vinay BY is right, the documentation says to use *, but the % works just the same and is what native SQL uses. Old habbit on my part using the %. Either way, you should be getting some results. Assuming I'm looking in the same place, I edited a custom property on a couple of nodes to have variations of support1 and…

Sure can. There are a couple of ways to go about it. The below is not pretty, but is simple in that it builds off of what we already have. You can change the asc to desc to change the sort order select cast( ( cast( datepart( year, [DateTime] ) as varchar ) + '/' + cast( datepart( month, [DateTime] ) as varchar ) + '/' +…

The issue still persists. It was decided that traps from the device were the desired alerting mechanism for hardware/environmental related issues and no effort has been put into correcting NPM. We are running 10.4.2, so an upgrade might be of benefit for us.

Apologies, I think that I copied the wrong query in as I have my columns labeled incorrectly. Labeling a column as "as" won't work. I did have one question, what verion of NPM are you running? I have access to 10.4 and 10.6 and neither of mine have an ObjectName field in the Nodes table. Is this a custom property? When I…

I wondered if that was where you were going with this as I thought that my answer might be a little limiting. I have similar needs for a more granular security model, but I have yet to find a way to allow a user to manage certain nodes and not others using the same user account. Likewise, I don't beleive there are any…

To make the RackNumber and/or other Custom Properties viewable in NPM, you will need to add the Custom Properties for Nodes resource to the view node details view. Once you have the resource added, you can select edit it to show the desired custom properties. The Custom Properties for Nodes resource can be found under the…

This is not something that NPM can readily monitor. Not to say that it can't, it's more of a maybe depending upon what the com+ component is doing and how creative you are. It starts to cross over into the probably not the best setup. SAM is much more capable of monitoring something like this. Once again, depending upon…

Sure can. If I select the Group of Interfaces limitation, the page will load after a few minutes. Once on the page that lists out every interface in NPM, checking the check box for any interface is a 2 minute process as you wait for the page to respond. During this time, I get the below error message from the browser…

I agree with ZachM, there is not a great way of reporting on counts historically that is straight forward. His way would be to the best to begin tracking. One thing that might work for you would be to report on the response times and traffic utilization. This will rely heavily on your data retention settings. Below is a…

This might work for you: Support_Team like '%Support1%' or Support_Team like '%Support2%' I beleive the "like" and the "%" are what you are looking for to give you the wildcard filtering.

If I understand correctly, you will have an Additional Web Server (AWS) place in the DMZ while the rest of NPM is on the internal network. The overal process is pretty straight forward as an AWS is easy to setup. The biggest issue is going to be configurnig the firewall to allow the AWS to communicate with the rest of the…

This is always a fun problem because SWQL works the same, but the table structure and functions change. For the tables, it looks like you need to prepend them with Orion. Below is an example of this. It's not always Orion and may be different depending upon the tables that you are trying to access. You can install the SDK…

You can find this under Message Center. The event you're looking for is under the Audit Events section as Node un-managed. You can pick a specific node or you can just search for the un-managed event based on time range.

Leon is right, you need to add a group by statement. A straight group by on a date will group by the smallest time element, ususally second, and often does not give the desired grouping. Given your example, it looks like you want to group by 30 minute blocks. Not sure if you want just counts or the actual details. Below…

The below query, while not pretty, will give you the number of interfaces that are admindown, total interfaces and percent that are admindown. You should be able to plug this in to an Advanced SQL report select (select count(*) from interfaces where adminstatus = 0) as [Count],count(*) as [Total],(select count(*) from…

I'll throw my two cents in too. We also run 10.4.2 and ran into the similar problem where the queues would climb. Looking at the perfmon counters for various SolarWinds processes, you would see they would effectively stop processing anything. Ended up being an issue with database blocking. More specifically the NPM…

I have a similar issue where I have a large installation scattered around. I have yet to find a good solution within the Orion suite that allows you to bring this all together and customize the views as desired. It really sounds like you are looking for the executive, show me the problems at a glance, type of view. I have…

Building on your existing query, I added and additional where clause that should get you what you need. Give it a shot and let me know how it works. SELECT TOP 10000 Nodes.NodeID AS NodeID, Nodes.Caption AS NodeCaption, Cast(Device_Type As nvarchar(250)) as Device_Type, Nodes.LastBoot AS Last_Boot, DATEDIFF(day,…

Generically you can pull all accounts from the accounts table using the below query. select * from accounts More specifically, you can use the below query to get a general list of permissions. select accountid, accountenabled, allowadmin, allownodemanagement, allowcustomize, alloweventclear, disablesessiontimeout from…

I have seen similar issues. I have seen NPM say that both power supplies in a device are not working. Given that the device only has two power supplies, something is not reporting properly. I have also seen similar issues where NPM only finds certain hardware items on a device. In general, we don't depend on NPM for…

Reworked the query a bit. Try the below query and let me know if it works as desired. SELECTn.NodeID, a.ID, n.Caption, n.ObjectNameFROM Nodes nINNER JOIN APM_HardwareItem aON convert(varchar(5), n.NodeID) = a.NodeIDINNER JOIN AlertStatus asON as.ActiveObject = convert(varchar(5), a.ID) WHERE n.ChildStatus = 3 AND…

I know this question is a bit old, but I came across it looking for the same answer. You will need to reference the custom properties using Nodes.CustomProperties.property_name notation. Below is a query that will retrieve the caption and a custom field labeled state. SELECT Caption, Nodes.CustomProperties.State FROM…

In the Admin under the users account, you will need to setup Account Limitations. When editing the account, you will see a button labeled Add Limitation about half way down the page. If you only want the user to see that particular interface and its associated node, you can setup a Single Interface Limitation and they will…

You will need to give the group Node Management rights and then apply limitations appropriate for the nodes that they are managing. The tricky part is that the limitations will need to be of a dynamic nature such as the Node Name Pattern. If you use a single node or group of nodes, when the users add a new node, the will…

The sample you found is pretty good. To do recurrsive lookups on sub folders, the code that actually gets the files needs to be wrapped in a function so that it can effectively call itself for the sub folders. Below is the updated version of the code. My syntax may be slightly different, but it should get you what you…

You can setup an advanced alert and on the Trigger Condition tab, select Custom SQL Alert and Trigger query of Node. Then insert the below SQL in the bottom box: WHERE Nodes.LastBoot < Getdate()-300 You can set the rest of the alert parameters as desired for trigger actions and so on.

In general, you can physically put all the pieces in separate locations. The big issue is the connectivity between them. For instance, we have additional pollers in separate states with devices all around the country. It works for us, but the communications between the pollers and DB/Main NPM Poller all ride on our…