# CMS_GetProperty

> Returns a property from the property table in the SQL database.

Source: https://docs.capaone.com/capainstaller/vb-scripting-library/cms-functions/cms-getproperty/  
Product: CapaInstaller — a separate CapaSystems product; do not apply this page to any other.

### Description

Returns a property from the property table in the SQL database.

### Syntax

**VBScript**

```vb
CMS_GetProperty(Prop) As string
```

**PowerShell**

```powershell
[string] CMS_GetProperty -prop <property>
```

### Parameters

#### Prop (String)

Name of property.

### Property whiteList

To protect the property table, only the following properties can be queried;

- CapaOneOrgId
- CapaOneOrgKey
- CapaOneOrgName
- CapaOneOrgTag
- CapaOneBaseUrl

### Return value

**VBScript**

Result will be stored in gsValue

**PowerShell**

Result will be returned as the result of the function

### Example

**VBScript**

```vb
If bStatus Then bStatus = CMS_GetProperty("CapaOneOrgName")
```

**PowerShell**

```powershell
$property = CMS_GetProperty -prop 'CapaOneOrgName'
$cs.Job_WriteLog("CapaOneOrgName" ,"$property")
```

[Scripting Guidelines](/capainstaller/vb-scripting-library/scripting-guidelines/)

### Related functions

[Constants](/capainstaller/vb-scripting-library/addendum/constants/) [Package Property](/capainstaller/vb-scripting-library/addendum/package-property/) [Variables](/capainstaller/vb-scripting-library/addendum/variables/) [Business Unit support](/capainstaller/vb-scripting-library/addendum/business-unit-support/)