SCCM (System Center Configuration Manager) is one of the modules of System Center products by Microsoft. It helps you manage machines in your network and provides features like:


  • Remote control
  • Patch management
  • Software distribution
  • Operating system deployment
  • Network access protection
  • Hardware and software inventory


With the first version of the Freshservice-SCCM Integration, you can sync your Hardware and Software inventory and User information available in SCCM with the CMDB/Asset Management module and Requesters in your Freshservice account.


SCCM is integrated with Freshservice using the client tool, Freshservice Discovery Probe. The Probe will serve as a generic client tool for Freshservice, by accommodating future client out of box integrations.


NOTE: Make sure your account has db_datareader access to the server and that it's a local SQL account (and not a domain account) before performing these steps.


1. You can download Freshservice Probe from your Freshservice account. Go to the Admin tab and click on Discovery under Configuration Management.





2. While setting up Probe, you’ll need to choose the configuration type for it. Select SCCM Integration and click Next.


NOTE: You can switch back to the configuration window before authorizing Probe. Once you do authorize it, the only way to switch the configuration type is by uninstalling and reinstalling it.





3. On the Authorize screen, enter your Freshservice URLUsernamePassword and Proxy details if applicable. Click Authorize.





4. On the Connect SCCM screen, enter the details of the MSSQL Server with which SCCM is associated. The data will be fetched from the SCCM database of this server’s inventory.





The SQL Server connection will be verified before saving it. In case the details are incorrect, the Probe will display an error message.





5. On the Import screen, you can choose to import UsersAssets or both. If you do not want to import the lists immediately, you can skip to the next step.





6. You can use the Schedule Manager screen to schedule automatic SCCM imports.




Once the wizard is configured, you’ll be taken to the regular landing screen, where imported users and assets will be listed.


The Import Users and Import Assets buttons will facilitate immediate import. On clicking the import buttons, a loader will be displayed until the corresponding entities are imported.


If the SQL Server configuration changes by any chance, you will be prompted to verify it before starting the next import.




The SQL Server details can be changed later by going to Settings → SCCM Settings. You can configure and verify the SQL connection and then import users and assets without problems.


You can use the Settings tab for the import ScheduleProbe Info and SCCM settings.

 

Technical aspects

  • The Tables and Columns which need to be queried from MS SQL server for SCCM Inventory details are configurable JSONs. If column names or table names are changed in the future, then the corresponding changes can be made in the JSON file.

  • On every SCCM Asset import, the devices whose LAST HARDWARE SCAN TIME is greater than or equal to the maximum LAST HARDWARE SCAN TIME available in the Probe will be fetched.

  • By any chance, if probe windows service is stopped or the machine is shut down in the middle of an import, the import will be resumed the next time the machine is started.

  • The SCCM User import will fetch all the user details available in the SCCM without any constraint.

  • You can configure either SCCM or Network Discovery in an instance of Probe.



SCCM - SQL Server

Views and columns used for synchronizing Freshservice



v_GS_SYSTEM


Column name in the Table

Can be used as

ResourceID

Device Identifier

Domain0

Device domain

Name0

Host Name

SMSID0

Guid identifier of the device



v_GS_COMPUTER_SYSTEM


Column name in the Table

Can be used as

ResourceID

Device Identifier

Manufacturer0

Device Manufacturer(Vendor)

Model0

Model of the Device (Product)

UserName0

User Name



v_GS_COMPUTER_SYSTEM_PRODUCT


Column name in the Table

Can be used as

ResourceID

Device Identifier

UUID0

UUID

Version0

Used as Product for Lenevo kind of Manufacturers



v_GS_OPERATING_SYSTEM


Column name in the Table

Can be used as

ResourceID

Device Identifier

Caption0

OS Name

CSDVersion0

OS Pack

InstallDate0

OS Install Date

Manufacturer0

OS Manufacturer

Name0

Name

SystemDirectory0

System Directory

TotalVirtualMemorySize0

Virtual Memory

TotalVisibleMemorySize0

Ram

Version0

Version

WindowsDirectory0

Install directory



v_GS_SYSTEM_ENCLOSURE


Column name in the Table

Can be used as

ResourceID

Device Identifier

ChassisTypes0

Currently used to identify asset/CI Type in Probe and Agent

SerialNumber0

Bios Service Tag(Serial Number)

SMBIOSAssetTag0

Asset Tag



v_GS_PC_BIOS


Column name in the Table

Can be used as

ResourceID

Device Identifier

SerialNumber0

Bios Service Tag(Serial Number)

Version0

Version of BIOS



v_GS_WORKSTATION_STATUS


Column name in the Table

Can be used as

ResourceID

Device Identifier

LastHWScan

Last Scan Time by SCCM



v_GS_NETWORK_ADAPTER_CONFIGURATION


Column name in the Table

Can be used as

ResourceID

Device Identifier

DHCPEnabled0

DHCP Enabled Value

IPAddress0

IPV4 and IPv6 Address.

MACAddress0

Mac Address of the Adapter

IPEnabled0

IP Enabled Flag



v_GS_ADD_REMOVE_PROGRAMS

In this table 32 bit applications Info can be collected.

Column name in the Table

Can be used as

ResourceID

Device Identifier

DisplayName0

Display Name of the Software

InstallDate0

Install Date of Appliciation

ProdID0

Product Id of Application

Publisher0

Publisher of the Application

Version0

Version of Software



v_GS_ADD_REMOVE_PROGRAMS_64

64 Bit Application Details

Column name in the Table

Can be used as

ResourceID

Device Identifier

DisplayName0

Display Name of the Software

InstallDate0

Install Date of Appliciation

ProdID0

Product Id of Application

Publisher0

Publisher of the Application

Version0

Version of Software



v_GS_LOGICAL_DISK

Drive related details for components

Column name in the Table

Can be used as

ResourceID

Device Identifier

Description0

Disk Description

DeviceID0

Drive Name

DriveType0

Drive Type (Removable/Local)

FileSystem0

File System of Drive (NTFS/extFat)

Name0

Drive Name

Size0

Drive Size

FreeSpace0

Drive Free Space



v_GS_NETWORK_ADAPTER


Column name in the Table

Can be used as

ResourceID

Device Identifier

AdapterType0

Adapter Type

Description0

Description of Adapter (name)

MACAddress0

Mac Address of Network Adapter

Name0

Name of Adapter

NetworkAddresses0

<No Comments>Null in my DB

PermanentAddress0

<No Comments>Null in my DB



v_GS_PHYSICAL_MEMORY

Column name in the Table

Can be used as

ResourceID

Device Identifier

BankLabel0

Memory Bank label

Caption0

Caption

DeviceLocator0

Bank Locator

MemoryType0

Memory type

Speed0

Speed



v_GS_PROCESSOR


Column name in the Table

Can be used as

ResourceID

Device Identifier

Manufacturer0

Processor Manufacturer

Name0

Model

NumberOfCores0

Cores

MaxClockSpeed0

Speed of the Processor



v_R_User


Column name in the Table

Can be used as

ResourceID

User Identifier

User_Name0

sAMAccountName

Full_User_Name0

name

Mail0

mail

Windows_NT_Domain0

Domain

Object_GUID0

Object GUID