sgenius

Yes I did save it as a .csv file.

Hi Vijay, Please see my codes below. ======================================================================================== IF (DatePart (weekday, GETDATE()) <> 7) AND (DatePart(weekday, GETDATE()) <> 1) SELECT Nodes.NodeID AS NodeID, Interfaces.InterfaceID AS InterfaceID, Nodes.Caption AS NodeName, Nodes.Location AS…

Hi Vijay, Yes, there exist an "export to csv" on the Orion Database Manager. I have never used it actually. That means I should be able to view the .csv files via Excel right? Anyway, recently I just observed that my SQL results do not display again, either via the Orion Report Writer or via Orion Database Manager. What I…

Hi Steven, Your response is wonderful. You may not understand how grateful I am but I must say: Thank you very much. This is really an eye-opener. However, please allow me to clarify something: Correct me if I'm wrong but from your explanation aforewritten, I have been able to understand that by default, it is only every…

Hi Rob, I have been able to understand what you mean by timeframe now. Yes I have timeframe. Everything seems to be fine; yet,it is not working. Please what do you advise? Infact, I went on further to ensure that "Group Historical Data by Days" is unchecked. Still, the same thing happens. Please, what do I do now? Regards.

Hi Rob, Many thanks for your response. Actually, I do not understand what you mean but I like to clarify my part again. The report I created was via the Orion Web Console, not via the Report Writer program at the back end. So, please could you calrify what you mean by checking the timeframe been reported on? I would really…

Hi Wiszm23 and Stuartwhyte, Thanks for responding. Wiszm23, your advice is exactly what I do whenever I want to add a node initially. If the test is not successful, nodes cannot be added to NPM. The network devices in my work environment are all Cisco; so as usual, I create an snmp user in the config file of the devices…

Hi Craig, First, I like to thank you for responding. However, I tried checking the license details of NPM and NTA in my work environmnent. Please see the screen shots below. From the above, I cannot suppose that the NPM license is finished but what I do not know is that of NTA. How many NTA licenses do I have left? I don't…

Many thanks guys. I'm very grateful. Just like my father would say: "Share your knowledge; it is a way to achieve immortality." Regards, David.

Hi Michal, I tweaked the TimeFrame variable of the report. I just set it to contain Date and Time values only. It worked. For example, Starting Date/Time = 4/4/2014 8:00:00 AM Ending Date/Time = 4/4/2014 6:00:00 PM But this settings can only give me business hours of a particular day (April 4, 2014). For now, my issue is…

Hi Guys, I still want to find out the possibility of generating report based on node availability under business hours using the WEB CONSOLE. I know how to do it with the Report Writer. Please enlighten me. Regards,

Hi Guys, I have tested all your advice. I tried to rediscover the device, it did not work. I tried what Mike1843 advised, it did not work; infact, as he rightly said, I lost old historical data on the interfaces I deleted. Honestly, it got to a point where I got frustrated and deleted the node and tried to re-add it. Of…

Hello Guys, Recently, I observed that while running the same code aforewritten, the SQL query code does not get executed. Instead, I get an error message: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign key constraints." Please take note that this code is the same that…

Hi Rob, Many thanks. Yes, the Orion Syslog server is running in my work environment. See below. However, Syslog Web Console does not display anything. See below. I just want to ask if there's something else that I have not done. Kindly assist me. Regards, David.

Infact, another observation is that I wrote an SQL code using Advanced SQL. In using this medium, you would not find any check box for "Group Historical Data by Days" to check or uncheck. So, why wouldn't I be able to spool the report via web console without the "No activity to report" pop-up? This is exactly what I get…