{"id":147,"date":"2012-08-10T16:28:14","date_gmt":"2012-08-10T14:28:14","guid":{"rendered":"http:\/\/workplace.skyworker.de\/?p=147"},"modified":"2023-08-22T10:39:23","modified_gmt":"2023-08-22T08:39:23","slug":"auslesen-von-device-name-mac-adress-und-device-collection-aus-der-pvs-datenbank","status":"publish","type":"post","link":"http:\/\/workplace.skyworker.de\/?p=147","title":{"rendered":"Powershell: Auslesen von Device Name, MAC Adress und Device Collection aus der PVS Datenbank"},"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>
\n

Um bestehende End-Systeme aus einer Provisioning Server Umgebung auszulesen, damit man diese in Empirum importieren kann, kann das folgende PowerShell Skript verwendet.<\/p>\n

Dieses Skript liest den PC Namen, die Mac Adresse und die Device Collection eines jeden End-Systems aus und schreibt diese Kommagetrennt in eine Ausgabedatei. Bei der MAC Adresse werden zus\u00e4tzlich noch die Bindestriche herausgefiltert, um diese f\u00fcr den Import in Empirum verwenden zu k\u00f6nnen.<\/p>\n<\/div>\n

\n

\"bt-attention-icon\"<\/a> Hinweis<\/strong><\/span>: Das Skript sollte man direkt auf dem Provisioning Server ausf\u00fchren, da eine installierte Provisioning Server Console vorausgesetzt wird. Zus\u00e4tzlich muss die Powershell executionpolicy angepasst werden, damit das ausf\u00fchren von Skripten erlaubt wird.<\/p>\n<\/blockquote>\n

Um das Skript verwenden zu k\u00f6nnen, m\u00fcssen die folgenden 4 Variablen im Skript angepasst werden:<\/p>\n

$servernameConnection = „IP Address of the PVS Server<\/strong>“
\n$username = „Domain Account with PVS Admin rights<\/strong>“
\n$domainNetBiosName = „Domain Name<\/strong>“
\n$password = „PVS Admin Account Password<\/strong>„<\/p><\/blockquote>\n

Wenn das Skript ausgef\u00fchrt wird, wird im Skriptordner eine Ausgabedatei mit dem folgenden Ausgabeformat angelegt:<\/p>\n

PC0102,45012ABC494C,DC_Production,
\nPC0103,45012ABC4942,DC_Production,
\nPC0104,45012ABC6277,DC_Integration,
\nPC0001,45012ABC708A,DC_Installation,
\nPC0002,45012ABC70B0,DC_Test,<\/p><\/blockquote>\n

Powershell Skript:\u00a0\u00a0 [ddownload id=178]<\/p>\n

[php]#Variable##################################################################################
\n$servernameConnection = "IP Address of the PVS Server"
\n$username = "Domain Account with PVS Admin rights"
\n$domainNetBiosName = "Domain Name"
\n$password = "PVS Admin Account Password"
\n###########################################################################################<\/p>\n

#Register the PowerShell Snap-In
\n$installutil = $env:systemroot + ‚\\Microsoft.NET\\Framework\\v2.0.50727\\installutil.exe‘
\n&$installutil McliPSSnapIn.dll<\/p>\n

$installutil = $env:systemroot + ‚\\Microsoft.NET\\Framework64\\v2.0.50727\\installutil.exe‘
\n&$installutil McliPSSnapIn.dll<\/p>\n

#Loading PVS MCLI CmdLet#####
\nfunction LoadCmdLet_PVS (){
\nwrite-host "Loading Citrix PVS MCLI, please wait…"<\/p>\n

get-pssnapin -name McliPSSnapin
\nif ($? -eq "True"){
\nwrite-host "\u00a0\u00a0\u00a0\u00a0 CtxPvsMCLI – Loading Citrix PVS MCLI exist – done"
\n}
\nElse{
\nAdd-PSSnapin -Name McliPSSnapIn
\nIf ($? -eq "True"){
\nwrite-host "\u00a0\u00a0\u00a0 CtxPvsMCLI – Loading Citrix PVS MCLI – done"
\n}
\nElse{
\nwrite-host "\u00a0\u00a0\u00a0\u00a0 CtxPvsMCLI – Loading Citrix PVS MCLI – failed"
\nexit
\n}
\n}
\n}<\/p>\n

#Connect to PVS server#####
\nfunction ConnectManagementServer_PVS (){
\nwrite-host "Connecting to Citrix PVS server, please wait…"<\/p>\n

Mcli-Run SetupConnection -p server=$servernameConnection, user=$username, domain=$domainNetBiosName, password=$password
\nIf ($? -eq "True"){
\nwrite-host "\u00a0\u00a0\u00a0\u00a0 CtxPvsMCLI – Connecting to Citrix PVS server – done"
\n}
\nElse {
\nwrite-host "\u00a0\u00a0\u00a0\u00a0 CtxPvsMCLI – Connecting to Citrix PVS server – failed"
\nexit
\n}
\n}<\/p>\n

#Get Script directory#####
\nfunction Get-ScriptDirectory{
\n$Invocation = (Get-Variable MyInvocation -Scope 1).Value
\nSplit-Path $Invocation.MyCommand.Path
\n}<\/p>\n

LoadCmdLet_PVS
\n#ConnectManagementServer_PVS<\/p>\n

#Output file#####
\n$OutPutFile = Join-Path (Get-ScriptDirectory) out_pvs.log
\nIf (test-path $OutPutFile) {Remove-Item $OutPutFile}<\/p>\n

#Get devicenames#####
\n$cc_devices = mcli-get device -f devicename | select-string devicename<\/p>\n

#Get information from devices#####
\nforeach ($cc_device in $cc_devices){
\n$cc_devicename_string = [string]$cc_device
\n$cc_devicename_string = $cc_devicename_string.substring(12)
\n$cc_deviceout = mcli-get device -p devicename=$cc_devicename_string -f devicename, devicemac, collectionname<\/p>\n

$cc_devicemac = $cc_deviceout | select-string devicemac
\n$cc_devicemac_string = [string]$cc_devicemac
\n$cc_devicemac_string = $cc_devicemac_string.substring(11)
\n$cc_devicemac_string = $cc_devicemac_string -replace "-",""<\/p>\n

$cc_devicecollectionname = $cc_deviceout | select-string collectionname
\n$cc_devicecollectionname_string = [string]$cc_devicecollectionname
\n$cc_devicecollectionname_string = $cc_devicecollectionname_string.substring(16)<\/p>\n

write-host $cc_devicename_string
\nwrite-host $cc_devicemac_string
\nwrite-host $cc_devicecollectionname_string<\/p>\n

$OutputLog = $cc_devicename_string + "," + $cc_devicemac_string + "," + $cc_devicecollectionname_string + "," + [STRING]$cc_devicepers<\/p>\n

$OutputLog | out-file -Append $OutPutFile
\n}<\/p>\n

[\/php]<\/p>\n","protected":false},"excerpt":{"rendered":"

0 0 Um bestehende End-Systeme aus einer Provisioning Server Umgebung auszulesen, damit man diese in Empirum importieren kann, kann das folgende PowerShell Skript verwendet. Dieses Skript liest den PC Namen, die Mac Adresse und die Device Collection eines jeden End-Systems aus und schreibt diese Kommagetrennt in eine Ausgabedatei. Bei der MAC Adresse werden zus\u00e4tzlich noch … \u201ePowershell: Auslesen von Device Name, MAC Adress und Device Collection aus der PVS Datenbank\u201c<\/span> weiterlesen<\/a><\/p>\n","protected":false},"author":1,"featured_media":1829,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,16,11,3,38,130],"tags":[5,9,23],"_links":{"self":[{"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/147"}],"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=147"}],"version-history":[{"count":5,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/147\/revisions"}],"predecessor-version":[{"id":149,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=\/wp\/v2\/posts\/147\/revisions\/149"}],"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=147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=147"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/workplace.skyworker.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}