I mean live systems. Not aged system that was in AD but removed from the network several months ago. Is it possible to generate a query that shows something like attempted client installed on a active resource? And if it failed or could not complete, show these systems for a given OU?

If you have a Fallback Status Point configured and are using FSP=FSP Server in the client installation command-line properties then you can see all the failed installation attempts in the default reports. You have several FSP reports that can assist you, one of them is called Client Deployment - Failure Report.Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund

Hi, There are no primary client deployment views, but there are status views that contain information about the deployment state of Configuration Manager 2007 client computers and devices. We can use v_ClientDeploymentState view for query: select FQDN as MachineNameFQDN, NetBiosName as MachineNameNetBios, ClientVersion as ClientVersion, DeploymentBeginTime as DeployStartTime, StateDescription as FailureDescription, LastMessageParam as DescriptionParam from v_ClientDeploymentState inner join v_R_System on v_R_System.Netbios_Name0 = v_ClientDeploymentState.NetBiosName inner join v_RA_System_SystemOUName on v_RA_System_SystemOUName.ResourceID = v_R_System.ResourceID where LastMessageStateID>100 AND LastMessageStateID<400 and v_RA_System_SystemOUName.System_OU_Name0 = '<OUName>' From v_StateNames view you will find why use LastMessageStateID>100 AND LastMessageStateID<400 as where statement. Thanks

Hi, There are no primary client deployment views, but there are status views that contain information about the deployment state of Configuration Manager 2007 client computers and devices. We can use v_ClientDeploymentState view for query: select FQDN as MachineNameFQDN, NetBiosName as MachineNameNetBios, ClientVersion as ClientVersion, DeploymentBeginTime as DeployStartTime, StateDescription as FailureDescription, LastMessageParam as DescriptionParam from v_ClientDeploymentState inner join v_R_System on v_R_System.Netbios_Name0 = v_ClientDeploymentState.NetBiosName inner join v_RA_System_SystemOUName on v_RA_System_SystemOUName.ResourceID = v_R_System.ResourceID where LastMessageStateID>100 AND LastMessageStateID<400 and v_RA_System_SystemOUName.System_OU_Name0 = '<OUName>' From v_StateNames view you will find why use LastMessageStateID>100 AND LastMessageStateID<400 as where statement. Thanks