|
Different SQL
Queries to Retrieve Archived Messages |
When we
install and activate Archiving server, "LcsLog" is the
database which gets created at the SQL Server. If users
are enabled for archiving, the messages exchanged
between them will be archived in this database.
There is
no way you can see the archived messages on the OCS
Server itself without any additional script or tool.
We are
going to discuss few scripts what you would use to see
the messages.
You need
to run these scripts on the SQL Server which hosts
Archiving database (LcsLog).
Following query will show all archived messages
Archived in the database LcsLog...
SELECT *
from dbo.Messages, dbo.Users where
dbo.Users.UserId = Messages.FromId
Following query will show all the archived messages per
user. In the following example, the output will show
messages exchanged to and by ocsa@ocsdom.local.
SELECT *
from LcsLog.dbo.Messages, LcsLog.dbo.Users where
LcsLog.dbo.Users.UserId =
LcsLog.dbo.Messages.ToId and LcsLog.dbo.Users.UserUri =
'ocsa@ocsdom.local'
Following query
will show all the archived messages per user (only
message)
SELECT Body from
LcsLog.dbo.Messages, LcsLog.dbo.Users where
LcsLog.dbo.Users.UserId =
LcsLog.dbo.Messages.ToId and LcsLog.dbo.Users.UserUri =
'ocsa@ocsdom.local'
There is a resource
kit tool "Archiving CDR reported tool" which can make
your life easier upto an extent if you are looking for
some pre-defined reporting features... You can learn
more
here...
Related Links:
How to configure Archiving Server
(OCS 2007)
Archiving CDR Reporter Tool and
custom SQL Queries
