SQL Query for Host relationship and computer report

Bruce Meyer 20 Reputation points
2024-01-09T09:09:06.84+00:00

Hey guys, I need an sql query that can pull below information Host Relationship (Servers)

  1. Host relationship (What vm's are connected to a host)
  2. Host Processor & CPU Core count
  3. VM Processor & CPU core count
  4. OS & version
  5. Assigned to
  6. Last scanned
  7. Power State
  8. Environment

Also need a query to only pull data for Desktops and laptops

  1. Asset Name
  2. Assigned to
  3. OS & Version
  4. Processor & CPU Core count
  5. Last scanned
  6. Power state
  7. Environment
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,993 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Garth Jones 1,666 Reputation points
    2024-01-09T12:53:57.48+00:00

    What do you have for a query now? What is not working for you? All of the supported sql views are here. https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/sql-server-views-configuration-manager


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.