i_like_eggs · Just an egg · ✭✭✭✭✭

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:

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…

Anytime

Lol oh yeah right there thanks dude

i am trying to mark you answer as 'answered' maybe i have 'newbie' rights? odd i cant find how to make the answer correct.. thats all i have..

you, could use use the golden Image approch, you pre-define all settings then deploy it with the image. but still this doesnt help when actaully pushing the agent out to already running vm's. might be worth puting this in your next build:Deploy with a Gold Master Imagem​ hopfully that helps

surething, you could use something like this: SWQL TILE QUERY SELECT Status, InstanceSiteId FROM ( SELECT i.Status, i.InstanceSiteId FROM Orion.NPM.Interfaces (nolock=true) i INNER JOIN Orion.NodesCustomProperties (nolock=true) as np on np.nodeid = i.nodeid WHERE np.xxx LIKE 'xxx' ) SWQL ASSET EXPLORER QUERY SELECT Status,…

i was actually hoping that the API would had a verb to update the world map table, would be a good feature. Still a couple of things you can do, just be careful. The first one is to update the table SELECT TOP 1000 * FROM [dbo].[WorldMapPoints] WHERE instance like 'Orion.Groups' here you can manualy update the Lat and Long…

I see alex jumping in <3