Solved

SCCM 2007 SQL Query

Posted on 2012-03-14
5
633 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 43

Expert Comment

by:Eugene Z
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 43

Expert Comment

by:Eugene Z
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
A small collection of useful tips and tricks for Windows 10 users that I decided to write as a result of recent questions that were asked and answered at Experts Exchange. Two short video tutorials included. Enjoy..
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

634 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