Hardware & Software Inventory Report

[Guest_imported]

Hello everyone,

I need to create two reports from SMS 2.0 using Crystal Reports. Backend being SQL2k
Reports are:
1. Hardware Info in a LAN
2. Software Info in a LAN.
I would like to know the name of the tables that SMS automatically creates in the SQL DB for this purpose.

Any help would be appreciated....

 

[RodTrent]

Just an FYI: SMS 2003 will no longer include the Crystal snap-in. Microsoft is putting heavy resources behind their Web Reporting tool, and you'll see a lot of integration with that.

You may want to load up the Web Reporting tool and take a look at the stock reports. I believe the reports you are looking for are already there.

MS Web Reporting information:

http://www.myitforum.com/articles/1/view.asp?id=1423

But, if the reports you are looking for are not there, you can always customizing the Web Reporting tool:

http://www.myitforum.com/inc/upload/787Customizing Web Reports.zip

http://www.myitforum.com/inc/upload/5246CustomWebReporting.ppt

Rod Trent
Microsoft.MVP.SMS
=======================================
Main site:

http://www.myITforum.com

=======================================