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

St John Jordaan 6 Reputation points
2021-02-09T05:01:05.383+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,860 questions
{count} vote

1 answer

Sort by: Most helpful
  1. 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

    1 person found this answer helpful.
    0 comments No comments