cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JKBH1
Level 10
Report Inappropriate Content
Message 1 of 3

Ingest to Splunk agent's last communication

Jump to solution

Hi @cdinet

I was able to pull a query in ePO to view which devices have communicated to ePO within the past week. I noticed the exact date in LastUpdate is customized based on the query I ran. How would this work with Splunk integration though if that exact date is provided in the SQL query within Splunk? Basically, I would like us to run a query in Splunk to give me the data on which servers have communicated to ePO within the past week.

Could [EPOLeafNode].[LastUpdate] >= '2021-12-06T16:55:31.041' be written as

[EPOLeafNode].[LastUpdate] >= 'last week'

I'm not sure if this is possible since LastUpdate schema is below. Please help. Thank you.

datetime

8

Date/Time value indicating the last time the system successfully performed an agent-server communication sequence.

---

select count(*) as 'count', [BooleanPieChart_Alias].[ChartColor], [BooleanPieChart_Alias].[ChartColor] from ( select ( case when ( ( [EPOLeafNode].[LastUpdate] >= '2021-12-06T16:55:31.041' ) and ( dbo.EPOFN_CompareVersions([EPOProdPropsView_EPOAGENT].[productversion], '1', 'gte') = 1 ) ) then 1 when ( not ( ( [EPOLeafNode].[LastUpdate] >= '2021-12-06T16:55:31.041' ) and ( dbo.EPOFN_CompareVersions([EPOProdPropsView_EPOAGENT].[productversion], '1', 'gte') = 1 ) ) ) then 0 else -1 end ) as ChartColor from [EPOLeafNode] left join [EPOProdPropsView_EPOAGENT] on [EPOLeafNode].[AutoID] = [EPOProdPropsView_EPOAGENT].[LeafNodeID] where ( [EPOLeafNode].[LastUpdate] >= '2021-11-30T16:55:31.041' ) ) as BooleanPieChart_Alias group by [BooleanPieChart_Alias].[ChartColor] order by [BooleanPieChart_Alias].[ChartColor] desc

1 Solution

Accepted Solutions
JKBH1
Level 10
Report Inappropriate Content
Message 3 of 3

Re: Ingest to Splunk agent's last communication

Jump to solution

Thanks @cdinet, you're spot on with the GETDATA() func. I worked with a DBA and he recommended the below query to get the past seven days data:

"[LastUpdate] BETWEEN GETDATE()-7 AND GETDATE()"

 

View solution in original post

2 Replies
cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 3

Re: Ingest to Splunk agent's last communication

Jump to solution

No, last week is not a valid parameter to search on.  You would need to get with a dba or splunk for syntax,.  They can use a GETDATE() function, but I am not a dba and don't know how to configure that.  Maybe someone else does.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

JKBH1
Level 10
Report Inappropriate Content
Message 3 of 3

Re: Ingest to Splunk agent's last communication

Jump to solution

Thanks @cdinet, you're spot on with the GETDATA() func. I worked with a DBA and he recommended the below query to get the past seven days data:

"[LastUpdate] BETWEEN GETDATE()-7 AND GETDATE()"

 

View solution in original post

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community