Solved

SCCM 2007 SQL Query

Posted on 2012-03-14
5
629 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Know what services you can and cannot, should and should not combine on your server.
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…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

823 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