{"id":520,"date":"2014-02-27T18:38:44","date_gmt":"2014-02-27T16:38:44","guid":{"rendered":"http:\/\/workplace.skyworker.de\/?p=520"},"modified":"2023-08-22T10:39:21","modified_gmt":"2023-08-22T08:39:21","slug":"powershell-auslesen-welche-software-sich-in-welcher-softwareklasse-befindet","status":"publish","type":"post","link":"http:\/\/workplace.skyworker.de\/?p=520","title":{"rendered":"Powershell: Auslesen welche Empirum Software sich in welcher Empirum Softwareklasse befindet"},"content":{"rendered":"
\r\n
\r\n \r\n <\/i>\r\n <\/a>\r\n 0 <\/span>\r\n<\/div>
\r\n \r\n <\/i>\r\n <\/a>\r\n 0<\/span>\r\n<\/div><\/div>

F\u00fcr die, die in Empirum mit sehr vielen Softwareklassen arbeiten habe ich ein kleines PowerShell Skript geschrieben, \u00fcber das gepr\u00fcft werden kann, in welchen Softwareklassen sich eine Software befindet.<\/p>\n

\"ps_sc_001\"<\/a><\/p>\n

<\/p>\n

Um das Skript verwenden zu k\u00f6nnen, muss die Variable $global:cc_database_server<\/span><\/strong>\u00a0 mit dem Namen des Datenbankservers (Dantenbankservername\\Instanzname), sowie die Variable $global:cc_database_db<\/strong><\/span> mit dem Namen der Datenbank bef\u00fcllt werden.<\/p>\n

#-----Variablen-------------------------------------------------------------\r\n$global:cc_database_server = \"EmpirumServer\\SQLExpress<\/strong>\"\r\n$global:cc_database_db = \"EmpirumDB<\/strong>\"<\/pre>\n
Powershell Skript:\u00a0\u00a0 [ddownload id=522]<\/p>\n
[php]cls<\/p>\n
#—–Variablen————————————————————-
\n$global:cc_database_server = "empirumserver\\instanz"
\n$global:cc_database_db = "Empirum"
\n$global:cc_multi_output1 = ""
\n$global:cc_multi_output2 = ""
\n#—————————————————————————<\/p>\n
#—–Auslesen des Skriptpfades———————————————
\n$global:ScriptDir = Split-Path
\n$MyInvocation.MyCommand.Path \u2013Parent
\n#—————————————————————————<\/p>\n
#—-Datenbankzugriff \/ Auslesen der Pakete \/ Ablage in Datei—————
\nfunction execute-sql-multi-output1 {
\nparam (
\n[string]$dbserver,
\n[string]$db,
\n[string]$SQLCommand
\n)<\/p>\n
#Connection to SQL-Server \u00a0$SqlConnection = New-Object System.Data.SqlClient.SqlConnection \u00a0$SqlConnection.ConnectionString = "Server = $dbserver; Database = $db; Integrated Security = True"<\/p>\n
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
\n$SqlCmd.CommandText = $SQLCommand
\n$SqlCmd.Connection = $SqlConnection<\/p>\n
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter $SqlAdapter.SelectCommand = $SqlCmd<\/p>\n
$global:cc_multi_output1 = New-Object System.Data.DataSet \u00a0$SqlAdapter.Fill($global:cc_multi_output1) \u00a0$SqlConnection.Close() \u00a0 }<\/p>\n
$cc_output_count = execute-sql-multi-output1 "$global:cc_database_server" "$global:cc_database_db" "SELECT * FROM Classes"
\n$global:cc_ClassesInfo = $global:cc_multi_output1 \u00a0 $global:cc_multi_output1 = ""<\/p>\n
$cc_output_count = execute-sql-multi-output1 "$global:cc_database_server" "$global:cc_database_db" "SELECT * FROM ClassesToSoftware"
\n$global:cc_ClassesToSoftware = $global:cc_multi_output1 \u00a0 $global:cc_multi_output1 = ""<\/p>\n
$cc_output_count = execute-sql-multi-output1 "$global:cc_database_server" "$global:cc_database_db" "SELECT * FROM Software"
\n$global:cc_Software = $global:cc_multi_output1 \u00a0 $global:cc_multi_output1 = ""<\/p>\n
#—————————————————————————<\/p>\n
function fu_search () {
\n$Global:SelectedSoftware = $objComboBox.SelectedItem.ToString()
\n$Global:ClassesIDArray = @()
\n$Global:ClassesNameArray = @()
\n$global:output = ""<\/p>\n
$h=0
\nforeach ($entry in $global:cc_Software.Tables[0]){
\n$cc_Software_SoftwareID = $global:cc_Software.Tables[0].Rows[$h][0]
\n$cc_Software_SoftwareName = $global:cc_Software.Tables[0].Rows[$h][3]
\nIf ($cc_Software_SoftwareName -eq $Global:SelectedSoftware){
\nbreak
\n}
\n$h++
\n}<\/p>\n
$h=0
\nforeach ($entry in $global:cc_ClassesToSoftware.Tables[0]){
\n$cc_ClassesToSoftware_ClassesID = $global:cc_ClassesToSoftware.Tables[0].Rows[$h][0]
\n$cc_ClassesToSoftware_SoftwareID = $global:cc_ClassesToSoftware.Tables[0].Rows[$h][1]
\nIf ($cc_ClassesToSoftware_SoftwareID -eq $cc_Software_SoftwareID){
\n$Global:ClassesIDArray += $cc_ClassesToSoftware_ClassesID
\n}
\n$h++
\n}<\/p>\n
$h=0
\nforeach ($entry in $global:cc_ClassesInfo.Tables[0]){
\n$cc_Classes_ClassesID = $global:cc_ClassesInfo.Tables[0].Rows[$h][0]
\n$cc_Classes_Name = $global:cc_ClassesInfo.Tables[0].Rows[$h][2]
\nforeach ($value in $Global:ClassesIDArray){
\nIf ($value -eq $cc_Classes_ClassesID){
\n$Global:ClassesNameArray += $cc_Classes_Name
\n}
\n}
\n$h++
\n}<\/p>\n
foreach ($entry in $Global:ClassesNameArray){
\n$global:output = $global:output + $entry + "`r`n"
\n}<\/p>\n
If ($global:output) {$objTextBox1.Text = "$global:output"}
\nElse {$objTextBox1.Text = "Keine Zuweisung"}<\/p>\n
$objForm.Update()<\/p>\n
}<\/p>\n
#—————————————————————————<\/p>\n
#—–GUI——————————————————————- \u00a0 [void] [System.Reflection.Assembly]::LoadWithPartialName("System.Drawing") \u00a0 [void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")<\/p>\n
$objForm = New-Object System.Windows.Forms.Form \u00a0 $objForm.Text = "Matrix42 Empirum Software Classes" \u00a0 $objForm.Size = New-Object System.Drawing.Size(600,240) \u00a0 $objForm.StartPosition = "CenterScreen" \u00a0 $objForm.autoscroll = $false \u00a0 $objForm.FormBorderStyle = 3<\/p>\n
$objForm.KeyPreview = $True \u00a0 $objForm.Add_KeyDown({if ($_.KeyCode -eq "Enter"){fu_search}}) \u00a0 $objForm.Add_KeyDown({if ($_.KeyCode -eq "Escape"){$objForm.Close()}})<\/p>\n
$objLabel = New-Object System.Windows.Forms.Label
\n$objLabel.Location = New-Object System.Drawing.Size(10,32)
\n$objLabel.Size = New-Object System.Drawing.Size(120,20)
\n$objLabel.Font = new-object System.Drawing.Font("Arial",11,[Drawing.FontStyle]’regular‘ ) \u00a0 $objLabel.Text = "Softwarename"
\n$objForm.Controls.Add($objLabel)<\/p>\n
$objComboBox = new-object System.Windows.Forms.ComboBox
\n$objComboBox.Location = new-object System.Drawing.Size(130,32)
\n$objComboBox.Size = new-object System.Drawing.Size(420,20)
\n$objComboBox.Font = new-object System.Drawing.Font("Arial",9 )
\n$j=0
\nforeach ($entry in $global:cc_Software.Tables[0]){
\n$cc_Software_SoftwareName = $global:cc_Software.Tables[0].Rows[$j][3]
\n$objComboBox.Items.Add($cc_Software_SoftwareName) \u00a0$j++ \u00a0 }
\n$objComboBox.Sorted = $true
\n$objForm.Controls.Add($objComboBox)<\/p>\n
$SearchButton = New-Object System.Windows.Forms.Button
\n$SearchButton.Location = New-Object System.Drawing.Size(260,60)
\n$SearchButton.Size = New-Object System.Drawing.Size(80,23)
\n$SearchButton.Font = new-object System.Drawing.Font("Arial",10,[Drawing.FontStyle]’bold‘ ) \u00a0 $SearchButton.Text = "Suchen…"
\n$SearchButton.Add_Click({fu_search})
\n$objForm.Controls.Add($SearchButton)<\/p>\n
$objTextBox1 = New-Object System.Windows.Forms.TextBox
\n$objTextBox1.Location = New-Object System.Drawing.Size(10,100)
\n$objTextBox1.Size = New-Object System.Drawing.Size(450,100)
\n$objTextBox1.Multiline = $true
\n$objTextBox1.ScrollBars = "Vertical"
\n$objTextBox1.Text = ""
\n$objForm.Controls.Add($objTextBox1)<\/p>\n
$CancelButton = New-Object System.Windows.Forms.Button
\n$CancelButton.Location = New-Object System.Drawing.Size(500,177)
\n$CancelButton.Size = New-Object System.Drawing.Size(80,23)
\n$CancelButton.Font = new-object System.Drawing.Font("Arial",10,[Drawing.FontStyle]’bold‘ ) \u00a0 $CancelButton.Text = "Close"
\n$CancelButton.Add_Click({$objForm.Close()})
\n$objForm.Controls.Add($CancelButton)<\/p>\n
$objForm.Topmost = $True<\/p>\n
$objForm.Add_Shown({$objForm.Activate()})
\n[void] $objForm.ShowDialog()
\n#—————————————————————————[\/php]<\/p>\n
\n","protected":false},"excerpt":{"rendered":"
0 0 F\u00fcr die, die in Empirum mit sehr vielen Softwareklassen arbeiten habe ich ein kleines PowerShell Skript geschrieben, \u00fcber das gepr\u00fcft werden kann, in welchen Softwareklassen sich eine Software befindet.<\/p>\n","protected":false},"author":1,"featured_media":1829,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,11,3,38],"tags":[128,9],"_links":{"self":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/520"}],"collection":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=520"}],"version-history":[{"count":9,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/520\/revisions"}],"predecessor-version":[{"id":1835,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/520\/revisions\/1835"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/media\/1829"}],"wp:attachment":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=520"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}