i_like_eggs · Just an egg · ✭✭✭✭✭

can you run search the OID in the universal device poller and get a value back? On the success centre there is a link alluding to a permission checker issue it might be worth taking a look here: Success Center

agh i see bud, if your not sure. maybe use the Soalrwinds database manager or just a read only account. lol not the 'sa' like me MUHAhahahaha.. lol if you need me to review bits for you ill try help out i can run in my dev environment.. 

HI Gret, are you using SQL server 2008 by chance ? the CONCAT function was introduced in 2012 SQL server, you can use the following in SQL 2008. Select{fn CONCAT ()} something like this: Select {fn CONCAT('<img src="'+'/Orion/Images/StatusIcons/'+Nodes.Statusled+'" width="16" height="16">','<a href="' +…

sure, are you using a custom property for the email? if so, you can just assign that custom property to the alert and it would pick up email based on the nodes custom properties here is more information: Success Center

orioncrack​ Version 3 thank you for the feed back. i have now added some custom links for volumes and added per node basis i actually have another idea id like to implement into this this report it should be ultimate volume report at the end Volume Report - Fixed Disk - Available - Size - Used - overall volume capacity NEW…

Done a quick browse been abit tided up today check this link out the Second one seems more legit Catalyst 6500 generates SNMP-3-INPUT_QFULL_ERR when receiving IF-MIB - SolarWinds Worldwide, LLC. Help and Support i actually think this is the solution at the moment for you seems to meet everything you've mentioned Cisco…

yo, could you run this is SWQL Studio ? SELECT CustomPollerStatusOnNodeTabular.Uri, CustomPollerStatusOnNodeTabular.DisplayName,Name.CustomPollerName,adminState.[Status] AS [Admin Status],ObjStat.[Status] AS [Object Status] FROM Orion.NPM.CustomPollerStatusOnNodeTabular AS CustomPollerStatusOnNodeTabularINNER JOIN…

HI, sure, you just need to toggle the 'Time-based settings' to 'Yes' this will then give you the desired output once you 'submit'

np, i am wondering are you locked down to only these 12 servers? ideally, an perhaps building one new addition poller with the 2016 O/S first, then migrate all your nodes to another additional poller to keep up with polling, of course networking will need to be configured for this polling, this will now give you time to…

Defiantly contact Support they will be able to help you if this is unusual activity, best of luck but one last thing check the logs TopologyCalculator.logs Mine are here yours will be in the same place but depends on your install. C:\ProgramData\Solarwinds\Topology\Logs

thanks for your help with this mesverrum​ you have definitely solved this, i should have been more specific with my information i was creating a Custom Chart in the report section not as a recourse and creating the dummy chart as a recourse works wonderfully as a resources but as a custom chart not so. i can work with this…

hi, A few things here: * can you run a SNMP walk on the device and search the OID? * have you tried to poll the same OID on a diffrent node? how to run walk exe: Success Center id put my money on this one: * from experience i have seen organisations create views on SNMP so information from the MIB is explicitly revoked on…

SELECT n.Caption AS NODE,CASE WHEN DATEDIFF(DAY, e.EventTime, getdate()) > 3 THEN CONVERT(NVARCHAR(50), DATEDIFF(DAY, e.EventTime, getUTCdate())) + ' days ago' ELSE CASE WHEN DATEDIFF(HOUR, e.EventTime, getdate()) > 3 THEN CONVERT(NVARCHAR(50), DATEDIFF(HOUR, e.EventTime, getdate())) + ' hours ago' ELSE…

i guess this would be the ideal scenario # Connect to SWIS $swis = Connect-Swis -Hostname $orionServer -UserName $orionUsername -Password $orionPassword # Fetch an existing report definition $reportInfo = Get-SwisData $swis "SELECT top 1 Name, Category, Title, Type, SubTitle, Description, Definition, LimitationCategory,…

Deltona I Agree, this would make my life allot easier specially when i use these tiles inside EOC and use grouping customers with custom properties is quite tedious. It would also be good to have the ability to not only link to nodes/ volumes and interfaces etc but to have it link to Alerts and sync criticality of alert…

The more digging the more knowledge thanks guys

Hi, i have only seen this done in SQL, the table you would be looking for is interfacesThresholds here is the idea: select * from InterfacesThresholds where CurrentValue > Level1Value AND name like 'NPM.Interfaces.Stats.InPercentUtilization' current value is last polled level1value is warning, so on..

hey dude, When looking at the Database you have tables called 'details' this details holds 7 days worth of data reflecting/ retention periods your see something like this: APM_ApplicationStatus_Detail < polling cycles, data that hasn't rolled up. APM_ApplicationStatus_Hourly < aggregated into an hour…

Agh I think I know the problem lol you need to use the custom query resource on the node details page and paste the query in that should work let me know if you if that works :)

hey, the query is going nodeid to ${nodeid} I have it working on th nodes details what type of message are you getting? Or is it just everything?

Hehe, you have me intreged..basically volume is what you would like? As a canned report?

Hi gert please paste your query here will take a look

looks like you are still looking at the Node rather then the table, please refer to the link i posted: "Key is to Start by setting Trigger Condition's Alert on: Custom Table Poller Current Status (Not Custom Poller or Node)"

Interesting, i am on NPM 12.5 i had a similar issue after un/re-managing a node it would go straight in to to unknown state. i didn't have an agent node polling but SNMP, to fix it i done a list recourses and select 'Status & Response Time' to be SNMP it then come back up, then i changed it back to 'ICMP (Ping) - Fastest'…

Thanks dude, yea whats really nice about the old method is you can just use Copy-Item cmdlet just copy to Report Writer folder done . can i export to xml then re-import Xml and use this method to bulk import Web based reports? ill give this a try my head was mush yesterday lol cheers

Hi tdanner​ thank you for your help. just run into a slight problem. tried so many ways to export the XML file and re import it i have tried to out file export to xml then import from xml but cant get it tow work if did create with the query. # Fetch an existing report definition $reportInfo = Get-SwisData $swis "SELECT…

hay hay, gonna ask, can you only import alerts that are already imported? iv tried a few ways but when the alert is imported i can run the above and the alert imports but when the alert is removed and then i re try to import the alert with the verb it doesn't work, its like the import needs the alert to be imported first…

ha, and wow, i didn't realise, you can actually deploy the agent via PowerShell, here is a snippet of already made code provided by the tdanner​ (very coooool) OrionSDK/DeployAgentViaVerb.ps1 at master · solarwinds/OrionSDK · GitHub

Just landed on a gold mine of a thread nice work chaps

hi, if it helps, you could use the 'Node/Unmanage From' column and 'Add display settings' then select 'Days Ago'. output: