SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

March 2009 - Posts

  • List computers by AV software

    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

    Posted Mar 31 2009, 12:58 PM by Garth with no comments
    Filed under: , , ,
  • Are you planning on taking 70-089?

     

    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

  • How user group events can make a difference!

    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.

  • Adding Publisher

    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

    Posted Mar 27 2009, 06:58 AM by Garth with no comments
    Filed under: , , ,
  • Monitoring a Windows Service

    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'

    Posted Mar 24 2009, 01:45 PM by Garth with no comments
    Filed under: , , ,
  • Microsoft Skills Week

    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!

  • List PCs with Type and OS Name

    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

    Posted Mar 07 2009, 11:02 AM by Garth with no comments
    Filed under: , , ,

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems