I'm using Splunk preview 2 (20071229) and have not been able to retrieve Security events from Windows XP workstations (non-domain members) at all; however, Windows 2003 R2 works fine. The problem is replicable on multiple workstations, so I can provide additional debugging information if anyone's interested.
As a followup to Burana400's comment - one additional thing that would be useful would be normalization and/or automatic extraction and indexing of fields from the "description" field of the Windows Event log. This is particularly valuable for security log events since the majority of the valuable information lies in the description field, unfortunately.
I'm putting together a transforms.conf that pulls out some of the most frequently-used fields from logon/logoff events for our internal use; if anyone thinks it's useful, I may put some additional time into it and make a bundle out of it. Here's a partial list of the contents (not sure if this will transmit well over the forum, feel free to mail me at james at unc dot edu for a clean copy):
[user]
REGEX = ^.*[\t]{1,}User\s+Name:[\t]{1,}(\S+)\s*\n.*$
FORMAT = winUserName::$1
[domain]
REGEX = ^.*[\t]{1,}Domain:[\t]{1,}(\S+)\s*\n.*$
FORMAT = winDomain::$1
[logontype]
REGEX = ^.*[\t]{1,}Logon\s+Type:[\t]{1,}(\S+)\s*\n.*$
FORMAT = winLogonType::$1
[logonprocess]
REGEX = ^.*[\t]{1,}Logon\s+Process:[\t]{1,}(\S+)\s*\n.*$
FORMAT = winLogonProcess::$1
[authpackage]
REGEX = ^.*[\t]{1,}Authentication\s+Package:[\t]{1,}(\S+)\s*\n.*$
FORMAT = winAuthPackage::$1
[workstation]
REGEX = ^.*[\t]{1,}Workstation\s+Name:[\t]{1,}(\S+)\s*\n.*$
FORMAT = winWorkstation::$1
[srcaddr]
REGEX = ^.*[\t]{1,}Source\s+Network\s+Address:[\t]{1,}(\S+)\s*\n.*$
FORMAT = winSrcAddr::$1
[srcport]
REGEX = ^.*[\t]{1,}Source\s+Port:[\t]{1,}(\S+)\s*\n.*$
FORMAT = winSrcPort::$1
Suggestions on improving the regexes are welcome; in most cases I've had to allow for one or more tab characters because the format of the description field varies from event to event. I understand that this situation has improved in Vista but deployment of that OS is very, very slow where I am, so we'll be parsing the older log formats for the foreseeable future.
James