...
URL | jdbc:sqlserver://SCCM;databaseName=SCCM_ITS | ||
---|---|---|---|
Query (initial) |
| ||
User | s_Service-Now2SCCM (see Windows group re: credentials) |
Data Contract
- The ITSM organization 'INF Windows Systems' department (Infrastructure group) is responsible for the source data contentsource; the POC is Adriene Radcliffe for now. Eventually this will have to be managed via other means yet to be specified (change management, delegates).
- spreadsheets containing data will exist at the above data source URLs (don't delete these files, or the integration will break)
- must remain XLS (Excel 97/2000) format
- must remain publicly accessible
- data will technical POC is Julio Valdes.
- data will be loaded daily at midnight
Load/Transform SN Links
Data Source - CMDB Business Services
Data Source - CMDB Provider Services
Data Source - CMDB Applications
...
Transformation Logic
- serial number, os version, and name are directly mapped.
- coalesce on serial number (target table enforces uniqueness).
- name, per the query, is the host + first FQDN suffix of the machine.
- os family is always 'Windows'
- group is always 'INF Windows Systems'
- ci owner is always manager of 'INF Windows Systems'