• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1003
  • Last Modified:

SCCM Query

Hi,

I am trying to pull the SCCM data into third party tool.The third party tool is quering the SCCM database using SQL and fetching the data.
There is one issue with SCCM data . When i query the system_data data i am getting 882 records but when i am quering the system_disc table i am getting 922 records. Can someone let me know the reason for this difference in records.

Regards,
Mitesh
0
amol_dbhatt
Asked:
amol_dbhatt
1 Solution
 
amol_dbhattAuthor Commented:
Added the SCCM zone.
0
 
Nagendra Pratap SinghDesktop Applications SpecialistCommented:
What tool is it?
0
 
amol_dbhattAuthor Commented:
I am using Service-now ITIL tool to integrate with SCCM that uses the JDBC probe to query the SCCM database and pull the information.
0
 
merowingerCommented:
use the sql view
v_R_System
this includes all Client records
0
 
KezziCommented:
it might depend on machines that are discovered havwe not run any data collections.  so AD import has worked but tyhe sccm client is either not installed or may be in an unknown state.  try run the discovery data cycle on machines showing up in your all systems collection as N/A, or Not Approved etc, also make sure obsolete records are removed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now