Comments
-
c7000 blade server chassis would be great to have a resource for enclosure power, fans, and blades health despite being in different tables :-( enclosure information and overall health should be an easy one
-
Spent a few minutes - here's the best I have - SELECT N.caption as Node , '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(N.nodeid) AS [_LinkFor_Node] , '/Orion/images/StatusIcons/Small-' + N.StatusLED AS [_IconFor_Node] , I.shortdescription as ChildStatus , '/Orion/images/StatusIcons/Small-' +…
-
Cirrus.ConfigArchive table - config is stored as string so any tool will do. If you need latest use MAX(downloadtime) and if you need node data then join (maybe a SWIS alias avail?h Cirrus.nodes on nodeid and Orion.Nodes on corenodeid=nodeid. Thanks, Christian
-
Absolutely possible in both the new and old report writer. If using the web reports you have the benefits of a simpler method of just including all three data sources into one report- not merging the results. This will be easier as merging the results will likely require a SQL query. Thanks, Christian
-
Kiran- are you able to search the alerts web page or app and see their alert history? This should help confirm which alert was triggered and therefore the logic and history. Is it possible that they were still up but that Orion lost network communication with them- what does their availablity show at the time of the alerts?
-
I would create a custom query and then add a case statement so create a sort field something like: select nodeid, caption, statusdescription, case when status=1 then 4 when status=2 then 1 else status end AS [sort] from Orion.nodes sort by [sort] desc status integer to your needs are not reflected above.
-
Which snmp properties are you searching? SELECT Nodes.Caption AS [Node] , '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(nodes.nodeid) AS [_LinkFor_Node] , '/Orion/images/StatusIcons/Small-' + nodes.StatusLED AS [_IconFor_Node] ,Contact ,Location FROM Orion.Nodes WHERE IsNull(Nodes.Contact,'') = '' OR…
-
Detrioter, when available add in the nodes.detailsurl column then your page link will magically work. Nodes and interfaces has it but others might not- I have had some luck in building my own column and calling it detailsurl and working. Which table is your custom SQL coming from?
-
Are you monitoring the snmp server and wmi for application from the same node in Solarwinds or as two separate nodes pointing to the same server?
-
Adding request for Juniper virtual switch stack monitoring
-
I would first consider upgrading to IPAM where most of the integration is built in. For example on my Orion homepage I have a search for IP resource which returns results from IPAM and there's also the strong integration with UDT. Otherwise I would link by IP address which would be the only common data between the apps.
-
I usually get that when I have order or group by clauses in my statement. Can you try it without the nested select statement ?
-
Short of oid polling I would and do simply monitor those ports in UDT. that allows you to pull plenty of operational information besides the standard NPM Interfaces.
-
Tainã, Did you decide on the 2960 for your IP SLA responders? I am debating getting some more temp but I think I'll re-use our 4948's as they come out of production since they have much better IP SLA support vs the Lan Base OS.
-
Old thread but here goes: You don't need to create a Solarwinds Custom Poller to see traps from an Isilon cluster. Just add the cluster nodes to Solarwinds then log into OneFS - Dashboard->Events->Cluster Events->Event Notification Rules-> Add Notification Rule and choose traps, set your solarwinds poller IP and a…
-
If you mean above the tabs then yes you can put on a custom logo with company details. Settings -> Web Console Settings -> Site Logo URL if you mean tabs then you cannot change but you can create custom menus under the existing tabs. I like to hijack virtualization tab as an admin menu test tab since its so easy to…
-
Old thread but... Default custom properties are now in NPM 11.5 - though it seems to default to the first value in your pick list
-
As admin says iFrame or use Orion SDK to pull data into another reporting tool such as Sharepoint.
-
Anyone else have issues where if you are logged in both iPad, desktop, and iPhone you keep getting logged out? #connectedproblems
-
My feedback is that the homepage recent content should not list when people vote in polls or bookmark items. This would help me find…well..recent content. Everything else is great
-
How dynamic are the interface names settings etc? If its turn down or up all x ports then its easy in the change template module, if you add and name them for something inventoried like from cdp then there are still examples in app, if you want to call out different names for each interface then to me the exec command…
-
support.microsoft.com/.../256282
-
Do you already have or would you consider creating these as groups? You might still need custom SQL to get the % down but it gives so much more metrics that way. Otherwise it's a SQL query each for that custom property and a subselect to get the percentage. Then these multiple queries would be aggregated with a union to…
-
Doing this very soon and I've done similar in the past. What's your cmdb and is it your source of just application name pick list values or also the mapping of each node to applications? What we did to prep for this was add a ServiceNow flat field which shows the upstream relationships (including applications) in a simple…
-
What time frame are you looking at? There is the application hourly table right near the detail one. I think I would try out the new web reports for this and see if I could put the graph up top followed by the table details summarized hourly or daily.
-
In my experience if the alert is active then it does not retrigger the alert even when the alert is modified. It would seem as if the query to tell you how many objects will trigger does not take this into account. If you wanted to retrigger so your new actions would run then you can always clear the older alerts or as the…
-
I am reading into this somewhat that you are not counting devices like Cisco switches since they are supported out of the box and not Dell Maybe something like this in a custom sql report? select n.caption,a.manufacturer,a.agentversion,a.agentname from dbo.Nodes n left join dbo.APM_HardwareInfo a on n.nodeid=a.nodeid where…
-
Does your server engineer plan for these updates somewhere? We put in an integration between our change management system where the assets dates and times are pushed into Solarwinds node table to unmanage them.
-
This is why it’s always best to code against the SWIS API so that you are abstracted off db schema changes. Download the swql studio app and connect to both instances and I’m sure the tables are consistent. also they just added ipam api methods to manage your subnets and IP’s
-
I would prefer color over a report so unless you can dig into SAM 6.0's cool new report charting I would split your ask into two * Provide a colorful GOC view (though with built-in resources it might be averages) * Provide a report to be emailed beginning of every shift to shift management and real-time alerts sent to…