AlexSoul · The Magician! · ✭✭✭✭✭

Try this: * Create web-based report > custom table * Selection method: Advanced DataBase Query * Query Type: SQL * Paste below > preview result > ADD TO LAYOUT * Then edit table and add all columns that you want * NEXT > NEXT > NEXT ... SELECT cps.RowID, cps.Status AS 'Service Tag', n.MachineType, n.Vendor, n.Caption FROM…

What version of NPM this is?

Quick answer - no, it is not possible to correctly identify which alerts can trigger for a particular node. SolarWinds has something like this out of the box as a widget, but I recall it was never accurate, especially with triggers based on queries. I am not blaming them here, from what I can see - it is physically simply…

Hey chaps, please see Alterego's reply here: - I think this will open few more opportunities for you on how to track disk space individually

Indeed so - both Virtual Memory and Physical memory will count towards your licenses for Volumes if you will select them in "List Resources". I would suggest you to not add any of those as SolarWinds is monitoring memory as part of Node license already. You can see this by adding "Memory Utilisation" resource(s) on your…

ok, here we go: * How do I report on the number of alerts which have triggered over the last N days for a particular Object (I know that number of triggered alerts is now readily available, but how do I restrict this to a time window, say last month only) * In addition to the above I also need to know when last trigger has…

Feature request for what? Here is a doc which describes in detail how SolarWind's alerting and suppression works: http://www.solarwinds.com/documentation/Orion/docs/UnderstandingOrionAdvancedAlerts.pdf

ok, getting closer... remove this condition now, leave it blank so that it captures everything, and see if you alert will trigger

Worked for me as well. Thank you

Does this user has local script execution rights on this server? As a temp test - make this user local admin and see what happens

Thank you guys for your help. I think you are right - there is no way of do it so... that's what I was afraid to hear. Thanks for your help anyway

Thank you for suggestion. ${TrapRule.RuleName} didn't work... well, I guess I have to park this till I have another inspiration to work this out...

I am stuck... I have created report with dynamic query to go on component page. I could not however find an option to specify macros fro ComponentID, so I used NodeName instead: I do not have anything coming through to Component Details page Custom Report Resource unfortunately: If I will change above macros in report to…

You need to replace "SolarWinds" database name in the code to be your database name. Check your SQL server how it is called or try "SolarWindsOrion" - hope it will works see below. I have also removed JOIN which was used to join group names. Now you can copy-paste... SELECT n.NodeID, n.Caption, n.IP_Address FROM…

ok, this one is a bit more complicated but still doable. I did similar thing with Unmanaged report - basically I wanted to see on the node page when node has been unmanaged and by whom. The logic goes as follows: 1. You report on the fact itself (node added, node unmanaged, etc). This is what you have done already 2. You…

Ye, your are right. I will make them all same in new deployment. Actually, this question is being asked all the time - why they are different My answer - bla-bla-bla... well, there is an answer, but you know what - it is irrelevant. Thinking about it now - I would give it a go and make them all the same. Tanks for pointing…

You need to be as specific as you can. I am just guessing that on this occasion you could not find out-of-the-box reports for your historical alerts. ... here you go... try this: (1) Reports > All Reports (2) Use search in top-right corner > search for "alert" (3) Here you go - your historical reports, including reset…

Hi aLTeReGo, I think I have found similar thread where it is explained how to place a custom dynamic report on a node page: Determine Group Membership From Node Page I am wondering if the same can be achieved with web-based reporting and for this particular scenario. Basically - the goal is - to display on a component page…

Wow, so much to learn... so much to do... I will start digging how to "use the ComponentID macro to build a dynamic report that could be placed on the Component Details view" and in the meantime would appreciate if you can post some links to existing resources you may think can be relevant to refer to Appreciate your help…

ye.. go on man... blast it off... we will all laugh together

This is not as much about the device as about management overhead. With components you would not need to create multiple alerts, would you? So, I just thought something similar is possible with UnDP, but it looks like it is not. I have requested feature and I will think about workarounds in the meantime

Yep, that's exactly where I am now... hence - this question. I do not want to create alerts every-time I add new UnDP. So, I need something more robust than this. Still gathering ideas then.... anyone?

Ou wow, thanks alterego. This DML thing is actually very decent workaround. I may use it for other tables as well to expand on audit logging. Perfect!

well done, you just hit the core This is something that I really, really want to see one day coming as an option for CPs to have multi-select dropdown type. Yes, you are absolutely right, with custom properties it is not possible to achieve this at the moment. I would love to hear myself from folks there how they manage to…

Haha, nice one mesverrum​, ThumbUp! I deal with both examples above in the following way ... yes, with custom properties Automatically Update World Map Points Based On Custom Property Value Automatic Dependencies Based On Custom Properties (Node Location)

avn - thank you, thank you, thank you

I just clicked on your name orioncrack​ and got some very interesting insights about your last posts... Quotes (just a few of them below): "SCOM does it brilliantly. I can export Excel sheets of all of my..." "The simple fact that SolarWinds does not autodiscover and maintain my fixed disk inventory for me makes it a…

I have found both STATUS and MESSAGE entries for both VBScript and SQL USer Experience monitor in [Orion.APM.ChartEvidence] table. Can I use this table instead of [Orion.APM.DynamicEvidence]? What are implications of doing so?

Hi Petr Vilem and lukas.belza, I really appreciate your help. As per your example above I do not have "ComponentStatisticData" nor ErrorMessage fields in Orion.APM.CurrentStatistics table (see screenshot of all fields I have in this table above) Any thoughts what I can do next?