AKB# 50744 covers a problem where the Altiris Agent install page loads very slowly. This symptom occurs regardless of how you access the page (Actions> Agents/Plug-ins> Push Altiris Agent) or (Settings> Agents/Plug-ins> Altiris Agent). In my environment I started seeing upwards of seven often 10 minute load times for the push screen, unacceptable by any standard. The KB talks about a stored procedure that is used to help populate the data in the grid on the install page. The article goes on to explain that in testing this SPROC was taking approximately  5 minutes to run, similar to the times I was seeing.

The article then discusses the evt_aex_agent_push_status table, this is where information about computers you add to the grid to install the agent to is stored. I found on my installation of SMP 7 SP4 that this table was named evt_aex_push_status with the word ‘agent’ removed. There are 2 solutions to this issue, the one prescribed in the KB article is the faster of the two.

1.) Truncate the evt_aex_agent_push_status or evt_aex_push_status table. This clears the data from the table and the SPROC should complete in seconds rather than minutes which translates directly into a much faster load time in the console. It is important to note the use of truncate here and not delete. ‘Deletes’ in SQL Server are logged and so running a delete against a table with a lot of records isn’t advisable (unless you have all day). Secondly, and perhaps more importantly, a truncate can be rolled back.

2.) If you wait the painful 5-10 minutes for the Agent push screen to load, clear all computers out of both the Windows and (more importantly) the ULM (unix linux mac) push tab. It seems as though ULM computers cause this more than windows devices.

The reason for this post is to add the following code that you can use to create a stored procedure (SPROC) of your own to truncate the aex push data table. Paste the following code into SSMS or your tool of choice.

USE Symantec_CMDB
CREATE PROCEDURE [dbo].[usp_TruncateAeXPushStatus]
TRUNCATE table Evt_AeX_Push_Status

This will create a SPROC called ‘usp_TruncateAeXPushStatus’ that you can then execute to truncate your push status table in the event that this should happen again. The SPROC might be overkill since you are typing ‘exec usp_truncateaexpushstatus’ instead of ‘truncate table evt_aex_push_status’ but hey, I saved you from typing some underscores.

Keep in mind you have to have the proper permissions to truncate tables and this also fixed another issue I was having where it was taking five minutes or more just to add a ULM computer on that screen.


Busy Busy Busy!

October 16, 2008

Have been so busy lately with work and things we are doing there. Binding macs to the domain, gathering advanced inventory of them through Inventory tasks from the notification server. I have the 3rd piece of the imaging series as well as another article for updating the ProcessorDesc.ini file to add descriptions for newer processors.

Should have these articles to the juice in the next week… so sorry for the long delay on the imaging article.

In other news, I have passed my Notification System Foundation exam with a 96% 🙂