karthik.ranganathan85

Comments

  • Hey Josh, The problem here is, From your original (base) query, JOIN clause (ON) condition does not satisfy. ( Select Nodes.NodeID, Nodes.Caption FROM Nodes JOIN Traps t ON t.Hostname = Nodes.caption) Look at the data from both nodes and traps table, where you can see nodes.caption has FQDN and traps.hostname has just…
    in Alerting with a custom SQL condition Comment by karthik.ranganathan85 June 2016
  • Hi Josh, Are you sure, Does the hostname exist with short name or FQDN in the table (Traps)? If you are not sure, please use like condition instead of IN condition. Eg: t.Hostname like 'r32paris02%' If still issue persist, please make sure all conditions in where clause satisfies in order to fetch you the data as you are…
    in Alerting with a custom SQL condition Comment by karthik.ranganathan85 June 2016
  • Hey Josh, I can see the problem is with your 1st SQL query, you cannot use * (special character) in your where clause when you use IN condition, t.Hostname IN ('devicename*'). Instead, you can try t.Hostname like 'devicename%' or t.Hostname in ('exactdevicename_that_exists_fromthetable'). Hope this resolves your issue.…
    in Alerting with a custom SQL condition Comment by karthik.ranganathan85 June 2016
  • Hi Chad, Thanks for your response. I tested the above component monitor, but it always gives me statistics as 1, even though I have more than 1 file on the folder. Eg: This is the path I have had in the script : \\{IP}\c$\Documents\*.* And no.of files on the folder on the target server is not always the same. For eg, For…
    in Monitor & Alert when new files created on a specific folder on Windows server 2008 Comment by karthik.ranganathan85 October 2016
  • Hi Erik, If it is possible to poll the process status using SNMP, try to use the below component monitor and see if that works. Thanks.
    in Monitor Windows service status without thresholds? Comment by karthik.ranganathan85 July 2016
  • Hi, Are you looking to achieve the report using custom SQL? If so, you will have to try to join 2 tables called Nodes and Interface keeping Nodeid as the primary key. You can actually get Interface Transmit Traffic using the column (Outbps) from table (Interface). For example, select n.caption,i.InterfaceName,i.Outbps from…
    in Need help with Report creation Comment by karthik.ranganathan85 July 2016
  • Hi Benton, When does the limitation (no.of rows) occurs, is that during preview the report or after generating the report in the form of PDF file or something? And are you trying to use Custom Chart or Custom table? If it is custom table being used, you will be able to see complete data (based on the query) after…
    in A question about creating custom tables Comment by karthik.ranganathan85 July 2016
Avatar