OU Count of PCs not reporting within 1 day

SELECT
    OU.System_OU_Name0,
    count(*) as 'Count'
FROM 
    dbo.v_GS_WORKSTATION_STATUS    as WS,
    dbo.v_R_System as SYS,
    dbo.v_RA_System_SystemOUName as OU
Where
    SYS.ResourceID = OU.ResourceID
    and SYS.ResourceID = WS.ResourceID
    and Datediff(dd,WS.LastHWScan, getdate()) > 1
group by
    OU.System_OU_Name0
order by
    OU.System_OU_Name0

Published Saturday, November 01, 2008 10:35 AM by Garth
Filed under: , , ,

Comments

# re: OU Count of PCs not reporting within 1 day@ Tuesday, November 04, 2008 8:49 AM

Hi!, I'm recent user of SCCM 2007 and I need to ask a question:

There is some way to see the column IP inside the collection's details panel?

Thanks by helping me

Oscar

by Oscargarcia

# Need assistance with query | keyongtech@ Sunday, January 18, 2009 11:12 AM

Pingback from  Need assistance with query | keyongtech

by Need assistance with query | keyongtech