Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

SCCM data pull

Jack62
Giga Guru

Evening all

 

I have setup the SCCM SGC integration in our dev instance and we are pulling data however we are only getting records in the low hundreds. When the infra team I am working with run my query (OOTB) on the database they get over 7k records. I can't work out why we are seeing such a different volume. Any thoughts?

 

Jack

8 REPLIES 8

luffy3478
Tera Guru

are you pulling the delta or full load? 

Jack62
Giga Guru

As far as I was aware the full load. Just left it out of the box for now. I am going into the SCCM-SG-SCCM Computer Identity data source and clicking load all records.

luffy3478
Tera Guru

is last run date time checkbox is cheked on data source?

Yup. My understanding is I should be going into the scheduled data import, click execute and then the others the follow from parent should trigger. When I run SCCM-SG-SCCM Computer OU this pulls in the 7.5k which is close to what the DB guys see there side using the same query I have in SG-SCCM Computer Identity, not sure if that confuses the issue or not.