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

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.

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 | 09 Sep 2013 | 0 comments

After I posted my previous blog entry [1] I went to implement a solution (for which the documentation is done and awaiting moderation to be release here on Connect).

It worked pretty well, but still we have far too many basic inventory coming in. A look at captured NSE's indicated that there is another problem with inventories hijacking the Basic Inventory Capture Item:

Sample 1:

<?xml version='1.0' ?>
<message>
<from><resource guid='{ffffff-ffff-ffff-ffff-ffffffffffff}' typeGuid='{493435F7-3B17-4C4C-B07F-C23E7AB7781F}'/></from>
<to>1592B913-72F3-4c36-91D2-D4EDA21D2F96</to>
<time>20130905211027.187000-120</time>
<body><inventory><dataClass guid="ca029e6b-f124-4399-9b91-10c41b73165b"><data><resource partialUpdate="true"><row PolicyGuid="ffffff-ffff-ffff-ffff-ffffffffffff" TaskInstanceGuid=...
Ludovic Ferre | 05 Sep 2013 | 2 comments

Today is riddle day. So here it is in full:

When is a basic inventory not a basic inventory?

When it's a custom inventory!!!

So, now this explains why we are getting thousands of customer inventory every day at my customer. The custom inventories are generated by VBS and as documented here on Connect [1] (and I'm sure in much of the product documentation) we generate NSE's with a msgTo element pointing to the Basic Inventory Dataclass:

'----------------------NOTIFICATION SERVER ENTRY STARTS HERE------------------
dim nse
set nse = WScript.CreateObject ("Altiris.AeXNSEvent")
nse.To = "{1592B913-72F3-4C36-91D2-D4EDA21D2F96}" 'Never change this guid, it is needed by NS.
nse.Priority = 1
dim objDCInstance
set objDCInstance = nse.AddDataClass ("{8284a0ad-b37f-4c9b-b0ad-cb92f97d7401}") ' Change this to math the guid of the custom data class
dim objDataClass
set objDataClass...
Marcello D'Angelone | 12 Aug 2013 | 0 comments
According to ssd-vs-hdd-report, Windows does not allow a reliable way to collect information about a SSD disks.
However we can identify the SSDs from the Inv_HW_Logical_Device data class.
  
You can copy the following query to create your own report:
 
SELECT
v.[Name] AS [Computer Name],
cs.[Model] AS [Computer Model],
hwl.Model,
ld.[Device ID] as Drive,
CAST((ISNULL(ld.[Size (Bytes)], 0)/(1024 * 1024 * 1024)) AS DECIMAL (10, 2)) AS 'Total Disk Space (GB)',
CAST((ISNULL(ld.[Free Space (Bytes)], 0)/(1024 * 1024 * 1024)) AS DECIMAL (10, 2)) AS 'Free Disk Space (GB)'

FROM vComputer v
INNER JOIN Inv_HW_Logical_Device hwl
ON v.Guid = hwl._ResourceGuid
INNER JOIN vHWComputerSystem...