Client Management Suite

 View Only

  • 1.  query for retired systems

    Posted May 02, 2013 01:52 PM

    Hi,

     

    I am looking for a quick and easy query that will give me a list of systems the NS 7.1 Purge 'Retired'. Help is appreciated.



  • 2.  RE: query for retired systems

    Posted May 02, 2013 05:55 PM

    Hi,

    Thanks for the help, but the SELECT rc.*  returns the folloowing error when ran:

     

    The column prefix 'rc' does not match with a table name or alias name used in the query.

     

     

     

     



  • 3.  RE: query for retired systems

    Posted May 02, 2013 05:58 PM

     

    SELECT ci.*

    FROM vRM_Computer_Item ci

    JOIN ResourceAssociation ra

       ON ra.ParentResourceGuid = ci.Guid

       AND ra.ResourceAssociationTypeGuid = '3028166F-C0D6-41D8-9CB7-F64852E0FD01'

       AND ra.ChildResourceGuid = '492C463B-AFA2-4DD6-AE73-6FD2C7B0E489'  --Retired



  • 4.  RE: query for retired systems

    Posted May 02, 2013 05:58 PM

    Sorry, I fixed it.