SCCM application/task sequence SQL query status 10005

Question

Hello everybody. I’m looking for a SCCM SQL query with which I can read the status 10005 of an application or a task sequence (application preferred). The query must contain the installation time and the machine name. Unfortunately I don’t know in which tables I should look for the status and whether applications output this or whether I need absolutely a task sequence. The application should distribute a VB script over several computers and then execute it on the computer.

solved 0
BDF34 2021-01-11T20:18:47+05:30 2 Answers 439 views Beginner
0

Answers ( 2 )

  2. Ankit Shukla
    0
    2021-01-13T09:06:03+05:30
    Reply

    Hello,
    If you want to get information on basis of status messages I suggest to create state message query.

    You can use below query and change the attribute value to your deploymentID.

    select
    SMS_StatusMessage.*,SMS_StatMsgInsStrings.*,SMS_StatMsgAttributes.*,SMS_StatMsgAttributes.AttributeTime
    from SMS_StatusMessage
    left join SMS_StatMsgInsStrings on SMS_StatMsgInsStrings.RecordID = SMS_StatusMessage.RecordID
    left join SMS_StatMsgAttributes on SMS_StatMsgAttributes.RecordID = SMS_StatusMessage.RecordID
    where SMS_StatMsgAttributes.AttributeID = 401 and SMS_StatMsgAttributes.AttributeValue = “1002000B” and SMS_StatMsgAttributes.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime##
    order by SMS_StatMsgAttributes.AttributeTime DESC

    https://systemcenterdudes.com/monitor-sccm-task-sequence/

    Best answer
  4. Anoop C Nair
    0
    2021-01-12T01:55:02+05:30
    Reply

    Have you seen the post from Ankit … it will surely help you

    SCCM Application Deployment Custom Report SQL Query | ConfigMgr https://www.anoopcnair.com/sccm-application-deployment-custom-report-sql-query-configmgr/

Leave an answer

Sorry, you do not have permission to answer to this question .