Hi All,
I am working on a log file , where i am parsing one log file for user name and their last login dates ..
this output return two columns , user name and last lgin date .
require 'ldapjclnt11.jar'
class OIDExtract < Batch::Job
include_package 'javax.naming' include_package 'javax.naming.ldap' include_package 'javax.naming.directory' include_package 'oracle.ldap.util'
IDTYPE_SIMPLE = 1 IDTYPE_DEFAULT = 3
configure acronyms: 'OID', do_not_track: true
def get_oid_connection(user_id, password, server, port = 10037) env = { Context::INITIAL_CONTEXT_FACTORY => 'com.sun.jndi.ldap.LdapCtxFactory', Context::SECURITY_AUTHENTICATION => 'simple', Context::SECURITY_PRINCIPAL => "uid=#{user_id}, cn=Users, dc=oracleoutsourcing, dc=com", Context::SECURITY_CREDENTIALS => password, Context::PROVIDER_URL => "ldap://#{server}:#{port}/", Context::REFERRAL => "follow" } ctx = InitialLdapContext.new(java.util.Hashtable.new(env), nil.to_java(Control)) end
def get_subscriber(ctx) roc = RootOracleContext.new(ctx) roc.getSubscriber(ctx, IDTYPE_DEFAULT, nil, ['*']) end
def get_user(ctx, sub, user_id) sub.getUser(ctx, IDTYPE_SIMPLE, user_id, ['*'].to_java(:String)) end
desc 'Extract user details from Oracle Internet Directory (OID)' job do admin_user = 'orcl_CommandCentre' admin_pwd = 'FiRST123!' server = 'logintrbs.oracleoutsourcing.com'
oid = get_oid_connection(admin_user, admin_pwd, server) sub = get_subscriber(oid)
xl = xl_create_workbook sheet = xl.workbook.add_worksheet(name: 'Users') sheet.add_row(['User Id', 'Create Date'], style: xl_styles['Title'])
log.info "Extracting users..." count = 0 users = sub.getUsers(oid, IDTYPE_SIMPLE, '*', nil, ['orcllastlogintime'].to_java(:String)) users.to_a.each do |user| count += 1 props = user.getProperties(oid, ['orcllastlogintime'].to_java(:String)) user.getDN(oid) =~ /^(?:cn|uid)=([^,]+)/ user_id = $1 create_date = props.getPropertySet(0).getProperty(0).getValue(0) create_date = Date.new(create_date[0..3].to_i, create_date[4..5].to_i, create_date[6..7].to_i) sheet.add_row([user_id, create_date]) # puts "#{$1}: #{Date.new(create_date[0..3].to_i, create_date[4..5].to_i, create_date[6..7].to_i)} (#{user.getDN(oid)} - #{create_date})" end log.detail "Output #{count.with_commas} users" xl_filter_and_freeze(sheet, 1) xl.serialize('OID_Users.xlsx') end
end
OIDExtract.run! if __FILE__ == $0
the above is the code :
but in the log file some user have last login date as
orcllastlogintime: 00000000 and some as orcllastlogintime: i, e blank only , so my code is getting failed with below error :
D:\Scripts\Batch\utils>jruby OID_Extract.rb DETAIL Loading configuration from D:/Scripts/Batch/lib/rbs/../../ secure_hp_config.yaml INFO Job 'OID Extract' started on VMHODTRBSP124 by c_anujt with PID 32252 DETAIL Working directory is: D:/Scripts/Batch/utils INFO Extracting users... ERROR An exception occurred in job 'OID Extract': ArgumentError: invalid date civil at jar:file:/D:/Scripts/Batch/jars/jruby-complete-1.7.3.jar!/META-I NF/jruby.home/lib/ruby/1.9/date.rb:809 OIDExtract at OID_Extract.rb:63 OIDExtract at OID_Extract.rb:57 run! at D:/Scripts/Batch/lib/batch/job.rb:66 (root) at OID_Extract.rb:75
INFO Job 'OID Extract' completed with errors in 2.001 seconds
now i have to write a code ..like
if
orcllastlogintime: 00000000 and some as orcllastlogintime:
then it should handle it ..accordingly.
