Sep 13, 2010
System Center Configuration Manager 2007
Here is each individual one if you are interested in only a single one:
General - http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/threads/
Announcements - http://social.technet.microsoft.com/Forums/en-US/configmgrannouncements/threads/
Admin Console - http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/threads/
Asset Intelligence – http://social.technet.microsoft.com/Forums/en-US/configmgrai/threads/
Backup and Recovery – http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/threads/
Desired Configuration Management – http://social.technet.microsoft.com/Forums/en-US/configmgrdcm/threads/
Documentation – http://social.technet.microsoft.com/Forums/en-US/configmgrdocs/threads/
Internet Clients and Native Mode – http://social.technet.microsoft.com/Forums/en-US/configmgribcm/threads/
Inventory - http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/threads/
Operating System Deployment – http://social.technet.microsoft.com/Forums/en-US/configmgrosd/threads/
SDK – http://social.technet.microsoft.com/Forums/en-US/configmgrsdk/threads/
Setup/Deployment – http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/threads/
Software Distribution – http://social.technet.microsoft.com/Forums/en-US/configmgrswdist/threads/
Software Updates Management – http://social.technet.microsoft.com/Forums/en-US/configmgrsum/threads/
Sep 6, 2010
Operations Manager 2007 – Knowledge Base
Перенос базы данных SCCM 2007 на другой сервер
База находилась на сервере SCCM. Возникла потребность вынести её на другой сервер.
Делаем резервную копию базы SCCM:
Делаем резервную копию базы SCCM:
На другом сервере устанавливаем SQL Server, копируем на локальный диск файл с резервной копией и восстанавливаем базу:
На сервере SCCM запускаем preinst /stopsite для остановки всех служб сайта:
Далее запускаем ConfigMgr Setup:
Отмечаем чекбокс:
Вписываем имя нового сервера с базой данных SCCM:
Перезагружаем сервер SCCM. Готово!
Sep 3, 2010
Export SCOM agents to Excel
A common questions in the forums is “how to export a list of all agents to Excel?” You can do that with Operations Manager shell. The Operations Manager command shell is built on Windows PowerShell. The Operations Manager command shell extends the Windows command shell with over 80 additional small utility programs, called cmdlets, which can either be run directly from the command shell prompt or called from within a batch file or script. To export a list of all agents and some info about them run the following command....
get-agent | select Displayname,InstallTime,InstalledBy,Version | export-csv -notype c:\agents.csv
That will give you a CSV file, C:\agents.csv. Open the file with Excel, select all the data, click the “text to columns” button and choose comma delimeter. That will convert your data into nice columns.

…and there you have your list in Excel with nice columns
get-agent | select Displayname,InstallTime,InstalledBy,Version | export-csv -notype c:\agents.csv
That will give you a CSV file, C:\agents.csv. Open the file with Excel, select all the data, click the “text to columns” button and choose comma delimeter. That will convert your data into nice columns.
…and there you have your list in Excel with nice columns
Aug 9, 2010
How to manually uninstall WSUS
Sometimes it may happen that in wanting to remove the installation of WSUS we throw an error and does not end up removing part of it. La idea es comentar los pasos necesarios para remover dicha instalación manualmente. The idea is to discuss the steps necessary to remove the installation manually. Qué se puede borrar, qué hay que modificar, qué hay que ejecutar, etc. What can delete, what to modify, what to run, etc.
Algunos pasos estan basados en KB's de Microsoft que también linkeo en el mismo artículo. Some steps are based on KB's from Microsoft that also'm just linking to the article. Luego de removerlo podrás instalarlo en el equipo nuevamente como si nunca hubiera estado instalado. After removing it you can install on your computer again as if it had never been installed.
1. 1. En principio debemos parar todos los servicios de WSUS asociados. In principle we should stop all WSUS related services. Tanto de Update Services, como de la base de datos en caso de ser local y los de IIS para poder hacer una desinstalación completa y que no falle ningún archivo. Both of Update Services, and the database should be local and IIS to do a complete uninstall and you do not miss any.
2. 2. En caso de ser un equipo dedicado a WSUS habría que eliminar la base de datos. In the case of a team dedicated to WSUS should be eliminated database. Si se instaló con SQL Server 2005 no hace falta desinstalarlo, sólo remover la base, pero si se utilizó Windows Internal Database habría que removerla para que no arroje errores al reinstalarlo. If SQL Server 2005 installed with no need to uninstall, just remove the base, but if Windows Internal Database was used to remove it would have to not throw errors when reinstalling.
3. 3. Ahora procedemos a eliminar el directorio de instalación, generalmente en %ProgramFiles%\Update Services . Now proceed to remove the installation directory, typically in% ProgramFiles% \ Update Services. Borramos esa carpeta y todas las subcarpetas. Delete that folder and all subfolders.
4. 4. Eliminamos la entrada en el registro correspondiente a la instalación del producto: Remove the registry entry for product installation:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Update Services
5. 5. Ahora eliminamos el resto de las entradas del registro que corresponden a los servicios de WSUS: Now remove the remaining registry entries that correspond to the WSUS service:
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: API Remoting Web Service HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: API Remoting Web Service
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Client Web Service HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Client Web Service
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Client Web Service Methods HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Client Web Service Methods
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Reporting Web Service HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Reporting Web Service
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Server Web Methods HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Server Web Methods
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Server Web Service HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Server Web Service
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Update Regulation Web Methods HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Update Regulation Web Methods
HKLM\SYSTEM\CurrentControlSet\Services\WSusCertServer HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSusCertServer
HKLM\SYSTEM\CurrentControlSet\Services\WsusService HKLM \ SYSTEM \ CurrentControlSet \ Services \ WsusService
6. 6. Como siguiente paso debemos eliminar los archivos de instalación MSI del producto. As a next step we delete the files from MSI installation of the product. Para esto vamos a utilizar una herramienta de Microsoft llamada Windows Installer CleanUp Utility . For this we will use a Microsoft tool called Windows Installer CleanUp Utility. La utilidad se encuentra en el KB290301 » de Microsoft. The utility is located in the KB290301 " from Microsoft. Ahí figura como bajarla y ejecutarla. There appears as lower it and run. Sólo debemos seleccionar los paquetes correspondientes a WSUS y removerlos. We just need to select packages and remove them for WSUS.
7. 7. Si el equipo no tiene otro sitio web instalado, entonces te recomiendo remover el servicio de IIS del servidor utilizando Add/Remove Programs o bien Roles del 2008. If the computer does not have another website up, then I recommend removing the IIS service on the server using Add / Remove Programs or Roles, 2008. En caso de que existan otros sitios sólo podes eliminar el de WSUS junto a su Application Pool correspondiente. If there are other places you can only delete the WSUS Application Pool with his question. En caso de que compartan el sitio pero con otros directorios virtuales, podes eliminar los siguientes que sí estan relacionados con WSUS: If the site but share with other virtual directories, you can delete the following if they are related to WSUS:
9. 9. Ahora reiniciá el servidor y ya quedaría limpio para reinstalar. Now restart the server and that would clean reinstall.
10. 10. Recordá que si eliminaste el IIS y querés reinstalar tenes que volver a agregarlo con los componentes básicos como requisito de instalación. Remember that if you delete the IIS and you want to reinstall you have to re-add with the basic components and installation requirements.
Algunos pasos estan basados en KB's de Microsoft que también linkeo en el mismo artículo. Some steps are based on KB's from Microsoft that also'm just linking to the article. Luego de removerlo podrás instalarlo en el equipo nuevamente como si nunca hubiera estado instalado. After removing it you can install on your computer again as if it had never been installed.
1. 1. En principio debemos parar todos los servicios de WSUS asociados. In principle we should stop all WSUS related services. Tanto de Update Services, como de la base de datos en caso de ser local y los de IIS para poder hacer una desinstalación completa y que no falle ningún archivo. Both of Update Services, and the database should be local and IIS to do a complete uninstall and you do not miss any.
2. 2. En caso de ser un equipo dedicado a WSUS habría que eliminar la base de datos. In the case of a team dedicated to WSUS should be eliminated database. Si se instaló con SQL Server 2005 no hace falta desinstalarlo, sólo remover la base, pero si se utilizó Windows Internal Database habría que removerla para que no arroje errores al reinstalarlo. If SQL Server 2005 installed with no need to uninstall, just remove the base, but if Windows Internal Database was used to remove it would have to not throw errors when reinstalling.
- Abrir una ventana de comandos ( cmd.exe ) Open a command window (cmd.exe)
- Ejecutar uno de los siguientes comandos: Run one of the following commands:
En plataforma 32-bit: msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe In 32-bit platform: msiexec / x (CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB) callerid = ocsetup.exe
En plataforma 64bit: msiexec /x {BDD79957-5801-4A2D-B09E-852E7FA64D01} callerid=ocsetup.exe 64bit platform: msiexec / x (BDD79957-5801-4A2D-B09E-852E7FA64D01) callerid = ocsetup.exe - Eliminar las bases que se encuentren debajo de la carpeta %windir%\SYSMSI\SSEE Remove the bases that are under the folder% windir% \ SYSMSI \ SSEE
3. 3. Ahora procedemos a eliminar el directorio de instalación, generalmente en %ProgramFiles%\Update Services . Now proceed to remove the installation directory, typically in% ProgramFiles% \ Update Services. Borramos esa carpeta y todas las subcarpetas. Delete that folder and all subfolders.
4. 4. Eliminamos la entrada en el registro correspondiente a la instalación del producto: Remove the registry entry for product installation:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Update Services
5. 5. Ahora eliminamos el resto de las entradas del registro que corresponden a los servicios de WSUS: Now remove the remaining registry entries that correspond to the WSUS service:
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: API Remoting Web Service HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: API Remoting Web Service
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Client Web Service HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Client Web Service
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Client Web Service Methods HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Client Web Service Methods
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Reporting Web Service HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Reporting Web Service
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Server Web Methods HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Server Web Methods
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Server Web Service HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Server Web Service
HKLM\SYSTEM\CurrentControlSet\Services\WSUS: Update Regulation Web Methods HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSUS: Update Regulation Web Methods
HKLM\SYSTEM\CurrentControlSet\Services\WSusCertServer HKLM \ SYSTEM \ CurrentControlSet \ Services \ WSusCertServer
HKLM\SYSTEM\CurrentControlSet\Services\WsusService HKLM \ SYSTEM \ CurrentControlSet \ Services \ WsusService
6. 6. Como siguiente paso debemos eliminar los archivos de instalación MSI del producto. As a next step we delete the files from MSI installation of the product. Para esto vamos a utilizar una herramienta de Microsoft llamada Windows Installer CleanUp Utility . For this we will use a Microsoft tool called Windows Installer CleanUp Utility. La utilidad se encuentra en el KB290301 » de Microsoft. The utility is located in the KB290301 " from Microsoft. Ahí figura como bajarla y ejecutarla. There appears as lower it and run. Sólo debemos seleccionar los paquetes correspondientes a WSUS y removerlos. We just need to select packages and remove them for WSUS.
7. 7. Si el equipo no tiene otro sitio web instalado, entonces te recomiendo remover el servicio de IIS del servidor utilizando Add/Remove Programs o bien Roles del 2008. If the computer does not have another website up, then I recommend removing the IIS service on the server using Add / Remove Programs or Roles, 2008. En caso de que existan otros sitios sólo podes eliminar el de WSUS junto a su Application Pool correspondiente. If there are other places you can only delete the WSUS Application Pool with his question. En caso de que compartan el sitio pero con otros directorios virtuales, podes eliminar los siguientes que sí estan relacionados con WSUS: If the site but share with other virtual directories, you can delete the following if they are related to WSUS:
- Inventory Inventory
- DSSAuthWebService DSSAuthWebService
- ApiRemoting30 ApiRemoting30
- Content Content
- ReportingWebService ReportingWebService
- SelfUpdate SelfUpdate
- ServerSyncWebService ServerSyncWebService
- SimpleAuthWebService SimpleAuthWebService
- ClientWebService ClientWebService
9. 9. Ahora reiniciá el servidor y ya quedaría limpio para reinstalar. Now restart the server and that would clean reinstall.
10. 10. Recordá que si eliminaste el IIS y querés reinstalar tenes que volver a agregarlo con los componentes básicos como requisito de instalación. Remember that if you delete the IIS and you want to reinstall you have to re-add with the basic components and installation requirements.
Aug 3, 2010
Получение залогиненных пользователей на ПК
Была когда-то давно задача вытащить всех пользователей с привязкой по ПК. Решено было с помощью любимого PoSh. Выложить данный скрипт натолкнул недавний вопрос на форуме TechNet.
После выгрузки мы имеем CSV файл, что с ним делать? Я лично импортирую его в Excel, c разделителем по запятой. Делается это примерно так:
cls
#Создаем фильтр проверки наличия компа в сети
Filter Where-Online
{
$ping = new-object System.Net.NetworkInformation.Ping
trap {Write-Verbose "ping error"; Continue}
if ($ping.send($_).Status -eq "Success" ) { $_ }
}
$Comp_list=@{}
#Получаем компы из нужной OU в AD
$comp_arr= Get-QADComputer -SearchRoot "ou=test, ou=workstations,dc=moscow,dc=domain,dc=ru" | foreach {$_.dnsname} | where-online
#загоняем в цикл
foreach ($pc in $comp_arr)
{
#Запрос к WMI даленного компа
$CS = Gwmi Win32_ComputerSystem -Comp $pc
"Machine Name: " + $CS.Name
"Logged On User: " + $CS.UserName
#add new object
$Comp_list[$CS.Name] = new-object System.Management.Automation.PSObject
$Comp_list[$CS.Name] | add-member noteproperty CompName $CS.Name
$Comp_list[$CS.Name] | add-member noteproperty User $CS.UserName
После выгрузки мы имеем CSV файл, что с ним делать? Я лично импортирую его в Excel, c разделителем по запятой. Делается это примерно так:
Subscribe to:
Posts (Atom)













