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

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

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 | 19 Jan 2014 | 0 comments

Here is an overview of how I am currently using the aila2 tools release here on Connect to provide updated data to users.

Only a couple of elements are missing from the image below:

  • A run batch file provides the processing core to sequence aila2-runner and aila2-siteconfig
  • An install batch provide the aila2-web configuration and files to the IIS directory

aila2 processing overview.png

More information will come on this implementation, with the full kit to install and run the aila2 set to your SMP or Site Servers.

SK | 17 Jan 2014 | 0 comments

I have just updated my article by adding a comment that includes the SQL behind the new view that ITMS 7.5 adds to "Manage > Software".

https://www-secure.symantec.com/connect/articles/s...

SK | 31 Dec 2013 | 1 comment

After a clean install of ITMS 7.1.2 MP1.1 v7RU, it was found that it was not possible to create a new CMDB rule as its first dropdown list failed to open.

To workaround this issue, you need to clone a sample CMDB rule and then modify it to suit your needs.

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