kfv7

Hi, I am new to this forum. I have a problem, i have to make a report in SCCM 2007 and I dont know SQL. I have made the following one copying from others ones. declare @Total int declare @Succeeded int declare @Failed int declare @InProgress int select @Succeeded = count (*) from v_ClientDeploymentState where DeploymentEndTime is not NULL select @Failed = count(*) from v_ClientDeploymentState where LastMessageStateID>100 AND LastMessageStateID<400 select @InProgress= count(*) from v_ClientDeploymentState where DeploymentEndTime is NULL and LastMessageStateID = 100 select @Total = @Failed + @InProgress + @Succeeded if @Total > 0 begin select @Total as ComputersWithStatus, @Succeeded as DeploySucceeded, @Failed as DeployFailed, @InProgress as DeployInProgress, round(100.0*@Succeeded/@Total,2) as SuccessRate, round(100.0*@Failed/@Total,2) as FailureRate, round(100.0*@InProgress/@Total,2) as InProgressRate end select FQDN as MachineNameFQDN, NetBiosName as MachineNameNetBios, ClientVersion as ClientVersion, DeploymentBeginTime as DeployStartTime, StateDescription as InProgressDescription, LastMessageParam as DescriptionParam from v_ClientDeploymentState where DeploymentEndTime is NULL and LastMessageStateID = 100 select FQDN as MachineNameFQDN, NetBiosName as MachineNameNetBios, ClientVersion as ClientVersion, DeploymentBeginTime as DeployStartTime, StateDescription as FailureDescription, LastMessageParam as DescriptionParam from v_ClientDeploymentState where LastMessageStateID>100 AND LastMessageStateID<400 select FQDN as MachineNameFQDN, NetBiosName as MachineNameNetBios, ClientVersion as ClientVersion, DeploymentBeginTime as DeployStartTime, DeploymentEndTime as DeployEndTime, RebootNeeded as RebootNeeded from v_ClientDeploymentState where DeploymentEndTime is not NULL The report shows the status of the SCCM client installation. I have to add a column to the 3 tables that shows the status of each pc. The column have to show the Description of the computer in Active Directory. I try adding the line "select SMS_R_System.description0 as Description", but I get the error "The multi-part identifier "SMS_R_System.description0" could not be bound". Any help would be greatly apreciated. Sorry for my poor english