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.
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 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 |
| Domain0 | Domain of the device |
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 |
