Month – November 2009

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 […]

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 […]

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)

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

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)

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)