Recently, I attended a webinar which suggested a great idea: use KACE to control DeepFreeze freezing and thawing for labs, without using the Deep Freeze console, thereby centralizing the management of both Deep Freeze and KACE patching. In theory, this sounded like a great idea. So, I decided to follow a white paper that KACE wrote to do this integration. (download below)
After getting everything in order following the instructions, I found at least one thing that was missing for my case. Due to the variations of versions, I decided to add a new field to the Deep Freeze Status, which would also include the version number of the Deep Freeze Config agent on each machine.
To do this, you need to add another Software Item in KACE, in the same manner that you added the “Deep Freeze Enterprise Status”, but this time, query for the “DF Version” instead of the “DF Status” and name the software item: “Deep Freeze Enterprise Version”. For a clearer idea regarding this, please refer to page 8 of the white paper.
Once the Custom Inventory Rule is added, now, all that is needed is to modify the MySQL code in the report, to include the version column. Below is the code needed, you can just take that, and replace the code that you currently have:
SELECT MACHINE.NAME AS SYSTEM_NAME, IP, MACHINE.DOMAIN, LAST_REBOOT, LAST_SHUTDOWN, (SELECT MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE FROM MACHINE_CUSTOM_INVENTORY JOIN SOFTWARE ON SOFTWARE.ID=MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID WHERE MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID and (SOFTWARE.DISPLAY_NAME = 'Deep Freeze Enterprise Status' OR SOFTWARE.DISPLAY_NAME='Deep Freeze Mac Status')) AS DEEP_FREEZE_STATUS, (SELECT MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE FROM MACHINE_CUSTOM_INVENTORY JOIN SOFTWARE ON SOFTWARE.ID=MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID WHERE MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND (SOFTWARE.DISPLAY_NAME = 'Deep Freeze Enterprise Version')) AS DEEP_FREEZE_VERSION FROM MACHINE WHERE ((1 in (select 1 from MACHINE_CUSTOM_INVENTORY join SOFTWARE on SOFTWARE.ID=MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID where MACHINE.ID = MACHINE_CUSTOM_INVENTORY.ID and (SOFTWARE.DISPLAY_NAME = 'Deep Freeze Enterprise Status' OR SOFTWARE.DISPLAY_NAME='Deep Freeze Mac Status') and MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE is not null)) ) ORDER BY DEEP_FREEZE_STATUS, SYSTEM_NAME
Now that we covered the good thing, I will go through some of the problematic items with this process:
These are only my first observations as I was testing the process. I will be updating this article as I work more with this, and perhaps suggest solutions if and when I find some. As a first impression though, this process of integration doesn’t seem to create a whole lot of benefit to justify re-setting up and scheduling the maintenance schedules already setup in Deep Freeze administrator.
Has anyone had any real life experience with this? if so, what was the solution to the above problems? Have you done anything creative to benefit more from this process? All sounded really snazzy in the webinar, and on paper, but in reality, it’s much less practical than one would want.