The below post explains the end to end process of software updates management in SCCM 2012 Pre-requisites: 1. WSUS Server (WSUS 3.0 SP2 ) should be installed on the SCCM site server or if you want to install WSUS on another server, it is important that you install WSUS administration console as the SCCM Server uses API. This link explains the step by step procedure to install WSUS 3.0 SP2 2. Install SUP-Software Update Point on the SCCM Server . 3. Reporting Services Point: Install reporting services point role as described in this link . 4. Client agent: The software update client agent should be enabled(will be enabled by default) and the settings have to specified as per the requirement. On SCCM console, go to Administration>Site Configuration>Client settings>Right click on Default client settings> Click on Properties. If required, we can create custom client settings and then enable client settings for that settings. ...
The below query provides the hostname,AD SITE
Name,Username,Client version,creation date,Operating System of a SCCM
client installed machine.
select Name0 AS 'HostName',
AD_Site_Name0 AS 'AD
Site Name',User_Name0 as 'User Name',Client_Version0 as
'Client Version',Creation_Date0 as 'Creation Date', Operating_System_Name_and0 as
'Operating System'
from dbo.v_R_System where Client0 <>
0 and Name0 <>
'null' and
Active0 = 1 and
Client_Version0 >= '4.00.6487.2000'
group by
AD_Site_Name0,NAME0,User_Name0,Client_Version0,Creation_Date0,Operating_System_Name_and0
Hello,
ReplyDelete"Creation Date" what is it referring to? Added to AD? Added to SCCM? Brought online through the network?
Thanks,
DOm