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

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

Ludovic Ferre | 04 Feb 2014 | 3 comments

January was a busy month with the release of aila2 here on Connect.

Interestingly enough it feels like I have spent much more time documenting the tool-kit and features than coding it, and I'm not completely done yet.

So, in order to motivate myself to publish some long awaited articles or downloads, here's a quick list of things to come:

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

The 1st item is almost complete and was used in a few production environment already and should be available real soon.

The 2nd and 3rd items are needed because we have large customers moving to my...

SK | 31 Jan 2014 | 5 comments

Today marks the last day that my community status will display Symantec Employee.

I will endeavour to maintain a community presence; however, I do not know how frequent this will be.

SK | 28 Jan 2014 | 5 comments

If you are testing Application Metering either in the lab or during a POC, you may wish to have the Application Metering Agent (AMAgent) send its data in a timely fashion, as its UI only offers either Daily or Weekly.

The following queries will allow you to do just this as well as to revert back to the original setting afterward for supportability:

--/ Obtain existing value (default = 86400)

SELECT State FROM Item WHERE [Guid] = '97D80113-8FE1-4ABD-AB08-EC7C8DDBDEF5'

--/ Change default using value in seconds (this example is for 5 minutes)

UPDATE Item SET State = '<item><Application type="inventory" interval="360" /></item>' WHERE Guid = '97D80113-8FE1-4ABD-AB08-EC7C8DDBDEF5'

--/ Rollback

UPDATE Item SET State = '<item><Application type="inventory" interval="86400" /></item>' WHERE Guid = '97D80113-8FE1-4ABD-AB08-EC7C8DDBDEF5'

Chad Dupin | 22 Jan 2014 | 0 comments

 ITS_Altiris_Roadshow_Header.png

We’re loading up the RV and hitting the road with Symantec to talk about Altiris 7.5. And We’re Coming To A City Near You.

Okay, we’re not actually loading up an RV, but it sure would be fun if we could!  We’re so excited to be part of this big release. The Altiris experts from ITS will review the 7 and a half reasons everyone should consider upgrading to the Altiris 7.5 platform. We’ll provide an overview of the features and capabilities that are new to the 7.5 platform, as well as how those will enable better management of your IT environment. You’re probably asking yourself, what are we actually going to talk about? Here’s what we’ll be covering:

  • Cloud Enabled Management
  • Deployment Solution
  • Macintosh Management
  • Performance
  • Platform Support
  • Automation
  • ...
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>

Ludovic Ferre | 20 Jan 2014 | 1 comment

Hotfix 3 for 7.5 was released to the public via the symantec.pl.xml. Below is a view of the changes from the xml file:

Revision: 987e0744f747
Author:   Ludovic FERRE <ludovic.f...@gmail.com>
Date:     Mon Jan 20 13:50:07 2014 UTC
Log:      Symantec.pl.xml md5 = 482cc8bd7ed41a7e3e6931e31f2d4c3e

http://code.google.com/p/ns7pl/source/detail?r=987e0744f747

Added:
 /solutions/7_5_hf3/cmdb/cmdb_hf3x64.msi_info
 /solutions/7_5_hf3/ds/deploymentsolutionlanguages_hf3_x64.msi_info
 /solutions/7_5_hf3/ds/symantec_deploymentsolution_7_5_hf3_x64.msi_info
 /solutions/7_5_hf3/monpack/monitorpackservers_hf3_x64.msi_info
 /solutions/7_5_hf3/pm/altiris_patchmanagementlinux_7_5_hf3_x64.msi_info
 /solutions/7_5_hf3/sim/...