Client Management Suite

 View Only

  • 1.  Altiris Report

    Posted Oct 24, 2013 12:47 AM

    How do i customise report for a perticular software?

    Thanks in Advance. 



  • 2.  RE: Altiris Report

    Posted Oct 24, 2013 01:22 AM

    Check this SQL query

    Zac H

    How about this?

     

    SELECT vc.Guid, vc.Name AS ComputerName, arp.DisplayName, arp.DisplayVersion, vu.Name AS UserName, vu.Department
    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
    WHERE arp.DisplayName LIKE 'Adobe Flash Player 10%' AND arp.InstallFlag=1
     
    Or
     
    Trusted Advisor mclemson Comments

    There are default reports available for you if you go to Reports > All Reports, then expand Reports > Discovery and Inventory > Inventory > Cross-platform > Software/Applications > Installed Software or Installed Software by Computer. For example, using the Installed Software report, type '%Adobe%' for the Company OR '%Lync%' for the Name

    https://www-secure.symantec.com/connect/forums/how-get-report-altiris-71#comment-8284511

     



  • 3.  RE: Altiris Report

    Posted Oct 24, 2013 03:06 AM

    Hi  Zac H,

     

    I used querty provided by you but there is error msg like "

    Msg 208, Level 16, State 1, Line 1

    Invalid object name 'vComputer'.

    "

    and for other solution(Or)
     
    it shows only counts version wise so i use to go in details and collect details for each version that is time consuming..
     
    Please suggest..


  • 4.  RE: Altiris Report



  • 5.  RE: Altiris Report

    Posted Oct 30, 2013 12:12 AM
     
     
    Do you need more help here?