Need to Modify ProblemNodes.Resource

dsullinger

I have made a copy of ProblemNodes.Resource and renamed it ProblemRouters.Resource. I am trying to add a SQL search feature so it will only display our Routers in the list. I know this can be completed through the filters function using Vendor = 'Wellfleet', but we have many users and they all have customized "Network Summary" pages. Instead of going into each users Network Summary page and add a filter, it would be easier just to add a new resource with the needed filtering already set.

I modified the following line in the ProblemRouters.Resource and something isn't working right... any help would be great:

SQLResource.SQL="Select * From Nodes Where Severity>0" & "MachineType = 'Wellfleet'" & "Order By Severity Desc, PercentLoss Desc"

I also looked at modifing the SQLResource.Filter=Resource.GetProperty("Filter") statement, but it just didn't seam like the right place to make the change and not only that, nothing I tried would work.

Thank you in advanced.

pancamo

maybe just a syntax problem? Ya need spaces in the the SQL statement

SQLResource.SQL="Select * From Nodes Where Severity>0 " & " MachineType = 'Wellfleet' " & " Order By Severity Desc, PercentLoss

quote:Originally posted by dsullinger I have made a copy of ProblemNodes.Resource and renamed it ProblemRouters.Resource. I am trying to add a SQL search feature so it will only display our Routers in the list. I know this can be completed through the filters function using Vendor = 'Wellfleet', but we have many users and they all have customized "Network Summary" pages. Instead of going into each users Network Summary page and add a filter, it would be easier just to add a new resource with the needed filtering already set. I modified the following line in the ProblemRouters.Resource and something isn't working right... any help would be great: SQLResource.SQL="Select * From Nodes Where Severity>0" & "MachineType = 'Wellfleet'" & "Order By Severity Desc, PercentLoss Desc" I also looked at modifing the SQLResource.Filter=Resource.GetProperty("Filter") statement, but it just didn't seam like the right place to make the change and not only that, nothing I tried would work. Thank you in advanced.