SELECT dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 AS Manufacturer, dbo.v_GS_COMPUTER_SYSTEM.Model0 AS Model, COUNT(dbo.v_GS_COMPUTER_SYSTEM.Model0) AS Total FROM dbo.v_GS_COMPUTER_SYSTEM INNER JOIN dbo.v_FullCollectionMembership ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_FullCollectionMembership.ResourceID GROUP BY dbo.v_GS_COMPUTER_SYSTEM.Model0, dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0, dbo.v_FullCollectionMembership.CollectionID HAVING (dbo.v_FullCollectionMembership.CollectionID = 'CollectionID’) ORDER BY Total DESC, Manufacturer, Model
Prerequisites configured before starting the installation: Windows Server 2008 R2 updated Active Directory Domain Services Installing Central Administration Site (CAS): Installing Primary Site:
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
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
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%"
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%"
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
Depending on what you need the .wim file for, you can create it manually or automatically. - To manually create a .wim file (capture image) you need a bootable CD with Windows PE (with ImageX.exe included) that you can create using Windows Automated Installation Kit. The basics steps are: Boot your computer using Windows PE … Continue reading How to create a Windows Image (.wim) file
Besides using Software Distribution to install software, you can do this using a Task Sequence too. This can be done during and Operating System Deployment process or not. Usually, I install software during an OSD. For this, you must have a package for that software product (of course) and at least one program that runs … Continue reading Install software using Task Sequence
Last month, after restoring the only ConfigMgr site and importing new reports, I saw that none of the reports I’m using have a link to another report. To be sincere, this was a problem I didn’t know where to start troubleshooting. Thanks to guys from Microsoft’s ConfigMgr forum, who helped me identify the problem and … Continue reading All reports with links to other reports