Invalid object name 'SMS_R_System'

Steven Song 1 Reputation point
2023-02-04T06:31:22.8233333+00:00

Invalid object name 'SMS_R_System' in SCCM SQL SERVER

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,759 questions
Microsoft Configuration Manager

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenLiu-MSFT 40,551 Reputation points Microsoft Vendor
    2023-02-06T08:24:45.24+00:00

    Hi, @steven song

    Thank you for posting in Microsoft Q&A forum.

    SMS_R_System is a class that we used in WMI with a WQL query.

    In SCCM SQL Server, the corresponding view is v_r_system, we should use v_r_system in SQL query.

    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".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.