njoylif ✭✭✭✭✭

the following will give you a list of volumes in an "unknown" state (state with "?") using SQL to query the DB: select * from volumes where Status=0 so the question is if you want to use report writer, you need to use the "status" field where it =0 and build the rest out that way.

The name field is auto checked/populated (I think on each discovery). I have created a custom property (field) called HName for my user friendly hostnames and have a SQL script that runs nightly.. Basically, it chops off everything from the first "." on, removing the FQDN stuff. No idea why its populating the SN though…

That is based on the number of Nodes/interfaces and frequency that the poller has to poll. I would guess you have not put many devices on the new poller yet. If you want to even out some, you will need to move about half of your pollers (based on nodes/interfaces/poll frequency) over to the new system. Then take a look at…

I've got experience with this. call me at the number below, we'll either work it or schedule something and I will try to assist. Please backup your database before calling.

theoretically, there should be 3 IPs, 1 real IP on each box and 1 virtual IP. IF that is the case, you'd probably want to monitor all 3. If in fact, there is only one, I do not think it would be possible to monitor the ghost box at the time it was not answering for the IP.

SSL cert expiration reports unused objects (orphaned SSL Cert or profile, or member not tied to VS) would both be very useful to us.

They feel great, though I think they fit a little snug...but I'm a big dog

if you don't need in the history table on a per alert incident basis, you can tie using ${alertobjectid} from the AlertActive table. That is what is used to Acknowledge. I would love to hear from SW on this as well. I need to update my alerts with ticket numbers too and hopefully I'm missing it, but the custom properties…

if you are talking port level, edit the interface(s) and select the option to mark as unplugged when down.

If you need to have it in the same report, try specifying a table for datetime...like cpu.datetime (i did not review code in detail, but ambiguous column name indicates multiple tables have same column name when doing join). Nice work/research Sean!

what error are you getting and where are you trying to run this? in Orion DB Manager, SQL mgmt studio, SWQL?

I suppose it all boils down to personal preference and what the specifics of the job are... Personally, if I were to be customizing an environment as the job, i'd probably enjoy it...i.e. scripting, SQL stuff, custom pollers, etc... If it were a "babysitting job", not so much, i.e. simply admin'ing the envirnment day to…

new Case #125971 Original case #103596. Moved to new box and had to re-create jobs. But all was done over phone, and I tried to re-open original (friday noon-ish), but haven't heard back yet. Thanks and I'll post outcome.

I have seen it. let me see if I can search for remnants. It wasn't that big of a deal for me but I did go back and forth a little w/ support.

edit the interface and click on the checkbox to "customize bandwidth" and it will allow you to put in the custom bandwidth and use that for its calculations.

I haven't done this but it should be simple enough. All of the SolarWinds inter-communication should be done on the "private" vlan or subnet. accomplish this by using that IP range when running the configuration wizard, that way the poller and web server hit the DB on the private side. There would be no default gateway on…

you are correct. you would need to allow that poller to talk to the main NPM server and SQL (same server right?). All the info the additional poller collects goes in the DB and the web site polls the DB for its info.

i would suggest you schedule the report to run on the first of every month and have it automatically email your boss and copy yourself to ensure it is going out properly. Report scheduler can be accessed by RDPing into the primary NPM box. 

I would create a report for those events and email out hourly. Theoretically, alerts would be acted on and reports are informational.

I can't see how that could be possible because it has to query to see if anything changed. what might help (depending if I'm reading between the lines correctly) is to show cached page while reloading. There is a setting that will keep the page up and a little spinner at the top will indicate it is doing a refresh, that…

deeper/expanded usefulness for groups. everytime I try to deploy it, I find it is not doing what I wanted it to do...which is group for alerting... also...inability to resize windows that list things like templates, custom properties, etc.. see and vote for Feature Request here: https://thwack.solarwinds.com/ideas/2043 Let…

I've had problems with that before as well. it should work if you put the whole statement in where clause... SELECT TOP 10 Nodes.Caption , Nodes.SysName , Nodes.DNS FROM Nodes WHERE (SUBSTRING(Nodes.SysName, 1, CHARINDEX('.', Nodes.SysName) - 1) AS SysName_hostname) <> ( SUBSTRING(Nodes.DNS, 1, CHARINDEX('.', Nodes.DNS) -…

I created a custom field called HostName (or HName if using Netflow) and run a SQL script everynight to populate that...Basically it chops off the DNS part...See below UPDATE Nodes SET HostName = ( SELECT RTRIM( SUBSTRING( Caption, 1,( ( Select CASE WHEN (CharIndex ('.', Caption) > 0) THEN (CharIndex ('.', Caption)-1) ELSE…

awesome solution RichardLetts​​ if you don't have the caption in the trap and this was really necessary for you... I've been chewing on this for a while and trying various things... best I could come up with, (though not scalable...) create an app with checks looking for windows event logs. log the trap to the event log.…

Do you: get a trap when the condition clears OR get repeated traps until condition clears AND does each storage unit have a unique IP? If so, another option would be to have the main Orion Alerting engine do alerting for these. This gives you a unique and real Alert that you can reference in the SQL Tables. see HERE for…

The alerts page out of the box leaves something to be desired, IMHO... so I spent some time writing this page up - which will relate back to the node the hardware belongs to. Just create a view with a report as the page, put it on your appropriate tabs and there you have it. As to why you have all the alerts all of the…

My guess would be that the NodeID is not the primary key for this table where it is for the other tables. not sure which tables you are referring to, but that would be my guess. look at primary and foreign keys for this table to see what it uses to tie to the other tables you are working with.

awesome, thanks for sharing!!

this all looks great, especially like the "knowledge base" type bullet - resolving events or alerts, as well as the last bullet - adding events to task list.

I wanted this as well. The caption field is auto populated and will be overwritten if you change, so... Basically, I created a new column called HName (originally used HostName, but Netflow uses that and it caused issues). This assumes that you don't have any periods (.) in your device name as that is what I cut off from…