Active workstations in the last 30 days

Select
    CS.Name0,
    WS.LastHWScan
From
    dbo.v_GS_COMPUTER_SYSTEM CS,
    dbo.v_GS_WORKSTATION_STATUS WS
Where
    CS.Resourceid = WS.ResourceID
    and datediff(dd,WS.LastHWScan,getdate())< 30

Leave a Reply

Your email address will not be published. Required fields are marked *