Skip to content

kfv7

Established Members
  • Joined

  • Last visited

  1. 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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.