Discovery and Inventory Group

Expand all | Collapse all

Computer summary report with last communication detail

  • 1.  Computer summary report with last communication detail

    Broadcom Employee
    Posted 06-10-2015 12:35 PM

    Hello

    Looking for Computer summary report with last Communication detail.

    Anyone having SQL query for the same???



  • 2.  RE: Computer summary report with last communication detail

    Broadcom Employee
    Posted 07-27-2015 05:12 PM

    This is kind of a cheat but I use the client date field from basic inventory.

     This is a field  that reports what time the computer believed it was when sending basic inventory.  It is not 100 percent infallible but on the other hand it does not require processing for the MAX value.

    AEX AC Identdification.Client Date



  • 3.  RE: Computer summary report with last communication detail

    Broadcom Employee
    Posted 06-10-2015 01:47 PM

    Hi,

    maybe it is not beautiful query, but helps me a lot.

    It is just last config request per host:

    DECLARE @comp_name nvarchar(50)
    SET @comp_name = '%'
    
    SELECT
    	ident.Name
    	,MAX(conf_req._eventTime)
    FROM Evt_NS_Client_Config_Request AS conf_req
    JOIN Inv_AeX_AC_Identification AS ident
    	ON conf_req.ResourceGuid = ident._ResourceGuid
    WHERE ident.Name LIKE '%'+@comp_name+'%'
    GROUP BY ident.Name
    ORDER BY ident.Name

     

    Regards



  • 4.  RE: Computer summary report with last communication detail

    Posted 06-10-2015 02:01 PM

    Igor 

    The reports posted by me and others give a better response 

    https://www-secure.symantec.com/connect/forums/inactive-machines-report-primary-user

     



  • 5.  RE: Computer summary report with last communication detail

    Posted 06-12-2015 03:07 PM

    The views pull from the same fields I have in my sql query.

    the issue with the agent health in V7.6 is it does not return the Full inventory time. Which is driven by a policy - so i put in for a field someplace that tracks the last full inventory cycle time. 

    Its one of those things if you actually use the Inventory reports to the depth of the information provided - you must have full inventories. 

     



  • 6.  RE: Computer summary report with last communication detail

    Posted 06-10-2015 06:10 PM

    if i posted it - it was for the greater good of the community. =) 



  • 7.  RE: Computer summary report with last communication detail

    Broadcom Employee
    Posted 06-12-2015 07:30 AM

    In ITMS 7.6 there are some views allowing to collect information about agent connectivity with Notification Server.

    vAC_AgentHealth and based on it

    vAC_AgentCommunicationHealth - view returning latest communication time from agent to Notification Server ,

    vAC_AgentConfigurationHealth - view returning latest time when agent requested configuration policy from Notification server

    vAC_AgentBasicInventoryHealth - view returning latest time when Notification Server received basic inventory from agent.



  • 8.  RE: Computer summary report with last communication detail

    Broadcom Employee
    Posted 06-10-2015 03:08 PM

    sdmayhew, I didn't want to brake copyrights of your report :- )



  • 9.  RE: Computer summary report with last communication detail

    Broadcom Employee
    Posted 06-10-2015 12:41 PM

    Hi CBZ9104,

    please check information from this thread:

    Thanks,

    IP.