Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: Capacity Planning

by FreeBeerReekingMonk (Deacon)
on Dec 06, 2016 at 19:04 UTC ( [id://1177319]=note: print w/replies, xml ) Need Help??


in reply to Capacity Planning

Although there are perl tools to read directly from your input file: Spreadsheet::XLSX (it comes with an example that will get you up and running in no time, just remember to do "cpanm Spreadsheet::XLSX" to install the extra libraries), I think it is better to save the spreadsheet as csv and read it in with something like Text::CSV.

you can implement it in pure perl, or mix a bit of .bat code, to bring up a notepad with your results.

As for something that types in the results, and alt-tabs to excel and notepad individually, try another language, specialized in Windows, for example Autoit3, and that has a working multiping example.

However, if you want an automated, lightweight, app that runs each 10 minutes, and report if thresholds are out of range... do it in Perl. :)

There are some perl GUI's... but it is not for beginners.

so for example:

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1177319]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (2)
As of 2024-04-26 00:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found