Versions Compared

Old Version 5

changes.mady.by.user Former user

Saved on

compared with

New Version 6

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

URL

jdbc:sqlserver://SCCM;databaseName=SCCM_ITS

Query (initial)

Code Block
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'

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 be loaded daily at midnight

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

...

  • technical POC is Julio Valdes.
  • data will be loaded daily at midnight