GFI Software Aurea SMB Solutions

Welcome to the GFI Software community forum! For support please open a ticket from https://support.gfi.com.

Home » GFI User Forums » GFI Archiver » Email Logs for OPRA requests (Report capability to generate email logs for OPRA requests)
Email Logs for OPRA requests [message #148315] Thu, 18 June 2020 13:34 Go to next message
SHeriff055 is currently offline  SHeriff055
Messages: 4
Registered: June 2020
There needs to be a way to generate email logs when OPRA requests are made requiring a specific users emails during a specified time frame showing: From, To, Date Subject and other requested information already stored in the Archiver Database. The search capability is already there but there is no way to generate and print a custom report with just the log information.

I can't be the only person who is needing this!
Re: Email Logs for OPRA requests [message #148316 is a reply to message #148315] Thu, 18 June 2020 14:22 Go to previous messageGo to next message
ian.bugeja is currently offline  ian.bugeja
Messages: 666
Registered: March 2017
Location: Malta
Hi

Do you mean just exporting the metadata, and not the entire email data?


Ian Bugeja
GFI Software
Re: Email Logs for OPRA requests [message #148317 is a reply to message #148316] Thu, 18 June 2020 14:41 Go to previous messageGo to next message
SHeriff055 is currently offline  SHeriff055
Messages: 4
Registered: June 2020
Here is a sample of a response to an OPRA request.
Re: Email Logs for OPRA requests [message #148321 is a reply to message #148315] Thu, 18 June 2020 17:52 Go to previous messageGo to next message
SHeriff055 is currently offline  SHeriff055
Messages: 4
Registered: June 2020
Not sure if you got this but here is an example of what needs to be provided
Re: Email Logs for OPRA requests [message #148338 is a reply to message #148321] Tue, 23 June 2020 10:43 Go to previous message
ian.bugeja is currently offline  ian.bugeja
Messages: 666
Registered: March 2017
Location: Malta
Hi

The easiest way you can achieve this I think is using the following SQL query

SELECT ar.[id]
      ,ar.[date]
      ,ar.[receivedDate]
      ,ar.[full_subject]
	  ,(
	  SELECT ad.[email]
	  FROM [dbo].[arc_add] ad
	  WHERE [type] = 0 AND (ad.id = ar.id)
	  ) as sender
	  ,Stuff((
	  SELECT '; ' + ad1.[email]
	  FROM [dbo].[arc_add] ad1
	  WHERE [type] > 0 AND (ad1.id = ar.id) FOR XML PATH('')
	  ), 1, 1, '') as ToCC
  FROM [dbo].[arc] ar


Ian Bugeja
GFI Software
Previous Topic: Export Tool Error
Next Topic: Taking off line with AD DC
Goto Forum:
  


Current Time: Thu Sep 23 16:47:57 CEST 2021

Total time taken to generate the page: 0.00394 seconds