Murty M

<div>
<div class="content wysiwyg-content">
VMWARE Horizon View 7.x Query: How can I get the last 10/20/30 days session details?<br />
In the console, I can see only the last 2000 events.<br />
I don't' have a Vrealize product to get reports.<br />
<a href="https://pubs.vmware.com/vrealizeoperationsmanager-6/index.jsp?topic=%2Fcom.vmware.vrealize.horizon.doc%2FGUID-078F4538-A891-4798-BD75-817233CC17F7.html" rel="ugc nofollow">https://pubs.vmware.com/vrealizeoperationsmanager-6/index.jsp?topic=%2Fcom.vmware.vrealize.horizon.doc%2FGUID-078F4538-A891-4798-BD75-817233CC17F7.html</a><br />
In this case, as per my knowledge, I should use SQL Query.<br />
Please suggest or provide such SQL Query. <br />
If we have any other ways to get the past reports, please suggest.
</div>
</div>


VMWARE Horizon View 7.x Query: How can I get the last 10/20/30 days session details?
In the console, I can see only the last 2000 events.
I don't' have a Vrealize product to get reports.
https://pubs.vmware.com/vrealizeoperationsmanager-6/index.jsp?topic=%2Fcom.vmware.vrealize.horizon.doc%2FGUID-078F4538-A891-4798-BD75-817233CC17F7.html
In this case, as per my knowledge, I should use SQL Query.
Please suggest or provide such SQL Query. 
If we have any other ways to get the past reports, please suggest.

VMWARE Horizon View 7.x Query: How can I get the last 10/20/30 days session details?

Citrix is the synonym for the virtualization and application infrastructure systems developed by the company of the same name. Main areas are application virtualization, Software-As-A-Service (SaaS), cloud-computing and networking. The two most well-known are Citrix XenApp or Citrix CloudPlatform.

Citrix

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

VMware, a software company founded in 1998,  was one of the first commercially successful companies to offer x86 virtualization. The storage company EMC purchased VMware in 1994. Dell Technologies acquired EMC in 2016. VMware’s parent company is now Dell Technologies.

VMware has many software products that run on desktops, Microsoft Windows, Linux, and macOS, which allows the virtualizing of the x86 architecture.  Its enterprise software hypervisor for servers, VMware vSphere Hypervisor (ESXi), is a bare-metal hypervisor that runs directly on the server hardware and does not require an additional underlying operating system.

VMware

Virtualization is the act of creating a virtual (rather than actual) version of something, including (but not limited to) a virtual computer hardware platform, operating system (OS), storage device, or computer network resources. Virtualization is usually the creation of a system that executes separate from the underlying hardware resources, or the creation of an entire desktop for systems located elsewhere, similar to thin clients.

Virtualization

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.