Share via

SQL view for return code client

matteu31 467 Reputation points
2020-10-20T15:29:28.187+00:00

Hello,

I'm sorry but I don't know really how to find information in the SCCM database, and if you have some good link about it, you're welcome.
I would like to know on which view I can find the return code of one client for my last step of task sequence execution.

I find report for windows compatibility check here : https://systemcenterdudes.com/sccm-windows-10-compatibility-check
but it doesn't work anymore because view informations changed since author wrote it.

I would like to know where I can find the last client return code to update this report :)

Thank you

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,913 questions
Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Garth Jones 2,076 Reputation points
    2020-10-20T17:07:39.85+00:00

    Here is a list of supported SQL views that you can use for reporting.
    https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/sql-server-views-configuration-manager

    vSMS_* are not supported views.

    1 person found this answer helpful.
    0 comments
  2. matteu31 467 Reputation points
    2020-10-20T16:43:52.03+00:00

    OK I find it with this link :
    https://thesitedoctor.co.uk/blog/search-every-table-and-field-in-a-sql-server-database-updated/

    It's on v_TaskExecutionStatus view or vSMS_TaskSequenceExecutionStatus

    but I think we have to only use the first one.

    This view is not used in the repport file dataset, and I don't have knowledge to fix it. Maybe someone here know how to do...

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