Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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