Systems part of what collections?

SELECT v_R_System.Name0, v_Collection.Name FROM v_FullCollectionMembership INNER JOIN v_R_System ON v_FullCollectionMembership.ResourceID = v_R_System.ResourceID INNER JOIN v_Collection ON v_FullCollectionMembership.CollectionID = v_Collection.CollectionID WHERE (v_R_System.Name0 = 'Systemname') for Webbased reports:– Here is the main section: SELECT v_FullCollectionMembership.Name as 'Computer Name', v_Collection.Name as 'Collection Name' FROM v_Collection v_Collection, v_FullCollectionMembership v_FullCollectionMembership WHERE v_FullCollectionMembership.CollectionID = v_Collection.CollectionID AND (v_FullCollectionMembership.Name=@prompt) Here is the "prompt" … Read more

All the Third-Party Solutions for SCCM & SMS

Web Sites: MyITForum is the premier online destination for IT professionals responsible for managing their corporations’ Microsoft Windows systems; it is especially useful for IT professionals working with Microsoft Systems Management Server. (https://www.myitforum.com) FAQshop endeavors to provide a “one-stop-shop” for systems management questions, answers, and utilities. (https://www.faqshop.com) SMS Alliance is a consortium of companies that … Read more

All the Third-Party Solutions for SCCM & SMS

Web Sites: MyITForum is the premier online destination for IT professionals responsible for managing their corporations’ Microsoft Windows systems; it is especially useful for IT professionals working with Microsoft Systems Management Server. (https://www.myitforum.com) FAQshop endeavors to provide a “one-stop-shop” for systems management questions, answers, and utilities. (https://www.faqshop.com) SMS Alliance is a consortium of companies that … Read more

SCCM / SMS Inactive systems from Active Directory?

Detailed Feature Comparison of ESD 2007, SMS 2003 and SCCM 2007 Feature ESD 2007 SMS SCCM 2007 Ability to extend discovery with additional AD Attributes Yes No Yes Ability to filter on the when changed attribute Yes No No Delta Discovery – Only Discover AD Objects that have changed since the last discovery Yes No … Read more

WQL to SQL Query

WQL to SQL Want to see What is the query????????   This SQL Query can be used to see how WQL is converted to SQL by SMS for collections   Select Collections.SiteID , Collections.CollectionName , Collection_Rules.QueryName , Collection_Rules_SQL.WQL , Collection_Rules_SQL.SQL From Collections,Collection_Rules, Collection_Rules_SQL Where Collections.CollectionID = Collection_Rules.CollectionID AND Collections.CollectionID = Collection_Rules_SQL.CollectionID——————- Thanks,https://sccm07.blogspot.com/

SCCM 2007 Right Click Tools latest version available, one can download from the below link

SCCM 2007 Right Click Tools latest version available, one can download from the below link   https://myitforum.com/cs2/blogs/rhouchins/archive/2008/04/09/sccm-right-click-tools.aspx   All the advantages from the above link are below( actual source is above link)   1.       Most of the tools that were included in the original SMS Console Additions V1.4 2.       The ability to see the computer … Read more

SCCM Query for SCCM Clients Model and Manufactures Name

Need to extract SCCM Clients Model and Manufactures Name?   You have to dig the Computer_System_DATA Table. Here are two shared SQL Querys.   Select DISTINCT Model0 from Computer_System_DATA The above one will show all the Models The below Query will show everything in the Database Select * from Computer_system_data ——————-Thanks,https://sccm07.blogspot.com/