Join Mike Pfeiffer for an in-depth discussion in this video Report On Archived Data, part of Lync 2010: Deploying Configuring and Administering.
Reporting on archived data can be a little tricky.…It requires you to either go into the SQL server,…or go into the command line and use the Lync server…management shell to export the data.…Let's take a look at both ways that you can do this.…First of all, I'm going to go into the SQL Server…Management Studio.…I'm going to query straight against…the archiving database.…I'm going to connect to SQL1 on that default instance…where I've got my Lync archiving databases installed.…I'm going to use the Query Analyzer here.…So I';; to create a new query.…
Now what I want to do here is use the LCS log database,…and I'm going to hit F5 to execute that command.…LCS log is the database that has all…the archived content in it.…Now that I've installed the archiving role…and configured my archiving policies,…now IMs that are going on in my environment…based on my policies are now being captured…in this database.…I'm querying against that database,…and I want to do a select star from messages.…So that table out there called messages…
Author
Mike Pfeiffer
Released
9/13/2012Skill Level Advanced
Duration
Views
-
1. Communicate with Lync 2010
-
Manage devices2m 49s
-
Manage contacts and groups4m 48s
-
2. Prepare for Lync Server 2010
-
Prepare Active Directory7m 3s
-
Implement Split-DNS3m 7s
-
3. Deploy Lync Server 2010
-
Configure DNS4m 4s
-
Install Lync Server 20104m 48s
-
Perform Lync updates7m 19s
-
4. Use Lync Administration Tools
-
Enable users for Lync6m 22s
-
5. Configure Role Based Access Control (RBAC)
-
Identify Lync RBAC roles5m 5s
-
Create custom RBAC roles5m 35s
-
Validate RBAC configuration5m 12s
-
6. Deploy Lync Clients and Devices
-
Deploy Lync Attendant2m 51s
-
Use Lync Web App3m 12s
-
Deploy Lync Attendee3m 24s
-
7. Configure Lync External User Access
-
Install and configure Edge roles21m 48s
-
8. Implement Enterprise Voice
-
9. Implement Enterprise Voice Features and Desk Phones
-
Configure Call Park3m 20s
-
Deploy device updates4m 51s
-
10. Integrate Lync with Exchange 2010
-
11. Deploy Conferencing
-
12. Implement Response Groups
-
13. Implement Monitoring and Archiving
-
Deploy Monitoring Reports5m 45s
-
Report On Archived Data4m 22s
-
14. Deploy Enhanced 911
-
Validate LIS configuration1m 38s
-
15. Back Up a Deployment
-
Response Group backups3m 38s
-
Export end-user contacts4m 20s
-
16. Call Admission Control
-
17. Implement High Availability
-
Implement DNS load balancing3m 48s
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Report On Archived Data