Symantec Management Platform (Notification Server)

Good day,

We received a request from a software vendor to generate a report of all our machines, and software that are installed on the machine including the path (path).

I searched in Altiris 7.2 and support, but was unable to generate anything that suited the request ..

Here's an example of what we need if anyone can help

Host - Software - Path
Test - Symantec Endpoint Protection 12 - C: \ Program Files (x86) \ Symantec \ Symantec Endpoint Protection

Here also we have so far, without the path

SELECT DISTINCT comps.Guid [Guid]
       ,comps.Name [Computer Name]
       ,prods.[Name]
       ,spv.[Version]
       ,company.Name [Company]
FROM vRM_Software_Component sc
JOIN Inv_InstalledSoftware inst
   ON inst._SoftwareComponentGuid = sc.Guid
   AND inst.InstallFlag = 1
JOIN (SELECT ra.ChildResourceGuid, spi.Guid, spi.Name 
      FROM vRM_Software_Product_Item spi
      JOIN ResourceAssociation ra
         ON ra.ParentResourceGuid = spi.Guid
         AND ra.ResourceAssociationTypeGuid = '9D67B0C6-BEFF-4FCD-86C1-4A40028FE483'
     )prods
   ON prods.ChildResourceGuid = sc.Guid
JOIN dbo.Inv_Software_Product_State sps
    ON sps._ResourceGuid = prods.Guid
    AND sps.IsManaged = 1
JOIN dbo.Inv_Software_Product_Version spv
        ON spv._ResourceGuid = prods.Guid
JOIN (SELECT vci.Guid, vci.Name
      FROM vRM_Computer_Item vci
      LEFT JOIN ResourceAssociation resAssoc
         ON vci.Guid = resAssoc.ParentResourceGuid
         AND resAssoc.ResourceAssociationTypeGuid = '3028166F-C0D6-41D8-9CB7-F64852E0FD01' --Asset Status
      WHERE (resAssoc.ChildResourceGuid = '0A0203A5-D2B6-49f1-A53B-5EC31A89437C' OR resAssoc.ChildResourceGuid IS NULL) -- ONLY Active Computers
      ) comps
   ON comps.Guid = inst._ResourceGuid
LEFT JOIN (SELECT ra.ParentResourceGuid AS softProdGuid, rc.Name
           FROM RM_ResourceCompany rc
           JOIN ResourceAssociation ra
              ON ra.ChildResourceGuid = rc.Guid
              AND ra.ResourceAssociationTypeGuid = 'D5C66D5A-7686-4CA2-B7C1-AC980576CE1D'
           ) company
   ON company.softProdGuid = spv._ResourceGuid
ORDER BY prods.Name, comps.Name

Sorry,

I was unaware of this report, and even support not indicated to me he ..

I got now.

Thank U.

SELECT distinct ci.[Guid], 
    ci.[Name] [Computer Name],
    fd.Name [File Name],
    wf.Manufacturer [Manufacturer],
    fd.Path [File Path]
FROM vRM_Computer_Item ci
      JOIN dbo.ScopeMembership sm1
            ON sm1.[ResourceGuid] = ci.Guid

      JOIN 
      ( dbo.Inv_Installed_File_Details fd
  
            LEFT JOIN Inv_File_Details ifd
                  ON ifd._ResourceGuid = fd.FileResourceGuid                  
            JOIN dbo.vWindowsFile wf
                  ON wf.Guid = fd.FileResourceGuid
                  AND (wf.ProductName like '%')

      )
      ON fd._ResourceGuid = ci.Guid
            AND LOWER (ci.[Name]) LIKE LOWER ('%')
            where ci.IsManaged = 1
ORDER BY ci.Name