00:00:00 - Monitoring and archiving
in Lync Server 2010.
00:00:03 - This Nugget is all about
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
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
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
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,
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
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
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
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
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
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
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
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
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
00:08:41 - to take care of an additional
server, or two or three.
00:08:44 - Monitoring and archiving
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
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
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
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
00:11:12 - This goes to the troubleshooting
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
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
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
00:13:01 - Conference metadata in terms of
who joins and who leaves.
00:13:04 - That can be especially
00:13:06 - I found in my experience,
working as part of a virtual
00:13:09 - team, especially the
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
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
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
00:14:23 - So what is the deployment
00:14:25 - monitoring and archiving?
00:14:27 - First, we have our
00:14:29 - And these are really
00:14:30 - If you don't do this, you're not
going to get any results
00:14:34 - in your monitoring
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
00:15:03 - These are 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
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
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
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
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
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
00:18:07 - Actually, let me start with
monitoring because that's
00:18:10 - historically what we've
00:18:12 - Let's make sure we haven't
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
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
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
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,
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
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
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
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
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
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
00:23:41 - We can't have SQL Server
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,
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
00:24:21 - That's what makes the
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
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
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
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
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
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
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
00:26:50 - My FQDN, as you know, is
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
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
00:27:30 - We'll choose New Archiving
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
00:27:55 - I'm going to do that.
00:27:58 - and the name of my shared folder
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
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
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
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
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
00:30:18 - Configuration Manager.
00:30:19 - It's asking us first
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,
00:30:31 - That was done at installation
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
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
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
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
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
00:33:16 - Installing the archive
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,
00:33:23 - But we're not installing
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
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
00:33:51 - It's almost a UDP operation,
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
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
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
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,
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,
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
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
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
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
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
00:37:47 - That might be important, again,
from a compliance
00:37:50 - standpoint.
00:37:51 - And frankly, just a good
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
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
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
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
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
00:39:32 - Let's Commit that change.
00:39:33 - And that's really it.
00:39:34 - At this point, our configuration
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
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
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
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
00:40:44 - So we'll click Next.
00:40:45 - I'm going to give the domain
00:40:50 - For the read-only analysis
group, I will do
00:40:53 - nuggetlab/RTCUni
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
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
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
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
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
00:42:51 - so let's Exit out.
00:42:52 - And that completes that
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
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
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
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
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,
00:44:27 - The options are hourly, daily,
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
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
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
00:45:31 - Notice that we get graphics as
well as the tabular data,
00:45:34 - which is good for
00:45:36 - Let's come back to Reports
one more time.
00:45:38 - User Registration
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
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
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
00:46:47 - All right then, now that we have
our configuration down,
00:46:49 - it's time to test monitoring
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--
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
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
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
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
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
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
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
00:49:25 - I believe Susan is the
originator of this conference.
00:49:28 - Things have happened
00:49:30 - Let me open the People
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,
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
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
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
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
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
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
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
00:54:16 - in the archiving
00:54:18 - Notice that there's DataConf
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
00:55:17 - is how to export that
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
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,
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"
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
00:56:42 - Looks like total number
of sessions, seven.
00:56:45 - Successfully exported
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
00:57:01 - And resultant email transcripts,
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
00:58:03 - You know what's involved
00:58:05 - You know about the agent
component, the server
00:58:08 - component, the back-end
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
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.