Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Intro

Server CI data are collected in two ways:

  • periodic SCCM data import (federated data about Windows servers)
  • periodic SNMP discovery (instrumented data about UNIX servers)

Use Cases

The initial requirement is to:

  • deliver an updated list of servers (Infrastructure groups, Windows and UNIX)

...to which ITIL users can associate incidents, changes, or problems, as with other CI types.

Fields

These are the target fields, and are subject to the following conditions:

Servers

Business Service Field Label

Rules

"Serial Number"

text, must be unique. Not normalized for case, characters, etc, so must be exact.

"Name"

text

"State"

assumed 'Active' if inserted/updated

"Functional Sponsor"

reference to a sys_user record in ServiceNow

"Assignment Group"

reference to a sys_user_group record, assumed to be the first matching 'INF Windows Systems'

"Service Owner"

assumed manager of the 'INF Windows Systems' group

Data Sources

CMDB: SCCM Servers

URL

jdbc:sqlserver://SCCM;databaseName=SCCM_ITS

Query (initial)

{{SELECT Upper(v_GS_SYSTEM.Name0) + '.' + Upper(v_gs_System.Domain0) 'Name', u_Operating_Systems.OperatingSystem 'Operating System Version', v_GS_OPERATING_SYSTEM.CSDVersion0 'Patch Level', .
V_GS_PC_BIOS.SerialNumber0 'SerialNumber'
FROM v_GS_SYSTEM INNER JOIN v_GS_OPERATING_SYSTEM ON v_GS_SYSTEM.ResourceID = v_GS_OPERATING_SYSTEM.ResourceID
inner JOIN
v_GS_PC_BIOS on v_GS_SYSTEM.ResourceID = v_GS_PC_BIOS.ResourceID
join
u_Operating_Systems on substring(v_GS_OPERATING_SYSTEM.Version0,0,4 ) = u_Operating_Systems.VersionNumber
order by 'Operating System Version'}}

Data Contract

  • The ITSM organization is responsible for the source data content; 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 be loaded daily at midnight

Data Source - CMDB Business Services
Data Source - CMDB Provider Services
Data Source - CMDB Applications

ยน To find categories as maintained by the Request Process, use the Category on the desired instance; URI:
/sc_category_list.do?sysparm_userpref_module=544cce908795810094ad56926d434de8&sysparm_view=CMDB

  • No labels