SCCM query

Question

SQL query OR Script to get patch error code failed for any software update deployment .

Doc2

 

solved 0
aamir ansari 9 months 2020-07-12T10:09:23+05:30 4 Answers 141 views Beginner 0

Answers ( 4 )

    0
    2020-07-15T17:11:28+05:30

    Hi Karthik ,

    i added document in question .need such information.

    0
    2020-07-14T10:30:40+05:30

    Thank you Anoop and karthik .

    let me check result for this .

    Hi Karthik can we make for particular collection and sup .

    1
    2020-07-13T11:05:04+05:30

    –All machines SUP Scan detailed report
    ——————————————————–
    select
    distinct Vrs.name0 as ‘ComputerName’,
    os.caption0 as ‘OSName’,
    Vrs.user_name0 as ‘UserName’,
    convert(nvarchar(26),ws.lasthwscan,100) as ‘LastHWScan’,
    convert(nvarchar(26),uss.LastScanTime,100) as ‘LastSUPScan’,
    uss.lasterrorcode as ‘LastSUPScanStatus’,
    uss.lastscanpackagelocation as ‘SUPLocationPath’
    from v_r_system as Vrs
    Left join v_gs_operating_system as os on os.resourceid=Vrs.resourceid
    Left join v_GS_WORKSTATION_STATUS as ws on ws.resourceid=Vrs.resourceid
    Left join v_updatescanstatus as uss on uss.ResourceId=Vrs.ResourceID
    order by uss.lasterrorcode

    Best answer

Leave an answer

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