Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.
Endpoint Management Community Blog
Showing posts in English
MS_ITMS | 26 Feb 2014 | 0 comments

Performance degradation can happen due to multiple reasons. The main bottlenecks that would affect performance are:

  1. Memory
  2. Disk IO
  3. CPU
  4. Blocking
  5. System resource contention
  6. Application design problems
  7. Queries or stored procedures that have long execution times

Please check the Article below which has articles from Symwise, Connect, Few Querys, 3rd Party Tools and Articles

Articles from SymWise

Creating a maintenance plan in SQL Server 2005 or 2008 to optimize database performance
http://www.symantec.com/docs/HOWTO8589

SQL Tuning and Performance
http://www.symantec.com/docs/HOWTO5289

Notification Server performance issues due to SQL index...

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

LS05 | 19 Feb 2014 | 0 comments

Here is the link to ITMS 7.5 HF4 Release Notes:
http://www.symantec.com/docs/DOC7126

General Availability of ITMS 7.5 HF4 via SIM. 

SK | 19 Feb 2014 | 1 comment

"Symantec™ IT Management Suite 7.5 HF4 powered by Altiris™ technology Release Notes" (http://www.symantec.com/docs/DOC7126)

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

SK | 12 Feb 2014 | 1 comment

If you have chosen to create your sites and subnets manually instead of importing them from AD, what is the easiest way to create filters that contain the computers associated with those sites?

The following query is one way of achieving this goal (another method would be to target the actual subnets contained in each site):

  SELECT ip._ResourceGuid
  FROM Inv_AeX_AC_TCPIP ip
  JOIN vSubnet sub ON sub.Subnet = ip.Subnet
  JOIN vSiteSubnetMap map ON map.SubnetGuid = sub.[Guid]
  JOIN vSite s ON s.[Guid] = map._ResourceGuid
  WHERE s.Name = 'name of site'

SK | 12 Feb 2014 | 0 comments

If you don't like drilling down into the usage report, here is a SQL query that you can run to find usage data either for all files that have been metered or for a specifc file:

SELECT rf.Name AS [File],c.Name AS Computer,wu.UserId,
ms.[Month Year],ms.[Run Count],ms.[Last Start]
FROM vAMMonthlySummary ms
JOIN vComputer c ON ms._ResourceGuid = c.[Guid]
JOIN Inv_Global_Windows_Users wu ON ms.UserGuid = wu._ResourceGuid
JOIN RM_ResourceFile rf ON ms.FileResourceGuid = rf.[Guid]
--WHERE rf.Name LIKE '%part of filename%' --provides data for specific file
ORDER BY c.Name,wu.UserId ASC

ianatkin | 12 Feb 2014 | 0 comments

 

 
There is a known issue with DS6.9 SP6 and WinPE4 which means that the PXE environment variables used in this article won't be set. To resolve this please take a look at  http://www.symantec.com/docs/TECH213143 and replace your startutl.bat batch file with the revised version in the tech note.
 
This is important for sites who use their DS6.9 PXE servers as image stores, and who therefore map a drive to  \\%ALTIRIS_PXE_IP%\images in Bootwiz to assist this process transparently across multiple PXE servers.
 
My google-fu failed to pick this tech note up and it took a fast response Altiris support ticket to track this one down. I've updated my "WAN Nirvana" article to reflect this.
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...