Symantec Management Platform (Notification Server)

Does anyone have a report for CMS7 which will show these results, I have tried to create a custom report using the custom wizard but it is faily limited in what you can bring back all in one report.

I have created a simple custom report showing just the Username and IP, this seems to show everyone on our network but I'd like it to show Office version and computer name if poss.

Here's the query converted to SQL you can also see the 2 fields I've used to create the report in the SQL code below shwon in bold.

DECLARE @v1_TrusteeScope nvarchar(max)
   SET @v1_TrusteeScope = N'%TrusteeScope%'
SELECT
   [vri2_Computer].[Guid] AS [_ItemGuid],
   [vri2_Computer].[Name],
   [dca4_AeX AC Primary User].[User],
   [dca3_AeX AC TCPIP].[IP Address]
FROM
   [vRM_Computer_Item] AS [vri2_Computer]
      LEFT OUTER JOIN [Inv_AeX_AC_TCPIP] AS [dca3_AeX AC TCPIP]
         ON ([vri2_Computer].[Guid] = [dca3_AeX AC TCPIP].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_AeX_AC_Primary_User] AS [dca4_AeX AC Primary User]
         ON ([vri2_Computer].[Guid] = [dca4_AeX AC Primary User].[_ResourceGuid])
WHERE
   (
      ([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
   )
Is it possible to customise this further or best to start a fresh?

Thanks

Shaun

What about something like this?

SELECT vc.name, vc.[IP Address], arp.DisplayName, arp.DisplayVersion, arp.Publisher, arp.ParentDisplayName FROM Inv_AddRemoveProgram arp

JOIN vComputer vc ON vc.Guid=arp._ResourceGuid

WHERE DisplayName LIKE '%Office%'

You can create a new Computer Report and then convert it to a SQL query and paste this in.

thanks for the reply, that is something like I was after, what SQL would I need to add to include the primary user of the machine and reduce the amount of returns for office as it brings back everything related to office in add remove, I'm only really looking to report on who's got which office version here.

Looks like I'm going to have to get the hang of SQL a little bit to develop custom reports for ourselves.

Thanks again anyway mclemson

Something like this then

SELECT vc.name, vc.[IP Address], arp.DisplayName, arp.DisplayVersion, arp.Publisher, arp.ParentDisplayName, aapu.[User]

FROM Inv_AddRemoveProgram arp

JOIN vComputer vc ON vc.Guid=arp._ResourceGuid

JOIN Inv_AeX_AC_Primary_User aapu ON aapu._ResourceGuid=vc.Guid

WHERE (DisplayName='Microsoft Office Enterprise 2007' OR DisplayName='Microsoft Office <Edition and Year>)

I'm not getting the primary user showing as a column in the report with this,  I had to edit the WHERE statement to suit how it displays but that was no problem.

Thanks for your help,