Symantec Management Platform (Notification Server)

 View Only

  • 1.  How to customize the "Computer" query

    Posted Sep 11, 2009 09:34 AM
    I am looking to customize the “Computer” query located on the Resource Tab > Resources> Configuration Items> IT> Computer.
     
    I would like to modify the query “Show: All Computers” with some Fields from the “Show: All Unmanaged Computers” for example the serial number and System number.
     
    Does anyone know where this query is stored?
     
    http://altirislive/Altiris/AssetContractCommon/AssetListPage.aspx?itemguid=493435f7-3b17-4c4c-b07f-c23e7ab7781f&resourcetypeguid=493435f7-3b17-4c4c-b07f-c23e7ab7781f


  • 2.  RE: How to customize the "Computer" query

    Posted Sep 11, 2009 05:08 PM
    Kemcinte,

    The data displayed on the Resources tab is fixed in format; you can't modify it AFAIK without breaking your console.  What you want is a report.  A basic report would be something like:

    SELECT vc.Name AS [Computer Name], vc.[OS Name], vc.[User] AS [Primary User], ISNULL(sn.[Serial Number], 'Unknown') AS [Serial Number], CASE vc.IsManaged WHEN 1 THEN 'Yes' ELSE 'No' END AS [Is Managed] FROM vComputer vc LEFT JOIN Inv_AeX_HW_Serial_Number sn ON vc.Guid = sn._ResourceGuid ORDER BY vc.Name ASC



  • 3.  RE: How to customize the "Computer" query

    Posted Sep 14, 2009 06:01 PM

    The two things under the Resources tab are your Collections (groups essentially) and your Data Classes. As Kyle mentioned don't jack with those. Create new reports under the Report tab and use the SQL query builder to make custom reports, or write them by hand and paste the SQL in.