We help IT Professionals succeed at work.

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?
Comment
Watch Question

EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT

Commented:
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
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT

Commented:
to ensure  100% - as I said - run query against your active DB not during data collection

Commented:
you could add the last hardware or software inventory date being less than 1 month.
Commented:
Ended up using the Active column from system table:

WHERE v_R_System.Active0 = 1

Author

Commented:
Most complete answer

Explore More ContentExplore courses, solutions, and other research materials related to this topic.