Microsoft Lync Server 2010 70-664

Monitoring and Archiving in Lync Server 2010

Start your 7-day free trial today.

This video is only available to subscribers.

A free trial includes:

  • Unlimited 24/7 access to our entire IT training video library.
  • Ability to train on the go with our mobile website and iOS/Android apps.
  • Note-taking, bookmarking, speed control, and closed captioning features.

Course Introduction

Understanding Lync Server 2010 Architecture

Deploying Lync Server 2010

Enabling Users and Managing the Lync Client

Managing External User Access

Implementing Enterprise Voice Part 1 of 2

Implementing Enterprise Voice Part 2 of 2

Implementing Response Groups

Administering Call Admission Control

Using Location Information Services and Enhanced 9-1-1

Conferencing in Lync Server 2010 Part 1 of 2

Conferencing in Lync Server 2010 Part 2 of 2

Implementing a Unified Mailbox with Exchange Server 2010 SP1 UM

Ensuring Voice Resiliency

Monitoring and Archiving in Lync Server 2010

00:00:00 - Monitoring and archiving in Lync Server 2010.
00:00:03 - This Nugget is all about troubleshooting and
00:00:06 - compliance.
00:00:07 - Monitoring and archiving are optional roles.
00:00:10 - They're not necessary to deploy in your infrastructure.
00:00:13 - However, you may want to enable one or both to give
00:00:16 - you, as a Lync administrator, greater insight into how your
00:00:20 - users experience with Lync is going.
00:00:22 - And also as I said, you may be subject to various industry
00:00:27 - and/or governmental regulations that require you
00:00:31 - to retain the content, for instance, of instant messages
00:00:34 - across your organization.
00:00:36 - First, we're going to differentiate what monitoring
00:00:38 - and archiving means, and make the business case for it.
00:00:42 - After we take care of that front end stuff, I'll discuss
00:00:45 - what infrastructure changes are necessary to integrate
00:00:48 - monitoring and/or archiving into your Lync environment.
00:00:51 - And by the end of this Nugget, you'll understand how to
00:00:54 - deploy and use both the monitoring and archiving
00:00:57 - server roles.
00:00:58 - Let's get started.
00:00:59 - Let's take a look at the business case for monitoring
00:01:02 - and archiving.
00:01:03 - What do we mean actually?
00:01:04 - If we install the monitoring server role in Lync 2010, what
00:01:08 - actually is happening?
00:01:10 - Well, the two main metrics, numerical data sets that are
00:01:15 - being aggregated by the Lync monitoring
00:01:18 - server are QoE and CDR.
00:01:20 - Now, what the heck does that mean?
00:01:21 - QoE refers to Quality of Experience and CDR refers to
00:01:27 - the Call Detail Record.
00:01:29 - Taken together, that set of metrics is going to give you a
00:01:33 - graphical and quantitative method of showing things like
00:01:38 - call metadata, how many minutes have been consumed and
00:01:41 - between which users.
00:01:43 - What is the quality of that line?
00:01:46 - How much jitter?
00:01:47 - How much noise was present on those calls?
00:01:50 - Conferences.
00:01:52 - Who joined conferences?
00:01:53 - Who left conferences?
00:01:55 - When?
00:01:55 - All of that associated metadata.
00:01:57 - I'm actually going to give you what is and what is not
00:02:00 - captured with monitoring in an upcoming whiteboard.
00:02:03 - But just know that this monitoring, this aggregation
00:02:07 - of data is useful for us as administrators, both for
00:02:10 - ensuring a good user experience as well as for
00:02:13 - troubleshooting when things go poorly.
00:02:16 - Lync is an expensive product.
00:02:18 - As we know, it's not just paying for the Lync Server and
00:02:22 - client access licenses, we're also paying for additional
00:02:25 - hardware to scale out the topology--
00:02:28 - scale up and scale out the topology we should say.
00:02:31 - If you're using Microsoft Exchange Server, Active
00:02:34 - Directory infrastructure, possible SharePoint
00:02:37 - integration, we could be talking about a very sizable
00:02:40 - investment, indeed.
00:02:42 - And if you're the one who convinced the powers that be
00:02:45 - within your organization that you need a Lync solution, it
00:02:49 - seems to me then you're going to be especially interested in
00:02:53 - keeping your finger on the pulse of Lync performance.
00:02:56 - Now, Warner's first rule of IT is you're never going to
00:02:59 - satisfy your entire user base.
00:03:01 - There are going to be folks who grumble and complain no
00:03:04 - matter what, saying they wish that the environment was what
00:03:07 - it was prior to Lync, and that their Lync experience is--
00:03:10 - I don't know, I'm thinking of things I've heard.
00:03:13 - Too cumbersome, too complex, I just want a phone, darn it,
00:03:17 - kind of thing.
00:03:18 - So by keeping your eye on those metrics, you can then
00:03:21 - generate reports with hard numbers to show to the
00:03:25 - stakeholders in your organization and say, this is
00:03:28 - the buy-in we have over this time frame.
00:03:31 - These are the problems we've identified.
00:03:33 - These are the good things that we've identified.
00:03:36 - And then as I said, the key to good troubleshooting--
00:03:39 - and this is standard across the board with IT--
00:03:41 - is as rich and robust intelligence on the front end
00:03:45 - of things as possible.
00:03:46 - We want to have as much data to work with as possible.
00:03:49 - Speaking of which, it's one thing for the monitoring
00:03:52 - server to gather the data for you.
00:03:54 - It's another thing to present it in a way that's easy to
00:03:57 - analyze and interpret.
00:03:59 - What we have with the Lync monitoring server is tight
00:04:02 - integration with SQL Server's reporting services component.
00:04:06 - In the demo, we're going to do a front to back installation,
00:04:09 - and we're going to install SQL Server 2008
00:04:12 - R2 as part of that.
00:04:13 - Now note that we're not talking Express edition here.
00:04:16 - You actually have to have an instance of SQL Server running
00:04:20 - in your environment.
00:04:21 - It does not have to be running on your monitoring box, but it
00:04:24 - has to be reachable by your monitoring Lync server.
00:04:28 - And of course, we have to make sure to install and configure
00:04:31 - the reporting services role of SQL Server.
00:04:34 - You're also going to see, as we go along, that the Lync
00:04:37 - Deployment Wizard has a one-click install.
00:04:40 - Actually, it's a few questions.
00:04:41 - It's a traditional wizard that installs a bunch of canned
00:04:45 - Lync monitoring reports into a target SSRS instance that
00:04:51 - saves us what would be a tremendous amount of work
00:04:54 - building those reports on your own.
00:04:56 - Forget about it, I would not want to do that for anything.
00:04:59 - So that in a nutshell is what's going on with
00:05:02 - monitoring.
00:05:02 - Now, archiving is again, a data aggregation process.
00:05:07 - The deal with archiving though is what may drive your
00:05:11 - adopting an archiving server is regulatory compliance, with
00:05:15 - things like information life cycle
00:05:17 - management, document retention.
00:05:19 - One of the great benefits of the Office Communications
00:05:23 - Server when it first was published by Microsoft LCS
00:05:26 - 2005, is that a company could own a private IM
00:05:31 - infrastructure.
00:05:32 - Confidential communications that were transmitted by
00:05:35 - instant message could be archived, parsed, and brought
00:05:38 - out in maybe a legal issue if that comes up.
00:05:41 - Or as I said, just simple compliance with some
00:05:44 - governmental or industry regulation.
00:05:47 - So you do, in fact, own your own private instant messaging
00:05:51 - infrastructure.
00:05:52 - The archiving can do more than archive just instant messages.
00:05:56 - As I said, shortly I'll give you the laundry list of what
00:05:59 - is and what is not captured.
00:06:00 - One thing you want to consider though, and this will come out
00:06:03 - in the demo is when you enable archiving, Lync gives you a
00:06:07 - choice to archive internal and/or external
00:06:12 - communications.
00:06:13 - Now, why is that important?
00:06:14 - Well, internal we presume that they're all company staffers.
00:06:18 - So we write it into their employment agreement that
00:06:21 - their email, their instant messages are all subject to
00:06:25 - archiving and auditing.
00:06:26 - But external partners, who could be Federated business
00:06:30 - partners, vendors, whomever, they may not cotton or
00:06:33 - appreciate having their communications
00:06:36 - captured and archived.
00:06:37 - So there's some things we can do with that.
00:06:39 - We can just turn off external archiving.
00:06:42 - And we can also send a disclaimer to those external
00:06:45 - folks when they're involved in an instant message or
00:06:49 - conferencing exchange.
00:06:50 - One thing that I find really weird about Lync Server 2010
00:06:54 - archiving is that there's no reporting feature.
00:06:57 - As I said with the monitoring server, we have all these
00:07:01 - canned reports that you can generate great, great
00:07:05 - informative reports, and then export those to a number of
00:07:09 - different formats--
00:07:10 - XML, CSV, PDF, Microsoft Word, you name it.
00:07:14 - But on archiving, it's just the opposite.
00:07:17 - There's almost nothing there.
00:07:19 - You literally have to either NoSQL and write SQL queries to
00:07:24 - go into the LCS log database and hit specific tables in
00:07:28 - there, or we could run a PowerShell cmdlet to take a
00:07:32 - timeframe and then dump of all of the archived content into a
00:07:37 - separate folder where you can use, say, an email client or a
00:07:41 - notepad, or whatever, to view that data.
00:07:43 - Now, I've heard rumors.
00:07:44 - At this point, Lync Server 2013 is well in development,
00:07:48 - but there's not an awful lot out there on it yet.
00:07:51 - But I've read and heard rumors that in the next version of
00:07:54 - Lync server, Microsoft has done quite a bit of tweaking
00:07:58 - and optimizing of monitoring and archiving.
00:08:01 - And when I say optimizing, I'm not saying
00:08:03 - optimizing for speed.
00:08:05 - I'm saying optimizing for user experience.
00:08:08 - Hopefully, they'll fix this lack of a reporting feature
00:08:11 - for archiving and give Lync administrators a much better
00:08:14 - interface for querying the archived content.
00:08:18 - I do know, if what I'm reading is correct, that the
00:08:20 - monitoring and archiving roles in Lync Server 2013 will be,
00:08:25 - by default, co-located on your front-end servers.
00:08:28 - That's very convenient.
00:08:29 - It makes deploying monitoring and archiving a heck of a lot
00:08:33 - easier, number one.
00:08:34 - And number two, businesses don't necessarily have the
00:08:37 - resources--
00:08:38 - hardware, software, or human resources--
00:08:41 - to take care of an additional server, or two or three.
00:08:44 - Monitoring and archiving are relatively
00:08:47 - low bandwidth services.
00:08:49 - They're meant, at least in Lync Server 2010, to be
00:08:52 - deployed together.
00:08:53 - So we can co-locate monitoring and archiving on the same box
00:08:58 - with no muss, no fuss, or greasy aftertaste.
00:09:01 - An important question here practically speaking is, what
00:09:04 - exactly is monitored versus is not monitored in terms of data
00:09:09 - aggregated by the Lync monitoring server?
00:09:12 - Well, as you see, there's a lot more that it is captured
00:09:15 - than is not.
00:09:15 - Let's actually go over to the "is not" column first.
00:09:18 - Phone call, instant message session, conference content is
00:09:23 - not monitored.
00:09:24 - The reason for that is that all of this data is captured
00:09:28 - by the archiving server.
00:09:29 - We don't need content.
00:09:31 - We don't need instant message message content.
00:09:34 - We don't need uploaded files and shared files in a
00:09:38 - conference session.
00:09:39 - We don't need metrics
00:09:40 - concerning phone call metadata--
00:09:43 - who called whom, when, blah, blah, blah.
00:09:45 - Instead, we're interested in more technical metadata on the
00:09:50 - monitoring side.
00:09:51 - Other aspects that are not monitored are non-Lync
00:09:54 - processes and services.
00:09:56 - That should make sense to you intuitively.
00:09:58 - Windows Server process info is not going to be captured by
00:10:02 - Lync monitoring tools.
00:10:03 - You're going to need to use the Windows Server in-box
00:10:06 - monitoring tools for that.
00:10:08 - The Performance Monitor tools, for instance.
00:10:10 - Similarly, application logging that's not Lync related is not
00:10:15 - captured by the monitoring server.
00:10:17 - We know that Lync does, in fact, write event log entries
00:10:22 - to its own log in Windows Server 2008 R2 and Windows
00:10:26 - Server 2012.
00:10:27 - But it's not going to do anything not Lync related.
00:10:30 - Now, on the other side, what data is captured by the
00:10:33 - monitoring server?
00:10:34 - Voice over IP phone call, IM session, and
00:10:37 - conferencing metadata.
00:10:39 - Metadata is a fancy term that means data about data.
00:10:44 - It's descriptive information.
00:10:46 - Endpoint metadata, the IP addresses, connection speed,
00:10:50 - which servers are being used by your endpoints.
00:10:53 - And your endpoints refer to the Lync Client,
00:10:56 - Lync Phones, et cetera.
00:10:58 - Call admission control session data, when policies are being
00:11:02 - enforced, PSTN rerouting, all of those details are captured
00:11:06 - for your analysis, or analytic pleasure I should say.
00:11:10 - Diagnostics for session failures.
00:11:12 - This goes to the troubleshooting equation.
00:11:15 - These first items are nice to know just to make sure
00:11:19 - everything's going well.
00:11:20 - We also have troubleshooting specific stuff-- session
00:11:24 - failure metadata, what's going on server-wise as it relates
00:11:28 - to Lync, packet loss, signal degradation, line noise, and
00:11:32 - quality measurements for SIP signaling, video
00:11:36 - streams, and so forth.
00:11:38 - So there's a lot of grist for the mill as Lync
00:11:41 - administrators for performance tuning, optimization, and
00:11:45 - troubleshooting.
00:11:46 - Now, let's do the same analysis, this time for the
00:11:48 - archive server.
00:11:49 - What is archived?
00:11:51 - Peer to peer and multi-party IM.
00:11:53 - So basically, all of your chat messages are picked up.
00:11:56 - However, file transfers are not, period.
00:11:59 - So if two Lync users transfer files, that traffic is not
00:12:04 - going to be picked up.
00:12:05 - Even in an honest to goodness MCU-based conference, file
00:12:09 - transfers are not picked up.
00:12:10 - However, in a conference, uploaded and shared content is
00:12:15 - in fact captured.
00:12:16 - And you'll see that in a demo.
00:12:17 - So if a presenter uploads a file and shares a file with
00:12:21 - other conference attendees, that file itself is going to
00:12:24 - be captured and archived.
00:12:26 - Similarly, if a presenter shares a PowerPoint deck, that
00:12:29 - will be included.
00:12:30 - Unfortunately, other methods of conference collaboration
00:12:34 - are not archived in this release.
00:12:36 - The poll feature, that would be really useful if the
00:12:38 - archive server grabbed polls.
00:12:40 - But it doesn't.
00:12:41 - Whiteboards, annotations.
00:12:43 - Again, those whiteboard are, in my experience, very useful
00:12:47 - for future analysis.
00:12:49 - It's crazy that they're not part of the archive corpus.
00:12:52 - I did hear-- again, this is a semi-rumor--
00:12:54 - that Lync Server 2013 does, in fact, archive that conference
00:12:58 - poll and whiteboard and annotation data.
00:13:01 - Conference metadata in terms of who joins and who leaves.
00:13:04 - That can be especially important.
00:13:06 - I found in my experience, working as part of a virtual
00:13:09 - team, especially the sales departments.
00:13:11 - When a sales manager has a web conference to do a knowledge
00:13:15 - transfer, product launch, whatever, they want to audit
00:13:18 - to make sure they know who was there for that conference.
00:13:22 - And I imagine it would be a black mark on a sales
00:13:25 - representative's jacket or their human resources
00:13:28 - personnel file if they're shown by looking at archive
00:13:31 - logs either not to have attended a conference or to
00:13:35 - have left it prematurely.
00:13:36 - Well, all of that is documented and captured in the
00:13:39 - Lync Server archive server.
00:13:41 - Your heavier weight data, your audio and video streams from
00:13:45 - peer to peer IM and conferences are not captured.
00:13:48 - Application sharing from peer to peer or conferencing,
00:13:51 - that's a lot of really good stuff.
00:13:53 - I imagine Microsoft did not archive this.
00:13:56 - Well, number one, how do you share if somebody
00:13:58 - shares their desktop?
00:13:59 - It seems to me kind of cumbersome and difficult to
00:14:02 - archive that.
00:14:03 - And in terms of video feed, it would probably just be a
00:14:06 - network bandwidth and disk storage space issue why that
00:14:10 - would not be archived by default.
00:14:13 - Finally, session failure diagnostics are not captured.
00:14:16 - And the reason for that is simple.
00:14:18 - That goes across the fence so to speak, and that data is
00:14:21 - picked up by the monitoring server.
00:14:23 - So what is the deployment process for
00:14:25 - monitoring and archiving?
00:14:27 - First, we have our prerequisites.
00:14:29 - And these are really important.
00:14:30 - If you don't do this, you're not going to get any results
00:14:34 - in your monitoring or archiving.
00:14:35 - It's just as simple as that.
00:14:37 - You have to make sure that on all of your Lync servers,
00:14:40 - particularly your front-end servers and your monitoring
00:14:43 - and archiving servers, that you've installed the .NET
00:14:46 - framework 3.5.1.
00:14:48 - That can be done through Server Manager or Server
00:14:51 - Manager CMD or PowerShell on your servers in
00:14:54 - Windows Server 2008 R2.
00:14:56 - And then this is crucial, you have to install Microsoft
00:14:59 - Message Queuing with Directory Services Integration.
00:15:03 - These are components, feature components.
00:15:06 - Again, you can get to them right from the Server Manager
00:15:09 - features list.
00:15:10 - MSMQ is a way for processes on the same box, or more likely
00:15:15 - separate machines, to exchange data with each other in the
00:15:19 - form of messages.
00:15:20 - And what's neat about MSMQ is that it's almost a guaranteed
00:15:24 - delivery system.
00:15:25 - It's meant to be asynchronous, such that if two hosts on the
00:15:29 - other end of a WAN connection need to exchange messages
00:15:32 - using MSMQ and the WAN goes down or is too heavily
00:15:36 - congested, MSMQ can actually--
00:15:39 - well, queue the data until it's safe to
00:15:42 - go across that WAN.
00:15:43 - It's a reliable communication scheme, and that's actually
00:15:46 - how the monitoring and archiving transmits its data.
00:15:50 - Actually, on your front-end server where the action is
00:15:53 - happening, when you roll out the monitoring and archiving
00:15:57 - bits, you actually wind up with the agent bits
00:16:00 - on the front end.
00:16:01 - And then on your monitoring and archiving server, you
00:16:04 - receive the data as it's generated on the front end.
00:16:08 - And of course, messaging and archiving is going to tie-in
00:16:11 - to a SQL Server back-end database.
00:16:13 - That's where the data is actually stored.
00:16:15 - We then interact with that using either SQL Server
00:16:18 - Reporting Services, SQL Scripts, or Ad-hoc queries.
00:16:23 - And finally, we have a PowerShell cmdlet as I told
00:16:26 - you earlier, with which we can export archived data.
00:16:30 - So you want to make sure those prerequisites are
00:16:32 - absolutely in place.
00:16:33 - You then need to deploy SQL Server
00:16:35 - with the SSRS component.
00:16:37 - And that's going to involve some
00:16:38 - configuration on its own, frankly.
00:16:40 - The next few steps should be very familiar to you.
00:16:43 - It's how we adjust the topology in Lync.
00:16:45 - First, we use topology builder to add the
00:16:48 - servers to the topology.
00:16:50 - No big deal.
00:16:50 - We're going to do that in the demo.
00:16:52 - You'll see how that works.
00:16:53 - And then, you know what's next.
00:16:54 - We go to the machine, or machines, that are going to
00:16:57 - host these roles and run the Deployment Wizard.
00:17:00 - The Deployment Wizard knows because it's going to install
00:17:03 - a local copy of the central management store database, and
00:17:06 - therefore has intelligence of the topology.
00:17:09 - The machine and Lync Deployment Wizard will
00:17:12 - understand which components need to come down to that box.
00:17:16 - Once you've done that, it's time to log in to the Lync
00:17:18 - Control Panel or use PowerShell cmdlets to define
00:17:21 - your monitoring and archiving policies.
00:17:23 - Again, we'll cover all that in detail in the demo.
00:17:26 - And then from there, you just simply sit back and let some
00:17:29 - data aggregate.
00:17:30 - And then at your leisure, analyze either your canned
00:17:33 - monitoring reports or use some of these tricky tools to look
00:17:37 - at your archived data.
00:17:39 - Now, there is a sub-step here.
00:17:41 - I'm going to add it right here.
00:17:43 - And that is to install the report pack.
00:17:47 - I told you once already that the Deployment Wizard on the
00:17:50 - main screen, there's a link there, a hyperlink that will
00:17:54 - kick off the installation of the Lync 2010 built-in reports
00:17:59 - that are so useful for us in this context.
00:18:01 - Before we go into the demo, let's just tie up any loose
00:18:04 - ends regarding archiving and monitoring.
00:18:07 - Actually, let me start with monitoring because that's
00:18:10 - historically what we've been doing.
00:18:12 - Let's make sure we haven't missed anything.
00:18:13 - The components of Lync Server 2010 monitoring are your data
00:18:17 - collection agents that exist on every front-end server.
00:18:20 - I just told you about that.
00:18:21 - The monitoring server itself with back-end database, using
00:18:25 - message queuing for passing the messages back and forth.
00:18:28 - That does need MSMQ.
00:18:30 - does need to be integrated in Active Directory.
00:18:33 - And then as a separate
00:18:34 - installation, our server reports.
00:18:36 - The metrics or the numerical data is divided as I said
00:18:39 - earlier into quality of experience and CDR.
00:18:42 - Specifically, the QoE data deals with the number and
00:18:46 - quality of calls, participant metadata, endpoint metadata.
00:18:50 - The call detail records is usage information regarding
00:18:54 - your VoIP calls and IMs.
00:18:55 - It's a subtle difference, and really they're blended
00:18:58 - together in the reporting interface.
00:19:00 - A/V conversations, meetings, file transfers, the content is
00:19:05 - not included.
00:19:06 - And again, by way of review this time on the archiving
00:19:09 - side, same basic components--
00:19:11 - MSMQ, back-end database, archiving server, and the
00:19:15 - front-end pools have archiving agent bits installed.
00:19:19 - The archiving policy can be scoped.
00:19:21 - We know now how a policy-based configuration
00:19:24 - works in Lync Server.
00:19:25 - And the fact that we have built-in global policies that
00:19:29 - by default hit your entire infrastructure, all of your
00:19:32 - central sites, all of your branch sites.
00:19:34 - But we can scope that policy down to the site level, or
00:19:37 - even the user level.
00:19:39 - And what's neat about that is if we did do that, let's say
00:19:42 - we were very parsimonious if you want a $5 word with our
00:19:46 - archiving policy, and we set it only to
00:19:49 - scope to certain users.
00:19:51 - If one of those archived enabled users were a member of
00:19:55 - a web conference, let's say, then the entire web
00:19:58 - conference, the IMs and the conference
00:20:00 - data, will be archived.
00:20:02 - Pretty powerful stuff.
00:20:03 - There's also what's called a critical mode configuration.
00:20:06 - You'll see this in the demo.
00:20:07 - I'll show you where it exists.
00:20:09 - And critical is used for those shops who have compliance
00:20:12 - requirements that are so stiff that you would deny service to
00:20:16 - your users.
00:20:16 - You would actually block instant messages and
00:20:19 - conferencing from taking place if archiving is
00:20:23 - somehow going to fail.
00:20:25 - So that is an option.
00:20:26 - And it should give some stakeholders security who are,
00:20:29 - as I said, under heavy regulation, that anything
00:20:33 - within that schema--
00:20:34 - instant messaging, conferencing--
00:20:36 - will, in fact, be archived.
00:20:38 - And if it can't for any reason, we're actually going
00:20:40 - to shut down the ability of our users to do that.
00:20:43 - All right then, I think enough talking and whiteboarding.
00:20:45 - Let's now head into the demo and I'll show you how this
00:20:48 - stuff works step by step.
00:20:50 - Hello, and welcome to this demo in which we work with
00:20:52 - monitoring server and archiving server in Lync
00:20:55 - Server 2010.
00:20:56 - We're actually going to co-locate both of these roles
00:20:59 - on branch nugget, which is a Windows Server 2008 R2 member
00:21:03 - server box that served several roles in various Nuggets
00:21:06 - throughout this training.
00:21:07 - It served as a survivable branch server as well as a
00:21:10 - front-end server.
00:21:12 - Here as I said I'm going to deploy the monitoring and
00:21:15 - archiving roles on it.
00:21:17 - I figure we'll start with monitoring because the set up
00:21:20 - is slightly more complex.
00:21:21 - As far as prerequisites go, I'm going to start by opening
00:21:24 - Server Manager.
00:21:25 - And we need to install the message queuing feature.
00:21:28 - This needs to be done not only on your monitoring and
00:21:31 - archiving server or servers, but also on your front-end
00:21:35 - servers as well.
00:21:36 - This is a feature, so I'm going to right click the
00:21:39 - Features node.
00:21:40 - Make sure that .NET framework 3.5.1 features are installed,
00:21:44 - which they are on my box.
00:21:46 - And it looks like I have at least some of the bits for
00:21:49 - message queuing installed as well.
00:21:51 - As a matter of fact, I have half of it there.
00:21:53 - The only thing I need to add is directory service
00:21:56 - integration.
00:21:56 - We'll click Next and Install.
00:21:58 - And I'll click Close.
00:22:00 - Another thing I'm going to need to do actually, I do have
00:22:03 - the IIS web server installed.
00:22:05 - That's going to be important when we bring up SQL Server
00:22:08 - Reporting Services for sure.
00:22:10 - And you can verify which role services are installed by
00:22:14 - right clicking the role and selecting either Add or Remove
00:22:18 - Role Services specifically.
00:22:20 - I've got the full boat, pretty much, installed on this IIS
00:22:23 - web server.
00:22:24 - Then next thing we're going to do is buzz through an
00:22:26 - installation of SQL Server 2008 R2.
00:22:29 - I'm going to right click that.
00:22:31 - I've mounted the DVD and choose Install or Run program
00:22:34 - from your media.
00:22:35 - That's going to launch the Deployment
00:22:37 - Wizard for SQL Server.
00:22:38 - Now, I'm going to blow through this pretty quickly.
00:22:41 - The only pause in configuration I'm going to go
00:22:43 - into any degree of depth on is that of SSRS to support what
00:22:47 - we're doing with Lync Server monitoring server.
00:22:50 - If you're interested in more in-depth training, front to
00:22:52 - back training for SQL Server, I've done
00:22:55 - training on SQL Server.
00:22:56 - Garth Schulte, Don Jones, several of my CBT Nuggets
00:23:00 - colleagues have done it.
00:23:01 - So you're in good hands really, if you're interested
00:23:04 - in that training.
00:23:05 - All right, so here's the SQL Server Installation Center.
00:23:07 - Let's go to Installation and New Installation.
00:23:11 - Prerequisite check has passed, so we'll OK past that.
00:23:14 - We specify the product key as usual and click Next.
00:23:17 - We have to accept the terms of the license agreement.
00:23:20 - I won't send future usage data.
00:23:22 - We'll install our setup support files next.
00:23:25 - And we're prompted for a restart.
00:23:26 - Great, we've passed all of our tests.
00:23:28 - The warnings I see here aren't that big of a deal, firewall
00:23:31 - and .NET security.
00:23:33 - This is a testing environment.
00:23:34 - We'll leave the default feature installation enabled
00:23:37 - and click Next.
00:23:38 - This is really the money of it.
00:23:39 - I'm going to install the database engine.
00:23:41 - We can't have SQL Server proper without
00:23:44 - database engine services.
00:23:46 - And of course, reporting services, very interesting.
00:23:49 - As soon as I selected that, notice we had a couple of
00:23:51 - additional options or things to do in our list here.
00:23:54 - I'm also going to install the management tools, client tools
00:23:57 - connectivity just for grins.
00:23:59 - Leave the default directories, click Next.
00:24:02 - I'm going to create a named instance called Lync 2010.
00:24:05 - Notice that we have RTC local and RTC.
00:24:09 - Remember, that the Central Management Store Database, the
00:24:12 - read/write copy exists on your first front-end server.
00:24:16 - And then you have a replicated copy that goes to also that
00:24:19 - server, but all of your other servers.
00:24:21 - That's what makes the topology builder
00:24:24 - publishing so powerful.
00:24:25 - Let's click Next to continue.
00:24:27 - We're just taking care of prereqs here.
00:24:29 - I'm going to use the same service account for all SQL
00:24:32 - Server Services.
00:24:33 - Domain Administrator is not recommended in a live
00:24:36 - production environment, but it'll work just
00:24:38 - fine here in my lab.
00:24:40 - I'm going to leave everything here at the default except I'm
00:24:43 - going to add in Domain Admins.
00:24:45 - Not all shops are that broad with their SQL Server
00:24:49 - permissions, for administrators that is.
00:24:51 - This is an important page for our purposes.
00:24:53 - When we install reporting services, we can do the
00:24:56 - default or native mode where it's just a simple web
00:24:59 - application and that's it.
00:25:00 - Or, if we're integrating reporting with SharePoint
00:25:03 - Business Intelligence, we can use
00:25:04 - SharePoint integrated mode.
00:25:06 - Or, we could say install the bits but don't do any
00:25:08 - configuration.
00:25:09 - I'm going to just simply leave the default here.
00:25:11 - Click Next.
00:25:12 - And it looks like we're ready to go ahead, ready to install.
00:25:15 - We can verify and click install and start chunking.
00:25:18 - Sit back and wait, I guess.
00:25:20 - While this installation proceeds, why don't we pop
00:25:22 - over to Lync Nugget, our front-end server.
00:25:25 - I've popped open topology builder as you see here.
00:25:28 - And we're going to go ahead and open our central site
00:25:31 - node, come down to monitoring servers, which
00:25:34 - there's nothing there.
00:25:35 - And we're going to modify the topology to bring in branch
00:25:38 - nugget as our monitoring server.
00:25:40 - We'll right click, select New Monitoring Server from the
00:25:42 - Shortcut menu, and we're asked to define an
00:25:45 - FQDN for that server.
00:25:46 - So it's branchnugget.nuggetlab.com.
00:25:49 - We're asked to define a SQL store.
00:25:53 - Well, it looks like we may have to wait for that server
00:25:56 - installation to finish.
00:25:58 - I was hoping we could save ourselves some time, but let's
00:26:00 - come back to branch nugget.
00:26:02 - It looks like we're almost finished here.
00:26:05 - In my experience installing SQL Server, it tends to take
00:26:08 - the longest right at the end of the installation progress.
00:26:12 - It seems to hang up to the point where you wonder if the
00:26:15 - installation has, in fact, frozen.
00:26:17 - All right, so we're complete, but it tells us we have to
00:26:20 - reboot, which I'm expecting.
00:26:22 - I'm going to close out here and let's just bounce this
00:26:25 - server really quickly.
00:26:26 - And when it comes back, we should be able to see that
00:26:29 - instance in topology builder.
00:26:31 - All right, so we're coming back into this server.
00:26:34 - Let me close out of Lync because we don't actually need
00:26:36 - the client running here.
00:26:38 - And let's switch over to Lync Nugget.
00:26:39 - Right click Monitoring Server, New Monitoring Server.
00:26:42 - And we're going to define a new SQL store for this.
00:26:45 - The FQDN is branchnugget.nuggetlab.com.
00:26:50 - My FQDN, as you know, is branchnugget.nuggetlab.com.
00:26:54 - The instance is Lync 2010.
00:26:56 - So we'll click Next.
00:26:57 - We're asked to associate with one or more front-end pools.
00:27:01 - Note that the monitoring server can provide call detail
00:27:05 - recording for multiple front-end pools.
00:27:08 - We have just one, so I'll select it and click Finish.
00:27:11 - If we edit the properties of the new monitoring server,
00:27:14 - there's really nothing there.
00:27:15 - There's the FQDN, which resolves in DNS, and the SQL
00:27:19 - database instance name.
00:27:20 - To actually make this go into effect, we can publish.
00:27:23 - But actually, since we're here, why don't we go ahead
00:27:26 - and add our archiving server?
00:27:28 - It's right underneath monitoring server.
00:27:30 - We'll choose New Archiving Server, branchnugget--
00:27:33 - same box-- .nuggetlab.com.
00:27:35 - In this case, we can use a previously defined SQL store.
00:27:39 - And we'll click Next.
00:27:40 - It's asking for a file share.
00:27:41 - This is important because as we're going to see a little
00:27:44 - bit later in the demo, we interact with archived file
00:27:47 - data, conversations, et cetera, in the share.
00:27:50 - Now, we can create a new share or we can reuse the share
00:27:53 - that's on our front-end server.
00:27:55 - I'm going to do that. lyncnugget/--
00:27:58 - and the name of my shared folder is unimaginatively
00:28:01 - enough share.
00:28:01 - Same as monitoring, we associate with a front-end
00:28:04 - pool and Finish.
00:28:05 - And the properties are just allowing us to change those
00:28:08 - very same options--
00:28:09 - the FQDN, SQL database, and the file share.
00:28:13 - At this point now, we can publish the topology.
00:28:16 - We've been here so many times you can go through topology
00:28:19 - manager blindfolded by now, can't you?
00:28:22 - Everything was successful.
00:28:23 - You know what this is going to say, too.
00:28:25 - We need to run Lync server setup on branch nugget to
00:28:29 - install those bits.
00:28:30 - So let's do that now.
00:28:31 - We'll close out of topology builder and come back to
00:28:34 - branch nugget.
00:28:35 - I have SQL Server Management Studio fired up and I'm
00:28:39 - connected to that named instance.
00:28:41 - Let's refresh our view.
00:28:42 - We haven't done anything yet.
00:28:44 - We will see some new databases in there once
00:28:47 - we install the bits.
00:28:48 - Let me mount the Lync 2010 media.
00:28:51 - And I still have remnants from my previous work in Lync.
00:28:55 - Lync doesn't do a particularly good job of cleaning up.
00:28:58 - When you decommission a Lync server, you might remember
00:29:01 - earlier when I showed you the fact that we have the RTC
00:29:05 - instances installed on this box.
00:29:07 - This box is no longer a front end, but it still has those
00:29:10 - databases left over.
00:29:12 - Similarly, we still have Lync Server 2010 with a link to the
00:29:16 - Deployment Wizard, the logging tool.
00:29:18 - And I wonder if the management shell is actually here, or if
00:29:21 - that's just a dead shortcut?
00:29:22 - I have a feeling it's actually still here.
00:29:25 - While we're waiting for the Deployment Wizard and the
00:29:27 - management shell to load into memory, we might as well get
00:29:30 - reporting services configuration finished.
00:29:33 - In our Start menu, we have links to all of
00:29:36 - our relevant tool--
00:29:37 - SQL Server Management Studio being the DBA's best friend.
00:29:41 - Under Configuration Tools, we have Reporting Services
00:29:44 - Configuration Manager.
00:29:46 - So let's fire this guy up.
00:29:47 - A lot happening at once here.
00:29:49 - We have the Deployment Wizard, which I will tuck down here.
00:29:52 - You can minimize the window, but I can try to tuck it out
00:29:55 - of the way.
00:29:55 - It looks like we do have a PowerShell command.
00:29:58 - Let me, just for grins, run a get command where the noun
00:30:01 - portion includes CS.
00:30:03 - Remember, CS are all of our communication server cmdlets.
00:30:07 - And they're all here, so that must have been left behind
00:30:10 - when we decommissioned this server.
00:30:12 - I actually did that behind the scenes as I was getting ready
00:30:15 - to teach you this Nugget.
00:30:16 - So this is the Reporting Services
00:30:18 - Configuration Manager.
00:30:19 - It's asking us first to connect.
00:30:21 - Let's make sure our server name and instance are correct.
00:30:24 - It is, so we'll connect.
00:30:26 - Verify the server is running, the service is running.
00:30:29 - Yep.
00:30:29 - The service account, verify that.
00:30:31 - That was done at installation time.
00:30:33 - Web service URL.
00:30:35 - This is fairly important.
00:30:36 - How are we going to connect to that box?
00:30:39 - We're asked to specify a virtual directory name, IP
00:30:42 - address, TCP port, SSL port.
00:30:45 - Advanced button takes you into sockets and SSL identities.
00:30:50 - In a production environment, it's really up to you on
00:30:52 - whether you want to use SSL/TLS.
00:30:55 - Or in other words, HTTPS.
00:30:57 - If you do, you're going to need digital certificates and
00:30:59 - all that kind of stuff.
00:31:01 - It's telling us here that our URL is going to be kind of
00:31:03 - honking here.
00:31:04 - Let me just change this virtual directory to reports.
00:31:07 - And it's also going to hit on the standard port 80.
00:31:10 - I'm worried that I already have that in use.
00:31:12 - So I'm going to switch that up to 8081 and I'm going to make
00:31:16 - the SSL port 4443 just to be safe.
00:31:20 - Apply these changes.
00:31:21 - Make sure nothing blows up.
00:31:23 - You can see down here in the results, as it's making
00:31:25 - changes to your configuration, it echoes that on the screen,
00:31:29 - which is pretty cool.
00:31:30 - This is actually a very nice tool.
00:31:31 - OK, so we're back in business here.
00:31:33 - That's really the major point.
00:31:35 - Database, it's verifying that.
00:31:37 - Again, that's all blah, blah, but.
00:31:38 - This is another URL, not for the web service but for
00:31:41 - actually the site.
00:31:42 - I'm going to call this Report Site, and I'm
00:31:44 - going to hit Advanced.
00:31:46 - And again, change the TCP port just to be sure.
00:31:49 - Don't need SMTP in this case.
00:31:51 - We're not going to worry about encryption keys or execution
00:31:54 - accounts or scale out.
00:31:55 - We're good here.
00:31:56 - So let's click Exit and now come into
00:31:58 - the Deployment Wizard.
00:31:59 - We're actually going to use two sections here, friends.
00:32:01 - We're going to do our regular bits install, then we're going
00:32:03 - to come over here to Deploy Monitoring Server Reports.
00:32:06 - It's nice that Lync gives us a link--
00:32:10 - a nice pun there, of course.
00:32:11 - I've reused it so many times you're probably
00:32:13 - ready to gag, though.
00:32:15 - But anyway, it's nice that Lync links to it right there.
00:32:17 - That we don't have to go to the Microsoft Download Site.
00:32:20 - We can just install it directly from within the
00:32:23 - Deployment Wizard.
00:32:24 - We're asked to install a copy of the local configuration
00:32:27 - store, and then set up those components.
00:32:29 - I'm going to buzz through both of these
00:32:31 - quickly behind the scenes.
00:32:33 - Because again, we've been there so many times I don't
00:32:36 - want to bore you.
00:32:36 - I want to show you as much different stuff as possible.
00:32:39 - At first, let's just make sure that we can in fact get back a
00:32:43 - replica of the central management database.
00:32:45 - We could.
00:32:46 - So now we can actually install the bits.
00:32:48 - Here I am going back on my word and showing you this.
00:32:51 - Note that it's checking for MSMQ.
00:32:54 - I'm sure it's checking for .NET as well.
00:32:56 - You see some raw developer-ish calls here to modules and
00:33:01 - files, DLLs, whatever.
00:33:03 - They don't have particularly useful names for us, as
00:33:06 - administrators, but they keep somebody in business over at
00:33:09 - Microsoft and give them some kind of job security.
00:33:13 - There we go.
00:33:13 - Installing the monitoring server.msi.
00:33:16 - Installing the archive service msi.
00:33:19 - That's what we want to see.
00:33:20 - Good deal, that finished.
00:33:21 - Much faster than I thought, quite honestly.
00:33:23 - But we're not installing a full-fledged
00:33:26 - front-end server here.
00:33:27 - We're just installing some very lightweight server roles.
00:33:30 - Let's go ahead and start those services.
00:33:32 - Point to mention--
00:33:33 - I don't know if I've told you this thus far.
00:33:35 - But when the Lync Deployment Wizard runs start CS Windows
00:33:39 - service, note that it passes in the no wait parameter.
00:33:43 - What that means is the Deployment Wizard sends a
00:33:45 - start signal for those services but does not wait to
00:33:49 - ensure that they've started successfully.
00:33:51 - It's almost a UDP operation, where it
00:33:54 - attempts it best effort.
00:33:56 - And if it fails, it fails.
00:33:57 - And sometimes, it does fail, which I think is why we have
00:34:01 - this final link in the wizard to check the service status.
00:34:04 - Which I'm actually going to hit now, so I can show you
00:34:07 - some of those new services that are in here.
00:34:09 - Here's this call detail recording, QoE monitoring
00:34:12 - service, and Lync server archiving.
00:34:15 - Those are your three main new services running on this box.
00:34:18 - Now let's reopen SQL Server Management Studio, refresh the
00:34:22 - display, and open the databases node.
00:34:25 - We now see three new databases in our Lync 2010 instance--
00:34:30 - QoE metrics, LCS log, and LCS CDR.
00:34:35 - Of course, CDR is our call detail records.
00:34:38 - QoE metrics is for quality of experience data.
00:34:41 - We're almost there.
00:34:42 - We've taken care of most of the back-end plumbing.
00:34:45 - We need to get back to Lync Nugget.
00:34:47 - We could, of course, just hit the admin URL from any box,
00:34:50 - but I've been having some Silverlight issues.
00:34:53 - So I'm going to open the Control Panel on Lync Nugget.
00:34:56 - I've downgraded Silverlight to version 4 on this box.
00:34:59 - I will authenticate as a CS administrator on this box.
00:35:03 - Maximize my view.
00:35:04 - And let's take a look at what we've got.
00:35:06 - We're going to visit a new area of the control panel,
00:35:09 - monitoring and archiving.
00:35:10 - And we're used to how this works by now.
00:35:12 - The fact that we have a default global policy that
00:35:15 - affects your entire deployment, but you can in
00:35:18 - fact scope certain policies, not call
00:35:21 - detail recording evidently.
00:35:22 - But for archiving policy, we can do site
00:35:25 - or user-level policies.
00:35:27 - And we go from there.
00:35:28 - Secondary Navigation shows two tabs for monitoring and two
00:35:33 - tabs for archiving.
00:35:34 - There's not a lot here to choose from, quite honestly.
00:35:37 - For call detail recording, if we select a policy, the global
00:35:41 - is the default.
00:35:42 - You can enable or disable CDR with just one click of the
00:35:46 - mouse from the Action menu.
00:35:48 - Otherwise, we can Edit, Delete, or just double left
00:35:51 - click to go in.
00:35:52 - I'm just going to modify the global policy in this example.
00:35:56 - Again, there's not too much here.
00:35:57 - Enable monitoring for CDR, enable purging.
00:36:01 - If you're going to do monitoring, obviously you need
00:36:03 - that enabled.
00:36:04 - Purging means that after a certain number of days, SQL
00:36:08 - and Lync will work together to purge old data.
00:36:11 - 60 is about 2 months, isn't it?
00:36:13 - This is going to be dependent upon your security policy and
00:36:16 - your compliance requirements.
00:36:18 - I'm going to set this to 1 year, or 365 days, and Commit.
00:36:22 - Note that that's an instant commit.
00:36:24 - If we go to QoE data-- again, if we select a policy, we can
00:36:27 - globally enable or disable QoE for the
00:36:30 - policy with just a click.
00:36:32 - If we go into the policy, besides its name-- again,
00:36:35 - enable monitoring of QoE data, enable purging, and then you
00:36:39 - have the purge interval, the maximum duration which I will
00:36:42 - set to 365.
00:36:44 - Pretty straightforward.
00:36:45 - Archiving as I said, there's two tabs.
00:36:47 - One that covers policy, one that covers configuration.
00:36:50 - You can quickly, using the Action menu, enable or disable
00:36:54 - archiving for internal or external communications.
00:36:58 - By contrast, you can double left click and do it that way.
00:37:01 - Either way, it doesn't matter.
00:37:02 - One thing that does require a little bit more talking is
00:37:06 - this external communications.
00:37:08 - Now, archiving of internal communications almost a
00:37:10 - no-brainer.
00:37:11 - But what about when you're dealing
00:37:13 - with federated partners?
00:37:14 - Legally, are you required to notify them that you're
00:37:18 - archiving those communications because their communications
00:37:21 - are affected by your policy?
00:37:23 - Well, here's what happens.
00:37:24 - With a federated partner, it's assumed that we're using Lync
00:37:27 - Edge Server for secure federation connections.
00:37:30 - If we go over to external user access, this is a bit of
00:37:34 - review from earlier in the course.
00:37:36 - Excess edge configuration and double left
00:37:39 - click our Active Policy.
00:37:40 - If we have federation enabled, note that we have Send
00:37:44 - Archiving Disclaimer to Federated Partners.
00:37:47 - That might be important, again, from a compliance
00:37:50 - standpoint.
00:37:51 - And frankly, just a good neighbor standpoint.
00:37:53 - I know myself, even when I'm hosting web conferences, most
00:37:57 - of the time I don't record.
00:37:59 - But sometimes for archival and training
00:38:01 - purposes, I'll record.
00:38:02 - And I just simply know out of habit to ask everybody on the
00:38:06 - line, I plan to record this.
00:38:08 - Is everybody cool with that?
00:38:10 - Now then, if we come back to-- where were we here?
00:38:13 - Monitoring and archiving.
00:38:14 - I don't want to leave this page yet, because I want to
00:38:17 - make sure I'm not enabling federation.
00:38:19 - Let me Commit that, and we'll come back to Monitoring and
00:38:21 - Archiving, Archiving Policy.
00:38:23 - Let's make sure that both of those are selected on my box.
00:38:26 - And then we'll go to Archiving Configuration last.
00:38:29 - The action menus here are o globally disable archiving,
00:38:33 - archive IM, archive IM and web conferencing.
00:38:36 - Very basic.
00:38:37 - Very basic.
00:38:38 - We choose the archive setting right here.
00:38:40 - I'm going to bring it to maximum archiving, both IM and
00:38:44 - web conferencing.
00:38:45 - This sub-policy is important, block IM or web conferencing
00:38:49 - sessions if archiving fails.
00:38:51 - You may have such an important need compliance-wise to store
00:38:56 - all of your IM traffic and conferencing metadata that you
00:39:00 - don't want anything lost.
00:39:01 - That you would rather deny service to your IM and
00:39:05 - conferencing users than not be able to archive that data.
00:39:08 - So think carefully before selecting that option.
00:39:11 - Alternatively, or in addition, we have
00:39:14 - again, the purge option.
00:39:15 - Purge exported archiving data and stored archiving data
00:39:19 - after a certain number of days.
00:39:21 - Now, if you export and move that data to a different
00:39:24 - location, I don't see how Lync can get to it.
00:39:27 - But certainly, the stored archiving data will purge
00:39:30 - after a certain number of days.
00:39:32 - Let's Commit that change.
00:39:33 - And that's really it.
00:39:34 - At this point, our configuration of both
00:39:37 - archiving server and monitoring server is complete.
00:39:40 - So it's just time to generate some traffic, some IM stuff,
00:39:44 - and bring up some web conferences
00:39:46 - with uploaded files.
00:39:48 - I'm going to do most of that activity behind the curtain so
00:39:51 - you don't have to watch it.
00:39:53 - Because I think you know by now, we've been through
00:39:55 - conferencing.
00:39:56 - We've been through IM.
00:39:57 - I'll spend some time generating the data, and then
00:40:00 - we'll complete this demonstration by my showing
00:40:02 - you how we can follow-up on those reports.
00:40:05 - And also, follow-up on viewing the archived data.
00:40:09 - Before we leave the Deployment Wizard, let's as promised,
00:40:12 - come over to Deploy Monitoring Server Reports.
00:40:15 - What we're doing here is installing canned reports into
00:40:19 - SQL Server reporting services.
00:40:21 - This is going to give us insight.
00:40:23 - We don't have to create cubes or worry about OLAP or any of
00:40:27 - that stuff.
00:40:28 - We can just use these canned reports to take a look at our
00:40:31 - quality of experience and CDR data.
00:40:35 - The first thing it asks us is, where is
00:40:37 - our monitoring server?
00:40:38 - We know that's correct.
00:40:39 - It asks us for the instance and it auto-detected the
00:40:42 - correct server and instance name.
00:40:44 - So we'll click Next.
00:40:45 - I'm going to give the domain administrator credentials.
00:40:50 - For the read-only analysis group, I will do
00:40:53 - nuggetlab/RTCUni versalReadOnlyAdmins.
00:40:59 - That group is going to be up to you, in terms of who your
00:41:02 - business analysts are, who needs to actually look
00:41:05 - at that Lync data.
00:41:06 - Actually, I wouldn't think this stuff would be viewable
00:41:10 - or should be viewable to anybody outside your
00:41:13 - infrastructure team.
00:41:14 - And in particular, your Lync admin team.
00:41:16 - It tells us that the following URL will be used for
00:41:19 - deployment, HTTPS--
00:41:21 - 4443/reports.
00:41:24 - We specified all of your URL metadata back in the SSRS
00:41:29 - Configuration Manager as we saw before.
00:41:31 - The reports are now starting their deployment.
00:41:34 - Great, we want to see all these success
00:41:36 - messages with no warnings.
00:41:38 - That's definitely awesome.
00:41:39 - And these are the individual reports that are being echoed.
00:41:42 - And while we're waiting for this to complete, friends,
00:41:45 - I've popped out to the Microsoft Download Center.
00:41:48 - Before we take a look at the reports, I'll tell you in
00:41:50 - advance SQL Server Reporting Services is one of those tools
00:41:54 - that you really need to understand what's being
00:41:56 - displayed in a report.
00:41:58 - The report builder and all that is a separate kettle of
00:42:01 - fish entirely.
00:42:02 - Again, CBT Nuggets--
00:42:03 - my colleagues, Julie Johnson, Don Jones, Garth Schulte,
00:42:07 - they've all given some excellent training on SQL
00:42:10 - Server Reporting Services if you need a deep dive.
00:42:13 - But for now, I would think that it would be very well
00:42:15 - advisable to you to download these Work Smart Guide
00:42:18 - documents for Lync Monitoring Server Reports.
00:42:21 - Check it out.
00:42:22 - These are Word files that show you how to understand those
00:42:26 - reports, how to get started with monitoring, using the
00:42:29 - reports, understanding alerting, or you could just
00:42:31 - download them all as a ZIP file.
00:42:33 - This is an important resource for you, not so much for the
00:42:37 - exam success but for your real-world
00:42:40 - monitoring best practices.
00:42:41 - Because unfortunately, due to time we're not going to be
00:42:45 - able to understand every report in this brief demo.
00:42:48 - Everything's completed successfully,
00:42:51 - so let's Exit out.
00:42:52 - And that completes that configuration.
00:42:54 - Next thing we want to do is fire up a web browser and
00:42:57 - navigate to your SQL Server Reporting Services Home URL.
00:43:01 - Remember, if you forget that, you can just open the
00:43:04 - Reporting Services Configuration Manager from
00:43:06 - your monitoring server SQL Server box, and verify.
00:43:10 - These are actually clickable URLs here for the Report
00:43:13 - Manager URL.
00:43:14 - Now, all I have installed are the Lync Server Reports.
00:43:18 - This interface should look familiar to you if you have
00:43:21 - any experience with working with SharePoint.
00:43:23 - It's a very stripped down version of Windows SharePoint
00:43:27 - Services 3.0.
00:43:28 - There are elements of it that reminds me
00:43:30 - of WSS 2 quite honestly.
00:43:32 - But anyway, if we hover over Lync Server Reports, there's a
00:43:35 - pop-up menu that gives us some management options to
00:43:39 - actually dive in.
00:43:40 - We can get to the Reports Home Page, and then there's a
00:43:43 - Reports Content sub-folder.
00:43:45 - All right, so we see our monitoring server reports that
00:43:48 - were given to us courtesy of the Lync Deployment Wizard are
00:43:51 - based on system usage.
00:43:53 - This is call detail recording, or CDR data,
00:43:56 - call diagnostic reports.
00:43:58 - These are failure diagnostics per user.
00:44:00 - We have called diagnostics that are in a summary for all
00:44:03 - your users, and we have media quality diagnostic reports.
00:44:08 - Can you add your own reports?
00:44:09 - Can you build archiving reports?
00:44:11 - The answer is absolutely, yes.
00:44:14 - But you have to know how to use Report Builder and that's
00:44:16 - a separate subject for a separate time.
00:44:19 - If I go to Conference Summary Report, it takes us into the
00:44:22 - report proper where we can customize the date range, the
00:44:25 - starting and ending dates, the interval.
00:44:27 - The options are hourly, daily, weekly, monthly.
00:44:30 - We can page through, change the zoom, do keyword searches,
00:44:34 - refresh the view, print.
00:44:35 - This guy is pretty cool.
00:44:36 - Look at all the different output options.
00:44:38 - General options, basic options, like XML and CSV.
00:44:42 - We can do PDF, which makes me chuckle when you think about
00:44:45 - it that we don't have an XPS option, but we have a PDF.
00:44:48 - Web archive, Excel, TIFF image, and Word.
00:44:51 - In other words, we can take this data out, perform further
00:44:54 - manipulations on it, or just snapshot it as is.
00:44:57 - Export to Data Feed is pretty cool.
00:44:59 - What this does is kick out an XML format.
00:45:02 - It's actually an atom-based XML feed file that you can
00:45:06 - feed into your feed reader, if you're into really simple
00:45:09 - syndication or RSS.
00:45:10 - That's especially helpful when we're viewing
00:45:12 - the dashboard page.
00:45:14 - So this is giving us, in Conference Summary Report,
00:45:17 - total number of conferences, total number of participants,
00:45:20 - average participants per conference.
00:45:22 - Pretty global information.
00:45:24 - If we come back to Reports, we can do a Peer-to-Peer Activity
00:45:27 - Report to look strictly at peer-to-peer conversations.
00:45:31 - Notice that we get graphics as well as the tabular data,
00:45:34 - which is good for showing trends.
00:45:36 - Let's come back to Reports one more time.
00:45:38 - User Registration Reports, Logons,
00:45:42 - unique logons, et cetera.
00:45:44 - And it just goes on from there, failures, et cetera.
00:45:46 - If you're going to look at these on a daily basis, I'd
00:45:49 - suggest you bookmark the Dashboard page.
00:45:52 - See the link up here in the upper right?
00:45:53 - We click it, and this is a traditional business
00:45:56 - intelligence dashboard.
00:45:57 - It's taking a moment to load.
00:45:59 - And what it shows us are summary items for
00:46:02 - all of those reports--
00:46:03 - system usage, conference info, call diagnostics.
00:46:07 - Not only for this week, but also as a trend, a line chart
00:46:11 - for the past six weeks.
00:46:12 - So you can see upward versus downward trends,
00:46:15 - versus steady states.
00:46:16 - This is a really nice roll-up of all of those metrics
00:46:20 - pertaining to monitoring.
00:46:21 - Now, notice that we also have the ability to export this as
00:46:25 - an atom feed, pop it into your RSS, and whenever a new entry
00:46:30 - is added to one of these reports, you'll see it in your
00:46:33 - feed reader.
00:46:34 - So those are the basic elements of monitoring,
00:46:37 - actually following monitoring using this web application.
00:46:40 - It's an ASP.NET web application that comes to us
00:46:44 - courtesy of SQL Server Reporting Services.
00:46:47 - All right then, now that we have our configuration down,
00:46:49 - it's time to test monitoring and archiving.
00:46:52 - I've been playing around behind the scenes generating
00:46:55 - traffic in my Lync network.
00:46:57 - We're talking IM message strings, telephone calls,
00:47:01 - right up into conferences.
00:47:02 - And I'm going to quickly generate a conference now so I
00:47:05 - can show you.
00:47:05 - But first, just a quick point-- troubleshooting.
00:47:08 - This is important.
00:47:09 - If you find that your Lync Server is not picking up
00:47:13 - archiving or monitoring, the reports generate no data, you
00:47:16 - go into SQL Server Management Studio, you're not getting any
00:47:19 - archiving back, there's a few things that you should check.
00:47:22 - The first thing you should do is verify your service account
00:47:25 - identities and your logins and security to SQL Server.
00:47:29 - Another thing you want to check--
00:47:30 - and this is not very well documented at all.
00:47:32 - You want to make sure that your computer accounts, your
00:47:35 - Lync front-ends as well as your monitoring and archiving
00:47:38 - servers allow the network service MSMQ privileges.
00:47:42 - Let me quickly show you how that works.
00:47:44 - We'll go into Active Directory Users and Computers.
00:47:47 - We'll make sure that we're showing Advanced features from
00:47:50 - the View menu.
00:47:51 - Navigate to the container or OU that contains our servers.
00:47:55 - Right click and select Properties from
00:47:57 - the Shortcut menu.
00:47:58 - Navigate to Security.
00:48:00 - Navigate to Advanced.
00:48:01 - And you want to add-in the network service identity,
00:48:04 - which I've already done.
00:48:06 - And I've given it full control in my lab environment.
00:48:09 - But in your production environments, you obviously
00:48:11 - want to be very careful about those permissions.
00:48:14 - Create MSMQ, delete MSNQ.
00:48:17 - Make sure that network service is allowed to do that.
00:48:20 - Even still, you might find that monitoring and archiving
00:48:23 - doesn't pick up any records.
00:48:25 - In this case, your front ends, not necessarily your
00:48:27 - monitoring and archiving servers.
00:48:29 - You may need to uninstall MSMQ, reboot the server, come
00:48:34 - back, install MSNQ, and then that worked
00:48:37 - like a charm for me.
00:48:38 - Suddenly, everything started working.
00:48:40 - So all that having been said, let me switch over to Lync
00:48:43 - Nugget where Susan Warner is here and she'll start an IM
00:48:46 - message with her contact and friend, Pat
00:48:49 - Fabello, I should say.
00:48:50 - Let's switch over, get that toast, respond, "I'm going to
00:48:54 - call you." And from the call menu, we'll escalate
00:48:57 - this to a VoIP call.
00:48:58 - We'll come back to Susan's machine.
00:49:00 - We'll accept the call.
00:49:02 - Let me immediately mute my microphone and speakers,
00:49:05 - actually on both ends of the equation.
00:49:07 - And now to turn this into a three-person conference, why
00:49:10 - don't we again, come back to Lync Nugget?
00:49:12 - And why doesn't Susan bring Administrator?
00:49:15 - By just dragging that guy into the list.
00:49:18 - Of course, we're going to have to grab the toast over here on
00:49:21 - Administrators box.
00:49:22 - And at this point, we have a full-fledged conference.
00:49:25 - I believe Susan is the originator of this conference.
00:49:28 - Things have happened so quickly.
00:49:30 - Let me open the People Options menu.
00:49:32 - Make everyone an attendee.
00:49:34 - Sure enough, the originator always is a presenter.
00:49:37 - By default, these other attendees, based on my
00:49:39 - conferencing policy, originally were
00:49:41 - presented as well.
00:49:43 - If Pat for instance, did that same command to make everyone
00:49:47 - an attendee--
00:49:47 - I'm also going to mute the audience while I'm at it--
00:49:50 - then that would leave the presenter and Pat as
00:49:52 - presenters, and just kick Administrator down to the
00:49:55 - attendee level.
00:49:56 - Got it?
00:49:57 - So let's make sure everybody has their stuff muted.
00:50:00 - I think we all do.
00:50:02 - Almost all.
00:50:02 - And now what I'm going to do is on Lync Nugget Susan's box,
00:50:06 - let's do a Share, Show Stage.
00:50:08 - Another bit of troubleshooting that I'm sure we'll see in the
00:50:11 - troubleshooting.
00:50:12 - Nugget is, if you find that you're in a conference and the
00:50:16 - share option doesn't show PowerPoint presentation,
00:50:19 - whiteboard, or poll, instead just shows desktop and
00:50:23 - program, the most likely reason for that is that the
00:50:25 - Lync Web Conferencing Service has somehow become stopped, or
00:50:29 - is otherwise not responding on your front-end server.
00:50:32 - So be aware of that.
00:50:34 - I'm going to upload a file here as Susan.
00:50:36 - I'm going to Add Attachment.
00:50:38 - I have a simple text file on my desktop that I'm going to
00:50:41 - use as an example here.
00:50:42 - The reason I'm adding this attachment is to demonstrate
00:50:45 - what is archived and what is not.
00:50:47 - And there it is, you see the one.
00:50:49 - What will happen is when participants click that link,
00:50:52 - they can download the file to their computer.
00:50:55 - They can also make it available if they've uploaded
00:50:58 - it to themselves.
00:50:59 - I'm going to, by default, leave it at everyone.
00:51:01 - Open, rename, remove.
00:51:03 - Other folks in the conference can download it, but they're
00:51:06 - not going to be able to delete it.
00:51:07 - Let me now open up and share a PowerPoint presentation that
00:51:11 - I've put on my desktop.
00:51:12 - The gotcha here, friends, is that you have to have
00:51:16 - PowerPoint installed on the system on which
00:51:19 - you're sharing the deck.
00:51:20 - The other attendees don't have to have it, but you, as the
00:51:23 - presenter, do need to have it installed.
00:51:26 - So now I've uploaded a file.
00:51:27 - I've shared PowerPoint.
00:51:29 - We've done text messaging.
00:51:30 - We're already on a call, so I think I've generated enough
00:51:33 - data, both from a monitoring as well as archiving
00:51:36 - standpoint.
00:51:37 - So let's remove everyone and end the meeting, close out the
00:51:40 - instructor session, and go over to Branch Nugget.
00:51:43 - Again, close the stage there.
00:51:44 - We'll minimize the Lync client.
00:51:46 - And let's have a look at what's going on.
00:51:48 - You're going to need a little bit of SQL or
00:51:50 - SQL skills for that.
00:51:51 - You'll need to fire up and login to your instance.
00:51:54 - In my case, it was branchnugget/lync2010.
00:51:58 - And in there, we want to draw our attention
00:52:00 - to the LCS log database.
00:52:02 - The CDR and the metrics, those are for the monitoring.
00:52:06 - And unless you're really a hard SQL fan, probably don't
00:52:10 - want to monkey around in those because you have the reports
00:52:12 - already built for you in Report Manager, or SSRS I
00:52:16 - should say.
00:52:17 - On the other hand, as we already discussed with
00:52:20 - archiving, there's no really nice front end that Microsoft
00:52:23 - gives us yet.
00:52:24 - So you're either looking at a third-party solution.
00:52:26 - I'm sure there are folks on CodePlex and elsewhere, who
00:52:29 - have developed a front end for you to look into your
00:52:32 - archiving data.
00:52:33 - Or, we're going to be working here in the SQL directly.
00:52:37 - Now, there are several tables here.
00:52:38 - The cool thing is that the LCS log tables are named pretty
00:52:42 - intelligently.
00:52:43 - You should be able to understand what they mean.
00:52:45 - Joins and leaves, MCU join and leaves,
00:52:48 - messages, roles, et cetera.
00:52:50 - Easiest possible way to look at your IM messages is to
00:52:54 - simply run select star from the messages table.
00:52:58 - I'm going to use the use command here, use LCS log, go,
00:53:01 - and then select star for messages and hit Execute.
00:53:04 - And this gives you-- let me shrink up the navigation pane,
00:53:08 - the Object Explorer--
00:53:09 - all of the recorded messages.
00:53:11 - So what do we have here?
00:53:12 - The columns are a little bit cryptic.
00:53:14 - You can definitely check out the documentation to
00:53:17 - understand the schema of the table.
00:53:20 - But you see here, we have with some markup.
00:53:23 - You know you have rich text support in
00:53:25 - the Lync 2010 client.
00:53:27 - With inline CSS it takes up a lot of space.
00:53:30 - Finally, you can see the message there.
00:53:32 - And these are plain text.
00:53:33 - They're not stored in any encryption way.
00:53:36 - Was there a toast associated with that particular message?
00:53:39 - Of course, there's questions that I'm sure you have.
00:53:41 - How do you figure out who the sending and
00:53:43 - receiving users are?
00:53:45 - Well, that's beyond our scope, unfortunately.
00:53:47 - But there's plenty of documentation online that you
00:53:50 - can leverage to that end.
00:53:52 - You may have to involve in some table joins.
00:53:55 - Again, the schema for these archiving databases is
00:53:58 - available online.
00:53:59 - If we do a select star from data MCU folder, that just
00:54:02 - returns one row.
00:54:04 - This is the path to where your conferencing files are stored.
00:54:07 - And remember, we specified the file store when
00:54:10 - we set up the archive.
00:54:12 - So it's telling us lyncnugget.nuggetlab.com/share
00:54:16 - in the archiving server folder.
00:54:18 - Notice that there's DataConf and MeetingConf.
00:54:21 - There's nothing in MeetingConf yet, but I have just had a
00:54:24 - session here and it has a really cryptic name.
00:54:27 - Again, it's not very user friendly, I have to just be
00:54:30 - honest with you.
00:54:30 - And finally, when you get into that particular GUID that
00:54:34 - corresponds to that conference-- it looks like it
00:54:37 - ends with b37--
00:54:38 - there we have the text file that I uploaded.
00:54:42 - And we also have the pptx file that I shared.
00:54:45 - So those files are, in fact, captured.
00:54:48 - Let's do a select star from conferences and see
00:54:51 - if we can find b37.
00:54:52 - I think that's the number that I had just referenced, right?
00:54:55 - It tells us that the conference URI is originating
00:54:58 - from sharter.
00:54:59 - Conference start time, end time.
00:55:01 - Again, if you want to change this into user-friendly format
00:55:05 - and just get more meaningful human readable data, you're
00:55:08 - going to have to delve into SQL, unfortunately, or go the
00:55:12 - third-party route.
00:55:13 - Final thing I'm going to show you-- we're going to fire up
00:55:15 - the Lync Server Management Shell--
00:55:17 - is how to export that conference data.
00:55:20 - I'm going to shift, right click, and run this session as
00:55:23 - administrator, just to make sure I don't run into any
00:55:26 - rogue permissions issues.
00:55:27 - All right, the cmdlet in question is
00:55:30 - export-csarchivingdata.
00:55:33 - And we can get syntax help for this by prepending get help.
00:55:37 - If we just want to see the examples, which is what I like
00:55:40 - to do a lot, I know generally what the cmdlet means.
00:55:43 - I want to see examples, just throw in -examples.
00:55:47 - And it'll give you plenty.
00:55:48 - It looks like we have three in this case.
00:55:49 - And we're going to model our work on that.
00:55:52 - So let's do an export-csar.
00:55:55 - And watch this, I'll press Tab.
00:55:57 - And it guessed correctly.
00:55:58 - That Tab auto complete is a feature of PowerShell that you
00:56:01 - really ought to take a look At.
00:56:03 - It's gotten really smart, especially in
00:56:05 - Windows Server 2012.
00:56:07 - We pass in dbinstance, which is a string,
00:56:09 - "branchnugget/lync2010." We specify a start date.
00:56:15 - This is a string, "8/25/2012--
00:56:19 - I'll say 12 o'clock.
00:56:22 - End date is "8/25/2012" 22 o'clock.
00:56:26 - 24 hour time as you see.
00:56:28 - Finally, outputfolder.
00:56:29 - c.
00:56:30 - It created a folder.
00:56:31 - Let me quickly pop up explorer conf.
00:56:33 - Press Enter and let this thing chug.
00:56:35 - The cmdlet takes a moment to run.
00:56:37 - If you don't have much that's been archived, like in my
00:56:39 - case, it was almost instantaneous.
00:56:42 - Looks like total number of sessions, seven.
00:56:45 - Successfully exported sessions, seven.
00:56:47 - Failed, zero.
00:56:48 - Well, that's what I want to see.
00:56:49 - A very final step is to open that target folder, see conf.
00:56:54 - We have a sub-folder named after the SQL Server and the
00:56:57 - instance name.
00:56:58 - And again, we have cryptic folders.
00:57:01 - And resultant email transcripts, depending upon
00:57:04 - whether they're peer-to-peer or
00:57:06 - conference-based in EML format.
00:57:09 - To view these message files, you need an application that
00:57:12 - can handle .EML files.
00:57:14 - And that's going to be Outlook client, or I've actually
00:57:17 - downloaded the free kernel EML viewer application that you're
00:57:21 - seeing here.
00:57:22 - And as you see, we can browse each one of those files and
00:57:25 - get metadata about them.
00:57:26 - It looks like that largest file, that 800 something
00:57:30 - kilobyte file, contains the uploaded and shared files from
00:57:34 - my session.
00:57:35 - And then working our way back, we can check out the contents
00:57:38 - of those messages, in plain or even rich text, depending upon
00:57:42 - what tool you're using to view those EML files.
00:57:46 - So there you have it, conferencing and archiving in
00:57:48 - Lync Server 2010.
00:57:49 - Monitoring and archiving in Lync Server 2010 review.
00:57:52 - We began this Nugget by-- you guessed it, as usual,
00:57:56 - describing the technology.
00:57:57 - You now understand the business case for monitoring
00:58:01 - and archiving in Lync Server 2010.
00:58:03 - You know what's involved infrastructure-wise.
00:58:05 - You know about the agent component, the server
00:58:08 - component, the back-end database component.
00:58:11 - Going further, you will absolutely answer correctly
00:58:14 - any questions you receive on your certification exam
00:58:17 - concerning the deployment, configuration, and use of the
00:58:21 - monitoring server and archiving server.
00:58:23 - We covered some really good rubber meets the road
00:58:26 - practical content in this Nugget.
00:58:28 - And it should pay off rich dividends because now more
00:58:31 - than ever, businesses do have to worry
00:58:33 - about compliance issues.
00:58:35 - And now more than ever with people being so accustomed to
00:58:39 - technology, they want the best possible experience they can
00:58:43 - get with their telephony, instant messaging, and
00:58:46 - conferencing.
00:58:47 - use on a daily basis at work.
00:58:49 - I hope that this has been informative for you, and I'd
00:58:51 - like to thank you for viewing.

High Availability and Disaster Recovery in Lync Server 2010

Deploying and Managing Clients and Devices

Patching and Troubleshooting Lync Server 2010

Administering Lync Server with PowerShell

Lync Server 2010 Additional Learning Resources

This forum is for community use – trainers will not participate in conversations. Share your thoughts on training content and engage with other members of the CBT Nuggets community. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus

Course Features

Speed Control

Play videos at a faster or slower pace.

Bookmarks

Pick up where you left off watching a video.

Notes

Jot down information to refer back to at a later time.

Closed Captions

Follow what the trainers are saying with ease.

NuggetLab

Files/materials that supplement the video training

Stay Connected

Get the latest updates on the subjects you choose.


  © 2014 CBT Nuggets. All rights reserved. Licensing Agreement | Billing Agreement | Privacy Policy | RSS