sgenius

Hi HolyGuacamole, Still awaiting the thread you promised to attach on Tuesday. Today is Wednesday. I'm patiently and humbly waiting. Many thanks for your contributions. Regards,

HolyGuacamole, I'm sure that you have observed that none of the legacy reports on the Orion Report Writer conveys results for what I want to achieve, or may be I have not seen it yet. What I mean is that, legacy report on interface traffic is different from the one on node availability, and even different from the one for…

Yes HolyGuacamole, You are very correct. Actually, in addition to this code, I want the one that would also be scheduled for every week day, say for example, at 6:30 pm of every week day, I want to receive an email with a file as an attachment to the mail which conveys the same interface traffic and node availability…

Hi Tisonet, Many thanks for your clarification. I'm no more confused. Regards,

Hi ZackM, The report actually works now while I run it via Orion Report Writer. If I say I know what happened, I'm not saying the truth. But via the Orion Web console, it's not working. I really do not know why. However, you said something about running the query against my database; please how do you mean? I have access…

Hi Guacamole, I use NPM 10.6 version. Please see the rest of the code below. ========================================================================= IF (DatePart (weekday, GETDATE()) <> 7) AND (DatePart(weekday, GETDATE()) <> 1) SELECT Nodes.NodeID AS NodeID, Interfaces.InterfaceID AS InterfaceID, Nodes.Caption AS…

Hi Borgan, Many thanks for the tip. You are very correct; these three data types that I desire can be combined on the same report by adding them as seperate contents. However, what if I want to tweak it in such a way that it will come out as a single table in one content on a report? This is actually my major challenge.…

Thanks aLTeReGo. I'll check it out to see if it matches what I desire. Regards, David.

Great piece of information. Regards,

Hi Lada, I did it. Find below, Business hours availability for nodes. SELECT TOP 10000 Convert(DateTime,Floor(Cast((DateTime) as Float)),0) AS SummaryDate, Nodes.Caption AS NodeName, Nodes.Location AS Location, MIN(ResponseTime.MinResponseTime) AS MIN_of_Minimum_Response_Time, AVG(ResponseTime.AvgResponseTime) AS…

Hi Richard, Very nice piece of information that you have shared. However, in my work environment, Solarwinds Trap Service is disabled. NPM was receiving too many trap messages which made spooling reports from our Solarwinds database very slow. So, please what do you advise? Any other ideas? Regards,

Hi Stuartwhyte, Please what do you mean by Active Maintenance? Regards,

Hi Craig, The devices are being polled by SNMPv3. Except there's some kind of SNMP test that I do not know of; please share it with me. However, from your explanation, would I be correct to say that I still have NTA licenses? Because, as you can observe from my screen shots, it is obvious, logical and easy to keep track of…

Hi Cmgurley, Please correct me if I'm wrong but if I understand your explanation very well, I want to clear out something. It's like giving back to a teacher, an explanation made by the teacher, just for the teacher to vet if his/her protege understands what he/she is saying. I want to assume two scenarios: first is when a…

Hi Richard, If I understand you correctly, the way forward on what you said, would be to edit the following: NodeID, InterfaceIndex, InterfaceName, InterfaceType, InterfaceTypeDescription, and Caption. How would this task be achieved? Regards,

Hi Familyofcrowes, If I understand you correctly, you mean instead of deleting the interface, you set it as unmanaged or unplugged?

Hi Vijay, Also, I noticed that the codes of one of the legacy reports of the Orion Report Writer worked while I executed the query on the Database manager. I exported it using the .csv tab and opened it in Excel but it did not dislay right. Have you experienced such before? If yes, please how did you go about it? Regards,

Hi ZackM, Thanks for your comment. Please, see the codes below. ------------------------------------------------------------------------------------------------------------------------------------------------ IF (DatePart (weekday, GETDATE()) <> 7) AND (DatePart(weekday, GETDATE()) <> 1) SELECT Nodes.NodeID AS NodeID,…

Hi Bluefunelemental, Yes, I want a report to be generated at a specific time. You said something about an SQL report and scheduler; please are you referring to the Orion Report Writer's Advanced SQL report and the Orion Report Scheduler? If so, I have made use of it before but I suspect that it's not really correct because…

Hi HolyGuacamole, I have made use of the Orion Report Writer. My observation is that it does not capture all that is desired in my work environment. For example, we want to be able to generate only one report that conveys the following information about our Cisco routers:bandwidth utlization (minimum, average, and maximum)…

Hi Stuartwhyte, O yes it did help. Many thanks. Regards, David.

Hi Leon, My words are not enough to express my gratitude for such information; yet, I must say " Thank You." I have really been enlightened. Regards, David Ibrahim.

Hi Michal, First, many thanks for responding. Actually, the Orion ReportWriter version in my work environment is 2013.2.1. In it, there exists a pre-configured report: Historical IP SLA QoS which does not have the features for one to pick out variables such as Day of Week, Time of Day, etc. I really think it's a typical…

Thank you Steven Carlson, Wonderful piece of information. However, please how can one create alerts to capture hardware sensors like Power Supply, Temperature, and Fan? In my work environment, we use an NPM 11.5. Regards,

Hi Borgan, Many thanks for the information. Actually, it's NPM 10.6 in my work environment. All I really want to do is ensure that this code runs. For now, I really don't know where I'm wrong. See the code below. SELECT TOP 10000 Nodes.NodeID AS NodeID, Nodes.Caption AS NodeName, Nodes.Location AS Location,…

Hi Stuart, You have made my day. This was what I thought initially but I was not sure. Yes, it totally helped. Many thanks.

Hi @Ryoung, First, I like to thank you for responding. Actually, I have gone through the link you sent but honestly, I have not been able to get detailed answer(s) to my question. Several articles exist. Which one gives me the detailed information that you think I need? Moreover, I perused the Alert Central article;…

Hi LadaVarga, Honestly, my words are not enough to express how grateful I am for your help. It was really an eye-opener. Many thanks. Please find below, the SQL 2008 server code on what I did to achieve mine. SELECT TOP 10000 Convert(DateTime,Floor(Cast((DateTime) as Float)),0) AS SummaryDate, Nodes.NodeID AS NodeID,…

Hi Rob, Thanks for responding. Actually, I do not seem to understand what you did in the web console report. Under what Orion Object Type can I get the Database columns for Transmit Pecernt Utilization and Receive Percent Utilization? I would really appreciate a reply. Thanks. Just to emphasize what I want from the report;…

Hi Dclick, Once you are done with running the SQL queries correctly via SQL Studio, I guess you copy the codes into the Advanced SQL option of the Report Writer right?