<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: VMWare PowerCLI &amp;amp; Horizon Assigned User in Horizon Desktops and Apps</title>
    <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860329#M94574</link>
    <description>&lt;P&gt;Ciao&amp;nbsp;&lt;/P&gt;&lt;P&gt;Try this script&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$vms = Get-HVMachineSummary -PoolName "&amp;lt;Pool Name&amp;gt;"&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$results = @()&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;foreach($vm in $vms){&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$properties = @{&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;UserName = $vm.NamesData.UserName&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;MachineName = $vm.Base.Name&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;VDIPool = $vm.NamesData.DesktopName&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;}&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$results += New-Object psobject -Property $properties&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;}&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$results | export-csv -NoTypeInformation -path &amp;nbsp;c:\Test.csv&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;</description>
    <pubDate>Mon, 02 Aug 2021 11:29:33 GMT</pubDate>
    <dc:creator>fabio1975</dc:creator>
    <dc:date>2021-08-02T11:29:33Z</dc:date>
    <item>
      <title>VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860300#M94568</link>
      <description>&lt;P&gt;Hi volks,&lt;/P&gt;&lt;P&gt;we are using VMWare PowerCLI to export information of specific machines for an external inventory tool.&lt;/P&gt;&lt;P&gt;There is one information that is missing:&lt;/P&gt;&lt;P&gt;I need the assigned user of the horizon machine.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Any ideas how to grab the user using PowerCLI?&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 02 Aug 2021 09:23:51 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860300#M94568</guid>
      <dc:creator>danielkrause</dc:creator>
      <dc:date>2021-08-02T09:23:51Z</dc:date>
    </item>
    <item>
      <title>Re: VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860308#M94569</link>
      <description>&lt;P&gt;Ciao&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Have you tried this command?&lt;/SPAN&gt;&lt;/P&gt;&lt;DIV class="FFpbKc"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;P&gt;&lt;STRONG&gt;get-hvmachinesummary -PoolName "&amp;lt;PoolName&amp;gt;" | Ft -AutoSize&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class="VIiyi"&gt;&lt;SPAN class="JLqJ4b ChMk0b"&gt;&lt;SPAN&gt;Or if you want to see the active sessions:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$query = New-Object "Vmware.Hv.QueryDefinition"&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$query.queryEntityType = 'SessionLocalSummaryView'&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$qSrv = New-Object "Vmware.Hv.QueryServiceService"&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$qSRv.QueryService_Query($global:DefaultHVServers[0].ExtensionData,$query) |&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Select -ExpandProperty Results |&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Select -ExpandProperty NamesData |&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Select-Object -Property UserName,DesktopType,DesktopName,MachineOrRDSServerDNS&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 02 Aug 2021 09:46:32 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860308#M94569</guid>
      <dc:creator>fabio1975</dc:creator>
      <dc:date>2021-08-02T09:46:32Z</dc:date>
    </item>
    <item>
      <title>Re: VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860313#M94571</link>
      <description>&lt;P&gt;Thank you sooo much.&lt;img class="lia-deferred-image lia-image-emoji" src="https://communities.vmware.com/html/@1F08D050FAC2EBFBB851E2E464CE7F41/emoticons/1f60a.png" alt=":smiling_face_with_smiling_eyes:" title=":smiling_face_with_smiling_eyes:" /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The 1st Command is not working, don't know why:&lt;/P&gt;&lt;P&gt;get-hvmachinesummary : The term 'get-hvmachinesummary' is not recognized as the name of a cmdlet, function, script file, or operable&lt;BR /&gt;program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The 2nd Command is not bad, but i need to see all Machines and not only open session and i need to filter for a pool&lt;/P&gt;</description>
      <pubDate>Mon, 02 Aug 2021 10:09:10 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860313#M94571</guid>
      <dc:creator>danielkrause</dc:creator>
      <dc:date>2021-08-02T10:09:10Z</dc:date>
    </item>
    <item>
      <title>Re: VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860315#M94572</link>
      <description>&lt;P&gt;Ciao&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Ok, you need to install the add-on module follow the following link:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;&lt;A href="https://docs.vmware.com/en/VMware-Horizon-7/7.13/horizon-integration/GUID-B29EB217-30F0-4C58-9A49-95160392AA9C.html#GUID-B29EB217-30F0-4C58-9A49-95160392AA9C" target="_blank"&gt;Run Example Horizon PowerCLI Scripts (vmware.com)&lt;/A&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 02 Aug 2021 10:26:49 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860315#M94572</guid>
      <dc:creator>fabio1975</dc:creator>
      <dc:date>2021-08-02T10:26:49Z</dc:date>
    </item>
    <item>
      <title>Re: VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860327#M94573</link>
      <description>&lt;P&gt;&lt;img class="lia-deferred-image lia-image-emoji" src="https://communities.vmware.com/html/@1F08D050FAC2EBFBB851E2E464CE7F41/emoticons/1f60a.png" alt=":smiling_face_with_smiling_eyes:" title=":smiling_face_with_smiling_eyes:" /&gt;Looks better, now i can use the command and i see all information.&lt;/P&gt;&lt;P&gt;get-hvmachinesummary -PoolName "XXXX"&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;...but i cannot add a "|" command.&lt;/P&gt;&lt;P&gt;I would like to filter or export to CSV, but if i do so, i get only clear data&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Like that:&lt;BR /&gt;| Sort-Object -Property Machine&lt;BR /&gt;| Export-Csv -Path c:\Test.csv -NoTypeInformation&lt;BR /&gt;| Select-Object -Property Machine, User&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 02 Aug 2021 11:19:12 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860327#M94573</guid>
      <dc:creator>danielkrause</dc:creator>
      <dc:date>2021-08-02T11:19:12Z</dc:date>
    </item>
    <item>
      <title>Re: VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860329#M94574</link>
      <description>&lt;P&gt;Ciao&amp;nbsp;&lt;/P&gt;&lt;P&gt;Try this script&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$vms = Get-HVMachineSummary -PoolName "&amp;lt;Pool Name&amp;gt;"&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$results = @()&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;foreach($vm in $vms){&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$properties = @{&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;UserName = $vm.NamesData.UserName&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;MachineName = $vm.Base.Name&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;VDIPool = $vm.NamesData.DesktopName&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;}&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$results += New-Object psobject -Property $properties&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;}&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$results | export-csv -NoTypeInformation -path &amp;nbsp;c:\Test.csv&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 02 Aug 2021 11:29:33 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860329#M94574</guid>
      <dc:creator>fabio1975</dc:creator>
      <dc:date>2021-08-02T11:29:33Z</dc:date>
    </item>
    <item>
      <title>Re: VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860345#M94575</link>
      <description>&lt;P&gt;Great!!! I modified it for also showing me VM Hardware Information.&lt;/P&gt;&lt;P&gt;I#This is the Destination Folder for the Export File&lt;BR /&gt;$LocationPath = "\\SERVER\path\"&lt;/P&gt;&lt;P&gt;#This is the function for Export my Data&lt;BR /&gt;function Get-PoolInfo{&lt;BR /&gt;Param (&lt;BR /&gt;$a&lt;BR /&gt;)&lt;/P&gt;&lt;P&gt;$vms = Get-HVMachineSummary -PoolName $a&lt;BR /&gt;$results = @()&lt;BR /&gt;foreach($vm in $vms){&lt;BR /&gt;write-Host $vm.Base.Name&lt;BR /&gt;$properties = @{&lt;BR /&gt;MachineName = $vm.Base.Name&lt;BR /&gt;VDIPool = $vm.NamesData.DesktopName&lt;BR /&gt;UserName = $vm.NamesData.UserName&lt;BR /&gt;GB = get-vm -Name $vm.Base.Name | Get-Harddisk | Select-Object -ExpandProperty CapacityGB&lt;BR /&gt;CPUs = get-vm -Name $vm.Base.Name | Select-Object -ExpandProperty NumCPU&lt;BR /&gt;RAM = get-vm -Name $vm.Base.Name | Select-Object -ExpandProperty MemoryMB&lt;BR /&gt;OS = (get-vm -Name GE-TEAMEDS-0013 | Get-Harddisk | Select-Object @{N="OS";E={$_.Parent.Guest.OSFullName}}) -replace "@{OS=", "" -replace "}", ""&lt;BR /&gt;Datastore = (get-vm -Name $vm.Base.Name | Get-Harddisk | Select-Object @{N="DS";E={$_.Filename.Split(']')[0].Trim('[')}}) -replace "@{DS=", "" -replace "}", ""&lt;/P&gt;&lt;P&gt;}&lt;BR /&gt;$results += New-Object psobject -Property $properties&lt;BR /&gt;}&lt;BR /&gt;$FilePath = $LocationPath + "Machines_" + $a + ".csv"&lt;BR /&gt;$results | export-csv -NoTypeInformation -path $FilePath&lt;BR /&gt;}&lt;/P&gt;&lt;P&gt;# Execute the function (Get-PoolInfo &amp;lt;Poolname&amp;gt;)&lt;BR /&gt;Get-PoolInfo &amp;lt;Poolname&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 02 Aug 2021 13:25:58 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860345#M94575</guid>
      <dc:creator>danielkrause</dc:creator>
      <dc:date>2021-08-02T13:25:58Z</dc:date>
    </item>
    <item>
      <title>Re: VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860483#M94578</link>
      <description>&lt;P&gt;Last question: Is there a possibility only export activ Sessions with Users in Automated pools?&lt;/P&gt;</description>
      <pubDate>Tue, 03 Aug 2021 07:29:13 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860483#M94578</guid>
      <dc:creator>danielkrause</dc:creator>
      <dc:date>2021-08-03T07:29:13Z</dc:date>
    </item>
    <item>
      <title>Re: VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860517#M94581</link>
      <description>&lt;P&gt;Ciao&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN class="VIiyi"&gt;&lt;SPAN class="JLqJ4b ChMk0b"&gt;&lt;SPAN&gt;try this script:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Connect-HVServer &amp;lt;Connection Server Name&amp;gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$query = New-Object "Vmware.Hv.QueryDefinition"&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$query.queryEntityType = 'SessionLocalSummaryView'&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$qSrv = New-Object "Vmware.Hv.QueryServiceService"&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;$qSRv.QueryService_Query($global:DefaultHVServers[0].ExtensionData,$query).Results |&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Select-Object -Property @{Name = 'Session Start Time'; Expression = {$_.sessiondata.startTime}},@{Name = 'Display Protocol'; Expression = {$_.sessiondata.SessionProtocol}},@{Name = 'Username'; Expression = {$_.namesdata.username}},@{Name = 'Pool Name'; Expression = {$_.namesdata.desktopname}},@{Name = 'Machine Name'; Expression = {$_.namesdata.machineorrdsservername}},@{Name = 'Session Type'; Expression = {$_.sessiondata.sessiontype}},@{Name = 'State'; Expression = {$_.sessiondata.sessionstate}},@{Name="TypePool";Expression={$_.NamesData.DesktopType}} | Where {$_.State -eq "CONNECTED"} | Where {$_.TypePool -eq "AUTOMATED"} |&amp;nbsp;Export-Csv -path &amp;lt;pathcsvfile&amp;gt; -NoTypeInformation&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 03 Aug 2021 10:39:35 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2860517#M94581</guid>
      <dc:creator>fabio1975</dc:creator>
      <dc:date>2021-08-03T10:39:35Z</dc:date>
    </item>
    <item>
      <title>Re: VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2960026#M98911</link>
      <description>&lt;P&gt;Thanks for your support and script. can you help what should I add to remove the assigned user?&lt;/P&gt;</description>
      <pubDate>Mon, 20 Mar 2023 12:04:37 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2960026#M98911</guid>
      <dc:creator>EK2023</dc:creator>
      <dc:date>2023-03-20T12:04:37Z</dc:date>
    </item>
    <item>
      <title>Re: VMWare PowerCLI &amp; Horizon Assigned User</title>
      <link>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2961228#M98975</link>
      <description>&lt;P&gt;Thank you for writing this script. Very helpful!&lt;/P&gt;</description>
      <pubDate>Mon, 27 Mar 2023 19:48:05 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/VMWare-PowerCLI-amp-Horizon-Assigned-User/m-p/2961228#M98975</guid>
      <dc:creator>dzak64</dc:creator>
      <dc:date>2023-03-27T19:48:05Z</dc:date>
    </item>
  </channel>
</rss>

