Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrade.
Please accept our apologies in advance for any inconvenience this might cause.

Endpoint Management Community Blog

Showing posts tagged with 7.x
Showing posts in English
SK | 20 Mar 2014 | 0 comments

Hello all,

Today I ran into the above mentioned problem whilst trying to perform a clean install of ITMS 7.5, so I thought I would share what worked and what didn't.

Windows 2008 SP1 R2 with SQL 2012 SP1.

SQL was initially configured for Windows Authentication.  When SIM failed, I manually created the database to no avail.

I then changed to mixed authentication and changed the SA account (as I obviously didn't know what the original one was) via the UI.  Unfortuantely, the SA account had the same problem.

 

What worked was running the following query:

USE master
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewSAPassword', CHECK_POLICY = OFF
GO
ALTER LOGIN [sa] ENABLE
GO

 

This allowed SIM to create the database and begin the installation phase.  Once ITMS 7.5 was installed, and the 9 hotfixes (required a rebot beforehand), I opened the Database Settings page and...

Ludovic Ferre | 14 Mar 2014 | 0 comments

With my customer we have moved from a central Software Update Policy model, using ZeroDayPatch, to avoid replication issues (we had some malfunctioning policies upon replication that caused a less than optimal compliance level).

It works very well, but we have some issues with some bulletins for which creating a policy was proving very difficult. The symptom is that when you create a new policy for the impacted bulletins, loading the policy will cause a general error (when you get the database error message). And on the "Home > Patch Management > Bulletin and Updates" grid view the bulletin will not show any policy associated even after a refresh.

To cut a long story short the problem lies in replication, as you could have guessed form the environment. The issue here is that revised updates are handled on the parent server and replicated down the hierarchy, however the update that was revised (the previous version), which is deleted on the parent, is not deleted...

SK | 06 Mar 2014 | 1 comment

The following query will list the contents of all item folders found within the console:

SELECT vi1.Name As Folder,vi2.Name AS Item
FROM vItem vi1
JOIN vItemFolder vif ON vif.ParentFolderGuid = vi1.[Guid]
JOIN vItem vi2 ON vi2.[Guid] = vif.ItemGuid
ORDER BY Folder,Item ASC
--WHERE vif.ParentFolderGuid = 'folderguid'
--WHERE vi1.Name = 'foldername'

If you wish to use one of the WHERE clauses, then make sure you remark (--) the ORDER BY line.

SK | 04 Mar 2014 | 1 comment

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

Ludovic Ferre | 24 Feb 2014 | 0 comments

As February is drawing to a close I thought I'd review the progress made this month on a few projects and report on some checks to be done.

First, let's look back at what I set to do in February [1]. I am almost there :D:

  • A wrap-up for aila2-version 1 containing a couple of installation files and the toolkit in a single zip --> _DONE_
  • A gauge control for Patch Compliance Trending to provide global compliance status at a glance --> _DONE_
  • A toolkit to link multiple Patch Trending sites to provide a global view for large environments <-- _NOT_DONE_
  • A Managed Delivery execution reporting toolkit, to display software execution over time --> _DONE_

I am also still working on the aila2 new features [2], with http return code stats done, hit count per IP Address done (not in the original plan, but needed...

Ludovic Ferre | 18 Feb 2014 | 0 comments

Today I was working with a customer on the quality of their inventory data in the CMDB. They have some questions about the data refresh, related to the (still on-going?) datahash problem [1].

 I'm honestly thinking that we should take some serious resolution to resolve the datahash problem outside of the product.

Now this is not what was interesting today. Rather I was saying to the customer that it would be great to have a dashboard where we could review the data quality quickly. After voicing this I went directly into SQL and crafted the query you can find below.

The result-set contains the following columns:

  • Data Class Guid
  • Data Class Name
  • Computer Count
  • Modified in the last 4 weeks
  • Not modified in the last 4 week
  • % up-to-date

The query tries to provide a clean result set (not returning internal data that doesn't relate to computer inventory). To achieve this result we only return...

Ludovic Ferre | 17 Feb 2014 | 0 comments

I have released aila2 at version 1 [1] a few weeks ago and have a fair few users already.

And some features requests coming in. So I have decided to publish the source code here, in case poeple want to extend the tool to match their own need, or just want to peer at the various project and programs.

Now, here are some fetaures that should be coming on version-2, but feel free to add on to the list, you never know - they may make it in ;-):

  • aila2 to account for http error codes (2xx, 3xx, 4xx, 5xx)
  • aila2 to report on specific Task Server interfaces
  • aila2-filter to add inclusion / exclusion based on return code type (2xx, 3xx...)
  • aila2-filter to add inclusion / exclusion based on the Web console traffic

[1] aila2: Version 1 Full Package with Installation and Execution Scripts

Ludovic Ferre | 10 Feb 2014 | 0 comments

I have progressed the Software Delivery trending tool quite nicely and has it often happen, the (interim) result drives the long term design.

So far I have 2 files for the toolkit: an executable that generate a Javascript output (based on the Evt_AeX_SWD_Execution table) and a web-page to display the java script as line charts (using the Google Chart API as usual).

You'll find a sample output at the end of this blog post.

There are a few design problem that were "solved" in the current build (we are still at version 0):

  • All the data is written into a single java script file
  • No more than 100 policies will be added to the js file
  • Visualization is based on a two column layout
  • By default 6 charts are displayed on a page view
  • You can set the view to at most 10 charts per page
  • Next and Previous Page navigation links allow to scroll thru the full data set
  • A home link allows the user to set the view...
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

Ludovic Ferre | 04 Feb 2014 | 0 comments

Introduction:

A few hours only past since my first post [1] on this matter, but there's nothing like Connect to keep the momentum.

So this evening I have 3 elements to add to the project:

  • The generic SQL query to summarise the content of the SWD Execution table
  • The houlry exec count per Advertisement Name
  • A sample page with a chart to validate the basic look and feel

SQL Query I:

The first query I ran is very simple: list all the software delivery execution in the event table by run count. Order the result by count descending, and lilmit the data set to 100 results, albeit we could limit the dataset to any policy that has more than n execution just as well:

select top 100 AdvertisementName , COUNT(*) as '#'
  from Evt_AeX_SWD_Execution
 group by AdvertisementName, AdvertisementId
 order by COUNT(*) desc

Note that we use the AdvertisementId field in the group by as a safety measure, in case we...