Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog
Showing posts in English
SK | 21 Jan 2014 | 0 comments

One unfortunate difference between SMP 7.1 and 7.5 is that in 7.1, when you run a report, the SMP records a number of "Altiris.Reporting....." entries in its logs; two of which were high useful:

 

Source: Altiris.Reporting.DataSource.ResourceDataSource.Run
Description: ResourceDataSource returned N rows in 'Table' table

N equates to the number of rows that you report displayed, making it easy to locate the write log records, because immediately below this line will be the actual reports SQL that was used:

Source: Altiris.Reporting.DataSource.ResourceDataSource.Run
Description: ResourceDataSource is running query:

<Reports SQL starts here>

Ludovic Ferre | 21 Jan 2014 | 1 comment

Hotfix 3 for 7.5 was released to the public via the symantec.pl.xml. Below is a view of the changes from the xml file:

Revision: 987e0744f747
Author:   Ludovic FERRE <ludovic.f...@gmail.com>
Date:     Mon Jan 20 13:50:07 2014 UTC
Log:      Symantec.pl.xml md5 = 482cc8bd7ed41a7e3e6931e31f2d4c3e

http://code.google.com/p/ns7pl/source/detail?r=987e0744f747

Added:
 /solutions/7_5_hf3/cmdb/cmdb_hf3x64.msi_info
 /solutions/7_5_hf3/ds/deploymentsolutionlanguages_hf3_x64.msi_info
 /solutions/7_5_hf3/ds/symantec_deploymentsolution_7_5_hf3_x64.msi_info
 /solutions/7_5_hf3/monpack/monitorpackservers_hf3_x64.msi_info
 /solutions/7_5_hf3/pm/altiris_patchmanagementlinux_7_5_hf3_x64.msi_info
 /solutions/7_5_hf3/sim/...

SK | 20 Jan 2014 | 11 comments

HF3 for ITMS 7.5 is now available via SIM.  Please review the attached screenshot for the seven products that it can update.

Ludovic Ferre | 19 Jan 2014 | 0 comments

Here is an overview of how I am currently using the aila2 tools release here on Connect to provide updated data to users.

Only a couple of elements are missing from the image below:

  • A run batch file provides the processing core to sequence aila2-runner and aila2-siteconfig
  • An install batch provide the aila2-web configuration and files to the IIS directory

aila2 processing overview.png

More information will come on this implementation, with the full kit to install and run the aila2 set to your SMP or Site Servers.

SK | 17 Jan 2014 | 0 comments

I have just updated my article by adding a comment that includes the SQL behind the new view that ITMS 7.5 adds to "Manage > Software".

https://www-secure.symantec.com/connect/articles/s...

andykn101 | 15 Jan 2014 | 0 comments

There is a useful SQL query in TECH183347 to measure queue processing but it doesn't contain descriptions for the Queue numbers, I've added a few CASE statements to do this:

SELECT Queueid As [Queue ID],
 [Queue]=CASE Queueid
 WHEN 0 Then 'Priority'
 WHEN 1 Then 'Fast'
 WHEN 2 Then 'Normal'
 WHEN 3 Then 'Slow' 
 WHEN 4 Then 'Large'
 END, COUNT(Id) AS [THREADS IN USE] 

FROM EventQueueEntry where ProcessingState = 2 
GROUP BY ProcessingState, QueueId order by queueid, ProcessingState
The descriptions are taken from DOC5480: http://www.symantec.com/docs/DOC5480
 
TECH183347: http://www.symantec.com/docs/TECH183347
Ludovic Ferre | 14 Jan 2014 | 0 comments

With aila2 and aila2-filter Downloads now available on Symantec Connect (see table below for links) I think it is time to document how these program make up just a part of the aila2 project and what the final result will look like.

The final result from a user standpoint is a web-site that provides a Calendar View where the aila2 parse results are displayed using a line graph showing the day trends (hit counts) per hour.

Here is a view from a test system:

aila2-calendar-view.png

The calendar view is currently set to 3 column wide and will show a maximum of 60 charts by default, but both default values can be overwritten on the UI itself. The calendar view also provides a link to access the detailed view on the server.

So here's a quick table of the aila2 tools and documents to be release in order to produce the above results:

...
Ryan Terry | 07 Jan 2014 | 0 comments

 

We recently held our first User Group Summit with 75 customers representing 28 different User Groups.  We also had several Symantec employees in attendance to network, field questions, share ideas, etc. 

One of the valuable interactions we had came from a Server Management Suite discussion table held at lunch.  There was interest expressed from several folks around getting together more often to share insights and best practices around Server Management Suite specifically.  Some of the customers even offered to present some of this information. 

We’d like to gauge interest around holding these sessions around Server Management Suite in 2014.  Please reply to this blog or send me an email at ryan_terry@symantec.com and offer your thoughts regarding the following questions:

•   How often you'd like to meet virtually to discuss best practices around...

SK | 31 Dec 2013 | 1 comment

After a clean install of ITMS 7.1.2 MP1.1 v7RU, it was found that it was not possible to create a new CMDB rule as its first dropdown list failed to open.

To workaround this issue, you need to clone a sample CMDB rule and then modify it to suit your needs.

SK | 28 Dec 2013 | 0 comments

Here is a handy SQL query that will allow you to search your database tables for a particular word or words (tested against SQL 2008 R2):

 

**********************************

CREATE TABLE myTable99 (TABLE_NAME sysname, COLUMN_NAME sysname, Occurs int)
GO

SET NOCOUNT ON

DECLARE @SQL varchar(8000), @TABLE_NAME sysname, @COLUMN_NAME sysname, @Sargable varchar(80), @Count int

SELECT @Sargable = 'enter word or words here'

DECLARE insaneCursor CURSOR FOR
    SELECT c.TABLE_NAME, c.COLUMN_NAME
      FROM INFORMATION_SCHEMA.Columns c INNER JOIN INFORMATION_SCHEMA.Tables t
        ON t.TABLE_SCHEMA = c.TABLE_SCHEMA AND t.TABLE_NAME = c.TABLE_NAME
     WHERE c.DATA_TYPE IN ('char','nchar','varchar','nvarchar','text','ntext')
       AND t.TABLE_TYPE = 'BASE TABLE'

OPEN insaneCursor...