Answers ( 4 )

  1. aamir ansari
    0
    Reply

    Hi Karthik ,

    i added document in question .need such information.

  2. aamir ansari
    0
    Reply

    Thank you Anoop and karthik .

    let me check result for this .

    Hi Karthik can we make for particular collection and sup .

  3. Karthikeyan
    1
    Reply

    –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
  4. Anoop C Nair
    0
    Reply

Leave an answer

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