The issue was raised recently that we needed a means of identifying all new servers introduced to the environment so that we can add them to the appropriate patching collections within SCCM. With the help of Donnie Taylor, I was able to get the following query to work:
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_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where DATEDIFF(dd, SMS_G_System_SYSTEM.TimeStamp,GetDate()) < 30
Now there is no logic in the code to select only server-based operating systems, but I accomplished this by limiting this collection results to the “Windows Server Systems” collection.
TechNet Webcast: Optimizing Desktop Management with System Center Configuration Manager and Microsoft SoftGrid Application Virtualization (Level 300)
Tuesday, January 15, 2008 – 1:00 PM – 2:00 PM Pacific Time
Jeff Wettlaufer, Senior Technical Product Manager, Microsoft Corporation
Chad Jones, Group Product Manager, Microsoft Corporation
IT Manager Webcast: Visualize Data with System Center Operations Manager, System Center Configuration Manager Add-Ins for Visio 2007 (Level 100)
Tuesday, January 29, 2008 – 11:00 AM – 12:00 PM Pacific Time
Kapil Tandon, Senior Product Manager, Microsoft Corporation
Thanks to Eileen Brown for keeping me up on these.
PS’SOFT ANNOUNCES ASSET AND SERVICE MANAGEMENT SUITE: “PS’Soft, a global provider of IT asset and service management solutions, today announced the general availability of its Asset and Service Management Suite which integrates the rich asset inventory data collected by Microsoft System Center Configuration Manager 2007. PS’Soft Asset Management solution integrates with Microsoft System Center Configuration Manager 2007 to deliver rich end-to-end software license management capabilities. Integration with Microsoft System Center Configuration Manager 2007 enables PS’Soft to address the needs of a vast user base of Microsoft System Center customers. “