i_like_eggs · Just an egg · ✭✭✭✭✭

you could re run the SolarWinds maintenance manually and see if it clears up the errrors, still id recommend contacting SolarWinds Support with the errors you've mentioned Start Database Maintenance in the SolarWinds Orion > Advanced Features program folder. Click Start.

solarwinds uses a poll based method to gather deivces Status, responce and drops via ICMP It will poll data every couple of minutes or every minute like you mentioned you have got the lowest values. you can recive real time data with the use of syslogs and traps if your device can send these to solarwinds then you can…

Hi fellas, i didn't get any answer for this in the end. apologizes for the lack of response on this. i think i have worked out how thresholds work and what the internal rule is, so just like SolarWinds, Cisco has its own built in thresholds for example: say you have a power sensor and its running normal at a value of 1000…

HI planglois​, can i ask where is the option in the log? i have looked through but cant see anything . many thanks in advances <?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <section name="log4net" type="System.Configuration.IgnoreSectionHandler" /> </configSections> <appSettings> <!-- User…

Cheers planglois​ thats just what i was looking for

HI. $swis = Connect-Swis -Hostname orion_ip -UserName USERNAME -Password "PASSWORD" #create the connection to Swis Add-PSSnapin swissnapin Get-SwisData $swis "SELECT Name AS AlertName, AlertMessage, AlertRefID, aa.Description, ObjectType, ac.Enabled, aa.Description,CategoryType,a.ActionTypeID,a.Title FROM…

Thanks guys, I ended up using the smart bundle installer on APE to match the PPE. That's a smart idea grouping them by custom properties , yea I'll push them over to the primary next time and build the APE. These days the lightweight installers are the business, but only a matter of time until a new client comes along on…

Best way to inderstand really is to run it in little chunks so Find an eventtype in the event type table for interaces like event something like interface down then just replace SELECT TOP 1 EventTime //what does it mean? FROM Events AS EndTimeTable where EndTimeTable.EventTime >= StartTime.EventTime AND…

something like this? select ahv.TimeStamp ,Caption ,ahv.EventTypeWord AS 'Event Type' ,Message ,asv.Acknowledged AS 'ACK Status' ,asv.Notes ,asv.AcknowledgedTime ,asv.AcknowledgedBy FROM AlertHistoryView ahv with(nolock) JOIN Nodes n WITH(NOLOCK) ON N.NodeID = RelatedNodeId JOIN AlertStatusView asv with(nolock)ON…

from the time i saw this and wrote the answer Will answered and its already a correct answer lol nice one

HI Mate, thanks for getting back but that still doesn't want to work, i put the dummy columns in and i get this: and when i select submit and preview i just get 'data is not available' can you please screenshot how you have set the data grouping? wish solarwinds wouldn't add this to custom charts its causing in consistency…

this should do the unmanaging for you over red that part lol.. this will un-mange for 2 minutes # Parameters $orionServer = "localhost" $orionUsername = "username" $orionPassword = "password" #Get snapin if (! (Get-PSSnapin | where {$_.Name -eq "SwisSnapin"})) { Add-PSSnapin "SwisSnapin" } # Connect to SWIS $swis =…

Thank you ZackM, i am going to play around with the report types see if i can get the outcome i want cheers,

HI mesverrum​, is it possible to output of the query below not with a chart or anything but just show the Select and the results, in a Custom HTML resource? i want to see if this would work rather then SWQL resource.. var params = JSON.stringify({query:'select n.caption, n.CPULoadHistory.AvgLoad from orion.nodes n where…

lol i cant seem to mark this answer as correct mmm what am i doing wrong ? lol

A very good starting point would be to start here: Chapter 18, page 882 http://www.solarwinds.com/documentation/apm/docs/SAMAdminGuide.pdf

cvachovecj how do you get NCM to show less number of lines before and after each change (by default it is 5)? thanks

HI, familyofcrowes​ xtraspecialj​ did you manage to find anything more on this? i am about to open a support case because i am getting slimier issues. cheers, Dan

IPAM dosent seem to hold the information you are looking for, the information is on the nodes you can in fact with SQL poll the data from the nodes if they have serial numbers and join onto IPAM records by IP address although this is not the best way to do things but can be done, or there maybe another way that i dont know…

excellent work friend

nice job philip.robinson​. you could also look at this from another perspective and create a resource that will act as a timer, something like node will re manged in 30 days or will be un-muted in 30 days or 7 days,could also have an informational email based on the query to informer number of devices that will re manged…

HI Orion, please paste the following Query to search for the Volume types were can filter by to show in the report: select distinct volumetype,VolumeTypeID from volumes output: paste back here lets see what we can do.

thank you for downloading it looks like you dont have the custom property 'customer' what i have done is removed the column name 'n_customer' so you will get something like this: i have attached the file for you named Volumesummaryreportnocustomer.xml

Thank you for pointing that out i have updated the screenshots now Missed the section 'Transfer status' you are correct selecting the trasfer status. Would be hella useful if it would just pop up when Show commands are executed. yea the outputs not formatted i hope this is something SolarWinds will make neat in the future…

hehe your welcome

hey, apologizes for the delay try this out, here's what your looking for: Select o.Caption AS [NODE], o.detailsurl as [_linkfor_NODE], o.IOSVersion, Serial, o.machinetype FROM Cirrus.Nodes n INNER JOIN Cirrus.EntityPhysical s ON n.nodeid = s.nodeid INNER JOIN Orion.Nodes o ON o.nodeid = n.corenodeid WHERE EntityClass IN…

Hey, the information in this table is being polled from the ncm job inventory. Do you have serial numbers on custom properties or are you after serial numbers of servers etc?

lol you could also break the events down into the event types looks cool as an stacked graph Here is the code: select convert(date,e.EventTime) ,Sum(case when e.NetObjectType = 'N' then 1 ELSE 0 END) AS [Node] ,Sum(case when e.netobjecttype = 'V' then 1 ELSE 0 END) AS [Volume] ,Sum(case when e.NetObjectType = 'I' then 1…

Hey, Heres a graph for ncm status. tweeking the code slightly might also be useful for your view select Convert(date,nc.LastInventory) AS [Date] ,sum(case when nc.LoginStatus like 'Connection Refused by%' then 1 else 0 END) AS [Connections Refrused] ,sum(case when nc.LoginStatus like 'Connectivity issues, %'then 1 else 0…

The first section of this is using a Custom Query resource - SWQL The second is using Custom charts SQL as a data series, it would be useful to know the grouping used in the charts i always have problems with grouping or could be a Component monitor using Custom object charts with the SAM module running SQL user…