---
sourceDocument: Yokohama IT Operations Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/it-operations-management

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# SQL Server Analysis Services

# SQL Server Analysis Services (SSAS) discovery {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

The Discovery and Service Mapping application uses the SSAS pattern to find SQL Server Analysis Services (SSAS) on your infrastructure. Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store..

## Request new or enhanced Patterns on the ServiceNow® Store {#r-SSAS-MSSQL__id_dpy_jmm_tyb}

Visit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/application/06a71b1367e4130051c9027e2685ef1e/1.6.0?referer=/store/search?listingtype=allintegrations%253Bancillary_app%253Bcertified_apps%253Bcontent%253Bindustry_solution%253Boem%253Butility%253Btemplate&q=Patterns&sl=sh) to view all the available updates and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the [ServiceNow Store version history release notes](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).{#r-SSAS-MSSQL__p_d21_nfg_h1c}

## Prerequisites {#r-SSAS-MSSQL__section_vc4_pgy_syb}

Verify the applications are up to date.
:   Discovery and Service Mapping Patterns
:   CMDB CI Class Models
:   Visibility Content

Verify the configuration of credentials
:   On the ServiceNow AI Platform®, verify the configuration of the Windows credentials. For more information, see [Windows credentials](https://www.servicenow.com/docs/access?context=r_WindowsCredentialsForm&version=yokohama&pubname=yokohama-platform-security&ft:locale=en-US)

## Data collected during horizontal discovery {#r-SSAS-MSSQL__section_aqs_wyl_r2b}

Discovery populates the following data when running the SSAS pattern.  
{#r-SSAS-MSSQL__table_bqs_wyl_r2b__entry__1}{#r-SSAS-MSSQL__table_bqs_wyl_r2b__entry__4}

| SQL Server Analysis Services \[cmdb_ci_db_mssql_analysis\] |||
| Label | Field | Description |
|-|-|-|
| Name | name | The SSAS on the Windows sever name |
| IP Address | ip_address | The SSAS IP address |
| Version | version | The SSAS version |
| Edition | edition | The SSAS edition |
| Installation directory | install_directory | The SSAS install directory |
| Instance Name | instance | The SSAS instance name |
| TCP port(s) | tcp_port | The SSAS TCP port |
[ ]

{#r-SSAS-MSSQL__table_bqs_wyl_r2b}