To install any IBM Lenovo drivers for Bad Drivers and softDrivers We need to download the Lenovo ThinInstaller and add the required model and download the Drivers. and set in the configuration all the drivers should set to active otherwise it gets failed Now create a package in SCCM for Think Installer and include a … Read more
To install the multiple software’s(Packages) based on the AD group Name. We need to have A VB script and one Database .DAT file Create a package with the Vbscript & APP.Dat files. and the Program command line is “wscript AppAutomationv0.1.2.7.vbs” Below is the VBScript: save as AppAutomationv0.1.2.7.vbs ‘Application Automation Version 1.0.1‘AppSetup will be the base … Read more
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
