berger

wrodenbusch, can you ask to get it changed? Since this is clearly a bug in report writer. The logical "starts with 123.456" = the SQL "LIKE '123.456%' ", but report writer is obviously meant to convert the logical into SQL, which it's not doing correctly here. Also found some bug, where sorting integers/dates doesn't work…

From what I've been reading there is apparently no way to get perlscript support on a 64-bit machine, so going to just re-write it in vbscript. If anyone has gotten it to work using a community edition of activeperl, please post how you did it.

Found a somewhat lengthy workaround. If perlscripts don't work for you and you can't/don't want to re-write the exact script completley in vbscript. Save the perl scripts to the server and then write a vbscript which will execute the perl scripts in cmd and set echos/status based on the output of the perl scripts.…

Hmmm getting it to work in perlscript is a bit more cumbersome than I expected. Mainly because no matter what virsion of activeperl I dl, it doesn't seem to download perlscript support. :( Are you experiencing the same problem, or are the scripts just not executing correctly with APM?

Finally ended up fixing the script to make it get a response back from our server. The problem was that our server was for some reason not allowing "NTP Reserved" mode packets to process. So I left wireshark on over night, and saw that our machines were using "NTP_Client" mode. Spent a couple of hours figuring out how to…

You have to make a separate UnDP for each OID (much like you have separate component monitors), but that should only take maybe a minute each (if you know OID), or a bit longer with transformations. After that you can then assign each UnDP to as many nodes as you want, and when you alert on them you only need to create…

Thank's, taking out quotes fixed the bug. However now it's saying the script returns undefined error with script file creation failing for the .pl extension. Don't think I can install perl on the ntp server, since it's not really running any regular os? Also wondering if you know of any go-around using some tempus OID?…

Not sure why that wasn't working but ended up writing an SQL, which fixed the problem (also added it to only show >4 years). SQL has been added to content exchange ()

Here are some screenshots, 1st is how the report looks before I set sort decending for status (does the same for node name), and second is after I set sort decending.

Appears to be no way to edit UnDP string outputs without creating a report at the moment. But looks like the next virsion of NPM will allow for SQL-Trigger alerts (going by the beta), which should easily allow for editing and alerting on strings. 

Sorry, meant the script is working on this network as well with the public "us.pool.ntp.org", just not with our ntp server. I just noticed that the two servers are the only ones that have "" marks around them in SW: Pressing them when using "test node" does nothing, and pressing select after trying to click on one of them…

Thanks again for the quick response. I somewhat re-wrote the earlier script, and actually had ",1, True" but apperently an argument wasn't getting passed correctly into the perl script, causing nothing to be placed in the created .txt file, and causing me to thing that the vbscript wasn't waiting. Although the ",1 True" or…

Haven't written any advanced SQL, so just made it from the historical UnDP template, with Node Name sort* function * Statistic (from poller group) sort * function * Trigger: Custom Node Poller is equal to Last_Battery_Replace_Date Time Frame=past 10 mins (so that it only shows 1 date per each node) And Formated Statistic…

Am I missing something? Can't we send them as a link or directly viewable in body? Don't think we can send as attachment, but that seems minor.

Andy, On a similar note could you see if "does not contain" can get added to the simple trigger condition in alerts. e.g. "status does not contain /2/10" Thanks, Jacob

Hi, Not sure what you are trying to do, but creating a custom undp, and then setting an advanced alert on the poller with part of the trigger being "Status is not equal to ___" could work in similar fashion.

The only other question I found referencing basically the same thing is ">, but the answer there just advised using another OID, which I don't think exists in this case.

OID: 1.3.1.4.1.318.1.1.2.1.3 Name: APCupsBasicBatteryLastReplaceDate Description: "The date when the UPS system's batteries were last replaced in mm/dd/yy format. For Smart-UPS models, this value is originally set in the facotry. When the UPS batteries are replaced, this value should be reset by the administrator." MIB…

Hi, thank's for the reply I am using a Linux/Unix Script Monitor with the script attached to the first post. I've tried both creating the monitor and then assigning it to our NTP servers, and just testing it with the NTP servers, but when you checkbox the two NTP servers and press next (when assigning), it says I didn't…

Josh, The /C appears to have only semi-fixed the problem. cmd.exe is indeed waiting for the perl script to finish before closing the cmd window; however, the vbscript keeps going without waiting, and in doing so causing only part of the file that's supposed to be written from execution of the perl script to get written.…

Thanks for the quick reply. I didn't think /C would wait for my perl scipts to finish, much like an appended "& exit" wouldn't, but now looking at it again looks like I was wrong. I will try out /C and post if it makes a difference. Edit: Not sure why the other method was failing, but it looks like that did the trick,…

Wow I am blind, missed this completely () Danke for the help 

Thank's for the reply, I ended up making some last second changes and uploaded to thwack (Fall semester at school is starting back up, so was my last day working with SW for the time being), Also reset the pause after the call to execute the perl script, and didn't receive and non-up emails on it for 10+ hours, so I assume…

Don't have access to the server over the weekend so can't post any screen shots. But, the report is just Node Name Statitistic exNodeName 08/10/09 exNodeName2 05/05/07 The statistic is from a UnDP on OID 1.3.1.4.1.318.1.1.2.1.3 (APCupsBasicBatteryLastReplaceDate), although if I change it to a different UnDP with just some…

Yeah, it definitely would be nice if they had it in APM, but to elaborate on what I was saying earlier (which should function in a similar manner) You should be able to create a UnDP by: * Logging in to Orion * Going to Orion Universal Device Poller * Going to New Universal Device Poller * Add your OID/Name/Description…

Any suggestions?

Basically just wondering if I can switch the string value "8/4/10" output from an OID/UnDP into something that can be compared to other values. e.g. Even if you could somehow remove the '/'s and just have 080410 you could compare it to dates with some appended 0s. I've seen some posts on some similar string issues…

Would this work for you? * TimeFrame->Reletive Time Frame->Past 9 hours * Then go to job scheduler and set it to send you a report every day at 5. If not then I would suggest changing it to an Advanced SQL: * Go to the top bar -> Report -> Show SQL * When in design view hit the SQL tab -> Copy all of the SQL * Create a new…

Does anyone else have an ntp server monitored by a user experience monitor?

Hi Valisha, This seemed somewhat useful for us as well, so I made one and uploaded to content exchange ">. If you want top 10 for past 25 days, just add the line "TOP 10" after SELECT, e.g.: "SELECT TOP 10" and if you want a different time period, or just all time periods either edit or remove the "( DateDiff(dd,…