Well, I'm stumped. I'm trying find a way in KIX to parse through multiple log files '@wksta.@domain.log' (which were generated via a KIX inventory script), and aggregate the reults to CSV format for import to Excel...Here is an example of one of the Log files:
--------------------------------------------
Opened 'QRTP50001.QRTP.log' at 05:58:42
--------------------------------------------
System Information
--------------------------------------------
DOMAIN = QRTP
LOGON_SERVER = \\QRTPNTPDC1
WORKSTATION = QRTP50001
USERID = user
FULLNAME = Test User
PRIVILIDGE = USER
IPADDRESS = 10. 1. 37. 52
MAC_ADDRESS = 00B0D056B084
LOCATION = CHELSEA
OS_VERSION = W2K
CPU_SPEED(MHz) = 498
FREE_C:\(Bytes) = 1401796
KIX_VERSION = 3.62
KIX_Directory = \\qrtpntbdc1\netlogon\logon
AMO_INSTALLED = Yes
SDO_INSTALLED = Yes
LAST_LOGIN = 2001/09/05 05:58:43
--------------------------------------------
Software Information
--------------------------------------------
Software Entry 1 Adobe Acrobat 4.0
Software Entry 2 AOL Instant Messenger (SM)
Software Entry 3 Branding
Software Entry 4 Unicenter TNG Software Delivery Option
Software Entry 5 Citrix ICA Client
Software Entry 6 Compaq Insight Manager XE Client Files
Software Entry 7 Internet Explorer Exception pack
Software Entry 8 Microsoft Internet Explorer 6
Software Entry 9 Internet Explorer ReadMe
Software Entry 10 J-Bots 2000m
Software Entry 11 LiveUpdate
Software Entry 12 Lotus Notes
Software Entry 13 MSN Gaming Zone
Software Entry 14 Microsoft PhotoDraw 2000
Software Entry 15 Microsoft Windows Critical Update Notification
Software Entry 16 Motocross Madness 1.0
Software Entry 17 Norton AntiVirus 5.0 for Windows NT
Software Entry 18 OutlookExpress
Software Entry 19 Proxy Remote Control Master
Software Entry 20 Windows 2000 Hotfix (Pre-SP3) [See Q293826 for more information]
Software Entry 21 Internet Explorer Update Q295106
Software Entry 22 Windows 2000 Hotfix (Pre-SP3) [See Q298012 for more information]
Software Entry 23 Internet Explorer Update Q299618
Software Entry 24 Windows 2000 Hotfix (Pre-SP3) [See Q300972 for more information]
Software Entry 25 Windows 2000 Hotfix (Pre-SP3) [See Q301625 for more information]
Software Entry 26 Remedy User 4.0
Software Entry 27 Remote Control Option
Software Entry 28 Shockwave Flash
Software Entry 29 SPX
Software Entry 30 Visual Kixtart Editor
Software Entry 31 WildTangent Updater
Software Entry 32 Windows 2000 Service Pack 2
Software Entry 33 WinRAR archiver
Software Entry 34 WildTangent Web Driver
Software Entry 35 Microsoft Office 2000 SR-1 Premium
Software Entry 36 Reflection X 8.0.1
Software Entry 37 Microsoft Windows 2000 Professional Resource Kit
Software Entry 38 WebFldrs
Software Entry 39 Windows 2000 Application Compatibility Update
Software Entry 40 DameWare NT Utilities
Software Entry 41 Macromedia Extension Manager
Software Entry 42 Macromedia Dreamweaver UltraDev 4
Software Entry 43 Windows 2000 Administration Tools
Software Entry 44 Extranet Access Client
------------------------------------------
There are approx. 1500 of these that I would like to parse and concatonate into a single CSV file.
Any help would be appreciated, I have a temporary solution in Unix Kornshell using Awk, but would like to keep the solution in pure KIX if possible.
Thanks for any pointers...
Chuck,
[ 05 September 2001: Message edited by: chas31av ]
[ 05 September 2001: Message edited by: chas31av ]