The first time setup portal does not load any computers. The frames all load but no data is shown

Products

• IT Management Suite

Issue/Introduction

The First Time Setup Portal (Under SMP Console Home> First Time Setup) does not load any computers.  The frames all load but no data is shown.

Computer counts on First Time Setup Portal (aka FTSP) page are zero after upgrading to 8.0 HF4 from 7.6 HF7. No errors noted in logs.

When trying to load the page:

http://localhost/Altiris/SetupPortal/Default.aspx?&ConsoleGuid=1b22db4e-a898-443f-9b99-855b1653d3f5

This is what we see:

Environment

ITMS 8.0 HF4

Cause

Issue is cause by low performance of [sp_SetupGetComputers] stored procedure in FTSP: not optimal trustee scope calculation.

Resolution

This issue has been reported to Symantec Development team. A fix has been included under ITMS 8.0 HF5.

In case that you can upgrade to HF5 yet, if can use the following workaround:

1. Update the following stored procedure on your Symantec_CMDB database:

Alter Procedure sp_SetupGetComputers     

(       

 @Trustee NVarChar(255),       

 @CreatedDate DateTime       

)       

As       

Set NoCount On       

CREATE TABLE #tmp_scope (Guid uniqueidentifier not null PRIMARY KEY)

INSERT INTO #tmp_scope SELECT ResourceGuid FROM fnGetTrusteeScopedResourcesByType('493435F7-3B17-4C4C-B07F-C23E7AB7781F', @Trustee, 1)

if exists (select id from dbo.sysobjects where id = object_id(N'[dbo].vHWInventoryResults') and [type] = 'V')  

Begin 

  Select comp.Guid, comp.Name, comp.[OS Name], comp.IsManaged, CONVERT(datetime, comp.CreatedDate, 5) as [CreatedDate], comp.[IP Address], CONVERT(datetime, ir.[Collection Time], 5) As [InventoryCollectionTime]

  From vComputer comp             

  JOIN #tmp_scope rc ON rc.Guid = comp.Guid

  LEFT JOIN (SELECT _ResourceGuid, CONVERT(datetime, MAX ([Collection Time]), 5) As [Collection Time]

From dbo.vHWInventoryResults Group By _ResourceGuid ) ir ON comp.Guid = ir._ResourceGuid

  Where comp.CreatedDate > @CreatedDate

End 

Else 

Begin 

  Select comp.Guid, comp.Name, comp.[OS Name], comp.IsManaged, CONVERT(datetime, comp.CreatedDate, 5) as [CreatedDate], comp.[IP Address], null As [InventoryCollectionTime]

  From vComputer comp

  JOIN #tmp_scope rc ON rc.Guid = comp.Guid

  Where comp.CreatedDate > @CreatedDate

End

 

DROP TABLE #tmp_scope