ouberlord

Agreed. It seems like realistically without any sort of proper user handling tools and permissions granularity it is entirely possible to "outgrow" NPM. People have made topics and requests specifically on node management granularity for three years now, but it never seems to make the cut in any capacity. Without a more…

In our use case, having all tasks under the root becomes problematic. We have servers dedicated to running scheduled tasks, and found early on that putting all of the tasks under the root makes finding the one(s) used for certain areas a pain. We thus have split them into various sub-directories. Echoing zackm, we would…

I've long been awaiting official support for such granular rights as well, and our organizational need for them has certainly grown over recent months. If anyone is interested in a stop-gap solution in the meantime, I've just published my efforts to this end on the content exchange: System to add granular node management…

From what I learned from a SolarWinds representative while I attended Orion training, this change is one of their most requested. However, it also requires an entire rewrite of their security model, which I would imagine is part of the reason that is has existed as no more than a request for so long. That said, I'd…

Same. Are the NPM 10.7 RC's still available?

I believe that NCM has the built-in ability to make changes to a config and apply it to the device. That said, I agree that either the line count should be a toggle-able option, or it should be presented in such a way that still allows for someone to copy a portion of the config via copy/paste without also grabbing the…

To my knowledge, as of right now no updated installers exist.

That's what's been said, but it remains to be seen. Either way, that DLL in question is the one known to be compromised. I would not advise anyone to try to manually put it in place. If you've already upgraded, you might be stuck until HF2 is released.

Excellent! That was the part that was needed. In the documentation I saw it was listed as UntilTime and UntilTimeUTC, but ToTime and ToTimeUTC seem to work great. Thank you for all of your help.

The top block of code (with just the "AND" clause that has ${FromTimeUTC}) works in that it both previews, shows up with the from dropdown, and works in the report. However, the one with two AND clauses (for ${FromTimeUTC} and ${UntilTimeUTC}) does not work and gives the "Query is not valid" error.

Scratch the last. I've gotten this to work (changing to multiple lines for better readability): WHERE [SolarWindsOrion].[dbo].[CustomPollerStatistics_Detail].[CustomPollerAssignmentID] = '6C4E621B-A7D3-439C-8402-D692BE67743A'AND [SolarWindsOrion].[dbo].[CustomPollerStatistics_Detail].[DateTime] >= ${FromTimeUTC} However,…

I've attempted to change the WHERE clause to the following: WHERE [SolarWindsOrion].[dbo].[CustomPollerStatistics_Detail].[CustomPollerAssignmentID] = '6C4E621B-A7D3-439C-8402-D692BE67743A' AND DateTime > ${fromtime} However, it will not let me preview or submit the new query, with an error of "Query is not valid".

Hello Simon, I know it has been a couple of years since this topic was active, but would you by chance still have that file laying around? The link in your post appears to no longer be valid, and we are looking to achieve the exact same thing that you seemingly have already accomplished. Thank you, -Tony

Eureka. This is not only a method that works without throwing an error, but is much easier to read and understand. I modified it by adding <Notes></Notes> and it works equally well if I populate it with $($Variable) or with $("Text goes here."). Thank you for the help. I was getting more and more lost by the day on this.

It seems as though the new functionality has some issues. Making a new thread (Options missing / nonfunctional from node Custom Charts driven by SQL queries) as it no longer corresponds to what the intended purpose of this one was.

Ah, so its the same type of functionality as the web reports; not displaying the output of the report itself. I had hoped I could reuse the same data sources as the ones I had built for the reports.

Man the holiday season has a way of sapping one's availability. I just finally got around to looking at that list, and sure enough the entries on that drop-down seem to sync up with all of the ones I have already encountered and documented. This gives me faith that the rest of the list is also the rest of the…

I don't see any loading state when clicking preview though something seems to flash by very quickly. It otherwise seems to go straight to the data not available output. Running the query in SQL Management Studio runs fine (its actually where I built the query in the first place before pasting it into Orion). The Custom…

You couldn't have seen it, but I'm pretty sure I just facepalmed so quickly it went supersonic. That's exactly what the missing piece of the puzzle was. As soon as I checked that box, the script ran like clockwork. I have no idea why I overlooked that checkmark, but thanks for pointing that out.

Figured it out! The issue stems from how Orion uses conventional ID numbers for most objects, but for Custom Node Pollers it uses what looks like unique identifiers (such as 01d8de05-4b07-4d07-98bc-32349f7820b4). Thus, when it tries to use one in a comparison it bombs out. To resolve this, I wrapped each Join On in a…

Well, I see something, but I'm not seeing where it fits. Near the end of a failure event in the log I am getting "System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting from a character string to uniqueidentifier." 

We do run SAM as well as NPM, I was just unclear as to which module what I was asking for was contained within. I will try a discovery and let you know how it goes.

Ah my mistake, I was unaware that function existed in NPM previously. Is there documentation on the list of SWQL functions available within NPM? My searches are coming up empty, and I'd like to have such a list as a reference now that I am diving into reporting.

Update: I've gotten it to work, but am still getting the XmlElement error. Here is my code: $query = "SELECT TOP 1 AlertDefID AS DefinitionId, ActiveObject AS ObjectId, ObjectType FROM Orion.AlertStatus WHERE Acknowledged = 0 AND AlertDefID = 'abbe043e-a4e4-49d8-85fd-eb55ebb378dc'"$queryResult = Get-SwisData $swis…

Ah, right, kind of a mental typo there. I'm testing the theory of using the API to Ack alerts based on a current Node Down alert I have. However, I'm still struggling with the building of the proper XML array. In this test scenario, here is my alert's SWQL data: AlertDefID: abbe043e-a4e4-49d8-85fd-eb55ebb378dc…

When rerunning the discovery of existing nodes, does it affect them in any other way? Will their current configuration and historical data remain unaffected?

I've gotten that far, but I'm not seeing anything in the "Orion Object" dropdown under "Add Data Series" that pertains to any reports, web or otherwise. Similarly, if I uncheck "Use current network object as Data Source" I do not see anything pertinent under "Select Data Source".

Hello, Last week I was able to open a ticket with support ( Ticket #607374 ). In working with the technician he was able to reproduce the same behavior as I am experiencing in his own NPM 10.7 environment. Thus, this seems like a bug in NPM itself, but as I recall you were able to get it to work in yours. Do you have any…

Is there any way to still let more than one group apply? In my prodding with it this afternoon I set up a test group, OrionTest, that is account limited to a handful of nodes, but has node management access. Another group, OrionUsers, has no account limitations set up but also lacks node management. It was my hope that…

Well, I tried a new tactic, and I've got some more info. For testing purposes, I temporarily changed and tested this script in Orion: Param([string]$Path)$FileType = "*.tmp"$FileCount = [System.IO.Directory]::GetFiles("$Path", "$FileType").Count$FileCount Interestingly, I get this as a response: Errors:…