The vComputer view provides an easy access to managed computers, however in very large reporting server this view (built on many other abstration) is taking a lot of time to run and is not the most efficient base to built report. How could we provide similar information without the overhead?

The following SQL query will return the guid, name, IsManaged, server (based on OwnerNSGuid) from the database using 3 tables and 2 joins.

create view dbo.vComputer2 as
select ir.Guid, ir.IsManaged, im.Name, ns.name as 'Server'
  from ItemResource ir
  join Item im
    on ir.guid = im.guid
  join Item ns
    on im.ownernsguid = ns.guid
 where ResourceTypeGuid='493435F7-3B17-4C4C-B07F-C23E7AB7781F'

On a reporting server with 60,000+ managed computers this query ran in 12 seconds returning 62,921 rows. In...

Deployment Solution for Solaris is a new solution that provides a customer the ability to rapidly deploy Solaris operating systems. It enables Scripted Installations of Sun Solaris, without requiring a Jumpstart server, or image-based deployment of Sun Solaris which leverages the power of mature technology from the Veritas Provisioning Manager product set. The solution will support SPARC hardware for Scripted OS Installations, and both SPARC and x86/x64 hardware for imaging deployments. It is natively built upon the Symantec Management Platform which allows for greater flexibility and scalability in today's enterprise customer. Being build on the Symantec Management Platform also ensures seamless integration with other Symantec products such as Altiris Server Management Suite or Altiris IT Management Suite.

Please visit the Endpoint Management Solutions Beta site on Connect found at Groups > Product Groups > Beta > Endpoint Management Solutions Beta to access...

Here's a quick SQL query I wrote for a customer of mine who needed to rename a few (varying count) number of Notification Servers on the tiered NS and Global Reporting Server. The problem spurred from the servers being renamed, which doesn't really change in the NS world (i.e. the NS are not updated with the new name in the different tiers).

So again, thanks SQL for letting us take control and fix issues directly.

use altiris
begin tran
set nocount on

declare @continue as int
    set @continue = 1
 
declare @watchdog as int
    set @watchdog = 0
 
declare @ns_guid as uniqueidentifier
declare @server_name as varchar(255)
 

while @continue = 1
begin
  set @watchdog = @watchdog + 1
 
  set @ns_guid = (
         select top 1 guid
           from item
          where classguid = '736EB7DF-1940-4F77-BE1B-CEB8E2DF6F4F'
            and name like '<name_pattern_here>%'  /* Note that this only work if the server naming convention allows us to...

I have a customer with some issue on a server, and has it happened a fair few software updates did not replicate for a while, and now we are struggling to get the PS to be fully synchronized in a low bandwidth environment where network blockouts are in place from 0900-1900.

In the process we crafted a SQL query to highlight how much data has to be replicated to Package Servers.

Here is the SQL query I crafted:

select pa.name, pk.name, count(*) as 'Package to replicate', cast(pk.[Package Size] / (1024.0*1024.0) as decimal(6,2)) as 'Package size in MiB', cast(pk.[Package Size] / (1024.0*1024.0) as decimal(6,2)) * count(*) as 'MiB to replicate'
  from ResourceAssociation ra
  join Item ch -- Software Update
    on ra.ChildResourceGuid = ch.Guid
  join Item pa -- Software Bulletin
    on ra.ParentResourceGuid = pa.Guid
  join ResourceAssociation ra2
    on ch.guid = ra2.parentresourceguid
  join Item it2
    on ra2.childresourceguid = it2...