Views [dbo].[UCAPMR_TierCalculation]
(local) > mdb > Views > dbo.UCAPMR_TierCalculation
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created1:33:10 PM Monday, January 04, 2010
Last Modified1:33:10 PM Monday, January 04, 2010
Columns
Name
assetlookup.assetid
assetlookup.assetname
assetlookup.hostname
assetlookup.item.itemname
assetlookup.item.abbreviatedname
assetlookup.processorcount
assetlookup.processorspeed
SQL Script
CREATE VIEW dbo.UCAPMR_TierCalculation AS SELECT DISTINCT "at".own_resource_uuid AS "assetlookup.assetid", "at".resource_name AS "assetlookup.assetname", "at".host_name AS "assetlookup.hostname", "at.it".name AS "assetlookup.item.itemname", "at.it".abbreviation AS "assetlookup.item.abbreviatedname", "at".processor_count AS "assetlookup.processorcount", "at".processor_speed AS "assetlookup.processorspeed" FROM dbo.ca_owned_resource "at" LEFT OUTER JOIN dbo.ca_model_def "at.it"  ON "at".model_uuid="at.it".model_uuid LEFT OUTER JOIN dbo.ca_resource_family "at.atty"  ON "at".resource_family="at.atty".id
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved