Wednesday, December 24, 2008

Easier WLST syntax

An easy way to simplify WLST script syntax while working in interactive mode is to use the easeSyntax() command after you log in. Using the Example from Satya Ghattu's blog ( ) cd(“/Servers/testServer”) ls() After executing easeSyntax() to navigate around you will use. cd /Servers/testServer ls piece of cake. Thanks for the tidbit, Satya. This will be a great timesaver for me as I am working on developing new WLST scripts. - Brian

Tuesday, December 23, 2008

Checking for Expired SSL certificates: keytool -list -keystore -alias <AliasIfYouKnowIt> -v

Tuesday, December 2, 2008

Creating Perl Modules

I've always been gun shy about creating perl modules for my code because I've never found a great tutorial that breaks it all down. Today it all changes as I cvame across this posting that does a pretty good job at breaking down how it all works. At least in a simple case...

Getting the most recent row for each id

I was working on configTracker today (a pet project to watch server configurations for changes and do alerting, reporting, etc...) and ran into a scenario where I needed to find the most recent row in a table for a given id. The table has a column called aud_ts of type timestamp. and a column call host_id of type integer. After several iterations (my SQL skills are waining after not developing for 5 or so years....) I came up with: select host_id, max(aud_ts) from myTable group by host_id; Then, I can join this table against all the others in the system on host_id and aud_ts and know I'm getting the most recent info for this server.