Hi Everyone,
Attached are the slides from our last meeting. We had a great turn out and we hope to see you all at future meetings.

I have been a sysadmin for two years for an auto group.  The decision was made to move to managed clients after noticing that many users were not updating there av.  During the time we did have a few virus's/trojans hit our network, but not many or so it seemed....
  After rolling out the managed client we were noticing regular infections mostly from upper managment who were less filtered than most user. What supprised me was not getting any phone calls or email letting me know they had been infected.  I just have to wonder how many infections had gone unreported, and now wonder how i could function without the ability to manage the av.

The following code will create a stored procedure on your SQL server for the SEPM database. This stored procedure excepts a single value in the form of a computer name. The ComputerName parameter is currently set to varchar(25) even though, as you probably already know, windows limits computer names to 15 characters.

Make sure you are set to use the SEPM DB and execute the following code:

CREATE PROCEDURE GetScanTime

--//* Create a parameter for user to enter computer name *\\

@ComputerName varchar(25)

AS

--//* Do not return row count * \\

SET NOCOUNT ON;
BEGIN

SELECT

--//* t1=dbo.scans, t2=dbo.sem_computer *\\

    t1.startdatetime AS 'Date',...

I recently ran a survey on password management.  You can see my original blog and even take the survey yourself here.   At best, I thought 20 or so of you would take the time to fill out the survey…and that would include most of my close relatives.  However, instead we got more than 400 responses in a few short days (not even including my relatives).  So, thank you to all who took the time to complete the survey.  I’ve posted the results below. 
 
I want to comment on some of the results.  It may be a stretch to draw too many definitive conclusions from the data, but it will be fun nonetheless.  If anyone wants to comment, correct or vehemently disagree with any of my conclusions please feel free to do so.

Let’s get started!