SCCM Report Last HW Scan

select
        [sys].[AD_Site_Name0]
        , [sys].[Name0]
        , [ws].[LastHWScan]

    from v_GS_WORKSTATION_STATUS [ws]

    join v_R_System [sys] on [ws].[ResourceID] = [sys].[ResourceID]
    left join v_GS_OPERATING_SYSTEM [os] on [ws].[ResourceID] = [os].[ResourceID]

    order by LastHWScan desc

********************************

Report view example: