Client Management Suite

 View Only

  • 1.  Tables in Altiris Database

    Posted Apr 04, 2012 04:38 PM
      |   view attached

    Hi,

    I'm user NS 7.0. I am creating customize report for client inventory, what is the tables for gather information of "Retired Date" in image.


    Thanks.



  • 2.  RE: Tables in Altiris Database

    Posted Apr 05, 2012 10:49 AM

    Hi Felipe,

    Could you please try this query? Today I´m without my Asset lab to test this query.

    -----------

    SELECT i1.Name AS Asset, rt.Name AS [resource type], i2.Name AS

    Status, i1.Guid , i2.CreatedDate

    FROM ResourceAssociation ra INNER JOIN

    Item i1 ON i1.Guid = ra.ParentResourceGuid INNER

    JOIN

    Item i2 ON i2.Guid = ra.ChildResourceGuid INNER

    JOIN

    ItemResource ir ON ra.ParentResourceGuid = ir.Guid

    INNER JOIN

    ResourceType rt ON rt.Guid = ir.ResourceTypeGuid

    WHERE (ra.ResourceAssociationTypeGuid =

    '3028166F-C0D6-41D8-9CB7-F64852E0FD01') AND (i2.Name LIKE 'retired')

    ----------
    Regards,