Office Communications Server 2007 R2 installation and configuration - 9 | IPSURE (Applications)
Category: ms tip - Tags: Archiving CDR reporter, Instant Messaging, OCS 2007 R2, OCS 2007 R2 Resource Kit for Office Communications stamp vector Server, query, sample query, query, sql server 2; Mehmet Bora Teoman @ 11:11
Office Communications Server 2007 R2 in the last part of the article series stamp vector came about. In this section we try to explain how we can read how the data is archived databases. For this purpose, except for third-party products is difficult to find a free product. Microsoft's "Archiving CDR Reporter" and "OCS 2007 R2 Resource Kit" for transactions in emerging and simple interface provides sufficient. Now let's see what it looks like if you want to install, and the interface. stamp vector
"OCS 2007 R2 Resource Kit" means (OCSReskit.msi file), you can download Microsoft http://www.microsoft.com/downloads/en/details.aspx?FamilyID=9e79a236-c0df-4a72-aba6-9a9602a93ed0 link. I'm starting Archiving Server after downloading the installation file. Because we have to use "Archiving CDR Reporter" Monitoring database or search the database interface or doing Archiving. Archiving server because it is not only our environment, this is all our work on our server (mstipocsarc.mstip.com) will be doing. As can be seen in Figure 1, the start menu after installation "Archiving CDR Reporter" kısayolumuz for coming. stamp vector
"Archiving CDR Reporter" you can see in Figure 2, the interface is seen when we run gadget. There are 3 menu above. These are the "File", stamp vector "Backend Details" and "Help". "File" menu, click "Export to Excel" and "Exit" options available. "Export to excel" If any of the answers returned to you when you make a call, to save them in Excel format works.
I think the most important one of these menus "Backend Details" menu (Figure 3). With this menu you define the databases before running the program we want to connect to. CDR in the database on the server Monitoring, Archiving database on the server, define the archiving. I am here only part of the Archiving tab of the My server instance name, the database name of my database by typing in part of the identification process and finish are on the OK button.
Before you start using this tool, I want to remind you there's stamp vector one more. The installation program defaults to the pre-defined query options on the left side where you see "C: \ Program Files \ Microsoft Office Communications Server 2007 R2 \ ResKit \ ArchivingCdrReporter" folder is located under the ArchivingCdrReporter_Config.xml stamp vector file. This small program is already stamp vector changing the file will do all the customizations. As you can see in Figure 2, left-hand stamp vector menu of 6 pre-defined query, there are three main headings. They obviously stamp vector will not do enough for us. I have a few more of you in this article, I will try to show customize your query showing an example of how this tool.
I had to make some changes to it under ArchivingCdrReporter_Config.xml file. After you open the file with a text editor Notapad or similar as shown in Table 1, and the file is added fourth one query XML file saved with the extension.
Note: Table 1, was written in italics and great for jotting fontlu articles that are written in bold letters indicate the additions made to the file. The file is already stamp vector present in the original texts written in normal font.
((User1Filter (s.User1Id) and User2Filter (s.User2Id)) stamp vector or
<Name> Mbteoman Reports </ Name>
<! [CDATA [
SELECT Body, u1.UserUri as [from], u2.UserUri as [to] from Messages, Users u1, u2 where Users Messages.FromId = u1.UserId and Messages.ToId = u2.UserId and User1Filter (u1.UserId) and User2Filter stamp vector (u2.UserId)
<database> Archiving </ Database>
]]>
Query Description:
If you want to finish the last article on the sample and do an interrogation. All messages that have come to the SIP address in Figure 6 listelettim mbteoman@mstip.com. Expulsion from the message list on the date of filing the user IDs of the users of OCS, who has been omitted from the message itself, all kinds of information available.
Related Articles Office Communications Server 2007 R2 installation stamp vector and configuration - 8 Office Communications Server 2007 R2 installation and configuration - 7 Office Communications Server 2007 R2 installation and configuration - 3
This study carried out by Mehmet Bora Teoman under a Creative Commons Attribution stamp vector - Noncommercial - Share Alike 3.0 Unported License is licensed under. Conditions outside the scope of this license, please follow the link to information on permissions.
GoProtein sponsoring websites
Category: ms tip - Tags: Archiving CDR reporter, Instant Messaging, OCS 2007 R2, OCS 2007 R2 Resource Kit for Office Communications stamp vector Server, query, sample query, query, sql server 2; Mehmet Bora Teoman @ 11:11
Office Communications Server 2007 R2 in the last part of the article series stamp vector came about. In this section we try to explain how we can read how the data is archived databases. For this purpose, except for third-party products is difficult to find a free product. Microsoft's "Archiving CDR Reporter" and "OCS 2007 R2 Resource Kit" for transactions in emerging and simple interface provides sufficient. Now let's see what it looks like if you want to install, and the interface. stamp vector
"OCS 2007 R2 Resource Kit" means (OCSReskit.msi file), you can download Microsoft http://www.microsoft.com/downloads/en/details.aspx?FamilyID=9e79a236-c0df-4a72-aba6-9a9602a93ed0 link. I'm starting Archiving Server after downloading the installation file. Because we have to use "Archiving CDR Reporter" Monitoring database or search the database interface or doing Archiving. Archiving server because it is not only our environment, this is all our work on our server (mstipocsarc.mstip.com) will be doing. As can be seen in Figure 1, the start menu after installation "Archiving CDR Reporter" kısayolumuz for coming. stamp vector
"Archiving CDR Reporter" you can see in Figure 2, the interface is seen when we run gadget. There are 3 menu above. These are the "File", stamp vector "Backend Details" and "Help". "File" menu, click "Export to Excel" and "Exit" options available. "Export to excel" If any of the answers returned to you when you make a call, to save them in Excel format works.
I think the most important one of these menus "Backend Details" menu (Figure 3). With this menu you define the databases before running the program we want to connect to. CDR in the database on the server Monitoring, Archiving database on the server, define the archiving. I am here only part of the Archiving tab of the My server instance name, the database name of my database by typing in part of the identification process and finish are on the OK button.
Before you start using this tool, I want to remind you there's stamp vector one more. The installation program defaults to the pre-defined query options on the left side where you see "C: \ Program Files \ Microsoft Office Communications Server 2007 R2 \ ResKit \ ArchivingCdrReporter" folder is located under the ArchivingCdrReporter_Config.xml stamp vector file. This small program is already stamp vector changing the file will do all the customizations. As you can see in Figure 2, left-hand stamp vector menu of 6 pre-defined query, there are three main headings. They obviously stamp vector will not do enough for us. I have a few more of you in this article, I will try to show customize your query showing an example of how this tool.
I had to make some changes to it under ArchivingCdrReporter_Config.xml file. After you open the file with a text editor Notapad or similar as shown in Table 1, and the file is added fourth one query XML file saved with the extension.
Note: Table 1, was written in italics and great for jotting fontlu articles that are written in bold letters indicate the additions made to the file. The file is already stamp vector present in the original texts written in normal font.
((User1Filter (s.User1Id) and User2Filter (s.User2Id)) stamp vector or
<Name> Mbteoman Reports </ Name>
<! [CDATA [
SELECT Body, u1.UserUri as [from], u2.UserUri as [to] from Messages, Users u1, u2 where Users Messages.FromId = u1.UserId and Messages.ToId = u2.UserId and User1Filter (u1.UserId) and User2Filter stamp vector (u2.UserId)
<database> Archiving </ Database>
]]>
Query Description:
If you want to finish the last article on the sample and do an interrogation. All messages that have come to the SIP address in Figure 6 listelettim mbteoman@mstip.com. Expulsion from the message list on the date of filing the user IDs of the users of OCS, who has been omitted from the message itself, all kinds of information available.
Related Articles Office Communications Server 2007 R2 installation stamp vector and configuration - 8 Office Communications Server 2007 R2 installation and configuration - 7 Office Communications Server 2007 R2 installation and configuration - 3
This study carried out by Mehmet Bora Teoman under a Creative Commons Attribution stamp vector - Noncommercial - Share Alike 3.0 Unported License is licensed under. Conditions outside the scope of this license, please follow the link to information on permissions.
GoProtein sponsoring websites