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?
restore right Databases
or run the query against your maun database..
the rest -- SSMS sql queries can be found here:
ALL SQL Queries