The impact of browser generated data on an Ivanti UWM Environment Manager Personalization database

Recently we’ve been working with several Ivanti UWM customers to understand what impact personalizing the various web browsers is having on their environment.  As part of these engagements, we have created a series of scripts which can be executed against the Environment Manager Personalization SQL database to see how much browser data is being stored.

The SQL scripts located here can be executed via SQL Management Studio to produce outputs similar to those shown below:

Ivanti Webcache Details.sql

Ivanti Chrome Details.sql

Ivanti Firefox Details.sql

The scripts support both Windows Settings Groups and Application Groups and will work with any version from Environment Manager 8.6 and above.

These scripts provide an understanding of how roaming web data will be impacting your environment.  They provide an overview of all the web data that is being stored within your Personalization server database as well as the additional data for the associated archives.  The size and volume of this data is relevant to the users’ logon experience as retrieving large files or a large number of individual files from a network resource will have a negative impact on user logon duration.  This data will also be impacting any archiving and maintenance routines that are scheduled to run in the environment as well as those related to SQL database backups.  This data will also be consuming unnecessary SQL Server resources, and reducing SQL Server performance.

We hope you find them useful and they help you assess your environments.