s-bolyard ✭✭✭✭✭

Verified that this works on two nodes running the script through the command line. Just like you I received the correct information in the History of this alert on this object and in the Alert Notes field. Both ran under 2 minutes.

No need to apologize. I REALLY appreciate your help with this. I'm learning a lot and it's forcing me out of my comfort zone by getting me to learn the code so that I can do this myself going forward. 

No worries. Just as an fyi, I did follow the steps above and I did receive output (similar to yours) for the Alert Notes. I ran it in CMD with the service account.

Corrected the Subject line. Got a little paste happy. We're on the 2020.5 HF1 version. I updated the network path to include the quotes. I installed the OrionSDK.msi which included the SwisPowerShell module. The install didn't ask the question about all users or just one. I've been using the Define user option it tests…

Update: Looking at the script a little further I noticed the authentication method is using the SolarWinds certificate. I did some research on that and found out that swispowershell is not installed on the main poller. I went ahead and did that and was able to make the connection to SWQL. Unfortunately I'm still having…

[View:/cfs-file/__key/communityserver-discussions-components-files/47/TEST_5F002B00_Server_5F002B00_Device_2B00_Down.xml:640:480]

Thanks @"KMSigma.SWI" and sorry for the delay in responding back to you. I thought this string was triggered to email me when there's a response. As far as the ping and tracert portion of the script, that's working. I'm trying to figure out why it's not populating the AlertNote in SWQL. My first guess is that the…

It works for some, but I also encountered others that this fix did not resolve the issue. I started a new message string, see below. Here's the link to the other string: https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/90786/orion-maps---images-keep-disappearing---why

Thanks @"KMSigma.SWI"! Last time I saw you was SWUG AZ right before the pandemic. I hope you and your family are doing well. Do you by chance have any examples of what that code should look like in the script or is there some documentation that I can work off of? In the meantime I'll look online and give it a try. Thanks…

Hello everyone. It's been a week and the images that I've re-added have stayed after running the above SQL query. Per SolarWinds support, Dev is working on the patch that will resolve this issue. Unfortunately he does not know the timeline of when it will be released. The work around for now is to run the above SQL query…

Update for those following at home: I'm working with SolarWinds support who's working with their Dev. team. It looks like some of the images are not creating a ProjectID in the Maps_Assets table. Here's the work-around steps provided by support: 1. Create a new map with the background images 2. Save the map - Important:…

Thanks for the feedback @"chippershredder". I checked the properties of the image files and they are all set to read only. I have a change scheduled for tomorrow morning to do the SAM hotfix, so I'll check my maps after it's finished because it will do the configuration wizard then.

My issue is with the insert image from the tool bar. I have a couple of dashboards that use the background option, but those seem to be ok.

Ok, will do. Thanks!

Hello @"jblankjblank" and thanks for the response. I just now submitted a case with SolarWinds support (00813389). I started noticing this behavior after the update to 2020.2.5 and I was also having issues with adding a SolarWinds summary URL to an image or label. Support did come up with a new format that seems to be…

.

Yep, replacing the & with the ? worked. Thank you @"jblankjblank"!

Thank you @"mesverrum"! Add another beer to the IOU list. Always appreciate your help.

Sorry @"tmcurry", just saw this message. I worked with SolarWinds support and I guess for these SQL queries to run you have to have a local account on the SQL database server you are monitoring. I was using a domain account to connect and I guess that won't work. Once I added the local SQL account on the database…

Try using COUNT(p.NodeID) and remove the count on ah.message. Disclaimer: I'm not a SQL/SWQL expert.

Has anyone heard of where we are at in regards to 2020.2.2 being available?

Your screen-shot shows that your Alerts have No Limitation, but I think you need to update the Report Limitation Category to No Limitations.

You're right about the limitations. I wish that they didn't make a separate entity from the classic dashboard. It would look great if the two could combine. I also read that at this time I can't make the Modern Dashboard be a home page for my application support folks. Hopefully that will be available soon.

I wonder if it doesn't work in the Application level like it does in the Node level.

Not a problem. I'll put something together and send it to you.

Thanks! I had a feeling that was going to be the answer.

Thanks for the information. I definitely voted for that feature request.

Sorry to bug you again. Last question I promise. I tried to follow the same format to concatenate to a SolarWinds page. ,concat('<a href="">thwack.solarwinds.com/.../NodeDetails.aspx ',ToString(o.RelatedNodeCaption),'</a>') as [Device Name] When I check the Allow HTML tags and submit, I get the below message. ls there…

Good luck. The integration with SolarWinds is pretty good. One other thing I had to change was the URL. It wasn't taking me to the incident number, just opening ServiceNow's home page. I changed it to: concat('<a href="https://<ServiceNOW URL>/nav_to.do?uri=incident.do?sys_id=',ToString(s.IncidentNumber),'">Incident…

Thanks for the feedback. Worked great!