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?
Who is Participating?
LouSch7Connect With a Mentor Author Commented:
Ended up using the Active column from system table:

WHERE v_R_System.Active0 = 1
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
Eugene ZCommented:
to ensure  100% - as I said - run query against your active DB not during data collection
you could add the last hardware or software inventory date being less than 1 month.
LouSch7Author Commented:
Most complete answer
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.

All Courses

From novice to tech pro — start learning today.