November 2009 - Posts

ConfigMgr and OpsMgr Exam Discounts
Friday, November 27, 2009 11:08 AM

 

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
Friday, November 27, 2009 9:30 AM

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
Wednesday, November 25, 2009 10:18 AM

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
Tuesday, November 24, 2009 8:34 AM

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
by Garth Jones
Filed under: , , ,
Twitter
Monday, November 23, 2009 9:54 PM

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

Digg This
by Garth Jones
Filed under: , ,
List of PCs not listed v_R_System
Monday, November 23, 2009 9:18 PM

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
by Garth Jones
Filed under: , , ,
An Ottawa summer in 30,000 fames
Sunday, November 22, 2009 8:43 PM

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/

by Garth Jones
Filed under: ,
Attribute Reference Query
Saturday, November 14, 2009 9:15 AM

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

by Garth Jones
Filed under: , , , ,
Find all non-client PCs
Tuesday, November 10, 2009 9:37 AM

 

:-) 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)

by Garth Jones
Filed under: , , ,
No HW inventory in the last 30 days.
Tuesday, November 10, 2009 8:51 AM

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)

by Garth Jones
Filed under: , , ,

This Blog

Syndication