One Liners: Sys Admin

• To get a list of the applications using the most memory: tasklist | sort /+65 /R | more
• To get the date your password will expire: net user %USERNAME% /domain | find /i "expires"
• 
  

Testing tools

Found a few sites that have great links to resources: opensourcetesting.org & softwareqatest.com.

I'm trying Log Parser Studio and have tried Splunk.

I've evaluated Telerik's Test Studio and was very impressed, but it's not something I can afford out of my pocket.

I've gotta say that if I can't persuade my employer to purchase PowerGREP I may pay for it myself. It does a lot when you need to look through and report on a variety of logs (WebSphere, IIS, Apache, DB2, SQL, vendor specific...). It uses regular expression or literal text and does collection that can be raw or grouped using a variety of methods.

Lawson Cleanup

Lawson Cleanup

The following are compiled from several resources and are in no particular order:



deljobhst -cjrw delete everything over 90 days
delusers delete orphaned users
jobinteg -vd
secinteg
permsmaint

RegEx Examples

Regular Expression Examples

Text Log Extractions

Multi-Line

^2013-01-16.{1,}16:[0-9]{2}:[0-9]{2}.+\)\x0AUSER:\s000000\x0Afinished\s.+ACCESS\sDENIED\x0a$

Breakdown:

^   Start Multi-line pattern

2013-01-16.{1,}16:[0-9]{2}:[0-9]{2}   Date stamp
.+   any character 1 or more times
\)   specific character ) could use \x29 or \051
\x0A  New line could be \n
USER:   beginning of next line starts with USER:
\s   There's white space
000000  looks for specific number sequence
\x0A  New line could be \n
finished   beginning of next line starts with finished
\s   There's white space
.+   any character 1 or more times
ACCESS\sDENIED   finds `ACCESS DENIED`
\x0A   New line could be \n
$   end of multi-line pattern

To get the UID, token and action that was denied:

^(USER:\s)([0-9]{6})(\r\n|\n)(.+tokenName=)(([A-Z]{2}[0-9]{2,3}\.[0-9]{1})|([A-Z]{2}[0-9]{2,3}))(.+actionCode=)([A-Z]{1})(:.+DENIED)$
Collect: $2,$5,$9\n
will return:        000000,GL124,I

How it works:
^ starts the multi-line pattern
(USER:\s) looks for the user
([0-9]{6}) gets the UID
(\r\n|\n) looks for the line break
(.+tokenName=) looks for the token
(([A-Z]{2}[0-9]{2,3}\.[0-9]{1})|([A-Z]{2}[0-9]{2,3})) gets the token
(.+actionCode=) looks for the action
([A-Z]{1})gets the action
(:.+DENIED) filters only the DENIED messages
$ ends the multi-line string