SCCM

Last hardware inventory 14 days

by

———————————————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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name not in (select SMS_R_System.Name 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 >= DateAdd(dd,-14,GetDate()) )———————–

You must know these collections as handy : Collections End to End

by

1.Client all system collection 2.Non client systems 3.Inactive systems 4.Obsolete system 5.Duplicate client Yes or No 6. Last hardware inventory 14 days 7.Last software inventory 14 days 8.Last Data discovery cycle. 9. XYZ package, XYZ Advertisement success systems’ collection 10. XYZ package, XYZ Advertisement Failed systems’ collection 11.XYZ subnet collection system 12.Add XYZ system’s to … Read more

WSUS Wiki and troubleshooting WSUS

by

Read here on the WSUS Team Blog a nice article about troubleshooting WSUS. It references the site https://www.wsuswiki.com/. This site was created to provide a place for the WSUS community to share information about WSUS, including troubleshooting steps and best practices. The advantages that this site provides over public news groups include: Content on this … Read more

SQL Reporting Services: SRS

by

SQL Reporting services have some benefits over the current reporting solution: Provide best in class reporting capability by integrating SQL Reporting Services, with the leading change and configuration management product: SCCM 2007 Enable Ad-hoc reporting – Make it easy for both SCCM administrators, and non administrators to find the information they need to make the … Read more