FormerMember ✭✭✭

Is it possible get report data into a chart? We would like the max channels # from your report in a daily step chart. I can't find a way to do it.

date : isn't used in sql 2005, i believe its 2008 onwards. Thanks for sharing this. We are finding it very useful. Just need to fgure out how to get the data into a graph.

we had the same error message using sql 2005 and made a few changes - SELECT DateTime, NodeID, NodeName, MAX(Max) AS Max From ( --SELECT COUNT(Row_ID) AS Max, NodeName, NodeID, Cast(DateTime as date) AS DateTime FROM SELECT COUNT(Row_ID) AS Max, NodeName, NodeID, REPLACE(CONVERT(VARCHAR(11), DateTime, 106), ' ', '-') AS…

Derik, Another reason to use the Report Writer reports is if you want to include a legacy report (Report Writer) in a view resource. As far as I can determine (NPM 12.2) you still cannot display a web based report in a view resource. I am thinking this is still on the roadmap, just not there yet. Until then Report Writer…

In the script, I have found that the show running-config line needs to be changed to sh run-config. Spelling out the word "running" fails as this is not a valid command. Also I do not see anything incorporated into the script to get throught the endless "Press enter to continue" prompts within the telnet session.

The SQL database userid and password are in the SWNetPerfMon.DB file if you forget. Wes Van Sickle | IT Operations Administrator | The Arizona Republic & azcentral.com • Office: 200 E. Van Buren Street | Phoenix, AZ 85004 • Office: (602) 444-7330 • Mobile: (623) 262-4050 •…

NM, I was able to figure this out somehow I captured the wrong latitude and longitude. This works as described. Very Cool !!

Setup has gone pretty uneventful for me, but I am seeing a scenario when I click on "State" in this scenario AZ, it redirects me to Austin Texas, any ideas on what I am missing?

You should also address limitations of monitoring virtual machine disk volume space. This was a feature of the appliance-based VMAN and was lost with the conversion to Orion-based VMAN. A KB was created to provide a work-around. Monitoring of virtual volumes should be included in future versions of Orion-based VMAN. What…

Thanks I tried changing it and it didn't work, so I ended up double-checking the path to the script and saw that I had a typo in there. At the beginning of the path I didn't delete the < sign. After that I tested with a domain account on the services as well as the local account and both options are working now. Thanks for…

Hi, I was trying to implement the host and interface checks via the PS scripts. If I open them in the powershell editor adopt the variables and test it I see the test post in Slack but if I create an Alert in Solarwinds and test it inside the Alert I don't get anything in my Slack channel. Any idea what I'm doing wrong or…

Hey Guys I'm having a tad bit of trouble implementing the last month clause into my report, not sure where I went wrong in this? SELECT * FROM ( SELECT Nodes.StatusLED, Nodes.Caption, Nodes.NodeID, StartTime.Message, StartTime.EventTime AS DownEventTime between dateadd(month, datediff(month, 0, getdate())-1, 0) and…

Please share source code of your apps. I would like to look... I am interested in.

Thank You! X1000

Hey Guys, Just one question. How do you convert the "Outage Duration In Minutes" in this SQL statement " SELECT * FROM ( SELECT Nodes.StatusLED, Nodes.Caption, Nodes.NodeID, StartTime.Message, StartTime.EventTime AS DownEventTime, ( SELECT TOP 1 EventTime FROM Events AS EndTimeTable where EndTimeTable.EventTime >=…

Hi Dear Users Is there anybody that can monitor GE UPS via Solarwinds ? if yes, Please give me a Screenshot of that Page to see it's Shapes & also Features from GE that Solarwinds can find & Monitor them for us . Best Regards, JJackson (jalal@arkbus.net)

Hi There, Thanks so much for this report, however with the results from the report, does it mean that interface has been over 85% for a certain period of time (ie 5mins?) or is it an exact time stamp?

hi rob.hock thank you for making this report it is really helpful but can you tell me how to filter report based on custom reports basically i am non programming guy i tried to make change but i wouldn't get succeed in this so would you help me in this thank you

Monitoring Request Forms – www.acmtix.com Yes I'm planning on updating too for SNMP V3 as my docs don't cover that.

No problem!

Can anyone point me in the right direction where (how) to set this up ? It seems like a powershell script, but I want this functionalitly inside solarwinds - or is this interfacing to solarwinds ? I´ve got a bunch of citrix, sql and other clustered servers. thanks in advance, Richard

very informative!

Damn DBA's trying to improve things...

Yeah useful info, not sure why anyone would turn Solarwinds off for an extended period though? who would do such a thing...?

Hi tbaggins, To achieve what you need simply go to SQL tab in the report designer and remove two last conditions in SQL query. Your last line should look like this: "WHERE CustomPollers.OID = '1.3.6.1.2.1.10.7.2.1.19' AND RawStatus != 1 AND Interfaces.OperStatus = 1"

Thanks, This works like a champ!

Hello Donald I downoaded the file but not to sure how or what to do with it. Can you email me some intructions or post here how to use this file thanks,

Sure, count me in.

I would like to give original credit to goodzhere. I used his SNMPv3 script as a template. 

Syslog Summary of messages with Source