Client Management Suite

 View Only

  • 1.  Table Name

    Posted May 16, 2012 02:53 AM

    Hi All,

    Can anyone help me getting the table name for the following data which shows in a Client's Resource Manager. We are using SMP7.1 SP1.

    Agent Last Configuration Request, Last Inventory Received and Last Event Received

     



  • 2.  RE: Table Name

    Posted May 23, 2012 04:47 PM

    There are various tables used for this, and calculations are made to determine what the most recent event was.  For example, this would tell you the last time each computer requested a new configuration.

     

     select vc.Name,max(StartTime) as 'Max start time'  
          from CollectionMembership cm  
          join vComputer vc on cm.Resourceguid = vc.Guid
          left join Evt_NS_Client_Config_Request cr  
            on cm.ResourceGuid = cr.ResourceGuid
            GROUP BY vc.Name
     
    ludovic_ferre's post is a good place to start if you are interested:
     
    Does this help answer your question?


  • 3.  RE: Table Name

    Posted May 24, 2012 09:21 AM

    From the, There Is More Than One Way to Skin a Cat Dept: 

    Pull it directly from the agent with a custom inventory script.