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?
Month: November 2009
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 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 […]
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”)
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)
Thanks Cliff.. π this Twitter add-on works great! Something tells me that I will be twittering more!
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/
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
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)
π 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)