This is an extract from spl liscenece log file

06/16/03 10:07:46 NOTICE: "./spm_key (Ver.1.1.11)" started to install licenses.
06/16/03 10:09:37 INFO: (fd=195.0): SPM license connection from [EMAIL PROTECTED]
035.cinegroupe.com[192.168.20.81] established (client SPM-version 1.1.11 [1223])
06/16/03 10:09:37 INFO: (fd=195.0) OUT xsirender XSIBatAdv2X 3.0 (SOFTIMAGE) granted:1(1) (1 shared)
06/16/03 10:09:38 INFO: (fd=192.0): IN xsirender XSIBatAdv2X 3.0 (SOFTIMAGE) returned:1


Here is what I am trying to do:

When ever there is a Notice line.. zap the table and continue to do the following
- get the host name from the SPM licence connection line like xsirender with reference to the fd #
update the table with host name and fd# and host name
- look for OUT line with the same FD# get the tag name like XSIBatAdv2X 3.0 and check if its
granted - up date the table with tag name
- then look for IN line with the same fd# and delete the all the entreid with the saem FD#


The point of all this to find out how many liscences are being used.

here is the tabke structure
id - autoincremeet
fd#
userid
tag
hostname
time

Let me know if u need more info on this

Thanks

Biju








From: "Dan Muey" <[EMAIL PROTECTED]>
To: "Biju Ramachandran" <[EMAIL PROTECTED]>,    <[EMAIL PROTECTED]>
Subject: RE: reading a text file
Date: Mon, 30 Jun 2003 11:02:02 -0500

> Hi there

Howdy

>
> In perl how do I read a text file and search for multiple

use open() or possibly File::SLurp
perldoc -f open
perldoc File::Slurp or search.cpan.prg

> matching patterns

Use regular expressions, this is a big topic.
if($text_file_guts =~ m/JoeMama/i) { ...

> and once found, write it to an Mysql

use DBI;
perldoc DBI


My question would be: once what is found write what to mysql? Perhaps more details would help us help you :)

>
> Thanks
No sweat!
HTH
Dmuey

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963



-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to