- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
View Desktop Connection Status | Historical Data
Dear all,
is it somehow possible (without having vCOPs yet) to have historical data on the vmware view administration dashboard?
I am currently having a report from liquidware showing the number of connected and disconnected desktops at a certain point in time.
I would also need available and all other statuses for some reports for our business.
Running View 5.X
Thanks in advance for any ideas.
best regards,
Niko
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
All event should be in the event-database, so it should be easy to create some sql-queries to extract the data you are interested in.
// Linjo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Easy said to be honest.
I dont find the appropriate tables/data to create such a request.
Is there some kind of table with statistical data? I cannot query the whole events db for connect, disconnect, etc and count them later.
I would just need those numbers as displayed in the admin desktop dashboard for a day (by hour) or a week (by day).
In example:
Day 1
Hour 0
300 connected
200 disconnected
100 available
5 agent-unreachable
Hour 1
400 connected
100 disconnected
100 available
5 agent-unreachable
and so on.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There are some sample queries in the integration guide that may point you in the right direction.
http://pubs.vmware.com/view-52/topic/com.vmware.ICbase/PDF/horizon-view-52-integration.pdf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you're just after a number, you should scrape the information using the perfmon counters we install - that will allow you to track the values through time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you explain that a little bit? Scrape how?
We have over 3500 machines. Is it still viable to use perfmon for this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I mean the perfmon counter on the connection server, not on each desktop. It will return the current number of connected sessions - you'd need a script to read the values out. That will only give you the session counts though, not other stats.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The problem with the session count is (if its the same as in the dashboard) that its including disconnected session.
I really would need all the numbers for all the different states by hour. Writing a script wouldn't be an issue. I just would need to know where i find the numbers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't think there's an equivalent to the dashboard rollup, however you could collect different bits of info from different powershell commands (e.g. you can use powershell to get the full list of View VMs via get-desktopvm, and sessions via get-remotesession).
If you go off the supported track, you could find the calls the UI is making to get that summary - http://velemental.com/2012/02/04/unofficial-advanced-vmware-view-powershell-cmdlets/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I get your point but that takes like forever for our environment and as you can imagine its so hard to create reports when you have to consider 4 different sources.
My current reporting is already based on LDAP queries, SQL Queries to event_db, vCenter exports and View exports.
The thing is that the event_db is supplying such a nice feature with the concurrent connections entry per day.
We will switch to vCOPS with view 6. Lets see if that is offering what it needs here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi mpryor,
i really like the link you've posted. Any idea how to access the amf channel? I cant on our view system sadly. Apparently other people have the same issue.