AlexSoul · The Magician! · ✭✭✭✭✭

etcentene​ You can get any URLs working by simply specifying WEB URL field proeprty in Report Writer for the column you want to be a link The link that you need to use is in comments section of the actual script above (highlighted examples below): As for the icons - you need to set properties of the icon field for the icon…

Short answer - it is possible AND it is fairly easy (I will post example with SQL below) Long answer - below: I would like to remind first of all the difference between Alert and Condition: * Condition is a factual evidence that something is not right - high CPU, high memory, component in error/warning, etc * Alert is…

Glad This is what I am here for - to receive this kind of replies from my fellow SolarWinders Thank You! As for the SQL part - as I have mentioned, view is already in SQL by default - so, you don't need to create anything. I think I know what is you problem - you simply copy-paste SQL script and didn't change database…

Hi J, APM_AlertsAndReportData is a standard view in SolarWinds. I didn't create it myself - it was there already. What SAM version do you have? If you have problems with finding actual gif icon, you can usually construct your own. For example: SELECT n.StatusLED AS 'nLED' ,'PIX-'+ard.ApplicationStatus+'.gif' AS 'aLED'…

this information is stored in AlertStatus table, which is not joined in this SWQL script. If you will refer to new SQL version of this solution (https://thwack.solarwinds.com/docs/DOC-176259) you will find this table is linked. You need to "ORDER BY ast.TriggerTimeStamp" in SQL version

Hi Guys, I have transposed this SWQL script into standard SQL... + there are some cool new features, such as muting on any level - nodes, apps, separate component and even template itself The Magic Of SQL Scripts: Resource To Display All Your Components With Problems

Alois Baumgartner better

Hi njoylif, It looks something really cool, but I was a bit struggling to understand the benefits of it. Would you please be able to describe in a bit more details what this solution does and how does it benefit IT/Business? Would you be able to give some business cases? Example of usage? Thanks, Alex

hoover over:

azabielski wrote: I did that before but then again the Report writer will eventually go away as its now even Legacy and it was take a while to load those resources as reports vs the straight swql or sql query How do you know Report Writer will go away leaving us with inability to run SQL reports as Custom Queries on pages?…

yep, this is something I have discovered as well, and, I have a solution for it. Just watch the space at The Magic Of SQL Scripts: Do What Counts, Don't Count What You Do and I will explain everything in my next article. This will be SQL though... @bao@xxxlutz.at, a.StatusDescription NOT IN ('Unmanaged','Up') will not help…

On the other hand - I don't understand why SQL is not an option. All you would need to do is to create report in Orion Writer (not web-based) and assign this report to the resource "Report from Orion Writer" on any page you like. I believe this would require same permissions that you need in order to be able to View your…

I copy-pasted your script above into my test-server and it has worked. I have removed HTML tags tough as it would not display images, but full HTML code instead, making it a bit of mess

yes, there is... I am getting ready next article which will explain how to do this with SQL ... I hope someone can help with SWQL in the meantime ...

What are you trying to achieve? Not so long ago I have converted SWQL into SQL and I am using SQL now - it is much more easier this way to build queries and you can still use them as resources, reports, alerts triggers, etc. What is your final goal?

Oh, by the way, and if you are copy/pasting "Nodes with problems" SWQL then you would need to remove last line of the code, as it is only applicable to my specific environment

That's correct, it is version 3 (SWQL). It definitely works over here. I guess try to re-type the above manually. Sometimes I have found that what would appear to be the same (such as single/double qutes for example), on the ASCII level is entirely different

Here is your answer AND ( a.Name LIKE ('%Windows%') OR a.Name LIKE ('%VMWare%') )

How about the following format? I use it for "Nodes with problems". Notice "LIKE" statements below... just try the same with the above. Let me know how did it go SELECT '' AS n, n.Caption AS NODE, n.StatusDescription AS STATUS, n.Stats.CPULoad AS CPU_LOAD, n.Stats.PercentMemoryUsed AS MEM_USED, n.Stats.ResponseTime AS…

Try these two threads - those should take you on to the right direction with regards to Alerts Help on getting HTML links into a Custom Query Custom alerts page using stored procedure and report

Hi, I didn't quite understand what exactly you are trying to achieve. Can you give a case study, sketch a draft or explain in a bit more details... On 8 May 2014 22:40, "SolarWinds Community Team" <

The width of my resource widget is set to 500px. When it comes to long app or long component names, the icon does not stay on the left. Instead - it is being left alone on the new line and all text goes beneath it. I want icon to always be displayed next-left-centred, regardless of how many lines my app name will be broken…

No, it is not possible. What you can do however, is to create two groups - one for one set of users and another one is for others, with different settings. You can then limit visibility of groups as required (ACCOUNT LIMITATIONS under SETTINGS > MANAGE ACCOUNTS > EDIT) so that your admin can see one group, whereas your…

Thank you. I have noticed indeed that sometimes copy-paste is not up to scratch. I have attached plain TXT file with SWQL query as well.

Here is my final version, which was flawlessly working in production for over 2 weeks now: SELECT '' AS n, n.Caption AS NODE, '/Orion/images/StatusIcons/small-' + ToString(n.StatusIcon) AS [_IconFor_n], '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.NodeID) AS [_LinkFor_NODE], '' AS a, a.Name AS APP,…

would you share the whole final query that you have now? I suspect it is pulling info from ChartEvidence as in first version, isn't it?

Guys, SCRATCH the above. I believe the first part of the above script will do the job needed (second part just produces duplicate records). Here it is - final version (I hope ): '' AS n, n.Caption AS NODE, '/Orion/images/StatusIcons/small-' + ToString(n.StatusIcon) AS [_IconFor_n],…

Hi All, I have realised that some components are not being picked up by this script, because they are not present in ChartEvidence table, such as "Process Monitoring", "Windows Scheudled Tasks" and some scripts. As suggested by Petr Vilem here - we can use UNION between CurrentStatistics and DynamicEvidence tables to pull…

Hi bluefunelemental, The following was not giving me icon with small child dots as you have on your screenshot. '/Orion/StatusIcon.ashx?entity=Orion.Nodes&status=' + ToString(n.Status) + '&size=small' AS [_IconFor_NODE], I have used the one below to accomplish this. '/Orion/images/StatusIcons/small-' +…

Good point. I agree, using corresponding icons next to NODE, APP and COMPONENT is very useful. Also, you can attach icons to any column, not necessarily to a new one as I created above How about this: SELECT n.Caption AS NODE, a.Name AS APP, c.ComponentName AS CMPNT, ce.AvgStatisticData AS STAT, ce.ErrorMessage AS MSG,…