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

SCCM 2007 SQL Query

I have a few queries I would like to be able to perform so that I can then do a daily dump of data from the SCCM SQL Database to another system.  Right now I am specifically looking for items such as Host Name, IP Address, MAC Address, Serial Number, Model and number of monitors attached.

The question I have is... What do I need to add to a query or query on rather to ensure that the data result I get only includes current records?
0
LouSch7
Asked:
LouSch7
  • 2
  • 2
1 Solution
 
Eugene ZCommented:
to insure:

restore right Databases
or run the query against your maun database..
the rest -- SSMS sql queries can be found here:

ALL SQL Queries
http://sms2003-sccm2007.blogspot.com/2008/08/all-sql-queries.html
0
 
Eugene ZCommented:
to ensure  100% - as I said - run query against your active DB not during data collection
0
 
KezziCommented:
you could add the last hardware or software inventory date being less than 1 month.
0
 
LouSch7Author Commented:
Ended up using the Active column from system table:

WHERE v_R_System.Active0 = 1
0
 
LouSch7Author Commented:
Most complete answer
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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