dkeyser ✭✭✭✭✭

That would allow me to do an initial sort but with the output being over 900 rows it becomes a bit large on the view I'm creating it on. I also lose the search feature. The end users might just have to live without the sort feature working if they want the ability to search all the interfaces for what they want to look for…

I did put in a feature request. thwack.solarwinds.com/.../addition-of-a-_labelfor_columnname-option-in-swql-in-hopes-it-fixes-sorting-of-number-and-string-concatenations

Thank you for the reply! I'm doing just what you discribed above but it's still sorting it as a string and not by the number it's concatenating to the string. In the image below you can see it's sorted Descending and it's mixing up the values due to string sort.

I was using the script found here: (+) SSL Certificate Expiration - CI, CN, and Expiry Date - Application Monitor Templates - Server & Application Monitor - THWACK (solarwinds.com)

SELECT Caption ,ComponentID ,ColumnName ,T1.StringData AS [Issuer] ,T2.AvgNumericData AS [Days Remaining] ,T3.StringData AS [Subject] FROM( SELECT Distinct de.ComponentStatus.Component.Application.ApplicationID ,DE.ComponentStatus.ComponentID ,De.ComponentStatus.Component.Application.Node.Caption ,ColumnName ,ColumnLabel…

That would work if I'm looking for only the top row but this is for over 200 nodes. Also there's no time stamp on the DynamicEvidence table in SWQL that I'm noticing. I'd probably try and cheat and do WHERE DateTime > MINUTEADD(GetDate(), -7) so I can catch the 5 minute polls with a bit of play in the poll time and data…

This is using REST so I'm using /SolarWinds/InformationService/v3/Json/Create/Orion.NPM.CustomPollerAssignmentOnNode and I'm passing the NodeID and CustomPollerID in the body as JSON. Not super familiar with REST CRUD operations so if there's other info needed just let me know and I'll try and figure out what you're…

Hey Kevin! Has there been any progress with this topic on the SWI side? Still not able to get this to work on my end. 

@"KMSigma.SWI" Were you able to test the functionality of the AppInsight specific verbs within SAM? I'm still not able to get that working like the example in Github as expected.

Nope, totally missed that one. Though when I replaced "Orion.APM.Application" with "Orion.APM.SqlServerApplication" I get the same effect. No error message and -1 as the return regardless of allowing dupes set to 'true' or 'false'. Nice find though!

Thanks for the reply! I was using the following column which I think matches your example. Acknowledge action kinda worked but not fully but Unacknowledge didn't seem to.

This was going into a Modern Dashboard with similar metrics. So I'm assuming it can't just keep the raw numbers in the output for my average then. Will that skew my results enough to matter?

Great hint! Below is the code I am using. I did find a out how to convert from another post and it seems like the slight loss in precision didn't effect the output. Not sure if it'd be an issue with lower conversions though. SELECT TOP 1000 sa.caption ,CASE WHEN ROUND((SUM(sacs.CapacityUserUsed*Weight)/(SUM(Weight))), 2)…

Nope. I'm trying to put asset tags into the system. Serial numbers show up just fine. The asset tags are only pulled from the node that's in Orion and not from the members in the stack.

Typically when you copy or download files that are untrusted by the server it will have an execution block on it imposed by the OS. If you right click a file and select 'Properties' you will see a button on the lower right of the dialog that says 'Unblock'. This will remove the execution block imposed by the OS.

Just tried out that script and it's getting an error around JobLogIndicator when it's trying to populate the $NcmJobs variable. Get-SwisData : Cannot resolve property JobLogIndicator At line:17 char:12 + $NcmJobs = Get-SwisData -SwisConnection $SwisConnection -Query $Swql +…

Running into this issue myself. At the bottom of the Jobs web page it just says "There was an error processing the request" and the loading box will spin indefinitely. This is keeping me from clearing the log also to see if it's just a size issue post upgrade to 2020.2.6 HF1

I'm in the same boat. Awesome that his works but it does make me curious what is different between our setups that makes the difference. Would be a nice addition if SolarWinds would add that functionality to its report scheduler. Would make automation easier.

thwack.solarwinds.com/.../DOC-169128 This is his write up.

I am currently unable to publish this package again after deleting the contents and starting over again. Error 2148081670 Sent from my iPad

We are seeing something similar to this except obviously a different URL. How did you come to the conclusion that this was the problem? Was it that the site wasn't responding quickly enough when browsing to it or something else? I'm seeing player load of over 100% and I'm looking for an explanation as to why and how this…

From my testing all discoveries are being left behind. The hidden parameter was doing something funky when set to true but as soon as I set it to false all of them came back in the DiscoveryProfiles table. Not sure what it's purpose is as I assumed it'd only hide it from the GUI. I'm thinking that scheduling a script to…

Something must have been stuck in memory. I shut down for the day and when I came back and tried it everything worked. Thank you for all your help. I've posted my function below. I'm passing 3 bits of information via the $NewNodeID variable so that's the reason I'm using the GetValue(2). #Function to add Interfaces…

Going back through my testing I've come to the conclusion that the columns you hide in the web console are hidden because of the flag given to them in the writer. That flag is ignored when generating the CSV. You would have to remove those columns from the report in order to remove them from the CSV file. I hope that helps.

I'd check to make sure I was using the right version of the report. If you had created more than one version in your testing you may be seeing one version on the site and sending another version. Since I can't send the reports as CSV files myself I can't reproduce your results and test from there. Would you explain how you…

Unfortunately it doesn't seem to be making the discoveries any longer. I did get one job to stay but anything afterwards shows up for a brief second and then vanishes. Even now when I'm attempting to execute the script to make a new job to discover a node I have removed for testing the job disappears after a second and…

I do have the KB2661254 patch installed on my test system. I've looked at certmgr.msc and I do have not one but two certificates in both those locations. Both are public key rsa 2048 encrypted. Will having two cause this issue? Sent from my iPad

I would like to keep this project off public forums so I'd like to send this via a private message. I'm not exactly sure how to do this so I've requested you to be a friend in hopes it gives me that option. I've also opened a case so that we can track this. Case# 728189.

Excellent to hear it has been solved! Also great learning and advice for us all. Thank you for sharing.

Thank you for that information. There was once an excellent youtube video on creating these rules back when this product was still eminentware. I believe you were the one who did it as well. Do you happen to have a link to this video?