Get Printer Details from SCCM

Sanjay27
Tera Contributor

Hi All,

I want to get Printer Data from SCCM like we get Computer Identity etc via Data sources.

Previously, SCCM was not having Printer Data but now its available.

So can any one provide me the details like while configuring the Data source for SCCM for Printer class, what will  be SQL query or any related info.

 

Thanks in advance

1 REPLY 1

DaveHertel
Kilo Sage
Kilo Sage

Hi - 

1. understand the exact SCCM (SQL) table and fields where the desired data (printers) are.  What fields do you need and their field types

2. review existing SCCM data sources (like computer identity) and create a new data source, very similar to it... but pointing to the SCCM table you wish to pull from.

3. Determine the exact SQL query you need. Look at existing queries, I presume it would be similar to model from... but this is where you will have to figure it the specifics on your own.

4. once you have a data source that is pulling in the desired data, you'll need to transform it.  since this is a custom solution (i.e. printers are not part of the OOB SCCM setup), you need to build transform maps to map the incoming data to the right fields.    

5.  OOB, viewing the robust transform maps that are part of the Service Graph Connector for SCCM is not easily seen. The robust transform maps are not clearly/easily exposed in the OOB install of SCCM.  I recommend installing the IntegrationHub ETL studio here... which enables you to create/manage robust transforms.

6. Use the IntegrationHub ETL to view existing maps for other SCCM data sources.  You'll have to build your own robust transform map for Printers.. it'll likely be similar to something like the mapping for Computer identities.  Of course, your destination class will be Printers... but its the same basic idea

7.  After you have the data source and robust transform map built, then the source can be added to the sequence of SCCM sources that are pulled via the SCCM import job

 

Hope this helps some?