userspace:opsi2ad
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
userspace:opsi2ad [2014/02/10 11:15] dkoch |
userspace:opsi2ad [2014/02/12 14:26] dkoch |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| --- // | --- // | ||
| This script synchronizes the client descriptions from OPSI to the AD. | This script synchronizes the client descriptions from OPSI to the AD. | ||
| - | You will have to store a mysql.exe binary in the same directory as the script. | ||
| + | - You will have to store a mysql.exe binary in the same directory as the script. | ||
| + | - Replace > | ||
| + | - Make sure your MySQL server listens ( bind-address in my.cnf ) | ||
| + | - Execute this script as Domain-Administrator on an DC | ||
| + | |||
| + | |||
| + | This Script requires Powershell 3 | ||
| <code powershell> | <code powershell> | ||
| # This script synchronizes the client descriptions from OPSI to the AD | # This script synchronizes the client descriptions from OPSI to the AD | ||
| + | $timestamp=Get-Date -format u | ||
| # Connect to the MYSQL of OPSI and crete a csv with $hostId and $description | # Connect to the MYSQL of OPSI and crete a csv with $hostId and $description | ||
| echo " | echo " | ||
| chcp 850 | chcp 850 | ||
| echo "SET NAMES ' | echo "SET NAMES ' | ||
| - | ./mysql.exe --default-character-set=utf8 -hDATABASE-HOST -uDATABASEUSER | + | ./mysql.exe --default-character-set=utf8 -h> |
| # Convert SQL output to valid CSV output | # Convert SQL output to valid CSV output | ||
| Line 23: | Line 30: | ||
| Import-Csv ./ | Import-Csv ./ | ||
| ForEach-Object { | ForEach-Object { | ||
| - | $hostId += $_.hostId.ToUpper().Replace(" | + | $hostId += $_.hostId.ToUpper().Replace(" |
| $description += $_.description | $description += $_.description | ||
| Line 35: | Line 42: | ||
| $olddescription= $olddescription.Trim() | $olddescription= $olddescription.Trim() | ||
| - | echo " | + | echo "[$timestamp] |
| dsmod computer $hostou -desc " | dsmod computer $hostou -desc " | ||
userspace/opsi2ad.txt ยท Last modified: 2021/08/23 08:37 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
