Hi All,
suppose you were an IS amanager and were concerned to detect whenever
administrators under your control changed things in TSM without filing
approprate change management documentation and seeking approval beforehand.
How would you approach this?
I can think of two possibilities -
1. Unload using sql to CSV files all of the relevant database tables daily,
eliminating those fields that change without administrator action, and run a
diff process between yesterday's and today's files to detect changes.
This has the advantage of completeness, but only compares snapshots, so it only
captures the last change on a given day, and may not detect an implementation
and backout. It is also dependent on database structure, which will change
unpredictably between versions.
2. Postprocessing the actlog.
This has the issues of separating scheduled commands from live commands, spurii
from syntax errors and filtering of delete/define/update commands from purely
query commands.
I'm half inclined to do both in some sort of scripting language - Ruby is my
current flavour of the month, but Perl will do just as well.
What do the rest of you do?
Steve
Steve Harris
AIX and TSM Admin
Queensland Health, Brisbane Australia
***********************************************************************************
This email, including any attachments sent with it, is confidential and for the
sole use of the intended recipient(s). This confidentiality is not waived or
lost, if you receive it and you are not the intended recipient(s), or if it is
transmitted/received in error.
Any unauthorised use, alteration, disclosure, distribution or review of this
email is prohibited. It may be subject to a statutory duty of confidentiality
if it relates to health service matters.
If you are not the intended recipient(s), or if you have received this email in
error, you are asked to immediately notify the sender by telephone or by return
email. You should also delete this email and destroy any hard copies produced.
***********************************************************************************
|