KQL query that can pull software license version of software installed on a server

St John Jordaan 6

Hello,

I'm attempting to find/construct a KQL query that can pull software license version of software installed on a server. So far (3 hours of searching) my efforts have been for naught. If somebody could at least point me in the right direction I would much appreciate it.

Thank you in advance

Daisy Zhou 21,361 Reputation points Microsoft Vendor

2021-02-09T09:25:33.883+00:00

Hello @St John Jordaan ,

Thank you for posting here.

1.What is software installed on the server?
2.Is KQL query you mentioned in sharepoint search or Azure?

For example:

KQL quick reference
https://learn.microsoft.com/en-us/azure/data-explorer/kql-quick-reference

Keyword Query Language (KQL) syntax reference
https://learn.microsoft.com/en-us/sharepoint/dev/general-development/keyword-query-language-kql-syntax-reference

Thank you for your understanding.

Best Regards,
Daisy Zhou
St John Jordaan 6 Reputation points

2021-02-09T12:31:42.157+00:00

Hi There,

Thank you for your reply.

I have been given a more clear view of the objective. Basically I need a Kusto query to find the SQL version on Azure.

In the same realm that you would query "SELECT @@version" with SQL, I need to find out what the KQL equivalent of that query is
Daisy Zhou 21,361 Reputation points Microsoft Vendor

2021-02-10T01:48:00.32+00:00

Hello @St John Jordaan ,

Thank you for your update.

So our request may related to SQL or Azure. I mainly focus on the issue or problem about on-premise AD.

I will change the tag to Azure and SQL. Then there may be engineer from SQL or Azure team to help you better.

Thank you for your understanding and support.

Best Regards,
Daisy Zhou

1 answer

Stephen Correia 6 Reputation points

2021-02-13T04:34:32.01+00:00
Assuming you have Change Tracking and Inventory implemented on your Azure
VM's you can use KQL to search the ConfigurationData table.

ConfigurationData | where ConfigDataType == "Software" | summarize arg_max(TimeGenerated, *) by SoftwareName, CurrentVersion | where Computer =="ContosoVM" | render table | summarize by Publisher, SoftwareName

Reference: https://learn.microsoft.com/en-us/azure/automation/automation-tutorial-installed-software#enable-change-tracking-and-inventory
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Share via

KQL query that can pull software license version of software installed on a server

1 answer