Month – November 2007

SQL, SMS, Code, System Center, ConfigMGr

Here is the MOF edit for DataShift – Local found on the SMS Expert Site http://www.smsexpert.com/MOF/Scripts.aspx DataShift –Local will return a list of who is within the Local Administrator group.   #pragma namespace(“\\\\.\\root\\cimv2\\SMS”) #pragma deleteclass(“SMX_LocalAdmins”,NOFAIL)   [SMS_Report(TRUE), SMS_Group_Name(“Local Administrators”), SMS_Class_ID(“MICROSOFT|SMXLocalAdmins|1.0”)]   class SMX_LocalAdmins : SMS_Class_Template { [SMS_Report(TRUE),Key]   String Account; };

Key Finds within the November release of the update ConfigMgr 2007 documentation

With the November release of update ConfigMgr 2007 documentation there are a few key finds. List of Log Files in Configuration Manager 2007 http://technet.microsoft.com/en-ca/library/bb892800.aspx   Inbox Folders in Configuration Manager 2007 http://technet.microsoft.com/en-ca/library/bb892790.aspx   Ports used by Configuration Manager http://technet.microsoft.com/en-ca/library/bb632618.aspx

DataShift – Printers

Here is the MOF edit for DataShift – Printers found on the SMS Expert Site http://www.smsexpert.com/MOF/Scripts.aspx Datashift – Printers will return a list of Printers including Network printers, which SMS/ConfigMgr can’t.   #pragma namespace(“\\\\.\\root\\cimv2\\SMS”) #pragma deleteclass(“SMX_Printer”,NOFAIL)   [SMS_Report(TRUE), SMS_Group_Name(“Printer Information”), SMS_Class_ID(“MICROSOFT|SMXPrinterInfo|1.0”)]   class SMX_Printer: SMS_Class_Template { [SMS_Report(TRUE)]   String Comment; [SMS_Report(TRUE)]   boolean Default  ; [SMS_Report(TRUE),Key]   string  DeviceID; […]

DataShift – Shares

Here is the MOF edit for DataShift – Shares found on the SMS Expert Site http://www.smsexpert.com/MOF/Scripts.aspx DataShift – Shares will return a list of share on the local PC.   #pragma namespace(“\\\\.\\root\\cimv2\\SMS”) #pragma deleteclass(“SMX_Shares”,NOFAIL)   [SMS_Report(TRUE), SMS_Group_Name(“Share Information”), SMS_Class_ID(“MICROSOFT|SMXShareInfo|1.0”)]   class SMX_Shares : SMS_Class_Template { [SMS_Report(TRUE)]    boolean AllowMaximum; [SMS_Report(TRUE)]   string  Description; [SMS_Report(TRUE)]    string  Description; [SMS_Report(TRUE),Key]    […]

Find all PCs where the RAM and when it changed

select CS.Name0, CS.UserName0, RAM.TotalPhysicalMemory0, RAM.TimeStamp, HRAM.TotalPhysicalMemory0, Max(HRAM.TimeStamp) from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_X86_PC_MEMORY RAM, dbo.v_HS_X86_PC_MEMORY HRAM Where CS.ResourceID = RAM.ResourceID and CS.ResourceID = HRAM.ResourceID and RAM.TotalPhysicalMemory0 != HRAM.TotalPhysicalMemory0 Group by CS.Name0, CS.UserName0, RAM.TotalPhysicalMemory0, RAM.TimeStamp, HRAM.TotalPhysicalMemory0