(EA)<sup>2</sup> supplies some SQL Server user-defined views that leverage the (EA)<sup>2</sup> metamodel to provide context not available from the views.
fnGetClassifiedName
This function returns an instance's classified name, i.e. the instance's name along with its classifier's name concatenates with a double colon. For example, a Server named SCMS-101 (the instance name) that was made from a Server Model of Compaq DL350 (the classifier's name), will have a classified name of SCMS-101::Compaq DL350. If the instance's name is blank, then the classifed name will simply be a double colon followed by the classifier's name.
Parameters:
InstanceName nvarchar(255)
ClassifierName nvarchar(255)
ClassifierID int
Return: nvarchar(255)
fnGetDeploymentStatus
This function determines the deployment status for the given life-cycle dates. The possible status values are.
Parameters:
ActualBeginDate : nvarchar(10)
ActualEndDate : nvarchar(10)
PlannedBeginDate : nvarchar(10)
PlannedEndDate : nvarchar(10)
Return: nvarchar(150) whose values can be "Was planned to be deployed", "Future deployment", "Unplanned", "Will be deployed", "Retired", "Will be retired", "Planned Retirement", "Missed retirement", "Deployed, Unknown", or one of several invalid values that indicate problems with the input dates.
fnGetProvisionedStatus
This function detemines the provisioned status for the given life-cycle dates, the status date, and the first year to be compared with.
