Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SCCM 2007 SQL Query

Posted on 2012-03-14
5
Medium Priority
?
640 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 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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..
In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

972 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