Last updated: 2019-09-13

Source: https://support.freshservice.com/support/solutions/articles/205230-how-to-integrate-sccm-with-your-freshservice-account

With the Freshservice-SCCM Integration, you can sync your Hardware, Software inventory and User information available in SCCM with the Freshservice.

SCCM is integrated with Freshservice using the Discovery Probe.

You can download Discovery Probe from your Freshservice account. While setting up Probe, you’ll need to choose the configuration type for it. Select SCCM Integration and click Next. The Probe will now automatically authenticate to Freshservice.

Upon successfully authenticating the Probe withFreshservice, you can connect to SCCM using either the SQL credentials or Windows Credentials. Enter the SQL Server Name, Port, Database Name and Instance Name where the SCCM device and user info is available.

You have two options to authenticate to SCCM.

  • If you use SQL Credentials, the SQL user should have data read permissions (db\_datareader) on this database.

  • For Windows Credentials, the user (domain user) should have data read permissions (db\_datareader) on the database.

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

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

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

    Once the wizard is configured, you’ll be taken to the 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 Schedule, Probe Info and SCCM settings.

    Points to note

  • 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 TableCan be used as
    ResourceIDDevice Identifier
    Domain0Device domain
    Name0Host Name
    SMSID0Guid identifier of the device

    v\_GS\_COMPUTER\_SYSTEM

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    Manufacturer0Device Manufacturer(Vendor)
    Model0Model of the Device (Product)
    UserName0User Name
    Domain0Domain of the device

    v\_GS\_COMPUTER\_SYSTEM\_PRODUCT

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    UUID0UUID
    Version0Used as Product for Lenevo kind of Manufacturers

    v\_GS\_OPERATING\_SYSTEM

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    Caption0OS Name
    CSDVersion0OS Pack
    InstallDate0OS Install Date
    Manufacturer0OS Manufacturer
    Name0Name
    SystemDirectory0System Directory
    TotalVirtualMemorySize0Virtual Memory
    TotalVisibleMemorySize0Ram
    Version0Version
    WindowsDirectory0Install directory

    v\_GS\_SYSTEM\_ENCLOSURE

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    ChassisTypes0Currently used to identify asset/CI Type in Probe and Agent
    SerialNumber0Bios Service Tag(Serial Number)
    SMBIOSAssetTag0Asset Tag

    v\_GS\_PC\_BIOS

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    SerialNumber0Bios Service Tag(Serial Number)
    Version0Version of BIOS

    v\_GS\_WORKSTATION\_STATUS

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    LastHWScanLast Scan Time by SCCM

    v\_GS\_NETWORK\_ADAPTER\_CONFIGURATION

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    DHCPEnabled0DHCP Enabled Value
    IPAddress0IPV4 and IPv6 Address.
    MACAddress0Mac Address of the Adapter
    IPEnabled0IP Enabled Flag

    v\_GS\_ADD\_REMOVE\_PROGRAMS

    In this table 32 bit applications Info can be collected.

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    DisplayName0Display Name of the Software
    InstallDate0Install Date of Appliciation
    ProdID0Product Id of Application
    Publisher0Publisher of the Application
    Version0Version of Software

    v\_GS\_ADD\_REMOVE\_PROGRAMS\_64

    64 Bit Application Details

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    DisplayName0Display Name of the Software
    InstallDate0Install Date of Appliciation
    ProdID0Product Id of Application
    Publisher0Publisher of the Application
    Version0Version of Software

    v\_GS\_LOGICAL\_DISK

    Drive related details for components

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    Description0Disk Description
    DeviceID0Drive Name
    DriveType0Drive Type (Removable/Local)
    FileSystem0File System of Drive (NTFS/extFat)
    Name0Drive Name
    Size0Drive Size
    FreeSpace0Drive Free Space

    v\_GS\_NETWORK\_ADAPTER

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    AdapterType0Adapter Type
    Description0Description of Adapter (name)
    MACAddress0Mac Address of Network Adapter
    Name0Name of Adapter
    NetworkAddresses0<No Comments>Null in my DB
    PermanentAddress0<No Comments>Null in my DB

    v\_GS\_PHYSICAL\_MEMORY

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    BankLabel0Memory Bank label
    Caption0Caption
    DeviceLocator0Bank Locator
    MemoryType0Memory type
    Speed0Speed

    v\_GS\_PROCESSOR

    Column name in the TableCan be used as
    ResourceIDDevice Identifier
    Manufacturer0Processor Manufacturer
    Name0Model
    NumberOfCores0Cores
    MaxClockSpeed0Speed of the Processor

    v\_R\_User

    Column name in the TableCan be used as
    ResourceIDUser Identifier
    User\_Name0sAMAccountName
    Full\_User\_Name0name
    Mail0mail
    Windows\_NT\_Domain0Domain
    Object\_GUID0Object GUID