Client Management Suite

 View Only
  • 1.  Report Computer <-> OU

    Posted Jan 14, 2011 04:50 AM

    Hi

     

    I'm searching for a Report  that is diplaying what Computers are in what Altiris Ou's.

    example

    Host                 Ou1           Ou2             Ou3

    computer1         1                  2

    computer2                                                3

    Is there a premade Report, a other display option or how can i achieve this goal?

     

    Thank you



  • 2.  RE: Report Computer <-> OU

    Posted Jan 14, 2011 01:05 PM

    I'm fuzzy on the numbers.  A computer can only exist in a single group in Altiris.  Does host represent a server or site server, or does host represent a computer client?  Are you wanting to know where computer resources exist in relation to an Active Directory view that includes groups synchronized with OU's?



  • 3.  RE: Report Computer <-> OU

    Posted Jan 14, 2011 05:45 PM

    There is a pre-built report in NS 6 called "Microsoft Active Directory Resources by Container".  It is in Reports > Notification Server Infrastructure > Active Directory.  Can you give an example of what your "OU1" would show?  Something like:

     

    Computer Name OU1  
    MYPC1 OU=Desktops,OU=Site1,OU=MySites,DC=DOMAIN,DC=COM  
    SERVER1 OU=Servers,OU=Site1,OU=MySites,DC=DOMAIN,DC=COM  

    As mclemson said, a machine can only be in a single OU...or are the numbers above a count of computers per ou?



  • 4.  RE: Report Computer <-> OU

    Posted Jan 17, 2011 02:18 AM

    I'm not interested in the Active Dircetory OU but in the Altiris OU.

    I think a computer in Altiris can be a Member of different OUs (ofcourse not in the AD).

    I import the Computers form Active directory and afterwards i add them manually to different  Altiris OUs (because of license Issues and Delegation of Control). If i miss to add a computer its very difficult to find because i need to compare manually the membership of all computers.

    A Report with the Membership of Altiris OUs would be helpful to easily identify missing or misplaced computers.



  • 5.  RE: Report Computer <-> OU

    Posted Jan 17, 2011 09:58 AM

    Altiris can have multiple organizational views.  For example, let's say we have an Active Directory view (based on an AD synchronization), an Operating System view, and a Geographic view.

    Within a view, a computer can exist in only one group.  Therefore, the MRZ-EXCH server can exist in the 'Exchange 2010 Back-End Servers' group within the Active Directory view, within the 'Windows Server 2008 R2' group within the OS view, and within the 'Minneapolis' group in the Geographic view.

    Would Thomas Baird's solution in this thread assist you?
    https://www-secure.symantec.com/connect/forums/sql-query-organizational-group

    Taking out some extra stuff, it would look like this if you wanted to report on a specific group:
    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.



  • 6.  RE: Report Computer <-> OU
    Best Answer

    Posted Jan 21, 2011 02:03 AM

    I solved the Problem with a different approach.

    I made a Software delivery Task and added all computers and excluded the Computers of a specific group. So i got the difference.

    Unfortunately there is only a way to export as a filter but not as csv/pdf ect.
    Not a great way but atleast a help.