Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SCCM 2007 SQL Query

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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

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.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
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…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

721 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