SMSUG.ca

...your virtual communITy

Featured Item

System Center Configuration Manager 2007 Software Updates Synchronization SuperFlow
 
Brief Description
 
The Software Updates Synchronization SuperFlow is a dynamic, interactive dataflow model that provides all of the information needed to understand the software updates synchronization process in Configuration Manager 2007. The SuperFlow also provides an animation for the process and resource files and links that provide information related to the process.
 
DOWNLOAD it today

Books

Microsoft® System Center Configuration Manager 2007 Administrator's Companion
Get the comprehensive, one-volume reference for administering System Center Configuration Manager 2007. This ADMINISTRATOR’S COMPANION delivers all the information you need to plan, design, deploy, and manage mission-critical software updates—and help maximize your organization’s productivity.
Read more about it at MSPress.
Microsoft® Systems Management Server 2003 Administrator's Companion
Streamline—and centralize—the management of your Microsoft Windows-based desktops with the essential guide to planning, deploying, and supporting Systems Management Server (SMS) 2003.
Read more about it at MSPress.

Thanks To

 
 
 
 
An information technology company specializing in Windows Management development, and implementation and customization of System Center Configuration Manger 2007 (ConfigMgr/ SCCM ), System Center Operation Manager 2007 (OpsMgr / SCOM), System Management Server (SMS) 2003, Microsoft Operations Manager 2005 (MOM) and Virtual Server 2005 (VS) environments. We focus on helping you manage your technology needs through our portfolio of world-class products and services.

Popular Tags

Browse All Tags

Welcome to SMSUG.ca

SMSUG.ca is your virtual SMS user group, dedicated to all things relating to Systems Management Server (SMS) and Configuration Manager (ConfigMgr) 2007.

SMSUG.ca includes an Event Calendar (local and global user group events, Technet Webcasts, and other events you'd like to be made aware of), Blogs, and Forums all provided for, and powered by you.

We'll also be monitoring, and forwarding problems, comments, and suggestions to the Microsoft Product team in order to keep Configuration Manager as a valuable management tool.

For any SMSUG.ca site suggestions, or Event Calendar additions, please contact us.

Garth Jones, Microsoft MVP-System Center Configuration Manager

What's New

  • Custom Windows 7 report - workstation manufacturer & model & client version

    SELECT DISTINCT COMSYS.Manufacturer0, COMSYS.Model0, Client.Version0, Count (*) FROM v_GS_COMPUTER_SYSTEM COMSYS JOIN v_FullCollectionMembership fcm ON COMSYS.ResourceID = FCM.ResourceID JOIN v_GS_PROCESSOR PROC 1 ON COMSYS.ResourceID = PROC 1.ResourceID JOIN v_GS_X86_PC_MEMORY MEM ON COMSYS.ResourceID = MEM.ResourceID JOIN v_GS_OPERATING_SYSTEM OPSYS...
    Posted to Garth Jones (Weblog) by Garth on 01-16-2012

  • Custom Windows 7 report - workstation manufacturer & model type

    SELECT DISTINCT COMSYS.Manufacturer0, COMSYS.Model0, Count (*) FROM v_GS_COMPUTER_SYSTEM COMSYS JOIN v_FullCollectionMembership fcm ON COMSYS.ResourceID = FCM.ResourceID JOIN v_GS_PROCESSOR PROC 1 ON COMSYS.ResourceID = PROC 1.ResourceID JOIN v_GS_X86_PC_MEMORY MEM ON COMSYS.ResourceID = MEM.ResourceID JOIN v_GS_OPERATING_SYSTEM OPSYS ON COMSYS.ResourceID...
    Posted to Garth Jones (Weblog) by Garth on 01-16-2012

  • WQL Query for both x86 and x64 version of Software

      select distinct SMS_R_System.Name, SMS_R_System.ResourceId from SMS_R_System where SMS_R_System.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = " Microsoft Lync 2010 ") or SMS_R_System.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS_64...
    Posted to Garth Jones (Weblog) by Garth on 01-16-2012

  • Adding IP address to Client Summary data

    select NetBiosName as " CAM NetBiosName ", LastPolicyRequest as " CAM LastPolicyRequest ", LastDDR as " CAM LastDDR ", sy.Operating_System_Name_and0 as " Operating System ", sy.Resource_Domain_OR_Workgr0 as " AD Domain ", NAC.IPAddress0 from v_CH_ClientSummary inner join v_R_System as sy on sy.ResourceID...
    Posted to Garth Jones (Weblog) by Garth on 01-13-2012

  • WINS/DNS for a Collection

    SELECT S.Name0 AS [System Name], OS.Caption0 AS [Operating System], OS.CSDVersion0 AS [Service Pack], OS.InstallDate0 AS [Original OS Install Date ], OS.LastBootUpTime0 AS [ Last Boot Time ], NAC.IPAddress0 AS [IP Address], NAC.IPSubnet0 AS [Subnet Mask], NAC.DefaultIPGateway0 AS [Gateway], NAC.DNSServerSearchOrder0 AS [DNS Servers], NAC.WINSPrimaryServer0...
    Posted to Garth Jones (Weblog) by Garth on 01-13-2012

  • MyITforum donation for 2012

    With the start of a new year, it is that time again to support the System Center Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). http://myitforum.com/myitforumwp/aboutus/donations/   MIF is truly a community that helps each other both professionally and personally. But it cost thousands of dollars each...
    Posted to Garth Jones (Weblog) by Garth on 01-02-2012

  • 64 Bit Office

    SELECT       CS . Name0 ,       ARP64 . DisplayName0 ,       ARP64 . Version0   FROM       dbo . v_GS_COMPUTER_SYSTEM CS       join dbo . v_GS_ADD_REMOVE_PROGRAMS_64 ARP64 on CS . ResourceID = ARP64 . ResourceID Where      ...
    Posted to Garth Jones (Weblog) by Garth on 12-29-2011

Who Is Online

©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems