Is there a way that I can pull all the projects created using the particular template? I am on On Demand Environment and I dont have database access.
You could use the Power Filter on the Project List to filter by Project Template. Never personally filtered by this attribute, but hopefully it will give you required results.
In relation to your comment 'On Demand and not having database access', you do have database access. This is available by JasperSoft Studio, which includes JDBC Drivers.
You can add the field Originating Template to the project list screen (or to the filter), to see the name of the template from which the project was created.
As roland.parrotte said above, you can use Jaspersoft Studio to query the database. You can also use SQL Squirrel: regoXchange :: CA PPM SaaS JDBC Connecting - Oracle SaaS