Collection of computers that don't have software adobe flash player 15 plugin

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.Name not in (select distinct SMS_G_System_COMPUTER_SYSTEM.Name  from SMS_R_System  inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId  inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId  where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Adobe Flash Player 15 Plugin%")

Query to get machines with specific exe (7zFM.exe)

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_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "7zFM.exe"

All Fujitsu ESPRIMO P9900 Client Machines

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.Manufacturer like "fujitsu%" and SMS_G_System_COMPUTER_SYSTEM.Model like "ESPRIMO P9900"

Collection Query: Computers by Model HP 3400 Pro MT 8GB

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 inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_PROCESSOR on SMS_G_System_PROCESSOR.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model = "HP Pro 3400 Series MT" and SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory in (8024304,8024368,8027504,8040752,8078252,8090728,8171976,8171980,8189536,8189908,8190016,8201632,8205512,8205516,8206112,8206124,8206616,8208868,8208876,8215920,8233552,8248200,8248208,8257960,8259612,8267656,8268140,8271052,8271336,8272736,8273448,8279796,8281904,8283444,8290672,8291140,8298032,8302412,8302448,8303036,8317616,8321120,8322232,8325808,8331744,8342992,8344472,8346028,8363760,8367744,8367748,8367748,8368448,8368460,8368964,8368980,8369392,8369456,8378068,8379448,8379852) and SMS_G_System_PROCESSOR.Name in ("Intel(R) Core(TM) i5-2500 CPU @ 3.30GHz","Intel(R) Core(TM) i5-2500S CPU @ 2.70GHz")

Ошибка 0x80041001 0x800706a6 на клиенте sccm 2012

Необходимо запустить службу терминалов



http://support.microsoft.com/kb/2713471

SCCM Client Installation Error 80041001 windows 7 and windows xp

Configuration Manager Client -- Ошибка 25100. Setup was unable to create the WMI namespace CCM\LocationServices The error code is 80041002 

Останавливаем службу Инструментарий управления (WMI)
Переименовываем папку  Windows\System32\Wbem\Repository в ”OldRepository”
Запускаем службу Инструментарий управления (WMI)
Запускаем повторно установку клиента Sccm 2012
Проверяем создание папки  Windows \System32\Wbem\Repository

http://gallery.technet.microsoft.com/WMI-Namespace-Errors-In-5cd5df28
http://blogs.catapultsystems.com/javery/archive/2009/07/01/sccm-client-installation-error-80041001.aspx

Как создать свой отчет в SCCM 2012 sp1

Запускаем консоль идем в Monitoring>reports

Далее жмем правой кнопкой на reports >Create  Reports

далее выбираем sql-based reports
В поле name вписываем название отчета
В поле description описание
Поле server не меняем
Path выбираем папку где будет хранится отчет.

После нажатия кнопки finish открывается Report Builder

Жмем на кнопку Table or Matrix

Подключаемся к БД.

Жмем на Edit as text вводим текст sql запроса, например
SELECT dbo.v_R_System.ResourceID,dbo.v_R_System.ResourceType,dbo.v_R_System.Name0,dbo.v_R_System.Resource_Domain_OR_Workgr0,dbo.v_R_System.SMS_Unique_Identifier0,dbo.v_R_System.Client0,dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0
FROM dbo.v_R_System
INNER JOIN dbo.v_GS_SYSTEM_ENCLOSURE ON dbo.v_R_System.ResourceID = dbo.v_GS_SYSTEM_ENCLOSURE.ResourceID
WHERE (dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = N’3′′)

Жмем на !  проверяем работу запроса

перетаскиваем мышкой поля Available fields в поле values или в Row Group(Выбираем значение данных)

Отчет открывается в   report builder настраиваем дизайн отчета и нажимаем сохранить

Link

Полезные Reports

The Report Builder click-once application does not exist on the report server Sccm 2012 sp1

Идем в папку Program Files (x86)\Microsoft Configuration Manager\AdminConsole\bin\
Открываем с помощью блокнота файл Microsoft.ConfigurationManagement.exe.config
Находим секцию 

Меняем значения 
add key=”10.0″ value=”ReportBuilder_2_0_0_0.application”
add key=”DEFAULT” value=”ReportBuilder_2_0_0_0.application”
на
add key=”10.0″ value=”ReportBuilder_3_0_0_0.application”
add key=”DEFAULT” value=”ReportBuilder_3_0_0_0.application”

Link

Либо в версии Sccm 2012  меняем ключ реестра
 ( ReportBuilderApplicationManifestName
HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/Microsoft/ConfigMgr10/AdminUI/Reporting.

Меняем ReportBuilder_2_0_0_0.application to ReportBuilder_3_0_0_0.application  OK.

Link

Как снять ограничение в коллекции sccm 2012 (maximum result value)

link

1. win+R
2. regedit
3. Разворачиваем ветку HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ConfigMgr10\AdminUI\QueryProcessors
4. добавляем значение dword "Valuelimit" и вбиваем в него 10000, максимально можно вбить 20000

Останавливаем службы SMS_EXECUTIVE и SMS_SITE_COMPONENT_MANAGER

Потом запускаем в том же порядке.

query sccm 2012

http://myitforum.com/cs2/blogs/gjones/archive/tags/WQL/default.aspx

query sccm 2012 version ultimate windows7 x64

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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC" and SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows 7 Ultimate" or SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 7 Максимальная"

Запрос в sccm выводит все ноутбуки

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_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId where

SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ( "8", "9", "10", "14" )

Описание значений
1 Other
2 Unknown
3 Desktop
4 Low Profile Desktop
5 Pizza Box
6 Mini Tower
7 Tower
8 Portable
9 Laptop
10 Notebook
11 Hand Held
12 Docking Station
13 All in One
14 Sub Notebook
15 Space-Saving
16 Lunch Box
17 Main System Chassis
18 Expansion Chassis
19 Sub Chassis
20 Bus Expansion Chassis
21 Peripheral Chassis
22 Storage Chassis
23 Rack Mount Chassis
24 Sealed-Case PC 

source

Поиск ключей удаления программ

http://www.itninja.com/blog/view/how-to-find-uninstall-strings
Скачать

http://finduninstallstring.codeplex.com/

 Скачать

Полезное дополнение для ConfigMgr 2012 Powershell Right Click Tools

http://psrightclicktools.codeplex.com/

sccm2012 PXE-E32: TFTP open timeout

1. Удаляем wds (Wireless Distribution System) сервис.
2. Удаляем  DP (distribution point)
3. Восстанавливаем обратно DP, - wds установится автоматически.


source

Удаление приложений в SCCM 2012

Have you tried to delete an application in SCCM 2012? It isn't so intuitive as in SCCM 2007.

First Retire the Application. Select it and click on Retire.

Now click on the Deployments tab, right click the deployment and click on delete.

Now right click the application and click on Revision History.

Now delete all revisions, starting with the first.

After all the revisions are deleted, the application will be gone.

 My next post will be about User Device Affinity.

http://fbinotto.blogspot.ru/2011/09/deleting-applications-in-sccm-2012.html