Skip navigation
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
This discussion is archived
263 Views 0 Replies Latest reply: Jan 3, 2013 12:19 PM by pboedges RSS
pboedges Apprentice 71 posts since
Jan 20, 2009
Currently Being Moderated

Jan 3, 2013 12:21 PM

Initial Agent Communication

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

More Like This

  • Retrieving data ...

Bookmarked By (0)