Symantec Management Platform (Notification Server)

 View Only

  • 1.  Need a Report for Active machine from last "N" days

    Posted Apr 12, 2013 04:59 PM

     

    Team, 

    I need to create a report for all computers in NS that were active in the last 60 days, with Name, Make, Model, OS and Type. 

    Suggestion greatly appreciated 

     



  • 2.  RE: Need a Report for Active machine from last "N" days

    Posted Apr 13, 2013 02:11 PM

    Hi Manny123,

    In this HOWTO you will find info to querys this type of information (HOWTO21590 - Which tables hold the last configuration request and last inventory received values?)

    http://www.symantec.com/docs/HOWTO21590

    Regards,

    Fábio Sanches



  • 3.  RE: Need a Report for Active machine from last "N" days
    Best Answer

    Posted Apr 17, 2013 03:20 PM

     

    I got the SQL Query
     
    SELECT     vc.Name, vc.Domain, vc.[OS Name], ictr.IsActive, ictr.LastRegistered, DATEDIFF(dd, ictr.LastRegistered, GETDATE()) AS Days, ihld.Manufacturer, ihld.Model,
                          ihld.[Device ID]
    FROM         dbo.vComputer AS vc LEFT OUTER JOIN
                          dbo.vHWComputerSystem AS ihld ON vc.Guid = ihld._ResourceGuid LEFT OUTER JOIN
                          dbo.Inv_Client_Task_Resources AS ictr ON vc.Guid = ictr._ResourceGuid
    WHERE     (ictr.IsActive = 1) AND (DATEDIFF(dd, ictr.LastRegistered, GETDATE()) < 60)