asked on SCCM 2007 SQL Query
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?
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?
Microsoft SQL Server 2005Windows OSMicrosoft Server OS
Last Comment
LouSch7
to ensure 100% - as I said - run query against your active DB not during data collection
you could add the last hardware or software inventory date being less than 1 month.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Most complete answer
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