0 Replies Latest reply: Jan 3, 2013 12:21 PM by pboedges RSS

    Initial Agent Communication

    pboedges

      Was hit by a request recently, one in which i wasn't prepared for.  "Can you tell me what day this particular system first communicated with ePO?", "How about a site(s) of systems?"  I knew the information was in the database the question was how to get it out and into a reportable format.

       

      I submit the sql script below as my solution.

       

      Update dbo.EPOComputerProperties

      Set UserProperty1 =(Select NodeCreatedDate FROM dbo.EPOLeafNode WHERE dbo.EPOLeafNode.AutoID =dbo.EPOComputerProperties.ParentID)

       

      The script queries the "NodeCreatedDate" from the "dbo.EPOLeafNode" table and appends it to the "UserProperty1" field in the "dbo.EPOComputerProperties" table.  I have set a job to run this once a week and i am able to generate a report that shows "Custom 1" which contains the date information i require.

       

      IMO it would be nice to have this already part of the default System Information view.

       

      on 1/3/13 1:21:06 PM GMT-05:00