Roger Zander Sourceforge Tools And Utilities SMS/SCCM Peer2Peer AddOn SMSTorrent is a Peer2Peer AddOn for SMS2003/SCCM2007 Clients. SMS/SCCM Clients are able to share the local Package cache with other Clients using the BitTorrent filesharing protocol. https://sourceforge.net/projects/smstorrent SMS Site Settings tweak SMSSettings provides a GUI to modify SMS2003 (Microsoft System Management Server 2003) Site Settings which … Read more
SELECT distinct dbo.v_R_System.Name0 AS [Computer Name], dbo.v_Add_Remove_Programs.DisplayName0 AS [Software Name], dbo.v_Add_Remove_Programs.Publisher0 AS Publisher, dbo.v_Add_Remove_Programs.Version0FROM dbo.v_Add_Remove_Programs INNER JOIN dbo.v_R_System ON dbo.v_Add_Remove_Programs.ResourceID = dbo.v_R_System.ResourceIDWHERE dbo.v_Add_Remove_Programs.DisplayName0 like ‘%Bright%’
SQL Query to find the collections Hierarchy WITH folderHierarchy (CollectionID,[Name],ParentCollectionID,[Path])AS( SELECT CollectionID, [Name], ParentCollectionID, CAST(‘/’+[Name]+’/’ AS VARCHAR(MAX)) AS [Path] FROM (SELECT CollectionID, [Name], ParentCollectionID FROM v_Collection INNER JOIN v_CollectToSubCollect ON v_Collection.CollectionID = v_CollectToSubCollect.SubCollectionID) AS V_1 WHERE ParentCollectionID = ‘COLLROOT’ UNION ALL SELECT child.CollectionID, child.Name, … Read more
Creating a Collection Query From SQL : Source : https://myitforum.com/cs2/blogs/cnackers/archive/2009/04/22/creating-a-collection-query-from-sql.aspx Credit to Dave Fuller for which this information is based upon. Creating a collection query that is based upon SQL can be done. It’s a little complicated, but not all that bad once you’ve done it a few times. There are many times where you … Read more
SELECT dbo.v_R_System.Name0 AS [Computer Name], A.System_OU_Name0FROM dbo.v_RA_System_SystemOUName AS A INNER JOIN (SELECT ResourceID, MAX(LEN(System_OU_Name0)) AS len FROM dbo.v_RA_System_SystemOUName GROUP BY ResourceID) AS B ON A.ResourceID = B.ResourceID AND LEN(A.System_OU_Name0) = B.len INNER JOIN dbo.v_R_System ON B.ResourceID = dbo.v_R_System.ResourceID If you want just for one computer then… SELECT dbo.v_R_System.Name0 AS [Computer … Read more
Configuration Manager R3 – Prestaged Media Setup and Walkthrough This blog will be a walkthrough and setup guide for Configuration Manager (ConfigMgr) R3 prestaged media. This will cover the basic steps required in order to use the new R3 feature in your environment. First some background on prestaged media from Microsoft: Prestaged media is an … Read more
Installing ConfigMgr R3 and Overview of New Features Source:- https://myitforum.com/cs2/blogs/cnackers/archive/2010/06/16/installing-configmgr-r3-and-overview-of-new-features.aspx This blog will cover the installation of ConfigMgr R3 into your lab environment as well as provide some additional information in regards to R3. R3 is still in beta, so I would not recommend you install it in production. I’ve actually been working with a … Read more
SELECT TOP (100) PERCENT dbo.v_Collection.Name, dbo.v_Collection.CollectionID, dbo.v_CollectionRuleQuery.RuleName, dbo.v_CollectionRuleQuery.QueryID, dbo.v_CollectionRuleQuery.LimitToCollectionID, dbo.v_CollectionRuleQuery.QueryExpressionFROM dbo.v_Collection INNER JOIN dbo.v_CollectionRuleQuery ON dbo.v_Collection.CollectionID = dbo.v_CollectionRuleQuery.CollectionIDORDER BY dbo.v_Collection.Name, dbo.v_Collection.CollectionID
SMS/SCCM Peer2Peer AddOn SMSTorrent is a Peer2Peer AddOn for SMS2003/SCCM2007 Clients. SMS/SCCM Clients are able to share the local Package cache with other Clients using the BitTorrent filesharing protocol.https://sourceforge.net/projects/smstorrentSMS Site Settings tweak SMSSettings provides a GUI to modify SMS2003 (Microsoft System Management Server 2003) Site Settings which are not accessible over the normal SMS Admin … Read more
To delete a class You can delete a class in the current namespace with Delete Class on the Windows Management Instrumentation Tester dialog box. Open the Windows Management Instrumentation Tester dialog box. In the Windows Management Instrumentation (WMI) Tester dialog box, click Connect. In the Namespace box, type the path to the namespace that you … Read more