Dear all
I wish to create a query for report /EOC Dashboard for Machine type and number of Devices present not full inventory
e.g
Windows Server =20
Linux =35
Router =5
etc
Please help
Below link would help, modify the query as required
SQL Query