Solved

SCCM 2007 SQL Query

Posted on 2012-03-14
5
626 Views
Last Modified: 2012-06-27
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
Comment
Question by:LouSch7
  • 2
  • 2
5 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 37724045
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
 
LVL 42

Expert Comment

by:EugeneZ
ID: 37724056
to ensure  100% - as I said - run query against your active DB not during data collection
0
 
LVL 10

Expert Comment

by:Kezzi
ID: 37724084
you could add the last hardware or software inventory date being less than 1 month.
0
 
LVL 3

Accepted Solution

by:
LouSch7 earned 0 total points
ID: 37853491
Ended up using the Active column from system table:

WHERE v_R_System.Active0 = 1
0
 
LVL 3

Author Closing Comment

by:LouSch7
ID: 37875103
Most complete answer
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

The use of stolen credentials is a hot commodity this year allowing threat actors to move laterally within the network in order to avoid breach detection.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now