can we populate "IMEI number" attribute using SCCM integration? if yes how,

Mallikharjuna
Tera Contributor

can we populate "IMEI number"  attribute using SCCM integration? if yes how,

5 REPLIES 5

Pranay
ServiceNow Employee
ServiceNow Employee

Assuming you are using a JDBC type data source to get information from SCCM. You can modify the SCCM data source SQL query (field name: "SQL statement") to include this attribute. Once you are getting this data, modify your transform map (or Robust transform map if you are using Service Graph connector for Microsoft SCCM) to map this data to a field in a table, possibly a CMDB table that can hold this information.

can you please help with which query like the general table name from sccm (sample with "IMEI" number)?

Pranay
ServiceNow Employee
ServiceNow Employee

That depends on how and where your data is stored in SCCM.

Any valid SQL statement works from the ServiceNow platform side.

SELECT
    [IMEI field name] as imei,
    FROM [database name]
        where [filter]​

 

Practically, your SQL statement might be a little more complex than this, but you will get an idea from this.

I found this resource which may be helpful.  https://systemcenterdudes.com/sccm-intune-imei-numbers/

find_real_file.png


The opinions expressed here are the opinions of the author, and are not endorsed by ServiceNow or any other employer, company, or entity.