---
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


---

# Microsoft SQL Server Integration Services

# Microsoft SQL Server Integration Services (SSIS) 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 SSIS pattern to find SQL Server Integration Services (SSIS) 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 {#ms-ssis-pattern__id_xl5_ngy_syb}

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).{#ms-ssis-pattern__p_d21_nfg_h1c}

## Prerequisites {#ms-ssis-pattern__section_vc4_pgy_syb}

Verify the plugins setup
:   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 {#ms-ssis-pattern__section_aqs_wyl_r2b}

Discovery populates the following data when running the SSIS
pattern.  
{#ms-ssis-pattern__table_bqs_wyl_r2b__entry__1}{#ms-ssis-pattern__table_bqs_wyl_r2b__entry__4}

| SQL Server Integration Services \[cmdb_ci_db_mssql_integration_list\] |||
| Label | Field | Description |
|-|-|-|
| Name | name | The SSIS on the Windows sever name |
| IP Address | ip_address | The SSIS IP address |
| Version | version | The SSIS version |
| Edition | edition | The SSIS edition |
| Installation directory | install_directory | The SSIS install directory |
| Instance Name | instance | The SSIS instance name |
[ ]

{#ms-ssis-pattern__table_bqs_wyl_r2b}