Symantec Management Platform (Notification Server)

Hi,

I've been given the task to create a SQL query to gain the following information on all my managed computers.  Any help is much appriciated.

Here is the info that is needed on in the report:

Thanks again! 

You should be able to find the information you need in the following tables and views:

• vComputer (Computer Name, OS, Primary Username)
• Inv_AddRemoveProgram (Lotus Notes and Office Version)
• Inv_HW_Logical_Disk (Disk Free Space)
• Inv_Global_User_General_Details (This is more user based than anything but will give an idea of where the machine is)

Here is the complete code incase anyone is looking for similar information:

 select pc.[Name] as 'Computer Name',
        pu.[User] as 'Primary User',
		pc.[OS Name] as 'OS Name',
		pc.[OS Type] as 'OS Type',
		pc.[OS Version] as 'OS Version',
		pc.[OS Revision] as 'OS Revision', 
        rp.DisplayName as 'Program Name',
		rp.DisplayVersion as 'Program Version',
		dsk.[Device ID] as 'Drive',
		dsk.[Free Space (Bytes)]/1048576 as 'Free Space (MB)'
 from dbo.Inv_AeX_AC_Identification pc
 left join dbo.Inv_AddRemoveProgram rp on pc._ResourceGuid=rp._ResourceGuid
 join dbo.Inv_AeX_AC_Primary_User pu on pu._ResourceGuid=pc._ResourceGuid
 join dbo.Inv_HW_Logical_Disk dsk on dsk._ResourceGuid=pc._ResourceGuid
 where
 (rp.DisplayName like 'Microsoft Office Standard%' or rp.DisplayName like 'Microsoft Office Prof%'or rp.DisplayName like 'IBM Notes %' or rp.DisplayName like 'Lotus Notes %')
 and dsk.[Device ID]='c:'