OPSI DokuWiki

User Tools

Site Tools

Trace:
userspace:opsi2ad

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
userspace:opsi2ad [2014/02/10 14:33] – dkochuserspace:opsi2ad [2021/08/23 10:37] (current) – external edit 127.0.0.1
Line 4: Line 4:
  
   - 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 DATABASE-HOST DATABASEUSER PASSWORD DATABASE (near mysql.exe) and YOUR-DOMAIN-SUFFIX (near For-Each) to fit for your setup+  - Replace >DATABASE-HOST< >DATABASEUSER< >PASSWORD< >DATABASE< (near mysql.exe) and >YOUR-DOMAIN-SUFFIX< (near ForEach) to fit for your setup
   - Make sure your MySQL server listens ( bind-address in my.cnf )    - Make sure your MySQL server listens ( bind-address in my.cnf ) 
   - Execute this script as Domain-Administrator on an DC   - Execute this script as Domain-Administrator on an DC
Line 10: Line 10:
  
  
 +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
Line 19: Line 19:
 chcp 850 chcp 850
 echo "SET NAMES 'cp850' ; select hostId, description from HOST" | ` echo "SET NAMES 'cp850' ; select hostId, description from HOST" | `
-./mysql.exe --default-character-set=utf8 -hDATABASE-HOST -uDATABASEUSER -pPASSWORD -DDATABASE > .output.sql+./mysql.exe --default-character-set=utf8 -h>DATABASE-HOST< -u>DATABASEUSER< -p>PASSWORD< -D>DATABASE< > .output.sql
    
 # Convert SQL output to valid CSV output # Convert SQL output to valid CSV output
Line 30: Line 30:
 Import-Csv ./.output.csv -encoding utf8 -Delimiter ";"  |` Import-Csv ./.output.csv -encoding utf8 -Delimiter ";"  |`
     ForEach-Object {     ForEach-Object {
-        $hostId += $_.hostId.ToUpper().Replace(".YOUR-DOMAIN-SUFFIX","")+        $hostId += $_.hostId.ToUpper().Replace(".>YOUR-DOMAIN-SUFFIX<","")
         $description += $_.description         $description += $_.description
  
Line 42: Line 42:
  $olddescription= $olddescription.Trim()  $olddescription= $olddescription.Trim()
   
- echo "$timestamp Updating $hostId with description: `"$description`" was `"$olddescription`"" >> opsi2ad.log+ echo "[$timestamp] Updating $hostId with description: `"$description`" was `"$olddescription`"" >> opsi2ad.log
  dsmod computer $hostou -desc "$description"  dsmod computer $hostou -desc "$description"
  
userspace/opsi2ad.1392039224.txt.gz · Last modified: (external edit)