Reporting Group

Sorry for the basic SQL question, but I need a report that only shows 3 columns for all computers in CMS - computer name, hardware serial number and last date that computer communicated to CMS.  I think Client Date is close enough as I need the day it last communicated, the exact time isn't as important.

I have this report that has the info I need in it, but it also has about 15 other columns my boss doesn't want to get.  How can I narrow down the report to only show those 3 columns?

select * 
 
FROM dbo.Inv_AeX_AC_Identification ac
left join (SELECT     _ResourceGuid, MAX([user]) AS [primary user]  
FROM         dbo.Inv_AeX_AC_Primary_User   
WHERE     ([User] IS NOT NULL) AND ([User] <> '') 
GROUP BY _ResourceGuid  ) Prime                          
on ac._resourceguid =  Prime._ResourceGuid
LEFT OUTER JOIN  dbo.Inv_Global_Windows_Users  T20                                                                                        
ON Prime.[primary user] = t20.[USERID] 
LEFT OUTER JOIN dbo.Inv_Global_User_General_Details  T10                                                                                        
ON t20._ResourceGuid = T10._ResourceGuid 

Thank you.  I wish I had the time to truly understand how to do reporting in CMS, or if their was a better web interface for building reports.  Our Mac Management tool is so much more user friendly in that regard.

Try: select ac.[name], ac.[HW Chassis Serial Number], ac.[Client Date] FROM ... The best way to create your own queries is to use SQL Server Management Studio on a test system, expand the Symantec database, right-click on Views > New View. You can then select the views and database tables you want to get info from (Inventory tells you what table the info is from) drag and drop Joins in the top pane and use the second pane to select the fields you want and put in filters (for example: like '%windows%') and then run it and the third pane will show what the SQL query looks like.