SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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 Nov 01 2008, 10:35 AM by Garth
Filed under: , , ,

Comments

 

Oscargarcia said:

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

November 4, 2008 8:49 AM
 

Need assistance with query | keyongtech said:

Pingback from  Need assistance with query | keyongtech

January 18, 2009 11:12 AM

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems