Symantec Management Platform (Notification Server)

Hi,

I'm trying to create a computer filter where the Primary User ID contains "TRP" from the code below, but with no success... What's wrong?

 ----
SELECT
   [Guid],
   [Name]
FROM
   [vComputer] 
WHERE
  [vComputer].[Primary User] like '%TRP'
 ----

The error message is this:

This DataSource is not in a runnable state.

When creating a filter, you'll only need the field Guid and no other column. The Primary User column in the view vComputer is actually named "User", and not "Primary User".

Hi

I dont think the column Primary User is available in the vComputer view, I might be wrong though.

The new silverlight interface (7.5 sp1 and later) is quite handy when it comes to creating filters.

This is the resolved query I got when using the report builder in 7.5 console (pre sp1 though, but it should work in sp1 aswell):

SELECT
   [vri1_Computer].[Guid],
   [vri1_Computer].[Name]
FROM
   [vRM_Computer_Item] AS [vri1_Computer]
      LEFT OUTER JOIN [Inv_AeX_AC_Primary_User] AS [dca2_AeX AC Primary User]
         ON ([vri1_Computer].[Guid] = [dca2_AeX AC Primary User].[_ResourceGuid])
WHERE
   (
      ([dca2_AeX AC Primary User].[User] LIKE N'%TRP')
   )

All of a sudden the filter just works. Thanks Rafael! :-)

Perhaps this is more complete

SELECT vc.Name AS Host, vu.Name AS UserName, vu.Department AS Departamento, vu.[Job Title] AS Cargo
FROM vComputer vc
RIGHT JOIN (SELECT DISTINCT Name FROM vComputer) AS vc1
ON vc1.Name = vc.Name
INNER JOIN vUser vu ON vc.[User] = vu.Name

with software

SELECT vc.Name AS Host, arp.DisplayName AS Software, arp.DisplayVersion AS Versão, vu.Name AS UserName, vu.Department AS Departamento, vu.[Job Title] AS Cargo
FROM vComputer vc
RIGHT JOIN (SELECT DISTINCT Name FROM vComputer) AS vc1
ON vc1.Name = vc.Name
INNER JOIN Inv_AddRemoveProgram arp ON vc.Guid = arp._ResourceGuid
INNER JOIN vUser vu ON vc.[User] = vu.Name