Symantec Management Platform (Notification Server)

 View Only
  • 1.  Altiris Report

    Posted Jun 16, 2013 05:48 AM

    I need the solution about altiris report, from where i can get the report of system serial number?



  • 2.  RE: Altiris Report
    Best Answer

    Posted Jun 16, 2013 06:03 AM

     Search by this report

    Computers by Serial Number

      A list of computers by serial number.

     



  • 3.  RE: Altiris Report
    Best Answer

    Posted Jun 16, 2013 06:11 AM

    Report is available

    Report - Discovery and Inventory --- Inventory --- Cross-platform -- Hardware -- Serial Number -- Computers by Serial Number



  • 4.  RE: Altiris Report



  • 5.  RE: Altiris Report

    Posted Jun 18, 2013 03:28 PM

    If your like me you hate using the built in report module. I wrote this simple query for you run it against your SQL CMDB and it will return Name - OS - Manufacuter - Model - Serial

     

    Select
    
           vc.[Name] AS Computer_Name,
    
           vc.[OS Name] as Operating_System,
    
           s.[Manufacturer] [System Manufacturer],
    
           s.[Model] [Computer Model],
    
           s.[Identifying Number] [Serial Number]
    
        
    
    FROM
    
           vComputer vc
    
           JOIN dbo.vHWComputerSystem s
    
        ON s.[_ResourceGuid]=vc.Guid
    
        
    
     
    
    ORDER BY
    
           vc.[Name]