Client Management Suite

I am working with altiris and it is Integrated to Active directory, now problem is

need to export report of computers OU and Sub OU wise. please suggest.

There's a canned report under Reports/All Reports/Notification Server Management/Microsoft Active Directory called Microsoft Active Directory Resources by Container that should be close to what you're looking for.

Hope it will be helpful to you...

DECLARE @v1_TrusteeScope nvarchar(max)
   SET @v1_TrusteeScope = N'%TrusteeScope%'
SELECT
   [vri2_Resource].[Guid] AS [_ItemGuid],
   [vri2_Resource].[Name]
FROM
   [vRM_Resource_Item] AS [vri2_Resource]
WHERE
   (
      ([vri2_Resource].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
   )
 

SELECT v1.[Name],
v1.Guid as 'ResourceGuid'
v1.[OS Name]
FROM vComputer v1
WHERE v1.Guid in (SELECT ResourceGuid FROM ScopeMembership WHERE ScopeCollectionGuid='GUID-of-the-GROUP-goes-here')
ORDER BY v1.Name

Just drop there WHERE ScopeCollectionGuid='GUID' part if you don't want to report on a specific group. I'm not a SQL expert, but give this a try.

Hi,

You can get the report in Reports/All Reports/Notification Server Management/Microsoft Active Directory/Container Members by Operating System Detail

form above report you have computers report for all domain, you can filter as your needs.