Video Screencast Help
Endpoint Management Community Blog
Showing posts in English
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...

Ludovic Ferre | 29 Nov 2013 | 0 comments

I have just released version 9 of Zero Day Patch with a couple of interesting features that I am going to detail here.

/exclude-on-fail

What is interesting here is not necessarily this new switch, but rather the work that went on to create it. In effect I started from a few customer reported problems: if ZeroDayPatch encounters a problem during the staging (for example not all files can be downloaded) or during the policy creation (the process is choosen as a deadlock victim) then ZeroDayPatch would simply terminate, causing the expected output to be delayed until the next scheduled run.

In order to avoid such problem I decided to catch exceptions around the critical paths (when we stage the bulletin or create the policy) and retry. At first I planned on retrying download and policy creations steps 4 times and exllude the bulletin on failure.

However during the test phase I noticed that the bulletin staging process already retires when a patch cannot...

Ludovic Ferre | 27 Nov 2013 | 0 comments

As you possibly have noticed we have anew version of the Patch Trending Site Builder executable and package.

The package contains everything you need for a fresh installation, however what do you need to do if you want to benefit from the changes in v15 without re-installing?

Here's a quick guide.

Part I: update the page getbulletin.html

Because version 15 introduces the /write-all option it will not over-write existing files. However there is only 1 file that really need to be updated: getbulletin.html, which is the page used to display the range-filter charts for the 'Compliance in %' and 'Installed versus Applicable' data.

So in order to get the page updated you have 3 options:

  • Run "site-builder /write-all" at least once after the v15 upgrade
  • Delete the file getbulletin.html before running the site builder, the latest version will be written down
  • Extract the update package attached...
Ludovic Ferre | 26 Nov 2013 | 0 comments

I have just released version 15 of the Patch Trending Site Builder. Here is the change log:

Release 15

This release contains a major codefix, a minor codefix and two important new features and a minor CLI change:

  • Code fix (1): Modified the getbulletin.html page to ensure it loads charts properly under various Internet Explorer versions (tested on Version 8, 9 and 10)
  • Code fix (2): Modified getbulletin.html to verify whether trending data exists or not for the requested entry. If not the message 'No data is available...' is displayed.
  • Feature (1): Added command line option /write-all to prevent the following static pages from being over-written with each site builder invocation (i.e. they will only be overwritten if you invoke 'sitebuilder.exe /write-all'):

    • inactive-computers.html
    • compliance-by-computer.html
    • getbulletin.html
    • webpart-fullview.html
    • menu.css
    • help...
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...