This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

SQL Query for DDR Heartbeat excluding the other agent times

Question
0

Sign in to vote
Is there a way in SCCM SQL queries to collect the machines' DDR Heart Discovery agent time on its own, without including the remaining agent times (AD Discovery, etc...) in that field?
- Edited by F.Dagher Saturday, February 8, 2014 12:45 AM typo
Saturday, February 8, 2014 12:44 AM

Answers

0

Sign in to vote
This query will get you started.

http://smsug.ca/blogs/garth_jones/archive/2008/02/02/pc-s-hearthbeat-discovery-data.aspx
http://www.enhansoft.com/
- Marked as answer by Jason Sandys [MSFT]MVP Sunday, February 9, 2014 4:12 AM
Saturday, February 8, 2014 3:50 AM

All replies

0

Sign in to vote
This query will get you started.

http://smsug.ca/blogs/garth_jones/archive/2008/02/02/pc-s-hearthbeat-discovery-data.aspx
http://www.enhansoft.com/
- Marked as answer by Jason Sandys [MSFT]MVP Sunday, February 9, 2014 4:12 AM
Saturday, February 8, 2014 3:50 AM
0

Sign in to vote

Thanks!

Can this be queried in WQL as well?

Tuesday, February 11, 2014 3:49 PM
0

Sign in to vote

You should be able to convert it to WQL. However you would have to manually create it.
http://www.enhansoft.com/

Tuesday, February 11, 2014 7:09 PM
0

Sign in to vote

Does anyone know the corresponding attribute class name for the view AgentDiscoveries? Can't find it anywhere in the query wizard.

Tuesday, February 11, 2014 7:25 PM
0

Sign in to vote

It will NOT be in the wizard, try sms_agentdiscoveries
http://www.enhansoft.com/

Thursday, February 13, 2014 4:10 PM
0

Sign in to vote

Can't see that in the wizard either

Tuesday, February 18, 2014 5:02 PM
0

Sign in to vote

Can't see that in the wizard either

It not in the wizard. You will need to custom write the query.
http://www.enhansoft.com/

Tuesday, February 18, 2014 6:20 PM