AlexSoul · The Magician! · ✭✭✭✭✭

Which version of NPM you have installed?

just comment out line #82 and use this SQL script to build web-based report - this will then report on all nodes

Your nodes must be set to poll routing table. Do List Resources on nodes that don't show up and ensure you have Routing Table (or similar name) checked. To troubleshoot, just remove all filters after JOINs, this will give you full list of everything, without filtering anything out. Add a.Vendor into Select statement to get…

yes, this is because this query is not suitable to run directly in management studio. You need to stick it into Report Writer and run it via Node's report resource as explained above Alternatively, if you want to test this - just comment out (or delete) line 82

r1 is just an alias for AuditingEvents table - you can see this defined on line 78. It will then used in line 68 to display user. Please ensure you have changed database name. There are 3 instances in total that you need to change to whatever database name you have

I have noticed that Hardware is cutting on false positives. After a bit of digging it seems that you are checking overall hardware category status for the node. I do not know which table you need to check via SWQL, but from SQL perspective I am checking dbo.APM_HardwareInfo table and any rows with IsDelete=1 must be…

Outstanding! This script works out-of-the-box incredibly well. Thank You. Your prioritising solution is amazing I have also created HTML Resource to go on the same page for "Using Search": TITLE: Using Search <b>By Node Name</b><br/> If you want to just display a node or a group of nodes with similar names, type node name…

Thank You dnerdahl for sharing this document. Although it is quite technical - I can see where you are coming from. Well done on documenting and sharing this solution.

Yep, that works, I didn't realise you can link image from internet. Gif is not animated though. Thanks for the hint - new tool in my pocket

That's cool ... although the whole point I guess was to be able to do so with Worldwide map where you can see your nodes as well.

That's cool, thanks for the hint hejman08. I could not find iframe tag, but I have added this line as a first line in the code, before <script> tag and it works a magic

This is not what I am asking for. I need to auto-refresh weather data itself, not nodes. At the moment I am using Chrome plugin to auto-refresh the whole page, but I am noticing that this is not always triggers refresh of the weather data. P.S. To auto-place nodes on the world map I have much better solution: Automatically…

Are you able to assist further with this? Can you help with SQL script?

Hi Guys, works brilliant but it doesn't refresh automatically. I just wonder if anyone had the same?

I have page with 20+ SQL reports on it - it does take time, but it loads them all pretty quick. I am not sure how exactly SWQL works, but the bottom line is - data is stored in SQL server. Tell me if I am wrong... even if it looks like it is one table - at the back of it you will still have SQL query being performed which…

ha-ha ... you reminded me about this: My Name Is Alex Soul And I Freaking Rock! well done! I learned in the past that you do not become an expert - you claim it! 5 stars *****

lsipple‌, thank you so much for the update and bug-fix. I have uploaded correct script file here for others to use

Sorry, slightly off topic, but still related. I was looking for a solution to increase font in certain widgets on certain pages. It seems like this HTML code does exactly that - it is able to modify the way widget looks like. Would it be possible to create similar HTML, which will modify size of the font in a given widget…

Yes, that's right. Replace the whole section of ###instet rows with ###Upsert rows from my comment. Also, you have mentioned that SP has been created already - so, you should be fine with this step. Best luck

well done thanks

Another test would be to run this PowerShell script with "Write-Host $Upsert" uncommented and ensure that every rowValue has a valid value. Non of them should be NULL

OK, I think I know. Do step (2) before step (1) in my previous comment. You do need to have Stored Procedure in SQL beforehand. Let me know how it goes...

Hmm.. not entirely sure. I have notice that sometimes copy-paste would screw characters. Try re-typing... I could have uploaded text attachment here, but there is no option to upload a file

I have summarised the whole process how to setup live VMWare Datastores monitoring here: Monitoring VMWare Datastores With SolarWinds SAM Thank You once again for sharing the above scripts -- Alex

OK, I am answering my own question above myself: After consulting with our DBA we came to conclusion that better way would be to utilise StoredProcedure within SQL to do the job. Here is what you need to do on top of everything what has been described above by hcy01uk 1. Change powershell script above a little bit, just…

That is absolutely awesome approach to monitor VMWare Datastores. I had a couple glitches whilst configuring everything from scratch, but those were due to permissions, default settings for PowerCLI, some default restrictions in PowerShell, etc. After getting though all this stuff - I can confirm above implementation works…

Orion will not be able to notify you about its own MSMQs, simply because your alerts will not go further than MSMQ itself. To be able to catch this - you need completely independent monitor.

Brilliant, thanks for the detailed feedback. I will come back to it once my platform is ready (in couple more weeks probably).

With regards to your question about location - please double-check script above. There is a specific column in the table which is used to populate location name. It is called "StreetAddress". Not the best name for it, but basically this is description that you see when you hover over pin on the map. I am not sure what you…

Thanks, never new that as I have never tried really. Ok, in this case I am even more excited about my approach I have been taking so far (described above in the article). Nowadays I do not create Auxiliary database anymore though. I create tables directly in Orion Database and prefix them with "AUX_" - works just fine here…