I need a custom report for SMS 2003. I know how to creat a new report, but that is where I hit the wall. I have no idea how to write the SQL queries needed.
I need a report that will:
Return system names from a selected Collection.
Return the Model information of each system.
Right now this is all i need, but I will want to add more info to the report in the future. So can you please explain the parts of the query and include the lines to add Total HD Space, Used HD Space, Total RAM, and Processor Name.