([EMAIL PROTECTED] [163.39.141.247])
by myrtle2.citicorp.com (Pro-8.9.3/8.9.3) with ESMTP id MAA00455
for <[EMAIL PROTECTED]>; Mon, 15 Nov 1999 12:37:26 -0500 (EST)
Received: from venus.email.citicorp.com ([EMAIL PROTECTED]
[163.39.252.139])
by x400prod2.cgin.us-md.citicorp.com (8.8.6 (PHNE_17135)/8.8.6) with ESMTP
id MAA03423
Mon, 15 Nov 1999 12:37:57 -0500 (EST)
Received: from localhost (root@localhost)
by venus.email.citicorp.com (8.8.6 (PHNE_17135)/8.8.6) with SMTP id
MAA01460
for [EMAIL PROTECTED]; Mon, 15 Nov 1999 12:34:59 -0500 (EST)
X-OpenMail-Hops: 1
Date: Mon, 15 Nov 1999 12:34:52 -0500
Message-Id: <H0000b6d05dd1874@MHS>
Subject: RE: Custom Reports
MIME-Version: 1.0
TO: [EMAIL PROTECTED]
Content-Type: multipart/mixed; boundary="openmail-part-1208da90-00000001"
Sender: [EMAIL PROTECTED]
Precedence: bulk
X-Loop: issforum
TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems!
----------------------------------------------------------------------------
--openmail-part-1208da90-00000001
Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit
Manuel:
Write an MS Access query to limits its output to the engine in question.
Then,
construct your reports using the MS Access Report Wizards. Here's how the
main
query might be constructed:
SELECT rslog.ID, rslog.EventDate, rslog.EventName, rslog.ProtocolID,
rslog.SourcePortName, rslog.DestinationPortName, rslog.SourceAddressName,
rslog.DestinationAddressName, rslog.RawData, rslog.EngineIP
FROM rslog
WHERE (((rslog.EngineIP)="engine ip address"))
ORDER BY rslog.EventDate;
(Note the "WHERE" statement.)
Peter Schawacker
CGTI Information Security-ISOCC NID/VA
-----Original Message-----
From: mrocha [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 12, 1999 10:35 AM
To: issforum
Cc: mrocha
Subject: Custom Reports
Hi,
How can I make custom reports in the RealSecure ???
How can I make a report from the data of one detector ??? I have 16 System
Agent and 2 Network engines.
Best Regards,
Manuel Rocha
Network Security Engineer Phone (809)220-7099
CODETEL a GTE Company Fax (809)220-4053
Dominican Republic Email [EMAIL PROTECTED]
--openmail-part-1208da90-00000001
Content-Type: application/octet-stream; name="Schawacker, Peter.vcf"
Content-Disposition: attachment; filename="Schawacker, Peter.vcf"
Content-Transfer-Encoding: base64
QkVHSU46VkNBUkQNClZFUlNJT046Mi4xDQpOOlNjaGF3YWNrZXI7UGV0ZXINCkZOOlNjaGF3
YWNrZXIsIFBldGVyDQpFTUFJTDtQUkVGO09QRU5NQUlMOlBldGVyIFNjaGF3YWNrZXIgLzAx
RVhUTkwNClJFVjoxOTk5MDUxOFQxOTM3MjhaDQpFTkQ6VkNBUkQNCg==
--openmail-part-1208da90-00000001
Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64
eJ8+Iv3jAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcADwAAAElQTS5O
b3RlLkhQQVRUAFkEAQ2ABAACAAAAAgACAAEDkAYADAAAAAEAAAADABcAAQAAABwAAQOQBgAM
AAAAAQAAAAMANgAAAAAAOgABBIABABMAAABSRTogQ3VzdG9tIFJlcG9ydHMAewYBA5AGACAA
AAABAAAAAgELMAEAAAAQAAAAIoSzMWqb0xGvywgACfz0UpAHAQOQBgAkAAAAAQAAAAMAYJwI
IAYAAAAAAMAAAAAAAABGAAAAAFKFAADwEwAADgQBA5AGACwAAAABAAAAHgBhnAggBgAAAAAA
wAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC41AMkDAQOQBgAkAAAAAQAAAAsAYpwIIAYAAAAA
AMAAAAAAAABGAAAAAAaFAAAAAAAAyQIBA5AGACQAAAABAAAAAwBjnAggBgAAAAAAwAAAAAAA
AEYAAAAAAYUAAAAAAAC9AgEDkAYAJAAAAAEAAAALAGScCCAGAAAAAADAAAAAAAAARgAAAAAO
hQAAAAAAANMCAQOQBgAkAAAAAQAAAAMAZZwIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAA
zgIBA5AGACQAAAABAAAAAwBmnAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAADQAgEDkAYA
JAAAAAEAAAALAGecCCAGAAAAAADAAAAAAAAARgAAAAAUhQAAAAAAANwCAQOQBgAkAAAAAQAA
AAMAaJwIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAA2QIBA5AGACwAAAABAAAAHgBpnAgg
BgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAABUDAQOQBgAsAAAAAQAAAB4AapwI
IAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAXAwEDkAYALAAAAAEAAAAeAGuc
CCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAGQMBA5AGACQAAAABAAAACwBs
nAsgBgAAAAAAwAAAAAAAAEYAAAAAAIgAAAAAAADTAgEDkAYAJAAAAAEAAAALAG2cCyAGAAAA
AADAAAAAAAAARgAAAAAFiAAAAAAAANkCAQOQBgAMAAAAAQAAAAMABhDgevIOdAIBA5AGAAwA
AAABAAAAAwAHEHoDAACYAAEDkAYAeAAAAAEAAAAeAAgQAQAAAGUAAABNQU5VRUw6V1JJVEVB
Tk1TQUNDRVNTUVVFUllUT0xJTUlUU0lUU09VVFBVVFRPVEhFRU5HSU5FSU5RVUVTVElPTlRI
RU4sQ09OU1RSVUNUWU9VUlJFUE9SVFNVU0lOR1RIRU1TAAAAAN8eAQOQBgAMAAAAAQAAAAMA
EBAAAAAAJAABA5AGAAwAAAABAAAAAwAREAAAAAAlAAEDkAYAIAAAAAEAAAAeAHAAAQAAAA8A
AABDdXN0b20gUmVwb3J0cwAAKQYBA5AGACgAAAABAAAAAgFxAAEAAAAWAAAAAb8vkDxSPaXP
vZtuEdOBMwDgKSEo7QAA5wkBA5AGAAwAAAABAAAAAwAuAAAAAAAyAAEDkAYADAAAAAEAAAAL
ACsAAAAAADcAAQOQBgAMAAAAAQAAAAsAAgABAAAADwABA5AGACwBAAABAAAAAgExAAEAAAAa
AQAAUENERkVCMDkAAQACAHYAAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAARU1TTURCLkRMTAAA
AAAAAAAAG1X6IKpmEc2byACqAC/EWgwAAABESVBST0QxAC9vPWNpdGljb3JwL291PURPTURJ
L2NuPVJlY2lwaWVudHMvY249cHNjaGF3YWNrZXIALgAAAAAAAAD26KTnxDbSEa+xCAAJ/PRS
AQALnrE1vSDSEa+eCAAJ/PRSAAAACKI9AAAAAAAALgAAAAAAAAD26KTnxDbSEa+xCAAJ/PRS
AQALnrE1vSDSEa+eCAAJ/PRSAAAACKI+AAAQAAAAIoSzMWqb0xGvywgACfz0UhMAAABSRTog
Q3VzdG9tIFJlcG9ydHMAAADfVQEDkAYARAAAAAEAAAAeAEIQAQAAADEAAAA8MEI5RUIxMzVC
RDIwRDIxMUFGOUUwODAwMDlGQ0Y0NTJCRTAyNTdARElQUk9EMT4AAAAA0AsBA5AGAAwAAAAB
AAAAAwDeP69vAAA/AgEDkAYAEAAAAAEAAABAADkA0NaRPJAvvwFsBAEDkAYADAAAAAEAAAAD
APE/CQQAAEEBAQOQBgAMAAAAAQAAAAMAGUABAAAAXgABA5AGAAwAAAABAAAAAwD9P+QEAAAo
AgEDkAYAYAAAAAEAAAACAfk/AQAAAE4AAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAAAAAA
L089Q0lUSUNPUlAvT1U9RE9NREkvQ049UkVDSVBJRU5UUy9DTj1QU0NIQVdBQ0tFUgAAACYW
AQOQBgAkAAAAAQAAAB4A+D8BAAAAEgAAAFNjaGF3YWNrZXIsIFBldGVyAAAAsQcBA5AGAGAA
AAABAAAAAgH7PwEAAABOAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC9PPUNJVElD
T1JQL09VPURPTURJL0NOPVJFQ0lQSUVOVFMvQ049UFNDSEFXQUNLRVIAAAAoFgEDkAYAJAAA
AAEAAAAeAPo/AQAAABIAAABTY2hhd2Fja2VyLCBQZXRlcgAAALMHAQOQBgAQAAAAAQAAAEAA
BzCM/4IqkC+/AS4EAQOQBgAQAAAAAQAAAEAACDBIFpk8kC+/ASsDAQOQBgBEAAAAAQAAAB4A
NRABAAAAMQAAADwwQjlFQjEzNUJEMjBEMjExQUY5RTA4MDAwOUZDRjQ1MjM0MEE0N0BESVBS
T0QxPgAAAACxCwEDkAYAEAAAAAEAAABAAEgAsOGRPZAvvwFnBAEDkAYANAAAAAEAAAAeAG6c
8G2G6onx0RG1WAgACbFJ2gAAAAABAAAAAQAAAAoAAABJU084ODU5XzEAAACpCwEDkAYAOAAA
AAEAAAAeAG+c8G2G6onx0RG1WAgACbFJ2gAAAAACAAAAAQAAAA4AAABCLjA1LjIwLjAwLjAx
AAAA2AsBA5AGACAAAAABAAAAAgEUNAEAAAAQAAAAVJShwCl/EBulhwgAKyolFz4FAQOQBgAY
AAAAAQAAAB4APQABAAAABQAAAFJFOiAAAAAAUwEBA5AGAAwAAAABAAAAAwCAEP////+QBAEJ
AAQAAgAAAAAAAAABA5AGAAwAAAABAAAACwAjAAEAAAAwAAEDkAYADAAAAAEAAAALACkAAQAA
ADYAAQSQBgCQAQAAAQAAABIAAAADAAAwAAAAAAsADw4AAAAAAgH/DwEAAAA5AAAAAAAAAIEr
H6S+oxAZnW4A3QEPVAIAAAAAJ2lzc2ZvcnVtJwBTTVRQAGlzc2ZvcnVtQGlzcy5uZXQAAAAA
HgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABEAAABpc3Nmb3J1bUBpc3MubmV0AAAAAB4A
ATABAAAACwAAACdpc3Nmb3J1bScAAAIB9g8BAAAABAAAAAAAAAADABUMAQAAAAIBCzABAAAA
FgAAAFNNVFA6SVNTRk9SVU1ASVNTLk5FVAAAAB4AIDoBAAAACwAAACdpc3Nmb3J1bScAAAsA
QDoBAAAAAwD+DwYAAAADAAA5AAAAAAMAcToAAAAAAwD/XwAAAAADAP1fAQAAAB4A9l8BAAAA
CQAAAGlzc2ZvcnVtAAAAAAIB918BAAAAOQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAACdp
c3Nmb3J1bScAU01UUABpc3Nmb3J1bUBpc3MubmV0AAAAAMdHAgKQBgAOAAAAAQD/////IAAg
AAAAAAA9BAISgAMADgAAAM8HBwANAAkAJwAYAAIANAECE4ADAA4AAADPBwUAEgAPACUAHgAC
AEEBAhGABgC4DQAAAQAJAAAD3AYAAAAAIQYAAAAABQAAAAkCAAAAAAUAAAABAv///wClAAAA
QQvGAIgAIAAgAAAAAAAgACAAAAAAACgAAAAgAAAAQAAAAAEAAQAAAAAAAAEAAAAAAAAAAAAA
AAAAAAAAAAAAAAAA////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA////////////////////////
//8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP//////////////////
//8hBgAAQQtGAGYAIAAgAAAAAAAgACAAAAAAACgAAAAgAAAAIAAAAAEAGAAAAAAAAAwAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACEhoSE
hoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSE
hoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoQAAACEhoTGx8bGx8bGx8bGx8bG
x8bGx8bGx8bGx8bGx8bGx8bGx8bGx8b/////////////////////////////////////////
//////////////////////////+EhoQAAACEhoTGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bG
x8bGx8bGx8bGx8b/////////////////////////////////////////////////////////
//////////+EhoQAAACEhoTGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8b/
//////////////////////////////////////////////////////////////////+EhoQA
AACEhoTGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8b///+EhoSEhoSEhoSE
hoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoT///+EhoQAAACEhoTGx8bGx8bG
x8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8b/////////////////////////////////
//////////////////////////////////+EhoQAAACEhoTGx8bGx8bGx8bGx8bGx8bGx8bG
x8bGx8bGx8bGx8bGx8bGx8b///+EhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSE
hoSEhoSEhoSEhoT///+EhoQAAACEhoTGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bG
x8bGx8b/////////////////////////////////////////////////////////////////
//+EhoQAAACEhoTGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8b///+EhoSE
hoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoT///+EhoQAAACEhoTG
x8aEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoTGx8bGx8b/////////////////////////
//////////////////////////////////////////+EhoQAAACEhoTGx8aEhoQAAACEhgCE
hgAAAAAAAACEhgAAAACEhoTGx8bGx8b/////////////////////////////////////////
//////////////////////////+EhoQAAACEhoTGx8aEhoSEhoQAAAAAAAD///////8AAACE
hoSEhoTGx8bGx8b/////////////////////////////////////////////////////////
//////////+EhoQAAACEhoTGx8aEhoSEhoQAAAD///////8AAAAAAACEhoSEhoTGx8bGx8b/
//+EAACEAACEAACEAACEAACEAACEAACEAACEAACEAACEAACEAACEAACEAACEAAD///+EhoQA
AACEhoTGx8aEhoQAAAAAAAAAAAD///////////8AAACEhoTGx8bGx8b///+EAACEAACEAACE
AACEAACEAACEAACEAACEAACEAACEAACEAACEAACEAACEAAD///+EhoQAAACEhoTGx8YAAADG
x8bGx8b///////////////8AAACEhoTGx8bGx8b/////////////////////////////////
//////////////////////////////////+EhoQAAACEhoTGx8YAAADGx8bGx8YAAAD/////
//////////8AAADGx8bGx8b/////////////////////////////////////////////////
//////////////////+EhoQAAACEhoTGx8YAAADGx8bGx8YAAAD///////8AAAAAAACEhoTG
x8bGx8b/////////////////////////////////////////////////////////////////
//+EhoQAAACEhoTGx8YAAADGx8bGx8bGx8YAAAD///////8AAACEhoTGx8bGx8b/////////
//////////////////////////////////////////////////////////+EhoQAAACEhoTG
x8aEhoQAAADGx8bGx8bGx8bGx8bGx8YAAACEhoTGx8bGx8b/////////////////////////
//////////////////////////////////////////+EhoQAAACEhoTGx8aEhoSEhoQAAAAA
AAAAAAAAAAAAAACEhoSEhoTGx8bGx8b/////////////////////////////////////////
//////////////////////////+EhoQAAACEhoTGx8bGx8bGx8bGx8bGx8bGx8bGx8bGx8bG
x8bGx8bGx8bGx8b/////////////////////////////////////////////////////////
//////////+EhoQAAACEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSE
hoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoSEhoQA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAADAAAAAAAuDwIQgAEADQAAAFNDSEFXQX4xLlZDRgBzAwIBkAYAFgAAAFNjaGF3
YWNrZXIsIFBldGVyLnZjZgC1BwIFkAYAHAEAABMAAAADACEOAAAAAAMACzf/////AwAgDqUO
AAADAPcPAAAAAEAABzDAJLuAPc2+AUAACDAAIbE/bqG+AQMABTcBAAAAQAD7fwBA3aNXRbMM
AgECNwEAAAAAAAAAQAD8fwBA3aNXRbMMAwD9fwAAAAAeAAEwAQAAABYAAABTY2hhd2Fja2Vy
LCBQZXRlci52Y2YAAAADAPp/AAAAAAsA/n8AAAAAHgAHNwEAAAAWAAAAU2NoYXdhY2tlciwg
UGV0ZXIudmNmAAAAHgADNwEAAAAFAAAALnZjZgAAAAACAfkPAQAAABAAAAAkhLMxapvTEa/L
CAAJ/PRSAwD+DwcAAAACAfgPAQAAABAAAAALnrE1vSDSEa+eCAAJ/PRSYUA=
--openmail-part-1208da90-00000001--
