Comments
-
Hello, Link should be live now: Orion Platform 2017.3 Hotfix 4 - SolarWinds Worldwide, LLC. Help and Support Thanks Lada
-
Hello I picked your first query and paste it to Custom chart in view and it is working. Support should contact you, if my last suggestion is not working we should arrange goto meeting because it is strange. Hello, I use this: SELECT Detail.[DateTime] AS Timestamp, Status.Status AS 'AP Name', SUM(Detail.[RawStatus]) AS…
-
Hello It is working OK in my enviroment. It should show data in "Main poller Timezone" not browser timezone. On which timezone is your Main poller? Run this in management studio or DAtabase manager: SELECT M.DateTime, M.AvgNumericData as "writes per second", N.Caption as "MultiData" FROM APM_MultiValueReportsData M…
-
yes
-
Hello Example: Netobject V:33 SUBSTRING(NetObject, 3, 10) = 33 In that where clausule: 33 IN (SELECT VolumeId FROM DeletedVolumes) try match 33 in all VolumeId. It is ok. Probably in some way Volumeid was not propagated to DeletedVolumes.
-
Hello, From history reason we are showing time (timezone) which is set on primary poller(website). It means when you access from any timezone you are aware which time is in Main poller or other pollers. If we will show browser time, every engineer will see other time according the timezone where is browser open. Definitely…
-
Yeah preview datasource show only small part of that. Could you please try use SAME datasource, but use Custom table instead of custom chart. Add all columns a try look how much data do you have. You need minimum 2 statistics data per one object. Do you see any loading state after you click preview? If nothing help could…
-
Hello, We have problem with @ in SQL macro. Only easy solution is: Create custom property defaultsupportemail and put there default email. Use that property aa value should be specified (use dropdown). ${SQL: select CASE WHEN Contact_Person is NULL THEN defaultsupportemail ELSE Contact_Person END from NodesCustomProperties…
-
Please try wrap ${CustomPollerAssignmentID} -> '${CustomPollerAssignmentID} ' as in first post.
-
Hello, I see your question. Could you please show me configuration of ServiceNow Action. (state section) Do you have action only in trigger. Which states is closed. Sorry for long response. LAda
-
Custom query use SWQL and that is similar to SQL. Probably use search in twhack, probably we don't have any guide how to create SWQL queries. If you need all ipadresses you can use same query without Where condition: SELECT ip.IPAddressType, ip.IPAddress, ip.InterfaceIndex, i.caption as Caption, i.DetailsURL as…
-
Select s.ObjectName as ServerVolume, s.TriggerTimeStamp as TriggerTime, c.Status, custompro.INC as Ticket, custompro.ServerException as Exception From Orion.AlertStatus s Join Orion.AlertDefinitions d on s.AlertDefID = d.AlertDefID Join Orion.Volumes c ON s.ActiveObject = c.VolumeID join Orion.VolumesCustomProperties…
-
Hello, Is this enough? https://github.com/solarwinds/OrionSDK/wiki/Alerts
-
Units in my database should be: B Scale units as : GB
-
Hello, You need upgrade to NPM 10.6/2013.2 to get ability to create new web-based reports. Thanks
-
Hello a_aziz, Could you please open support ticket. Thanks
-
Is this enough for you? select aa.[timestamp] as TriggeredDateTime , aa.message, (CASE aa.eventtype WHEN 0 then 'Triggered' WHEN 1 THEN 'Reset' WHEN 2 THEN 'Acknowledged' WHEN 3 THEN 'Note Added' WHEN 4 THEN 'Added to Incident' WHEN 5 THEN 'Action Failed' WHEN 6 THEN 'Action Succeeded' WHEN 7 THEN 'Unacknowledge' WHEN 8…
-
Hello, I looked this and these two types of resources can be done via Custom object resource. 1. Add 6 custom object resource. 2. Pick approprite nodes. 3. Pick appropriate object resource:
-
Hello, Yes, there is inconsistency between Custom chart + Custom SQL datasource on Report and Custom chart + Custom SQL datasource in view. I recommend change SQL datasource to SWQL datasource, which does not have this limitation. Thanks Lada
-
Hello, You can add many types of netobject to group (nodes, interfaces, application, volumes). We can't store availability for every member, that mean you can get only availability of whole group, which are computed from Rollup status -> can be 0 100 or 50. That above report do that. If you need availability of nodes,…
-
When you creating Custom Table you pick Type of datasource. There is SQL.
-
Hello, HolyGuacamole tells true, you can compose View as you want by: Custom object resource Custom Table Custom chart Report from Orion report writer I think it should cover your needs.
-
Yes, you are right. Probably you can check this options and in trigger condition add do not trigger if node is in unamanage status. (node status is not equial unamanage).
-
Hello, Could you please set more frequent check for the alerts. It is in settings on Desktop notification tool. If you need more custom sound you can use text to speech. It will read the alert message for you. Lada
-
Hello, Could you please put support ticket number here. We will look at it. First question: Have you successfully added some ServiceNow instance to NPM 12? It looks yes because without that you will not able create ServiceNow action. Thanks a lot for your cooperation Lada
-
Hello, Up to which type of entity (node, volume, F5..) are you trying to trigger/reset alert? Lada
-
Hello, If you have in ServiceNow Short Description as list of definitions it will show you the same in NPM. Can you put Custom Value to Short Description in ServiceNow? Which type is Short description field Doesn't you have any other Short Description or similar text field in ServiceNow? You can add any field from incident…
-
Did you try create resource from scratch? Detail.[DateTime] is that datetime type? Should be if it is working in Report. Remove Order by (you dont need that in Custom chart 1. Add new custom chart resource to report put above query and try create in report. 2. Add NEW resource Custom chart (not copy) resource to view put…
-
Hello alexslv, Unfortunately Map tooltips doesn't support SQL variable. For this please create feature request. For Alert message this should be work Lada
-
Hello, You can filter it in Data source via Dynamic query builder - advanced.