i_like_eggs · Just an egg · ✭✭✭✭✭

hey, your need the SAM Module for this but its here:

HI @Tdanner but what is the definition? i have done the below and copied a 'definition' from an exciting report but its not quite working have i got the syntax correct? Invoke-SwisVerb $swis Orion.Report CreateReport @("Active Alerts older than 7 days","All alerts 'Active' older then 7…

agh yes thanks, ill use the Notes field of when the update will happen and include that in the report to get the details into the report. would have been cool to have a random field that will allow enter data in a adhoc manor and save to the report but this can work Thanks for your assistance

You will need to add the widget back to the view, its worth mentioning that once you remove the widget it will go back to its default

Who knew a CPU report could have so many veriabels lol

'remote install' didn't see that

jburke​ did you manage to get it to work in the end? if so what did you do? thanks

i have made some updates to this query to include Perfstack charts to pre populate 'Availability' SELECT n.Caption as [Node], n.IP_Address AS [IP Address], c.Detailsurl as [_linkfor_Node] ,n.StatusDescription AS [Status] ,'Availability' as [Availability] ,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node]…

+plus 1 for that. Could be the engineID table or the website table that has the old data still there, removing the old fields and re running the configuration would hopefully do the job, definitely do that with solarwinds assistant

Following on from this, i would suggest trying to remove 'nightly inventory job' from this device if you have this set up or removing the node from NCM if its configured with this modul. I would remove the device from NCM then check back tomorrow

You could actually do the same thing paste the SQL code in to the report but select the 'advanced Database Query (sql,SWQL) paste bam lol

you could reverse the logic here.

I like the syslog idea nice one superfly99​

also a issue for me, do we know of a work around for this?

if you add this resource then add your filters for nodes down it will be status '2' and status '1' for up. you can include custom properties for extra filters. nodes.status = '2' AND Nodes.OfficeName like '%cro%'

HI ryan.davis26​, i am trying to learn this. how do i read up more how this works ? thanks,

Potentually you could try something like this and build in your ODBC canonical datetime format. unforuntaly i dont have wireless access points in my setup but here is an example data from events table, you might be able to tweek to your needs.. i just stuck the MIN function in so i didnt need to call it in my grouping…

hehe, yea the SDK and what its capable of doing will put me out of a job lol some really cool stuff the SW guys are doing to automate tasks.. agh yes the the dashboard comes from the variable $path = "newname" before it would have been $path = 'Dashbaordv2 i just removed it thinking its easy to read

yo. if you are getting chunks of netflow data and not minute by minute check this out Netflow data spikes instead of flowing evenly as expected transfer rate - SolarWinds Worldwide, LLC. Help and Support

Good day, Are you listing resources after a reboot of the node? this maybe be a problem with the interfaces reindexing after the reboot? (possible Fix below) you can delete the rogue interfaces by the following (but yea this will mean you will loose the interface history) Click manage nodes. Then re-list resources. this…

this link should work: ORION PLATFORM 2019.2 - ORION MAPS 2.0

haha damn thats not fair lol i just copied the post lol that rogue comma in the select statement how do you get eh text background for code? nice and neat

Your need to re run the configuration wizard and specify not to use https. if you have already done so you could reference the Migrate SolarWinds Orion products to a new server with a new IP or hostname and update tables referencing to the old syntax. DECLARE @oldHostname nvarchar(max) SET @oldHostname = 'Server1' DECLARE…

cscoengineer​ where can i read more on this? cheers,

nice work, i am planning a Servicenow integration ill be sure to bookmark

are these filters Just base on sql filters In the WHERE clause? So ineterface.status <>2 and node.vendor like 'cisco'

Speaking with support. PaaS and SQLaaS are not supported. Installation of Orion to Azure Virtual machine and DB storage in another Azure virtual machine was tested and supported. Amazon RDS is supported Anything else besides these have not been tested. The above are our official requirements for Orion Core.

agh i see, thank you, this leads me to my next question how do i see the available verbs? i thought the only available verbs were in purple lol this is going to answer another question i have lol. i created a PS script to create custom properties using the Orion.NodesCustomProperties CreateCustomProperty which was cool. i…

something like that?

Re-red youe question lol. You should just reverse the logic for the alert so where alert on node down flip it over and say where node is up that will be all the object that can trigger