SCCM 2007

script that has WMI connection error will skip it and move to next

by

strComputer = “MYcomputername” Set objExcel = CreateObject(“Excel.Application”) objExcel.Visible = True objExcel.Workbooks.Add intRow = 2 objExcel.Cells(1, 1).Value = “Logon Name” objExcel.Cells(1, 2).Value = “Full Name” objExcel.Cells(1, 3).Value = “Description” objExcel.Cells(1, 4).Value = “Domain” objExcel.Cells(1, 5).Value = “Password Changeable” objExcel.Cells(1, 6).Value = “Password Required” objExcel.Cells(1, 7).Value = “Password Expires” objExcel.Cells(1, 8).Value = “Account Disabled” objExcel.Cells(1, 9).Value = … Read more

Collection : For software distribution status if system pending for reboot

by

For software distribution status if system pending for reboot   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 AS sms_r_system     join SMS_StatMsg  as st on sms_r_system.Name = st.MachineName     join SMS_AdvertisementStatusInformation sti on st.MessageID = sti.MessageID where         sti.messagestate = 102  102 is the reboot pending code you can get the complete list … Read more

Collections based on software updates deployment status in Configuration Manager

by

ConfigMgr sccm patching status based collections LastEnforcementMessageIDLastEnforcementMessageName 1        Enforcement started    3        Waiting for another installation to complete 6    General failure 8    Installing update    9    Pending system restart    10  Successfully installed update    11  Failed to install update    12  Downloading update    13  Downloaded update    So in this example we would like to use the status of reboot … Read more

SMS 2003 Patching : Pending for reboot collection

by

A collection listing all servers/clients that were pending reboot (see query statement):       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_PatchStatus on SMS_G_System_PatchStatus.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PatchStatus.LastStateName = “Reboot Pending”    

Sysprep parameters

by

Sysprep parameters You can use the following optional parameters with the Sysprep command in Windows XP: -activated – Do not reset the grace period for Windows product activation. Use this parameter only if you have activated the Windows installation in the factory.Important The product key that you use to activate the Windows installation must match … Read more