@neerukattu you can export the results of a query into Excel from the Azure Portal using the Export button in the toolbar (see pic below). As to the query itself, what information are you looking for - for example do you want a report on “all missing patches”, “the status of all updates on a particular machine”, and so on?
