EdgeSight: Timezone offsets

Intro If you have implemented any of the ad hoc SQL queries available on this site, you may have noticed that most time queries are offset by –4 or –5 hours. This is because the EdgeSight database uses GMT to record time and I am located in the U.S. Eastern Time Zone. In this post […]

Read More EdgeSight: Timezone offsets

EdgeSight: Finding Users On Your Network, Using PC’s, and Running a Certain Application

Intro Recently I was asked to determine which users were using a certain application in our Citrix Farm.  We are using a published desktop and while EdgeSight has reports to show published applications, few built-in reports to show what users are running in their session.  In addition, I was only looking for users who were […]

Read More EdgeSight: Finding Users On Your Network, Using PC’s, and Running a Certain Application

EdgeSight: Reporting On Non-PC Devices

UPDATE: Added new WHERE statement to select just iOS devices (see below). Intro Today’s workplace no longer follows a strict standard in terms of endpoint devices.  Despite the efforts of your infrastructure, network, and security teams users are connecting non-approved devices to your network and your Citrix farm.  A lot has been said about the […]

Read More EdgeSight: Reporting On Non-PC Devices