When you want to create a custom report in System Center Configuration Manager 2007 you can use existing objects in SQL SCMM database or you can create? new SQL objects using SQL Server Management Studio.
 

1. Create a new SQL object

Open SQL Server Management Studio
Use Object Explorer: [Server name] > Databases > [SCCM Database] > [...]