Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

query for retired systems

Created: 02 May 2013 | 3 comments

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.

Operating Systems:

Comments 3 CommentsJump to latest comment

Andrew Bosch's picture

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

------------------------------------
Sr. Principal SQA Engineer
Symantec

Briandr88's picture

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.

Andrew Bosch's picture

Sorry, I fixed it.

------------------------------------
Sr. Principal SQA Engineer
Symantec