SMSUG.ca

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

Garth Jones

November 2009 - Posts

  • ConfigMgr and OpsMgr Exam Discounts

     

    Are you looking to become certified on ConfigMgr 2007 (70-401) or OpsMgr 2007 (70-400)?

     

    Well you are in Luck! Prometric is offering a 20% discount on both exam!

    http://www.prometric.com/Microsoft/CareerOffer.htm#vouchers20

     

    So what are you waiting for?

    Digg This
  • Making the World Safer

    Yesterday, I receive the typical spam message and every so often I go to the website just checking out the phishing site and to see how bad their really are!

     

    Yesterday I went off to the SPAMMER website and was surprised that I found that the site was not blocked but IE! It look like the normal bank site.

     

    Anyways I was trying to remember how to report bogus websites so that they would get blocked by IE.  I could not find the option within IE to reports this site, So I sent a quick email off to Bruce Cowper at MS Canada, I don’t remember what Bruce’s official title is but it is something like “Canadian Security Officer” or something like that.

     

    Bruce replied with the steps to report bogus site. ( I have expanded them and added the screenshots)

     

    From within IE and while you are on the site.

    Select Safety from the tool bar.

    Point to SmartScreen Filter then  select Report Unsafe Website.

    image

     

    On the MS site, check the appropriate check box

    Type the CAPTCHA word and click submit.

     

    image

    Anyways today I thought that I would blog about this, mostly as a reminder to everyone that if you see a website that is bogus, then report them. Today this is what I got when I tried to get to the bogus site! Thanks Bruce.

     

     

    image

     

     

     

    Digg This
  • Cal Tracking and ConfigMgr SP2

    Like many of you I applied SP2 a while back and promptly added  a few classes back to the sms_def.mof, however I had enable the Cal tracking too and it is enabled within the configuration.mof.

    Today I realized that it was disable (default setting) because both the smsdef.mof and configuration.mof are over written as part of applying the service pack. Therefore if you did have it enable and you applied the SP for ConfigMgr, remember to re-enable it.

    Digg This
  • List of all machines used by users in a certain AD group

    select distinct
    R.Name,
    SCU.TopConsoleUser
    from
    SMS_R_System R
    inner join SMS_G_System_SYSTEM_CONSOLE_USAGE SCU on SCU.ResourceID = R.ResourceId
    where
    SCU.TopConsoleUser in ( select
         U.UniqueUserName 
        from 
         SMS_R_User U 
        where
         U.UserGroupName = "GARTEK\\Test1")

    Digg This
    Posted Nov 24 2009, 08:34 AM by Garth with 2 comment(s)
    Filed under: , , ,
  • Twitter

    Thanks Cliff.. ;-) this Twitter add-on works great! Something tells me that I will be twittering more!

    Digg This
  • List of PCs not listed v_R_System

    select

          CS.name0 as 'PC name',

          WS.LastHWScan as 'Last HW scan Date'

           

    from

          dbo.v_GS_COMPUTER_SYSTEM CS

          join dbo.v_GS_WORKSTATION_STATUS WS on CS.resourceID = WS.resourceID

    Where

          CS.resourceID not in (select R.resourceID from v_R_System R)

    Digg This
    Posted Nov 23 2009, 09:18 PM by Garth with 1 comment(s)
    Filed under: , , ,
  • An Ottawa summer in 30,000 fames

    I don’t know how I originally found this RSS feed but here is a cool video of Ottawa in 30000 frames.

    http://waa.loudandskittish.com/2009/11/14/an-ottawa-summer-in-30000-frames/

    Posted Nov 22 2009, 08:43 PM by Garth with no comments
    Filed under: ,
  • Attribute Reference Query

    select
        SMS_R_System.ResourceId,
        SMS_R_System.ResourceType,
        SMS_R_System.Name,
        SMS_R_System.SMSUniqueIdentifier,
        SMS_R_System.ResourceDomainORWorkgroup,
        SMS_R_System.Client,
        SMS_G_System_SYSTEM_CONSOLE_USER.LastConsoleUse,
        SMS_G_System_COMPUTER_SYSTEM.TimeStamp
    from 
        SMS_R_System
        inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
        inner join SMS_G_System_SYSTEM_CONSOLE_USER on SMS_G_System_SYSTEM_CONSOLE_USER.ResourceId = SMS_R_System.ResourceId
    where
        SMS_G_System_COMPUTER_SYSTEM.UserName = SMS_G_System_SYSTEM_CONSOLE_USER.SystemConsoleUser

    Posted Nov 14 2009, 09:15 AM by Garth with no comments
    Filed under: , , , ,
  • Find all non-client PCs

     

    :-) at the suggestion of a friend here is a query to find all non-client PCs.

    select

                   SMS_R_SYSTEM.ResourceID,

                   SMS_R_SYSTEM.ResourceType,

                   SMS_R_SYSTEM.Name,

                   SMS_R_SYSTEM.SMSUniqueIdentifier,

                   SMS_R_SYSTEM.ResourceDomainORWorkgroup,

                   SMS_R_SYSTEM.Client

    from

                   SMS_R_System

    where

                   SMS_R_SYSTEM.ResourceID not in (Select SMS_R_SYSTEM.ResourceID from SMS_R_System where SMS_R_System.Client = 1)

    Posted Nov 10 2009, 09:37 AM by Garth with no comments
    Filed under: , , ,
  • No HW inventory in the last 30 days.

    select
        SMS_R_SYSTEM.ResourceID,
        SMS_R_SYSTEM.ResourceType,
        SMS_R_SYSTEM.Name,
        SMS_R_SYSTEM.SMSUniqueIdentifier,
        SMS_R_SYSTEM.ResourceDomainORWorkgroup,
        SMS_R_SYSTEM.Client
    from
        SMS_R_System
        inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceId = SMS_R_System.ResourceId
    where
        SMS_G_System_WORKSTATION_STATUS.LastHardwareScan < Datediff(dd,Getdate(),-30)

    Posted Nov 10 2009, 08:51 AM by Garth with no comments
    Filed under: , , ,

This Blog

Syndication

News

Training

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