Prerequisites configured before starting the installation: Windows Server 2008 R2 updated Active Directory Domain Services Installing Central Administration Site (CAS): Installing Primary Site:
Distribute Adobe Flash Player
If you need to create a ConfigMgr software package with Adobe Flash Player and want to use it’s .msi file, you can find this file at the following address: http://www.adobe.com/products/flashplayer/fp_distribution3.html Please note that in order to distribute Adobe Flash Player you need to have a valid Adobe Flash Player Distribution License Agreement in place. For … Continue reading Distribute Adobe Flash Player
Report with computer models and manufacturers
SELECT TOP (100) PERCENT Manufacturer0 AS Manufacturer, Model0 AS Model, COUNT(Model0) AS Total FROM dbo.v_GS_COMPUTER_SYSTEM GROUP BY Model0, Manufacturer0 ORDER BY Total DESC, Manufacturer, Model
Collection with client Computers without ConfigMgr client
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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.Client = 0 and SMS_G_System_OPERATING_SYSTEM.Caption not like "%Server%" or SMS_R_System.Client is null and SMS_G_System_OPERATING_SYSTEM.Caption not like "%Server%"
Deploy Office 2007 SP2 with ConfigMgr 2007
As Microsoft recently released Service Pack 2 for Office 2007 suite, it is a good idea to add the update files to the package so it can be installed during the installation. So, first of all we have to download the SP2 executable file from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=b444bf18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en (see Visio and Project information at the end … Continue reading Deploy Office 2007 SP2 with ConfigMgr 2007
Collection based on computer model
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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "%HP ProBook 4710s%"
Add TCP/IP printer – Access Denied
Yesterday I was trying to install a network printer on Windows Server 2008 system. After typing printer’s IP address, I received an “Access denied” error. The problem was that I tried to install the printer while I was logged on with a user that had domain admin privileges, but not the default domain Administrator account. … Continue reading Add TCP/IP printer – Access Denied
Find computer model and manufacturer using remote WMI
In case you need to find the computer model and manufacturer of a remote computer, just use the following command in a command prompt window: %windir%\System32\wbem\WMIC.exe /node:"ComputerNameORIpAddress" ComputerSystem Get Model, Manufacturer If you need to specify user credentials, use the following command: %windir%\System32\wbem\WMIC.exe /node:"ComputerNameORIpAddress" /user:"domain\username" /password:"password" ComputerSystem Get Model, Manufacturer
Upgrade Configuration Manager client
Recently I reinstalled ConfigMgr server in my company and was looking for an easy method to upgrade all Configuration Manager clients to 4.00.6487.2000 version. Put some notes on the table and finally made the following plan: Create a report that counts all client versions. (This is optional, just for informational purposes). Report query is:SELECT TOP … Continue reading Upgrade Configuration Manager client
Problem installing WSUS on a remote SQL server.
Today I again learned a lesson I knew for some time but was hoping that I can forget it. The lesson was about: “Trust anyone. Test for yourself.” Having to install WSUS on a remote SQL 2005 that had WSUS database installed before, I asked one SQL guy if renaming the old WSUS database is … Continue reading Problem installing WSUS on a remote SQL server.