Email Location In content Server

Hi Pros:

Here is a query i did for a SQL 2008 based DB to get such emails which does not an entry in otemailproperties.

select DataID,Name, CreateDate,ModifyDate ,CreatedBy from Dtree

where dtree.SubType =749 and

DataID not in (select nodeid from OTEmailProperties )

I wish to have a way to write a either sub-report or include details in this main report itself which could fetch me the location of these emails in content server so that i can go to these email and move them to a temp folder in outlook and drag and drop them at the same place.

Or any other ways to export them etc

Thanks,

Mkesh

Find more posts tagged with

Comments

Mukesh_Giri

Please ignore the request, i was able to achieve what i wanted to.

Thanks

Lindsay_Davies

Hi Mukesh,

As you are selecting from DTree you could use a “LiveReport:” report format instead of Auto Livereport (which I assume you are using at present).

That would make the output show the object with its Content Server context / function menu.

To achieve that, change your query as follows

select %1 from Dtree

where dtree.SubType =749 and

DataID not in (select nodeid from OTEmailProperties )

Then alter the report so Parameter 1 (%1) = Report Fields

and Report Format = LiveReport:

If you already know you will get a lot of rows, you might want to limit the rows returned by setting a value in the Record Limit field so you have a manageable list for the manual operations you want to perform.

Regards

Lindsay

European Escalation Team

OpenText UK

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 October 11, Thu 06:15
To: eLink Recipient
Subject: Email Location In content Server

Email Location In content Server

Posted bymukesh.kumargiri@nike.com (Giri, Mukesh) On 10-10-2012 15:34

Hi Pros:

Here is a query i did for a SQL 2008 based DB to get such emails which does not an entry in otemailproperties.

select DataID,Name, CreateDate,ModifyDate ,CreatedBy from Dtree

where dtree.SubType =749 and

DataID not in (select nodeid from OTEmailProperties )

Or any other ways to export them etc

Thanks,

Mkesh

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center