SCCM SQL Queries tables are blank

sccm t 0 Reputation points
2025-03-11T22:17:50.3233333+00:00

Dear Team,

I have a issue with my new SCCM Server. if i run the following queries in my new sccm server , my tables are empty
User's image

.................................
But the same queries i run in my old server . all the tables have records.

User's image

Can You please help.

System Center Orchestrator
System Center Orchestrator
A family of System Center products that provide an automation platform for orchestrating and integrating both Microsoft and non-Microsoft IT tools.
252 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AllenLiu-MSFT 48,356 Reputation points Microsoft External Staff
    2025-03-12T01:50:15.47+00:00

    Hi, @sccm t

    Thank you for posting in Microsoft Q&A forum.

    The views start with v_GS_ obtain the data from hardware inventory, have we enable the hardware inventory on the new server and wait for the hardware inventory completed on the clients?

    https://learn.microsoft.com/en-us/mem/configmgr/core/clients/manage/inventory/configure-hardware-inventory#to-configure-hardware-inventory


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

    After the way you tag questions on Q&A is updated, for any "Microsoft Configuration Manager" related problem, you can tag it with "Microsoft Intune", and then "Microsoft Configuration Manager" as the child tag.

    0 comments No comments

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.