Solved

VMware View 4.5 script to logoff users.

Posted on 2011-02-24
4
803 Views
Last Modified: 2012-05-11
I want to query the view composer database to find out the last compose date for view desktops then schedule a reboot of the oldest desktops.  But I  have not been able to find that information in the database.  Anyone know the table that this would be in, and what it would be called?
0
Comment
Question by:MGHS
  • 3
4 Comments
 
LVL 118

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 125 total points
ID: 34979311
if you have a look in the View Composer SQL database that you have created for use for VMware View 4.5.

table dbo_SVI_SIM_CLONE

has SIM_CLONE names, VM_NAME, GOLDEN_MASTER, LAST_SYNC_TIME and VM_UUID.

table dbo_SVI_DEPLOYMENT_GROUP

has VM_SS_CREATE_TIME

table dbo_SVI_REPLICA

has GOLDEN_SS_CREATE_TIME

I'm sure you could use these timestamps in your scripts if you wanted.
0
 

Author Comment

by:MGHS
ID: 34981842
Since I don't have these View desktops registering in DNS restarting by name didn't work.  Is there a table that you know of that I could query for Last_Sync_Time and IP address instead of VM_NAME?   The reason for this is that View was so successful that the demand has exceeds the host resources when a large number of users trying getting a session at once.  So while we beg for money to buy 2 new host servers I set the pool to never disconnect the sessions.   But to keep from filling the disk space I want to query for the oldest VM's then pass the IP to powershell to restart computer which triggers view composer to destroy the desktop and create a fresh one.  This way we have control over how many users are forced to log into a new session each morning.

Thank you very much for your help.
0
 
LVL 118
ID: 34981866
No IP Addresses are stored in the tables.
0
 
LVL 118
ID: 34981868
Machine Names and VMware UUIDs
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now