March 2009 - Posts

List computers by AV software
Tuesday, March 31, 2009 1:58 PM

SELECT DISTINCT
    R.Netbios_Name0,
    R.User_Name0,
    WS.lastHWScan,
    CASE
        WHEN ARP.DisplayName0 = 'Symantec Endpoint Protection' THEN '*'
        else ' '
    END As SEP,
    CASE
        WHEN ARP.DisplayName0 = 'McAfee VirusScan Enterprise' THEN '*'
        else ' '
    END As Mcafee,
    ' ' As 'No AVS'
FROM 
    dbo.v_R_System R
    left outer join dbo.v_RA_System_SMSAssignedSites RASS on (RASS.ResourceID = R.ResourceID)
    Left outer join dbo.v_GS_ADD_REMOVE_PROGRAMS ARP on (ARP.ResourceID = R.ResourceID)
    Left outer join dbo.v_GS_WORKSTATION_STATUS ws on (WS.ResourceID = R.ResourceID)
WHERE
    ARP.DisplayName0 = 'Symantec Endpoint Protection' OR ARP.DisplayName0 = 'McAfee VirusScan Enterprise'

union

SELECT DISTINCT
    R.Netbios_Name0,
    R.User_Name0,
    WS.lastHWScan,
    ' ' As SEP,
    ' ' As Mcafee,
    '*' As 'No AVS'
FROM 
    dbo.v_R_System R
    left outer join dbo.v_RA_System_SMSAssignedSites RASS on (RASS.ResourceID = R.ResourceID)
    Left outer join dbo.v_GS_ADD_REMOVE_PROGRAMS ARP on (ARP.ResourceID = R.ResourceID)
    Left outer join dbo.v_GS_WORKSTATION_STATUS ws on (WS.ResourceID = R.ResourceID)
WHERE
    R.ResourceId not in (select ResourceID from dbo.v_GS_ADD_REMOVE_PROGRAMS ARP where ARP.DisplayName0 = 'Symantec Endpoint Protection' OR ARP.DisplayName0 = 'McAfee VirusScan Enterprise')
    AND R.Netbios_Name0 != ''
Order by
    R.Netbios_Name0,
    R.User_Name0

by Garth Jones

Filed under: ConfigMGr, SMS, Code, SQL

Are you planning on taking 70-089?
Monday, March 30, 2009 8:22 AM

 

What is covered on the exam

http://www.microsoft.com/learning/en/us/exams/70-089.mspx

 

Here are the type of questions you should expect to see, Make sure to download the demo software.

http://smsug.ca/blogs/garth_jones/archive/2008/09/16/microsoft-exam-questions.aspx

 

Here is evaluation version of testing software that you can purchase.

http://www.transcender.com/product.aspx?product_id=Cert-70-089&Search=1

 

Here are about 30 Q&A that will help you study for the exam.

http://myitforum.com/cs2/blogs/socal/archive/tags/SMS+2003+Certification/default.aspx

by Garth Jones

Filed under: SMS, Training, self-study, exam, 70-089

How user group events can make a difference!
Saturday, March 28, 2009 12:23 PM

Do you go to User Group event? Have you gone out for pints afterwards? Did you know some of the best idea come from the informal after events?

Here is a case and point of how a few people (and yes there was woman there too!) can brainstorm and come up with an idea that helps everyone. “Security Bulletins for the regular IT guy” Podcast http://blogs.technet.com/canitpro/archive/2009/03/10/security-bulletins-for-the-regular-it-guy-podcast-03-10-2009.aspx.

On side note I was met with Bruce Cowper yesterday, He is the Chief Security Advisor for Microsoft Canada. One of the ideas that I asked him to consider is arranging for a presentation to OWSUG (hopefully recording it too) on Patch management.

· How to catch up on past software updates

· Best practices with respect to testing software updates.

· How to “sell” software updates to Management

· How to “sell” software updates to End clients

· How to deploy software updates to end clients with the least amount of disruption.

· Reporting Software update compliancy levels.

That last item, I got “roped” into updating a query that I wrote for ConfigMgr “Patch compliance progression report” to make it more useful.

by Garth Jones

Filed under: User Groups, ConfigMGr, System Center, Ottawa

Adding Publisher
Friday, March 27, 2009 7:58 AM

Select
    SOFT.ProductName0 as 'Browser Name',
    Soft.Publisher0,
    Count(SOFT.ProductName0) as 'Count'
FROM
    v_GS_INSTALLED_SOFTWARE_CATEGORIZED SOFT
WHERE
    SOFT.ProductName0 LIKE 'Mozilla Firefox%'
    OR SOFT.ProductName0 LIKE 'Safari'
    OR SOFT.ProductName0 LIKE '%Internet Explorer%'
    OR SOFT.ProductName0 LIKE '%Google Chrome%'
Group by
    SOFT.ProductName0,
    Soft.Publisher0

by Garth Jones

Filed under: ConfigMGr, SMS, Code, SQL

Monitoring a Windows Service
Tuesday, March 24, 2009 2:45 PM

select Distinct
CS.Name0, 
SER.Displayname0,
SER.Started0,
SER.StartMode0,
SER.State0
from
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_SERVICE SER,
dbo.v_FullCollectionMembership FCM
where
CS.ResourceId = SER.ResourceID
and CS.ResourceId = FCM.ResourceID
and SER.displayname0 like '%firewall%'
and (SER.State0 != 'Running' or Isnull(SER.State0,'')='')
and FCM.CollectionID = 'SMS00001'

by Garth Jones

Filed under: ConfigMGr, SMS, Code, SQL

Microsoft Skills Week
Monday, March 16, 2009 10:20 AM

Hi Everyone I just got a email from the team at CTE. They want to give the OWSUG first crack at their Microsoft Skills Week sessions! Below are the details!

We've found what you're looking for...

During the week of April 14th-17th we'll be hosting a Microsoft Skills Week in Ottawa and you're invited!  Choose from  the following emerging technology courses for Microsoft Windows Server 2008 Active Directory, Hyper-V, and SQL Server 2008.

Oh and by the way you'll save over 50% off regularly advertised prices.

6424 Fundamentals of Windows Server 2008 Active Directory>>>>>>$495

This 3-day instructor-led course has been accelerated into 2-days with lengthened hours provides Active Directory Technology Specialists an introduction to Active Directory server roles in Windows Server 2008. The course is intended for entry level students who want to get familiar with the Active Directory server roles and their basic functionality.

Dates: Apr. 14th-15th or Apr 16th-17th (2 days)
Hours: 8am-5pm
Your Instructor: Gerry Tessier
Register Online Now - Email Us - Call 613-798-5353

6422 Implementing and Managing Windows Server 2008 Hyper-V >>>>>>$495

This 3-day course has been accelerated into 2-days with lengthened hours.  This instructor-led course teaches students how to implement and manage Windows Server 2008 Hyper-V. It also teaches students how to manage Hyper-V with Solution Center Virtual Machine Manager (VMM) and with PowerShell.

Date: Apr. 14th-15th (2 days)
Hours: 8am-5pm
Your Instructor: Kim Frank
Register Online Now - Email Us - Call 613-798-5353

6158: Updating Your SQL Server 2005 Skills to SQL Server 2008>>>>>>$695

Get expert training on Microsoft SQL Server 2008, and get the software as a free offer.  In this 3-day course, you will learn to take advantage of the powerful and trustworthy array of new data-driven management solutions in SQL Server 2008.  This course is designed for administrators and developers.

Date: Apr. 14th-16th (3 days)
Hours: 9am-4:30pm
Your Instructor: Susan Ibach
Register Online Now - Email Us - Call 613-798-5353

CTE Solutions delivers - Training with IMPACT!

by Garth Jones

Filed under: User Groups, Training, Ottawa

List PCs with Type and OS Name
Saturday, March 07, 2009 11:02 AM

select
    CS.Name0,
    CS.Systemtype0,
    OS.Caption0
from
    dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceId= OS.ResourceID

by Garth Jones

Filed under: ConfigMGr, SMS, Code, SQL