• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

Message Screener Log to SQL2000

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> Message Screener Log to SQL2000 Page: [1]
Login
Message << Older Topic   Newer Topic >>
Message Screener Log to SQL2000 - 24.Sep.2004 8:30:00 AM   
ssv1907

 

Posts: 7
Joined: 24.Sep.2004
From: Moscow, Russian
Status: offline
Hi All! Help me please edit this file for Message Screener log to SQL2000

CREATE TABLE WebProxyLog (
[ClientIP] varchar(32),
[ClientUserName] nvarchar(514),
[ClientAgent] varchar(128),
[ClientAuthenticate] varchar(5),
[logDate] datetime,
[logTime] datetime,
[service] varchar(16),
[servername] nvarchar(32),
[referredserver] varchar(32),
[DestHost] varchar(255),
[DestHostIP] varchar(32),
[DestHostPort] int,
[processingtime] int,
[bytesrecvd] int,
[bytessent] int,
[protocol] varchar(12),
[transport] varchar(8),
[operation] varchar(24),
[uri] varchar(2048),
[mimetype] varchar(32),
[objectsource] varchar(12),
[resultcode] int,
[CacheInfo] int,
[rule] nvarchar(128),
[FilterInfo] nvarchar(128),
[SrcNetwork] nvarchar(128),
[DstNetwork] nvarchar(128),
[ErrorInfo] int,
[Action] varchar(32)
)

CREATE INDEX [IX_WebProxyLog_Date] ON [WebProxyLog]([logDate]) ON [PRIMARY]
GO

CREATE INDEX [IX_WebProxyLog_DateTime] ON [WebProxyLog]([logDate], [logTime]) ON [PRIMARY]
GO

Fanks for U help
Post #: 1

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> Message Screener Log to SQL2000 Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts