UMS Maintenance Vol 1

If you have been using UMS since the IGEL OS 10.x.x version, I think, this can be interesting for you.

A lot of changes have been made by Igel into UMS, of course, they need to evolve.

But, what happens when you are a customer who has to manage not only Igel but also ten other things? Does it sound familiar?

Well, I will try to help you, but just with Igel. ?

I can tell you, after doing the following steps, we reduced our UMS Database from 85Gb to…. 1GB.

Yes, you are reading it right, 1GB after doing all of these tasks. Of course, our DB backups were very fast after this.

Let’s go to see what we did:

1. We removed all our unused firmware. To do this, go to MISC –> FIRMWARE STATISTICS
   

In this table you can see very important information:

• Firmware version USED and NOT USED.
  
• The number of devices using what Firmware Version.
  
• In Red, all the Profiles-Based On Firmware Version that we have.

With all of this info, we go to MISC –> REMOVE UNUSED FIRMWARE

Select what we want to delete, and push “Delete Selected Firmwares“

After finishing, you don’t need to go to Recycle Bin.

2. The next step we have to accomplish, we need to go to UMS Administration –> Administrative Tasks

Here, we need to create several Maintenance Tasks.

• Chose a name for the Administrative Task.
  
• Select the Action “Delete Logging Data“
  
• You can send the task result to your email if you want.
  
• Make sure “Active” is selected.
  
• Push “Next“

This task is going to create several files as the result of the deletion process, so it needs a temporal folder to store all of these files. If you don’t change it, it will use the default target temp folder.

You can leave as it is, with messages older than 5 days. I always choose this option, but it is up to you.

Next, you have to choose time/Date when you want to run this task. Try to do it out of business hours.

Now, you should repeat the same process with :

• Delete job execution data.
  
• Delete administrative task execution data.
  
• Delete Process Events.

I choose 5 days in all of them.

After all your tasks have been executed, at least once, we have to do a last step.

In your UMS, look for UMS Administrator

Now, go to DATASOURCE and push Optimize Database

I hope this can help you to have a healthier UMS. In the next post we will see one additional cleaning step.