Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog
Showing posts tagged with 7.x
Showing posts in English
SK | 04 Mar 2014 | 1 comment

Release Notes and the actual RU can be obtained from HOWTO81832.

SK | 08 Feb 2014 | 1 comment

The following query maps item names to the three different guids found within the ResourceAssociation table, allowing you to understand its contents better:

SELECT
vi1.[Guid] AS ResourceAssociatiopnTypeGuid,vi1.Name AS ResourceAssociatiopnType,
vi2.[Guid] AS ParentResourceGuid,vi2.Name AS ParentResource,
vi3.[Guid] AS ChildResourceGuid,vi3.Name AS ChildResource
FROM vItem vi1
JOIN ResourceAssociation ra ON ra.ResourceAssociationTypeGuid = vi1.[Guid]
JOIN vItem vi2 ON vi2.[Guid] = ra.ParentResourceGuid
JOIN vItem vi3 ON vi3.[Guid] = ra.ChildResourceGuid
ORDER BY vi1.Name ASC

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>

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

Ludovic Ferre | 18 Nov 2013 | 0 comments

The Deployment Solution Agent (7.x) comes in as an all or nothing bundle. Once installed the agent will run all of its tasks whenever it finds it suitable, without giving administrators a chance to control what should or should not be done.

The iLO inventory is one such task that the Deployment Agent runs everytime the agent is started. Given you can't disabled the inventory process you cannot either prevent the events related to running the task.

This means that if you have 10,000 computers starting on Monday morning all with the Deployment Agent installed you will get 10,000 RILOE Capture Event messages sent to the SMP.

As previously stated with the DS Agent it's an all or nothing deal, but thankfully some Agent built-in feature can be used here to prevent the undesired messages from living the workstation:

The Altiris Agent Transport Filters. These filters are normally delivered to the managed machine with its client policy and are stored in...

ianatkin | 14 Nov 2013 | 0 comments

Today, I'm looking at problem with NS7 inventory.

Whenever Linux automation has a kernel upgrade (which hasn't happened for a while but is about too), one of the steps I do is confirm hardware support. In NS6 I did this by gathering up all the relevent device IDs of the PCI bus for network cards and storage with the following SQL,

 

SELECT * 

FROM...

jon_sharp | 10 Jun 2013

Symantec Deployment Solutions is dependent on the use of pre-boot operating systems in the management of workstation and server systems. The pre-boot environment is delivered to target workstation and server systems via network PXE servers or through the use of physical devices and media. This process has the potential for exposure to possible malicious activity from a person who may have already breached network security, either physically or through a remote network connection, or from a malicious but authorized network user. This paper will address these types of secondary security exposures. ...

Click here to read the full KB.

Rae Landua | 06 May 2013 | 0 comments

ITS & Altrinsic Solutions' free Altiris Deployment webinar is just around the corner! Join Mark England to hear Quagmires Quandries and Snake Pits: Don’t Get Stuck on Deployments on Thursday 5/9/13 at 1pm CDT. Register now to save your spot!  https://www1.gotomeeting.com/register/454827056

Tim.Jing | 21 Feb 2013 | 0 comments

Found out that there is a hidden covert entity existing inside the Symantec Support world where all the product experts converge. They will host sessions with clients when there are issues with the SMP product. Session 2 is coming up soon to address the imaging timing issue.

At this point, looking in to the spy glass, I'd say this is has been a very shaky start which will probably cost me my job.

But we do have a glimmer of hope now with the new resources. There are some clever SQL plays and work around suggested which would make some of the issues go away.

However we are discovering some odd and serious replication problems which hopefully will get solved today.

1. Certain jobs will replicate to one child server, but error when replicated to the other.

2. Full inventory is shown on Child NS, but basic on the parent server.

 

Tim.Jing | 20 Feb 2013 | 0 comments

So you have support on the line, and they have a fix for an issue for you. WebEx session, servers configured service restarted, all good right?

Not so quick, 5 minutes later, complaint about console not longer accessible. 10 minutes after that's resolved, no jobs/tasks will run!

That's the worst moment in IT, when everyone that's never roamed near your cube is now gathering inside or huddled in to an empty space just to spectate. It's like mosh pit thick ring side when Tyson's strolling down the isle, and in my mind, a numbing silence like someone that just got TKO'ed.

Starting from the beginning, we had NSE processing performance issues and a call was made to support to change queue processing size. (TECH183347 ) After the changes, both server seems normal when using the console while remoted to the server. The call ends, and then we found out the console no longer...