i_like_eggs · Just an egg · ✭✭✭✭✭

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'…

the node properties can be defined in the group itself by setting up a dynamic query you are able to determine what populates the groups based on the node properties, for example:

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:

awesome peice of code like it. can i ask what was your throught process here x.NODEID= ${NODEID}) ans can you do thjs with captions?

personally, I would re-run the config wizard and select the 'Enable HTTPS' this will then update the required tables.

personally this is what I would do. all in LAB first stage: [1] build new servers with 2016 O/S [2] configure and set up SQL 2016 [3] install the exact like for like modules on the new main polling engine, so both version match. [4] run configuration wizard as if you was going to set up a completely NEW solarwinds now you…

sweet thats good to know ill keep that document close by:). Just one more thought. if you have access to your db your be able to test filters before you put them in, for your desired output. Thats cool

here is an example: WITH (NOLOCK) INNER JOIN CustomPollerAssignmentView cv WITH (NOLOCK) ON cv.CustomPollerAssignmentID = CustomPollerStatusTable.CustomPollerAssignmentID WHERE CustomPollerName IN ('DataPower_ObjectAdminStateStatusTbl','DataPower_ObjectStatusTbl') AND (Status = 2)

very interesting, thanks man very, very informative One final little question what Cirrus.Nodes? thanks again

this should work what NPM version are you on? have you applied any hot fixes ? can i also also ask in your settings did you need to change anything for example thanks again dude

Yo dude, apologizes for the delay thanks for the nudge i had to comment out the CP but should give you what you want Select NodeID, Event_Time, NodeName, Event_Type, RELATEDNODEID, Acknowledged,AcknowledgedBy, Cast(Message As nvarchar(250)) as Message From ( SELECT Nodes.NodeID AS NodeID,Events.EventTime AS…