Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog
Showing posts in English
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 Server...

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
 ...

Ray OConnor | 18 Dec 2013 | 1 comment

Does anyone know who does the scheduling for the Michigan Endpoint Management User Group meeting? I find these meetings valuable and want to assume responsibility for managing them and getting support for them. Please contact me about the details for being a part of setting the meetings up.

-Ray

Ludovic Ferre | 18 Dec 2013 | 0 comments

A new Symantec pl xml was released to Solution Sam and it contains the Hotfix 2 for the Symantec Management Platform 7.5.

Here are the file details:

File name = Symantec_v2.pl.xml
MD5 hash ='1ab2fa5f2eb387a3b0de3e01c732340c'
Modified date = 2013-12-13 03:45

And here are the added files in the Solution tree:

  • solutions/7_5/sim/7_5_126/symantecinstallationmanagersetup.exe
  • solutions/7_5_hf2/ds/symantec_deploymentsolution_7_5_hf2_x64.msi
  • solutions/7_5_hf2/smp/altiris_directoryservices_hotfix_x64.msi
  • solutions/7_5_hf2/smp/altiris_ns_hotfix_x64.msi
  • solutions/7_5_hf2/smp/altiris_unixagent_7_5_hf2_x64.msi
  • solutions/7_5_hf2/smp/symantec_softwaremanagementframework_75_hf2_x64.msi
 
SK | 10 Dec 2013 | 1 comment

The following query has the ability to list all Software Releases and their associated rules or just the rules associated with a specifc Software Release:

SELECT rsr.Name AS [Software Release],rir.Name AS [Rule],rir.[Description] AS [Rule Description]
FROM RM_ResourceSoftware_Release rsr
JOIN ResourceAssociation ra ON ra.ParentResourceGuid = rsr.[Guid]
JOIN RM_ResourceInventory_Rule rir ON rir.[Guid] = ra.ChildResourceGuid
--WHERE rsr.Name = 'specific software release'
ORDER BY rsr.Name ASC

As Applicability and Detection rules are both classed as inventory rules, they do not have their own resource type or class; however, it does appear that detection rule names begin with "Detection Rule for", which should allow you to distinguish between the two.

mszlosarczyk | 09 Dec 2013 | 0 comments

Hi Everyone,

Cloud-enabled Management (CEM) is a new feature that allows you to manage client computers outside the corporate network, even if you do not use a Virtual Private Network. CEM was first introduced with IT Management Suite 7.5.

To make the process of implementation quick and easy, we have prepared a whitepaper that describes the concept, requirements and the process of implementation of Cloud-enabled Management.

You can find the whitepaper at the following URL:
http://www.symantec.com/docs/DOC7049

Ludovic Ferre | 02 Dec 2013 | 0 comments

After a short but nice break (just two days without a computer) I am back to work looking forward to what week 49 has to offer.

I havea few things high on the list for this week:

  • Duplicating problem with the Package Access Credntial store in Rollup v7 agent on fresh (Scripted or CD install) Windows 7
  • Drill down into MS12-034, 12-035 ad 12-060 for which compliance as been steadily and surely erroding over te past month (we're down below the 90% mark)
  • Research a problem with user access and database
  • Check why the Patch Agent from rollup v7 is not installing on computers that are in the policy target (and the policy is scheduled to run every 2 hours on a 24 hours window).

Then there'll be te usual incoming events and working on cases.

Oh, one final point: we're about 1 week away from patch Tuesday. Which is just 4 weeks since the last one. And given we release updates to production ~ 1 week after Patch...