Getting only the current configuration of a Windows Service using VM inventory

Question

Getting only the current configuration of a Windows Service using VM inventory

Tiemen Jansen 0

When I search the 'ConfigurationData' table used for tracking the inventory of virtual machines, I don't ONLY get the current inventory. I also get the change history. I thought the 'ConfigurationChange' table is meant for this. The data I need is actually the same as what is available through the web portal. User's image

When i use Log analytics i get this: User's image

Monalla-MSFT 13,071 Reputation points Moderator

2024-02-26T20:10:52.3366667+00:00

@Tiemen Jansen Just checking in to see if the below answer helped. If this answers your query, do click "Accept as Answer" and click "Yes" for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Your answer

Monalla-MSFT 13,071 Reputation points Moderator

2024-02-26T20:10:52.3366667+00:00

@Tiemen Jansen Just checking in to see if the below answer helped. If this answers your query, do click "Accept as Answer" and click "Yes" for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Clive Watson 7,866 MVP Volunteer Moderator

Does the result change if you specifically get the most recent record, using arg_max?

ConfigurationData
| where Computer =="VM01"
| where ConfigDataType =='WindowsServices'
| summarize arg_max(TimeGenerated, *) by Computer, SvcName
| order by SvcName asc

Share via

Getting only the current configuration of a Windows Service using VM inventory

1 answer

Your answer