Inventory Report

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Inventory Report

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Inventory Report

Page: [1]

Message

<< Older Topic Newer Topic >>

Inventory Report - 6/9/2008 11:35:45 AM

jferguson234

Posts: 27
Score: 0
Joined: 6/14/2007
Status: offline

Hi all I was wondering if someone could point me in the direction of how I would get a inventory report but make that report as of 12/31/07. Is this possible? If so could you point me where to go. Thanks for any help you could give

Post #: 1

RE: Inventory Report - 6/9/2008 12:36:48 PM

skissinger

Posts: 2293
Score: 145
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline

The SMS Database is almost constantly updated with data from your SMS clients. The only way I can think of to get a snapshot-in-time report is to restore the database from a backup you took on 12/31/07. Perhaps your company creates year-end backups to tape? If you have a backup from that time, restore the SQL db to a test SQL Server (not to production!), and you could do SQL queries to create the reports you wish.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to jferguson234)

Post #: 2

RE: Inventory Report - 6/9/2008 1:49:15 PM

jferguson234

Posts: 27
Score: 0
Joined: 6/14/2007
Status: offline

Thank you for the response. James

(in reply to jferguson234)

Post #: 3