Client Management Suite

 View Only
  • 1.  Altiris 7.1 Custom Report - Oracle Discoverer

    Posted Jun 22, 2011 02:43 PM

    I need to create a custom report of every computer that has Oracle Discoverer Admin (a $5000 program) installed.  I have narrowed down the files present to:

    Discoverer Desktop default:  C:\oracle\BIToolsHome_1\bin\dis51usr.exe
    Discoverer Admin default:  C:\oracle\BIToolsHome_1\bin\dis51adm.exe

    The files show up in Organizational Views > Default > File

    I just don't know what tables to reference to create a report of all computers that have these files on them.  Can anyone help with this please?



  • 2.  RE: Altiris 7.1 Custom Report - Oracle Discoverer

    Posted Jun 23, 2011 10:57 AM

    Maybe this will get you started?  Enter this raw SQL into a report and see if it gets you what you need...

     

     

    SELECT vc.Name AS [Computer Name], ifd.Name AS [File Name], ifd.Path, sci.Name [Software Name]
    FROM ResourceAssociation ra
    JOIN Inv_Installed_File_Details ifd
       ON ifd.FileResourceGuid = ra.ChildResourceGuid
       AND ra.ResourceAssociationTypeGuid = 'EABE86D3-AAFD-487A-AF63-5C95D7511AF6'
    JOIN vRM_Software_Component_Item sci
       ON sci.Guid = ra.ParentResourceGuid
    JOIN vComputer vc
       ON vc.Guid = ifd._ResourceGuid
    WHERE LOWER(ifd.Name) IN ('dis51usr.exe','dis51adm.exe')


  • 3.  RE: Altiris 7.1 Custom Report - Oracle Discoverer

    Posted Nov 02, 2011 01:06 PM

    The query above did not return any results.  However if I run the query below I get results.  Could there be something wrong with the resource association part of it?

    SELECT vc.Name
          ,ifd.[Name]
          ,ifd.[Path]
    FROM Inv_Installed_File_Details ifd
    JOIN vComputer vc
       ON vc.Guid = ifd._ResourceGuid
    WHERE LOWER(ifd.Name) IN ('dis51usr.exe','dis51adm.exe')
    ORDER BY vc.Name



  • 4.  RE: Altiris 7.1 Custom Report - Oracle Discoverer

    Posted Nov 02, 2011 01:14 PM

    Try this:

    SELECT vc.Name AS [Computer Name], ifd.Name AS [File Name], ifd.Path, sci.Name [Software Name]
    FROM ResourceAssociation ra
    JOIN Inv_Installed_File_Details ifd
    ON ifd.FileResourceGuid = ra.ChildResourceGuid
    JOIN vRM_Software_Component_Item sci
    ON sci.Guid = ra.ParentResourceGuid
    JOIN vComputer vc
    ON vc.Guid = ifd._ResourceGuid
    WHERE LOWER(ifd.Name) IN ('dis51usr.exe','dis51adm.exe')


  • 5.  RE: Altiris 7.1 Custom Report - Oracle Discoverer

    Posted Nov 02, 2011 01:47 PM

    No results returned.



  • 6.  RE: Altiris 7.1 Custom Report - Oracle Discoverer

    Posted Nov 02, 2011 03:10 PM

     

    OK, I assumed each file was associated with at least 1 software component.  This query will still display the file details even if it isn't associated to a component.
     
    SELECT vc.Name AS [Computer Name]
          ,ifd.[Name] AS [File Name]
          ,ifd.[Path]
          ,ISNULL(sw.Name, '') AS [Software Name]
    FROM Inv_Installed_File_Details ifd
    JOIN vComputer vc
       ON vc.Guid = ifd._ResourceGuid
    -- Find associated software component, if one exists
    LEFT JOIN (SELECT sci.Name, ra.ChildResourceGuid 
               FROM ResourceAssociation ra
               JOIN vRM_Software_Component_Item sci
                  ON sci.Guid = ra.ParentResourceGuid 
               WHERE ra.ResourceAssociationTypeGuid = 'EABE86D3-AAFD-487A-AF63-5C95D7511AF6') sw
       ON ifd.FileResourceGuid = sw.ChildResourceGuid
    WHERE LOWER(ifd.Name) IN ('dis51usr.exe','dis51adm.exe')
    ORDER BY vc.Name


  • 7.  RE: Altiris 7.1 Custom Report - Oracle Discoverer

    Posted Nov 02, 2011 05:22 PM

    I guess Oracle does not allow for the association or Altiris does not immediately associate it with a component.